// POST: api/Login
public void Post
(
string Name
, string LastNames
, string Email
, string Password
, string RoleID
, bool Active
, float BaseSalary
, float BreakfastDeduction
, float SavingDeduction
)
{
try
{
Employees_Tab employees = new Employees_Tab();
employees.Name = Name;
employees.LastNames = LastNames;
employees.Email = Email;
employees.Password = Password;
employees.RoleID = (int?)int.Parse(RoleID);
employees.Active = Active;
employees.AdmissionDate = DateTime.Now;
PayRollDB.Employees_Tab.Add(employees);
PayRollDB.SaveChanges();
string lastInserted = PayRollDB.Employees_Tab.OrderByDescending(bt => bt.EmployeeID).Take(1).Select(bt => bt.EmployeeID).FirstOrDefault().ToString();
PayRollInfo_Tab payRollInfo = new PayRollInfo_Tab();
payRollInfo.EmployeeID = int.Parse(lastInserted);
payRollInfo.BaseSalary = decimal.Parse(BaseSalary.ToString());
payRollInfo.BreakfastDeduction = decimal.Parse(BreakfastDeduction.ToString());
payRollInfo.SavingDeduction = decimal.Parse(SavingDeduction.ToString());
payRollInfo.CreationDate = DateTime.Now;
payRollInfo.Active = Active;
PayRollDB.PayRollInfo_Tab.Add(payRollInfo);
PayRollDB.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
// DELETE: api/Login/5
public void Delete(int id)
{
try
{
PayRollInfo_Tab payRollInfo = PayRollDB.PayRollInfo_Tab.Where(bt => bt.EmployeeID == id).FirstOrDefault();
PayRollDB.PayRollInfo_Tab.Remove(payRollInfo);
PayRollDB.SaveChanges();
Employees_Tab employees = PayRollDB.Employees_Tab.Where(bt => bt.EmployeeID == id).FirstOrDefault();
PayRollDB.Employees_Tab.Remove(employees);
PayRollDB.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Updates a PayRollInfo for an employee within Employee PayRoll
/// </summary>
/// <param name="payRollInfo_">PayRollInfo to add to current Employee</param>
/// <returns></returns>
public Responser Put([FromBody] AM_PayRollInfo payRollInfo_)
{
try
{
PayRollDB = new PayRollDB_();
responser_ = this.ValidateAuthorization(payRollInfo_.Token.ToString());
if (responser_.Data.Get <bool>())
{
PayRollInfo_Tab payRollInfo = PayRollDB.PayRollInfo_Tab.Where(bt => bt.EmployeeID == payRollInfo_.EmployeeID).FirstOrDefault();
if (payRollInfo != null)
{
payRollInfo.BaseSalary = payRollInfo_.BaseSalary;
payRollInfo.BreakfastDeduction = payRollInfo_.BreakfastDeduction;
payRollInfo.SavingDeduction = payRollInfo_.SavingDeduction;
PayRollDB.SaveChanges();
responser_.StatusMessage = "Operation Put for PayRollInfo successfully.";
responser_.Data = payRollInfo_.PayRollInfoID;
}
else
{
responser_.StatusMessage = "PayRollInfo not found: Operation Put for PayRollInfo Failed.";
responser_.Data = payRollInfo_.PayRollInfoID;
}
responser_.Status = 0;
}
return(responser_);
}
catch (Exception e)
{
responser_.Data = null;
responser_.Status = -1;
responser_.StatusMessage = e.Message.ToString();
return(responser_);
}
}
// PUT: api/Login
public void Put
(
int EmployeeID
, string Name
, string LastNames
, string Email
, string Password
, string RoleID
, bool Active
, float BaseSalary
, float BreakfastDeduction
, float SavingDeduction
)
{
try
{
Employees_Tab employees = PayRollDB.Employees_Tab.Where(bt => bt.EmployeeID == EmployeeID).FirstOrDefault();
employees.Name = Name;
employees.LastNames = LastNames;
employees.Email = Email;
employees.Password = Password;
employees.RoleID = (int?)int.Parse(RoleID);
employees.Active = Active;
PayRollDB.SaveChanges();
PayRollInfo_Tab payRollInfo = PayRollDB.PayRollInfo_Tab.Where(bt => bt.EmployeeID == EmployeeID).FirstOrDefault();
payRollInfo.BaseSalary = decimal.Parse(BaseSalary.ToString());
payRollInfo.BreakfastDeduction = decimal.Parse(BreakfastDeduction.ToString());
payRollInfo.SavingDeduction = decimal.Parse(SavingDeduction.ToString());
PayRollDB.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Adds a PayRollInfo for an employee within Employee PayRoll
/// </summary>
/// <param name="payRollInfo_">PayRollInfo to add to current Employee</param>
/// <returns></returns>
public Responser Post([FromBody] AM_PayRollInfo payRollInfo_)
{
try
{
PayRollDB = new PayRollDB_();
responser_ = this.ValidateAuthorization(payRollInfo_.Token.ToString());
if (responser_.Data.Get <bool>())
{
PayRollInfo_Tab payRollInfo = new PayRollInfo_Tab();
payRollInfo.EmployeeID = payRollInfo_.EmployeeID;
payRollInfo.BaseSalary = payRollInfo_.BaseSalary;
payRollInfo.BreakfastDeduction = payRollInfo_.BreakfastDeduction;
payRollInfo.SavingDeduction = payRollInfo_.SavingDeduction;
payRollInfo.CreationDate = DateTime.Now;
payRollInfo.Active = payRollInfo_.Active;
PayRollDB.PayRollInfo_Tab.Add(payRollInfo);
PayRollDB.SaveChanges();
string lastInserted = PayRollDB.PayRollInfo_Tab.OrderByDescending(bt => bt.PayRollInfoID).Take(1).Select(bt => bt.PayRollInfoID).FirstOrDefault().ToString();
responser_.Data = lastInserted;
responser_.Status = 0;
responser_.StatusMessage = "Operation Post for PayRollInfo successfully.";
}
return(responser_);
}
catch (Exception e)
{
responser_.Data = null;
responser_.Status = -1;
responser_.StatusMessage = e.Message.ToString();
return(responser_);
}
}
