protected void SaveButton_Click(object sender, EventArgs e) { Pioneertech.Consultancy.model.EmployeeDetail employeeDetail = new Pioneertech.Consultancy.model.EmployeeDetail { FirstName = FirstNameTextBox.Text, LastName = LastNameTextBox.Text, EmailId = EmailIdTextBox.Text, PhoneNumber = Convert.ToInt64(PhoneNumberTextBox.Text), AlternatePhoneNumber = Convert.ToInt64(AlternatePhoneNumberTextBox.Text), Address1 = Address1TextBox.Text, Address2 = Address2TextBox.Text, HomeCountry = HomeCountryTextBox.Text, CurrentCountry = CurrentCountryTextBox.Text, ZipCode = Convert.ToInt32(ZipCodeTextBox.Text) }; EmployeeDataAccessLayer employeeDAL = new EmployeeDataAccessLayer(); int numberOfRowEffected = employeeDAL.SaveEmployeeData(employeeDetail); if (numberOfRowEffected > 0) { string display = "Employee Data is Successfully Saved"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "Employee Data not Saved. Please try again."; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
protected void EditButton_Click(object sender, EventArgs e) { Pioneertech.Consultancy.model.EmployeeDetail employeeDetail = new Pioneertech.Consultancy.model.EmployeeDetail { FirstName = FirstNameTextBox.Text, LastName = LastNameTextBox.Text, EmailId = EmailIdTextBox.Text, PhoneNumber = Convert.ToInt64(PhoneNumberTextBox.Text), AlternatePhoneNumber = Convert.ToInt64(AlternatePhoneNumberTextBox.Text), Address1 = Address1TextBox.Text, Address2 = Address2TextBox.Text, HomeCountry = HomeCountryTextBox.Text, CurrentCountry = CurrentCountryTextBox.Text, ZipCode = Convert.ToInt32(ZipCodeTextBox.Text) }; int EmployeeId = int.Parse(EmployeeIdDropDownList.Text); SqlConnection mssqlconnection = new SqlConnection("Data Source=DESKTOP-I3T5H70;" + "Initial Catalog=PioneerTech;" + "Integrated Security=true"); mssqlconnection.Open(); string sql = $"UPDATE [EmployeeDetail] SET[FirstName] = '{employeeDetail.FirstName}'," + $"[LastName] = '{employeeDetail.LastName}'," + $"[Email] = '{employeeDetail.EmailId}'," + $"[ContactNumber] = {employeeDetail.PhoneNumber}," + $"[AlternateContactNumber] = {employeeDetail.AlternatePhoneNumber}," + $"[Address] =' {employeeDetail.Address1}'," + $"[AlternateAddress] =' {employeeDetail.Address2}'," + $"[HomeCountry] =' {employeeDetail.HomeCountry}'," + $"[CurrentCountry] =' {employeeDetail.CurrentCountry}'," + $"[ZipCode] = {employeeDetail.ZipCode} " + $"WHERE EmployeeID= {EmployeeId}"; SqlCommand command = new SqlCommand(sql, mssqlconnection); int numberOfRowEffected = command.ExecuteNonQuery(); mssqlconnection.Close(); if (numberOfRowEffected > 0) { string display = "Employee Company Data is Successfully Edited"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "Employee Company Data not Edited. Please try again."; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }