/// <summary>
/// Update payroll
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static PayrollInfoModel Update(PayrollInfoModel model)
{
var entity = new sal_PayrollInfo();
// set entity props
model.FillEntity(ref entity);
// update
return(new PayrollInfoModel(sal_PayrollInfoServices.Update(entity)));
}
/// <summary>
/// Create payroll
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static PayrollInfoModel Create(PayrollInfoModel model)
{
// init new entity
var entity = new sal_PayrollInfo();
// set entity props
model.FillEntity(ref entity);
// insert
return(new PayrollInfoModel(sal_PayrollInfoServices.Create(entity)));
}
public void SaveData(string json)
{
// get payroll
_payroll = PayrollController.GetById(int.Parse(hdfPayrollId.Text));
if (_payroll == null)
{
return;
}
// save data
_payroll.Data = json;
var table = PayrollController.GetPayrollDetail(null, _payroll.Id, null, null);
if (table.Rows.Count > 0)
{
for (var i = 0; i < table.Rows.Count; i++)
{
//save payrollInfo
var payrollInfo = new PayrollInfoModel()
{
SalaryBoardId = _payroll.Id,
RecordId = table.Rows[i]["RecordId"] != null?Convert.ToInt32(table.Rows[i]["RecordId"].ToString()) : 0,
TotalIncome = 0,
IndividualTax = 0,
EnterpriseSocial = 0,
LaborerSocial = 0,
ActualSalary = 0,
Month = _payroll.Month,
Year = _payroll.Year,
CreatedBy = "admin",
CreatedDate = DateTime.Now,
EditedBy = "",
EditedDate = DateTime.Now,
IsDeleted = false
};
//check exist column
if (table.Columns.Contains("{0}".FormatWith(Constant.IndividualTax)))
{
payrollInfo.IndividualTax = table.Rows[i]["IndividualTax"] != null
? Convert.ToDecimal(table.Rows[i]["IndividualTax"].ToString())
: 0;
}
if (table.Columns.Contains("{0}".FormatWith(Constant.TotalIncome)))
{
payrollInfo.TotalIncome = table.Rows[i]["TotalIncome"] != null
? Convert.ToInt32(table.Rows[i]["TotalIncome"].ToString())
: 0;
}
if (table.Columns.Contains("{0}".FormatWith(Constant.EnterpriseSocialInsurance)))
{
payrollInfo.EnterpriseSocial = table.Rows[i]["EnterpriseSocialInsurance"] != null
? Convert.ToInt32(table.Rows[i]["EnterpriseSocialInsurance"].ToString())
: 0;
}
if (table.Columns.Contains("{0}".FormatWith(Constant.LaborerSocialInsurance)))
{
payrollInfo.LaborerSocial = table.Rows[i]["LaborerSocialInsurance"] != null
? Convert.ToInt32(table.Rows[i]["LaborerSocialInsurance"].ToString())
: 0;
}
if (table.Columns.Contains("{0}".FormatWith(Constant.ActualSalary)))
{
payrollInfo.ActualSalary = table.Rows[i]["ActualSalary"] != null
? Convert.ToInt32(table.Rows[i]["ActualSalary"].ToString())
: 0;
}
var checkExistModel = PayrollInfoController.GetUnique(payrollInfo.SalaryBoardId, payrollInfo.RecordId, payrollInfo.Month, payrollInfo.Year);
if (checkExistModel != null)
{
payrollInfo.Id = checkExistModel.Id;
payrollInfo.EditedDate = DateTime.Now;
payrollInfo.EditedBy = CurrentUser.User.UserName;
//update
PayrollInfoController.Update(payrollInfo);
}
else
{
//create
PayrollInfoController.Create(payrollInfo);
}
}
}
// update payroll
PayrollController.Update(_payroll);
}
