//Method to add employee
public Employee Add(Employee employee)
{
using (EmployeeContext employeeContext = new EmployeeContext())
{
//SqlParameter sqlFirstname = new SqlParameter("@Firstname", employee.Firstname);
//SqlParameter sqlLastname = new SqlParameter("@Lastname", employee.Lastname);
//SqlParameter sqlEmailId = new SqlParameter("@EmailId", employee.EmailId);
//SqlParameter sqlGender = new SqlParameter("@Gender", employee.Gender);
//SqlParameter sqlMobilenumber = new SqlParameter("@Mobilenumber", employee.Mobilenumber);
//SqlParameter sqlDOB = new SqlParameter("@DOB", employee.DOB);
//SqlParameter sqlDOJ = new SqlParameter("@DOJ", employee.DOJ);
//SqlParameter sqlDesignationId = new SqlParameter("@DesignationId", employee.DesignationId);
//SqlParameter sqlDepartmentId = new SqlParameter("@DepartmentId", employee.DepartmentId);
//SqlParameter sqlAccountId = new SqlParameter("@AccountId", employee.AccountId);
//int count = employeeContext.Database.ExecuteSqlCommand("Employee_Insert @Firstname,@Lastname,@EmailId,@Gender,@Mobilenumber, @DOB, @DOJ, @DesignationId, @DepartmentId,@AccountId", sqlFirstname, sqlLastname, sqlEmailId, sqlGender, sqlMobilenumber, sqlDOB, sqlDOJ, sqlDesignationId, sqlDepartmentId, sqlAccountId);
employeeContext.Entry(employee).State = EntityState.Added;
employeeContext.SaveChanges();
return(employee);
}
}
