private void btnSave_Click(object sender, EventArgs e) { Employee svEmp = new Employee(); svEmp.FullName1 = tbxFullName.Text; svEmp.ShortName1 = tbxShortName.Text; svEmp.Title1 = cbxTitle.Text; svEmp.DateOfBirth1 = Convert.ToDateTime(mtbxDoB.Text); svEmp.Type1 = cbxType.Text; svEmp.Active1 = cbxActive.Text; svEmp.OfficePhone1 = cbxOfficePhone.Text; svEmp.HomePhone1 = mtbHomePhone.Text; svEmp.MobilePhone1 = mtbMobilePhone.Text; svEmp.EmergContact1 = tbxEmergContact.Text; svEmp.EmergPhone1 = mtbContactPhone.Text; int result = dbconnect.Insert(svEmp); if (result > 0) { Timer timer1 = new Timer(); timer1.Interval = 5000; statusAction.Text = ("Update Successful!"); timer1.Start(); timer1.Tick += new EventHandler(timer1_Tick); } else { Timer timer1 = new Timer(); timer1.Interval = 5000; statusAction.Text = ("Update Failed!"); timer1.Start(); timer1.Tick += new EventHandler(timer1_Tick); } }
here is the other end of that method which is in a different class file.
//employee save method
public int Insert(Employee svEmp) { int result = 0; try { dbcommand.CommandText = "INSERT INTO tblEmployee(FullName, ShortName, Title, OfficePhone, HomePhone, MobilePhone, DateOfBirth, Type, Active,EmergPhone, EmergContact) VALUES (@vFull, @vShort, @vTitle, @vOffice, @vHome, @vMobile, @vDob, @vType, @vActive, @vEPhone, @vEContact)"; dbcommand.Parameters.AddWithValue("@vFull", svEmp.FullName1); dbcommand.Parameters.AddWithValue("@vShort", svEmp.ShortName1); dbcommand.Parameters.AddWithValue("@vTitle", svEmp.Title1); dbcommand.Parameters.AddWithValue("@vOffice", svEmp.OfficePhone1); dbcommand.Parameters.AddWithValue("@vHome", svEmp.HomePhone1); dbcommand.Parameters.AddWithValue("@vMobile", svEmp.MobilePhone1); dbcommand.Parameters.AddWithValue("@vDob", svEmp.DateOfBirth1); dbcommand.Parameters.AddWithValue("@vType", svEmp.Type1); dbcommand.Parameters.AddWithValue("@vActive", svEmp.Active1); dbcommand.Parameters.AddWithValue("@vEPhone", svEmp.EmergPhone1); dbcommand.Parameters.AddWithValue("@vEContact", svEmp.EmergContact1); dbcommand.CommandType = System.Data.CommandType.Text; dbconnect.Open(); result = dbcommand.ExecuteNonQuery(); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } finally { dbconnect.Close(); dbconnect.Dispose(); } return result; }