public bool DeleteSalaryTicketDetail(string id)
{
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_SalaryTicketDetail())
{
var detail = ctx.SalaryTicketDetails.Where(c => c.SalaryTicketID == id).FirstOrDefault();
ctx.Entry(detail).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
return(true);
}
}
public SalaryTicketDetail GetExactSalaryTicketDetails(String id)
{
SalaryTicketDetail searcheddetail = null;
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_SalaryTicketDetail())
{
if (id != null)
{
searcheddetail = ctx.SalaryTicketDetails.Where(c => (c.SalaryTicketID.Equals(id))
).FirstOrDefault <SalaryTicketDetail>();
}
}
return(searcheddetail);
}
public bool CreateSalaryTicketDetail(SalaryTicketDetail salaryTicketDetail)
{
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_SalaryTicketDetail())
{
ctx.SalaryTicketDetails.Add(new SalaryTicketDetail()
{
SalaryTicketID = salaryTicketDetail.SalaryTicketID,
AllowanceID = salaryTicketDetail.AllowanceID,
WorkingTimeID = salaryTicketDetail.WorkingTimeID,
TaxID = salaryTicketDetail.TaxID,
WageTier = salaryTicketDetail.WageTier,
BasicSalary = salaryTicketDetail.BasicSalary,
FinalSalary = salaryTicketDetail.FinalSalary
});
ctx.SaveChanges();
}
return(true);
}
public bool UpdateSalaryTicketDetail(SalaryTicketDetailModel salaryTicketDetail)
{
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_SalaryTicketDetail())
{
var checkExistingTicketDetail = ctx.SalaryTicketDetails.Where(c => c.SalaryTicketID == salaryTicketDetail.SalaryTicketID).FirstOrDefault <SalaryTicketDetail>();
if (checkExistingTicketDetail != null)
{
checkExistingTicketDetail.TaxID = salaryTicketDetail.TaxID;
checkExistingTicketDetail.AllowanceID = salaryTicketDetail.AllowanceID;
checkExistingTicketDetail.WorkingTimeID = salaryTicketDetail.WorkingTimeID;
checkExistingTicketDetail.WageTier = (int)salaryTicketDetail.WageTier;
checkExistingTicketDetail.BasicSalary = (double)salaryTicketDetail.BasicSalary;
checkExistingTicketDetail.FinalSalary = (double)salaryTicketDetail.FinalSalary;
ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public IList <SalaryTicketDetail> GetSalaryTicketDetails(SalaryTicketDetailModel detail)
{
IList <SalaryTicketDetail> listdetail = null;
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_SalaryTicketDetail())
{
if (detail != null)
{
listdetail = ctx.SalaryTicketDetails.Where(c => (c.SalaryTicketID.Contains(detail.SalaryTicketID) || detail.SalaryTicketID == null) &&
(c.AllowanceID.Contains(detail.AllowanceID) || detail.AllowanceID == null) &&
(c.TaxID.Contains(detail.TaxID) || detail.TaxID == null) &&
(c.WorkingTimeID.Contains(detail.WorkingTimeID) || detail.WorkingTimeID == null) &&
(c.WageTier == detail.WageTier || detail.WageTier == null) &&
(c.BasicSalary == detail.BasicSalary || detail.BasicSalary == null) &&
(c.FinalSalary == detail.FinalSalary || detail.FinalSalary == null)
).ToList <SalaryTicketDetail>();
}
else
{
listdetail = ctx.SalaryTicketDetails.ToList <SalaryTicketDetail>();
}
}
return(listdetail);
}
public bool CalculateFinalSalary(SalaryTicketDetailModel salaryTicketDetail)
{
double?taxcoefficient = 1, allowanceMoney = 1, wagecoefficient = 1, workedtime = 1, standardworkingdays = 1, basicsalary = 1, finalsalary = 1;
string periodId = "";
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_Tax())
{
var tax = ctx.PersonalIncomeTaxes.Where(c => c.TaxID == salaryTicketDetail.TaxID).FirstOrDefault <PersonalIncomeTax>();
if (tax != null)
{
taxcoefficient = tax.Coefficient;
}
}
using (var ctx = new SalaryManagement_SWD391_Project_Allowance_Entities())
{
var allowance = ctx.Allowances.Where(c => c.AllowanceID == salaryTicketDetail.AllowanceID).FirstOrDefault <Allowance>();
if (allowance != null)
{
allowanceMoney = Double.Parse(allowance.AllowanceMoney);
}
}
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_Payroll())
{
var payroll = ctx.Payrolls.Where(c => c.WageTier == salaryTicketDetail.WageTier).FirstOrDefault <Payroll>();
if (payroll != null)
{
wagecoefficient = payroll.Coefficient;
}
}
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_WorkingTime())
{
var time = ctx.WorkingTimes.Where(c => c.WorkingTimeID == salaryTicketDetail.WorkingTimeID).FirstOrDefault <WorkingTime>();
if (time != null)
{
workedtime = time.WorkedTime;
}
}
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_SalaryTicket())
{
var ticket = ctx.SalaryTickets.Where(c => c.SalaryTicketID == salaryTicketDetail.SalaryTicketID).FirstOrDefault <SalaryTicket>();
if (ticket != null)
{
periodId = ticket.PeriodID;
}
}
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_Period())
{
var period = ctx.Periods.Where(c => c.PeriodID == periodId).FirstOrDefault <Period>();
if (period != null)
{
standardworkingdays = period.StandardWorkingDays;
}
}
basicsalary = salaryTicketDetail.BasicSalary;
finalsalary = ((basicsalary * wagecoefficient) * (workedtime / standardworkingdays)) - (basicsalary * taxcoefficient) + allowanceMoney;
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_SalaryTicketDetail())
{
var checkExistingTicketDetail = ctx.SalaryTicketDetails.Where(c => c.SalaryTicketID == salaryTicketDetail.SalaryTicketID).FirstOrDefault <SalaryTicketDetail>();
if (checkExistingTicketDetail != null)
{
checkExistingTicketDetail.FinalSalary = finalsalary;
ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
