public ActionResult EditEmployee3(int id) { ShowAllInformation dataModel = new ShowAllInformation(); DataTable tblda = new DataTable(); using (con) { con.Open(); //string query = "SELECT EmpName,DeptName,DOJ,Designation,DOB,Degree,POY,BankName,AccNo,BasicSalary,HRA,OtherAllowance,GrossSalary,PF,MedicalPremium,TDS,NetSalary from Employee e join Department d on d.DeptId = e.DeptId left join EmployeeDetails2 empd on empd.EmpId = e.EmpId left join BankDetails2 bnk on bnk.EmpId = e.EmpId where e.EmpId = @EmpId"; SqlCommand sc = new SqlCommand("Sp_ShowAllInformation2", con); sc.CommandType = CommandType.StoredProcedure; SqlDataAdapter sqlda = new SqlDataAdapter(sc); sqlda.SelectCommand.Parameters.AddWithValue("@EmpId", id); sqlda.Fill(tblda); } if (tblda.Rows.Count == 1) { dataModel.EmpId = Convert.ToInt32(tblda.Rows[0][0]); dataModel.EmpName = tblda.Rows[0][1].ToString(); //dataModel.DeptName = tblda.Rows[0][2].ToString(); //if (!String.IsNullOrEmpty(tblda.Rows[0][3].ToString())) // dataModel.DOB = Convert.ToString(tblda.Rows[0][3]).("dd/MM/yyyy"); //if (!String.IsNullOrEmpty(tblda.Rows[0]["DOB"].ToString())) // dataModel.DOB = Convert.ToDateTime(tblda.Rows[0]["DOB"]).ToString("dd/MM/yyyy"); //if (!DBNull.Value.Equals(tblda.Rows[0][3])) // dataModel.DOB=Convert.ToDateTime(tblda.Rows[0][3]); //else // dataModel.DOB= (DateTime)Convert.ChangeType(tblda.Rows[0][3],TypeCode.DateTime); //if (dataModel.DOB is DBNull) dataModel.DOB = tblda.Rows[0][3].ToString(); dataModel.Designation = tblda.Rows[0][4].ToString(); //if (dataModel.DOJ is DBNull) dataModel.DOJ = tblda.Rows[0][5].ToString(); dataModel.Degree = tblda.Rows[0][6].ToString(); //if (dataModel.POY is DBNull) dataModel.POY = tblda.Rows[0][7].ToString(); dataModel.BankName = tblda.Rows[0][8].ToString(); //if (dataModel.AccNo is DBNull) dataModel.AccNo = tblda.Rows[0][9].ToString(); //if (dataModel.GrossSalary is DBNull) dataModel.GrossSalary = tblda.Rows[0][10].ToString(); return(View(dataModel)); } else { return(RedirectToAction("Index")); } }
//[ValidateAntiForgeryToken] public ActionResult EditEmployee3(ShowAllInformation sai) { using (con) { con.Open(); //string query = "update Employee set EmpName=@EmpName,DeptName=@DeptName,DOB=@DOB,Designation=@Designation,DOJ=@DOJ,Degree=@Degree,POY=@POY,BankName=@BankName,AccNo=@AccNo,GrossSalary=@GrossSalary where EmpId=@EmpId"; SqlCommand sqlcom = new SqlCommand("Sp_EditAllInformation5", con); sqlcom.CommandType = CommandType.StoredProcedure; //SqlCommand sqlcom = new SqlCommand(query, con); sqlcom.Parameters.AddWithValue("@EmpId", sai.EmpId); sqlcom.Parameters.AddWithValue("@EmpName", sai.EmpName); //sqlcom.Parameters.AddWithValue("@DeptName", sai.DeptName); sqlcom.Parameters.AddWithValue("@DOB", sai.DOB); sqlcom.Parameters.AddWithValue("@Designation", sai.Designation); sqlcom.Parameters.AddWithValue("@DOJ", sai.DOJ); sqlcom.Parameters.AddWithValue("@Degree", sai.Degree); sqlcom.Parameters.AddWithValue("@POY", sai.POY); sqlcom.Parameters.AddWithValue("@BankName", sai.BankName); sqlcom.Parameters.AddWithValue("@AccNo", sai.AccNo); sqlcom.Parameters.AddWithValue("@GrossSalary", sai.GrossSalary); sqlcom.ExecuteNonQuery(); } return(RedirectToAction("Index", "ShowData")); }