public bool UpdateEmployees(EmpMod obj, int id)
{
connection();
MySqlCommand com = new MySqlCommand("UpdateEmpDetails", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("E_Emp_ID", id);
com.Parameters.AddWithValue("E_Emp_Name", obj.Name);
com.Parameters.AddWithValue("E_Address", obj.Address);
com.Parameters.AddWithValue("E_Contact", obj.Contact_number);
com.Parameters.AddWithValue("E_PAN", obj.Pan);
com.Parameters.AddWithValue("E_Start_Date", obj.Start_date);
com.Parameters.AddWithValue("E_End_Date", obj.End_date);
com.Parameters.AddWithValue("E_Date_Of_Birth", obj.Date_of_birth);
com.Parameters.AddWithValue("E_Salary", obj.Salary);
com.Parameters.AddWithValue("E_Emp_Status", obj.Status);
con.Open();
int i = com.ExecuteNonQuery();
con.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult EditEmpDetails(int id, EmpMod obj)
{
try
{
EmpMod emp = new EmpMod();
EmpRepository EmpRepo = new EmpRepository();
EmpRepo.UpdateEmployees(obj, id);
return(RedirectToAction("GetAllEmpDetails"));
}
catch {
return(View());
}
}
public ActionResult AddEmployee(EmpMod Emp)
{
try
{
EmpRepository EmpRepo = new EmpRepository();
if (EmpRepo.AddEmployee(Emp))
{
ViewBag.Message = "Employee details added Successfully";
}
return(RedirectToAction("GetAllEmpDetails"));
}
catch
{
return(View());
}
}
public ActionResult Del(EmpMod empMod)
{
return(Json(empModOper.Del(empMod)));
}
public ActionResult Update(EmpMod empMod)
{
return(Json(empModOper.Update(empMod)));
}
public ActionResult Add(EmpMod empMod)
{
return(Json(empModOper.Add(empMod)));
}
