public string DeleteRegisterPosition(int id)
{
try
{
ManageRegisterPosition MRegisterPosition = new ManageRegisterPosition();
MRegisterPosition = Context.ManageRegisterPosition.Where(x => x.Id == id).FirstOrDefault();
Context.ManageRegisterPosition.Remove(MRegisterPosition);
Context.SaveChanges();
return("success");
}
catch (Exception e) { throw e; }
}
public string EditRegisterPosition(PositionDTO position)
{
try
{
ManageRegisterPosition MRegisterPosition = new ManageRegisterPosition();
MRegisterPosition = Context.ManageRegisterPosition.Where(x => x.Id == position.id).FirstOrDefault();
MRegisterPosition.NumberOfPosition = position.NumberOfPosition;
MRegisterPosition.ActiveStatus = position.Active;
MRegisterPosition.UpdBy = position.Username;
MRegisterPosition.UpdDate = DateTime.Now;
MRegisterPosition.TypeEmployee = position.Type_Employee;
Context.ManageRegisterPosition.Update(MRegisterPosition);
Context.SaveChanges();
return("success");
}
catch (Exception e) { throw e; }
}
public string AddRegisterPosition(PositionDTO position)
{
try
{
List <PositionDTO> data = (
from typeEmployee in Context.ManageRegisterPosition
where typeEmployee.PositionId == position.PositionId
select new PositionDTO
{
Type_Employee = typeEmployee.TypeEmployee
}).ToList();
for (int i = 0; i < data.Count; i++)
{
if (data[i].Type_Employee == position.Type_Employee)
{
return("warning");
}
}
ManageRegisterPosition MRegisterPosition = new ManageRegisterPosition();
MRegisterPosition.PositionId = position.PositionId;
MRegisterPosition.NumberOfPosition = position.NumberOfPosition;
MRegisterPosition.ActiveStatus = position.Active;
MRegisterPosition.CrBy = position.Username;
MRegisterPosition.CrDate = DateTime.Now;
MRegisterPosition.UpdBy = position.Username;
MRegisterPosition.UpdDate = DateTime.Now;
MRegisterPosition.TypeEmployee = position.Type_Employee;
Context.ManageRegisterPosition.Add(MRegisterPosition);
Context.SaveChanges();
return("success");
}
catch (Exception e) { throw e; }
}