public string AddEmployee(EmplyeesModel employee)
{
conn.ConnOpen();
SqlCommand cmd = new SqlCommand("stpAddEmployee", conn.conectarbd);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LoginID", employee.LoginId);
cmd.Parameters.AddWithValue("@OrganizationNode", employee.OrganizationNode);
cmd.Parameters.AddWithValue("@JobTitle", employee.JobTitle);
cmd.Parameters.AddWithValue("@BirthDate", employee.BirthDate);
cmd.Parameters.AddWithValue("@MaritalStatus", employee.MaritalStatus);
cmd.Parameters.AddWithValue("@Gender", employee.Gender);
cmd.Parameters.AddWithValue("@HireDate", employee.HireDate);
cmd.Parameters.AddWithValue("@SalariedFlag", employee.SalariedFlag);
cmd.Parameters.AddWithValue("@VacationHours", employee.VacationHours);
cmd.Parameters.AddWithValue("@SickLeaveHours", employee.SickLeaveHours);
cmd.Parameters.AddWithValue("@CurrentFlag", employee.CurrentFlag);
int i = cmd.ExecuteNonQuery();
conn.ConnClose();
if (i >= 1)
{
return("1");
}
else
{
return("0");
}
}
public List <EmplyeesModel> GetListEmployee()
{
conn.ConnOpen();
SqlCommand cmd = new SqlCommand("stpGetEmployee", conn.conectarbd);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
List <EmplyeesModel> listEmployee = new List <EmplyeesModel>();
EmplyeesModel emplyeesModel; new EmplyeesModel();
while (dr.Read())
{
emplyeesModel = new EmplyeesModel();
emplyeesModel.BusinessEntityID = Convert.ToInt32(dr[0]);
emplyeesModel.NationalIDNumber = dr[1].ToString();
var column = dr.GetOrdinal("OrganizationLevel");
if (!dr.IsDBNull(column))
{
emplyeesModel.OrganizationLevel = Convert.ToInt32(dr["OrganizationLevel"]);
}
emplyeesModel.JobTitle = dr[3].ToString();
emplyeesModel.BirthDate = Convert.ToDateTime(dr[4]);
emplyeesModel.Gender = Convert.ToChar(dr[5]);
emplyeesModel.ModifiedDate = Convert.ToDateTime(dr[6]);
listEmployee.Add(emplyeesModel);
}
conn.ConnClose();
return(listEmployee);
}
public ActionResult UpdateEmployee(int id, EmplyeesModel employee)
{
try
{
var result = _employeesI.UpdateEmployee(id, employee);
if (result == "0")
{
return(Ok(new { message = "Employee Deleted Successfully", code = 0 }));
}
else
{
return(BadRequest(new { message = "Employee Not Delete Successfully", code = 0 }));
}
}
catch (Exception ex)
{
return(StatusCode(500, new { Message = "Internal Error Server", ErrorMessage = "" + ex }));
}
}
