public ActionResult Edit(int id)
{
EmployeeBusinessLayer employeeBusinessLayer = new EmployeeBusinessLayer();
BusinessLayer.BO_Employee employee = employeeBusinessLayer.Employees.Single(emp => emp.Id == id);
return(View(employee));
}
public int InsertEmployee(BO_Employee employee)
{
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spInsert_Employee", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter P_Name = new SqlParameter("@Name", employee.Name);
cmd.Parameters.Add(P_Name);
SqlParameter P_Age = new SqlParameter("@Age", employee.Age);
cmd.Parameters.Add(P_Age);
SqlParameter P_Gender = new SqlParameter("@Gender", employee.Gender);
cmd.Parameters.Add(P_Gender);
con.Open();
return(cmd.ExecuteNonQuery());
}
}
