public ActionResult AddDept(EEP_Models.Models.Department objmodel)
{
int i = objdepservice.serviceaddemp(objmodel);
if (i == 1)
{
ViewData["a"] = "Added successfully";
}
else
{
ViewData["a"] = "failed";
}
return(View());
}
public virtual int Deptadd(EEP_Models.Models.Department objbodept)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand("proc_adddept", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DepId", objbodept.DeptId);
cmd.Parameters.AddWithValue("@Deptname", objbodept.DeptName);
cmd.Parameters.AddWithValue("@DeptRoll", objbodept.DeptRole);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
