public ActionResult CreatePayroll(int EmployeeID)
{
Employee em = infoWeb.GetEmployeeByID(EmployeeID);
Account acc = infoWeb.GetAccountByEmail(em.Email);
BasicSalary basicSalary = infoWeb.GetBasicSalaryByEmployeeID(EmployeeID);
Salary salary = infoWeb.GetSalaryBySalaryID(basicSalary.SalaryID);
ConvertAccount c = new ConvertAccount();
ViewData["EmployeeID"] = EmployeeID;
ViewData["EmployeeName"] = em.Name;
ViewData["PositionDisplay"] = c.ConvertAccType(acc.AccType) + " " + c.ConvertPosition(acc.Position);
ViewData["Position"] = acc.AccType + " " + acc.Position;
ViewData["SalaryType"] = salary.Type;
ViewData["BasicSalary"] = salary.UnitPrice;
bool result = info.CheckTimeSheetOfEmployee(EmployeeID);
if (result == false)
{
ViewData["WorkDay"] = 0;
}
else
{
TimeSheet timeSheet = info.GetTimeSheetByEmployeeID(EmployeeID);
ViewData["WorkDay"] = timeSheet.TotalDay;
}
return(View());
}
public bool CheckBasicSalaryOfEmployee(int EmployeeID)
{
BasicSalary bs = (from basicSalary in context.BasicSalaries
where basicSalary.EmployeeID == EmployeeID
select basicSalary).SingleOrDefault();
return(true);
}
public ActionResult EditPayrollOfEmployee(int PayrollID)
{
Payroll payroll = info.GetPayrollByPayrollID(PayrollID);
BasicSalary bs = infoWeb.GetBasicSalaryByEmployeeID(payroll.EmployeeID);
Salary salary = infoWeb.GetSalaryBySalaryID(bs.SalaryID);
ViewData["SalaryType"] = salary.Type;
ViewData["PayrollID"] = PayrollID;
return(View(payroll));
}
public bool DeleteBasicSalary(int EmployeeID)
{
try
{
BasicSalary basicSalary = context.BasicSalaries.FirstOrDefault(bs => bs.EmployeeID == EmployeeID);
context.BasicSalaries.DeleteOnSubmit(basicSalary);
context.SubmitChanges();
return(true);
}
catch (Exception e)
{
throw new Exception("Error Delete BasicSalary: " + e.Message);
}
}
public bool UpdateBasicSalary(int EmployeeID, int SalaryID)
{
try
{
BasicSalary basicSalary = context.BasicSalaries.FirstOrDefault(bs => bs.EmployeeID == EmployeeID);
basicSalary.SalaryID = SalaryID;
context.SubmitChanges();
return(true);
}
catch (Exception e)
{
throw new Exception("Error Update BasicSalary: " + e.Message);
}
}
public BasicSalary GetBasicSalaryByEmployeeID(int EmployeeID)
{
try
{
BasicSalary bs = (from basicSalary in context.BasicSalaries
where basicSalary.EmployeeID == EmployeeID
select basicSalary).SingleOrDefault();
return(bs);
}
catch (Exception e)
{
return(null);
}
}
public bool InsertBasicSalary(int EmployeeID, int SalaryID)
{
try
{
BasicSalary basicSalary = new BasicSalary();
basicSalary.EmployeeID = EmployeeID;
basicSalary.SalaryID = SalaryID;
this.context.BasicSalaries.InsertOnSubmit(basicSalary);
context.SubmitChanges();
return(true);
}
catch (Exception e)
{
throw new Exception("Error Insert BasicSalary: " + e.Message);
}
}
public static Salary FromBasic(BasicSalary basic)
{
return(new Salary(basic));
}
internal Salary(BasicSalary basic) : base(basic)
{
// private ctor
}
private void Checked(object sender, RoutedEventArgs e)
{
BasicSalary.IsEnabled = true;
BasicSalary.Focus();
}
