public static HR_ProvidentFundRegister GetHR_RowStatusByRowStatusID(int RowStatusID)
{
HR_ProvidentFundRegister hR_ProvidentFundRegister = new HR_ProvidentFundRegister();
SqlHR_ProvidentFundRegisterProvider sqlHR_ProvidentFundRegisterProvider = new SqlHR_ProvidentFundRegisterProvider();
hR_ProvidentFundRegister = sqlHR_ProvidentFundRegisterProvider.GetHR_ProvidentFundRegisterByRowStatusID(RowStatusID);
return hR_ProvidentFundRegister;
}
public static HR_ProvidentFundRegister GetHR_ProvidentFundRegisterByProvidentFundRegisterID(int ProvidentFundRegisterID)
{
HR_ProvidentFundRegister hR_ProvidentFundRegister = new HR_ProvidentFundRegister();
SqlHR_ProvidentFundRegisterProvider sqlHR_ProvidentFundRegisterProvider = new SqlHR_ProvidentFundRegisterProvider();
hR_ProvidentFundRegister = sqlHR_ProvidentFundRegisterProvider.GetHR_ProvidentFundRegisterByProvidentFundRegisterID(ProvidentFundRegisterID);
return hR_ProvidentFundRegister;
}
public static HR_ProvidentFundRegister GetHR_ProvidentFundRegisterByEmployeeID(string EmployeeID)
{
HR_ProvidentFundRegister hR_ProvidentFundRegister = new HR_ProvidentFundRegister();
SqlHR_ProvidentFundRegisterProvider sqlHR_ProvidentFundRegisterProvider = new SqlHR_ProvidentFundRegisterProvider();
hR_ProvidentFundRegister = sqlHR_ProvidentFundRegisterProvider.GetHR_ProvidentFundRegisterByEmployeeID(EmployeeID);
return hR_ProvidentFundRegister;
}
protected void btnPost_Click(object sender, EventArgs e)
{
try
{
int newEntry = 0;
int prevEntry = 0;
string userID = Profile.card_id;
List<string> newPostings = new List<string>();
List<string> prevPostings = new List<string>();
foreach (GridViewRow row in gvSalaryDetailBreakdown.Rows)
{
CheckBox chkBox = (CheckBox)row.FindControl("chkBoxSelect");
if (chkBox.Checked)
{
HiddenField hfEmployID = (HiddenField)row.FindControl("hfEmployID");
Label lblTotalSalary = (Label)row.FindControl("lblTotalSalary");
Label lblEmployeeName = (Label)row.FindControl("lblEmployeeName");
Label lblPFAmount = (Label)row.FindControl("lblPFAmount");
Label lblSecurityAmount = (Label)row.FindControl("lblSecurityAmount");
GridView gridViewSalaryBreakdown = (GridView)row.FindControl("gvSalaryOnly");
TextBox txtLoanDeduction = (TextBox)row.FindControl("txtLoanDeduction");
Label lbGrandTotal = (Label)row.FindControl("lblGrandTotal");
ACC_EmployPayRoleSalary paySalary = new ACC_EmployPayRoleSalary();
paySalary.AddedBy = userID;
paySalary.AddedDate = DateTime.Now;
paySalary.UpdatedBy = userID;
paySalary.UpdatedDate = DateTime.Now;
paySalary.EmployeeID = hfEmployID.Value;
paySalary.SalaryAmount = Convert.ToDecimal(lbGrandTotal.Text);
paySalary.PaidSalaryAmount = Convert.ToDecimal("0");
paySalary.UnpaidSalaryAmount = Convert.ToDecimal(lbGrandTotal.Text);
paySalary.Status = 1;
paySalary.RowStatusID = 1;
paySalary.SalaryOfDate = ddlMonths.SelectedItem.Text + ", " + ddlYears.SelectedValue;
string salBreakDownHistory = string.Empty;
foreach (GridViewRow salBreakRow in gridViewSalaryBreakdown.Rows)
{
Label lblDescription = (Label)salBreakRow.FindControl("lblDescription");
Label lblSalaryValue = (Label)salBreakRow.FindControl("lblSalaryValue");
salBreakDownHistory += lblDescription.Text + ":" + lblSalaryValue.Text+";";
}
paySalary.ExtraField1 = salBreakDownHistory;
paySalary.ExtraField2 = lblTotalSalary.Text.Trim();
paySalary.ExtraField3 = string.Empty;
paySalary.ExtraField4 = string.Empty;
paySalary.ExtraField5 = string.Empty;
paySalary.ExtraField6 = string.Empty;
paySalary.ExtraField7 = string.Empty;
paySalary.ExtraField8 = Convert.ToDecimal(lbGrandTotal.Text).ToString("0.0");
paySalary.ExtraField9 = string.Empty;
paySalary.ExtraField10 = string.Empty;
int insertedID = ACC_EmployPayRoleSalaryManager.InsertEmployPayRoleSalary(paySalary);
if (insertedID > 0)
{
List<HR_ProvidentFundRegister> providentFundRegisterColl = new List<HR_ProvidentFundRegister>();
HR_ProvidentFundRegister pfRegister = new HR_ProvidentFundRegister();
pfRegister.EmployeeID = hfEmployID.Value;
pfRegister.ExtraField1 = insertedID.ToString();
pfRegister.PayrollMonthDate = Convert.ToDateTime(DateTime.DaysInMonth(Convert.ToInt32(ddlYears.SelectedValue), Convert.ToInt32(ddlMonths.SelectedValue)) + " " + ddlMonths.SelectedItem.Text + " " + ddlYears.SelectedValue);
pfRegister.EPF = Convert.ToDecimal(lblPFAmount.Text);
pfRegister.CPF = Convert.ToDecimal(lblPFAmount.Text);
pfRegister.ExtraField2 = paySalary.ExtraField8;
pfRegister.TotalPFAmount = pfRegister.EPF + pfRegister.CPF;
//pfRegister.WithdrawLastDate = Nullable<DateTime>;
pfRegister.AddedBy = userID;
pfRegister.AddedDate = DateTime.Now;
pfRegister.RowStatusID = 1;
providentFundRegisterColl.Add(pfRegister);
HR_ProvidentFundRegisterManager.InsertHR_ProvidentFundRegister(providentFundRegisterColl);
providentFundRegisterColl.Clear();
if (Convert.ToDecimal(lblPFAmount.Text) != 0)
{
ACC_Journal pfACC_Journal = new ACC_Journal();
pfACC_Journal.UserID = hfEmployID.Value;
pfACC_Journal.Balance = Convert.ToDecimal(lblPFAmount.Text);
pfACC_Journal.AddedBy = userID;
pfACC_Journal.AddedDate = DateTime.Now;
pfACC_Journal.UpdatedBy = userID;
pfACC_Journal.UpdateDate = DateTime.Now;
pfACC_Journal.EmployPayRoleSalaryID = insertedID;
ACC_AccountingCommonManager.ProcessACC_ProvidentFund(hfEmployID.Value, pfACC_Journal);
}
if (Convert.ToDecimal(lblSecurityAmount.Text) != 0)
{
ACC_Journal pfACC_Journal = new ACC_Journal();
pfACC_Journal.UserID = hfEmployID.Value;
pfACC_Journal.Balance = Convert.ToDecimal(lblSecurityAmount.Text);
pfACC_Journal.AddedBy = userID;
pfACC_Journal.AddedDate = DateTime.Now;
pfACC_Journal.UpdatedBy = userID;
pfACC_Journal.UpdateDate = DateTime.Now;
pfACC_Journal.EmployPayRoleSalaryID = insertedID;
ACC_AccountingCommonManager.ProcessACC_SecurityAmount(hfEmployID.Value, pfACC_Journal);
}
if (txtLoanDeduction.Text.Trim() != string.Empty)
{
ACC_Journal advSalaryACC_Journal = new ACC_Journal();
advSalaryACC_Journal.UserID = hfEmployID.Value;
advSalaryACC_Journal.Balance = Convert.ToDecimal(txtLoanDeduction.Text);
advSalaryACC_Journal.AddedBy = userID;
advSalaryACC_Journal.AddedDate = DateTime.Now;
advSalaryACC_Journal.UpdatedBy = userID;
advSalaryACC_Journal.UpdateDate = DateTime.Now;
advSalaryACC_Journal.SalaryOfDate = paySalary.SalaryOfDate;
ACC_AccountingCommonManager.ProcessACC_AdvanceSalary(hfEmployID.Value, advSalaryACC_Journal);
}
newEntry++;
//"<td>" + hfEmployID.Value + "</td>"
newPostings.Add("<td>" + lblEmployeeName.Text + "</td>");
}
else
{
prevEntry++;
//<td>" + hfEmployID.Value + "</td>
prevPostings.Add("<td>" + lblEmployeeName.Text + "</td>");
}
}
}
litSummary.Text = "<table style=\"width:50%;float:left;\"><tr><td style=\"color:Green;font-weight:bold;\">New Postings</td></tr>";
foreach (string entity in newPostings)
{
litSummary.Text += "<tr>"+entity+"</tr>";
}
if (newPostings.Count == 0)
litSummary.Text += "<td>No New Postings</td>";
litSummary.Text += "</table>";
litSummary.Text += "<table style=\"width:50%;float:left;\"><tr><td style=\"color:Green;font-weight:bold;\">Posted Before</td></tr>";
foreach (string entity in prevPostings)
{
litSummary.Text += "<tr>" + entity + "</tr>";
}
if (prevPostings.Count == 0)
litSummary.Text += "<td>No Old Postings</td>";
litSummary.Text += "</table>";
string scriptText = "alert('New Entry : " + newEntry.ToString() + " Old Entry : " + prevEntry.ToString() + "');";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "Summary", scriptText, true);
}
catch (Exception ex)
{
if (ex != null)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "Error", ex.Message, true);
}
}
}
protected void btnJournalEntry_Click(object sender, EventArgs e)
{
if (Request.QueryString["ID"] != null)
{
#region Update preentry process
HR_Employee employee = new HR_Employee();
employee.EmployeeID = Convert.ToString(Request.QueryString["ID"]);
employee.ResignDescription = txtResignDescription.Text.Trim();
employee.ResignDate = Convert.ToDateTime(txtResignDate.Text.Trim());
employee.Flag = false;
string userID = Profile.card_id;
employee.ModifiedBy = userID;
employee.ModifiedDate = DateTime.Now;
HR_ProvidentFundRegister providentFundRegister = new HR_ProvidentFundRegister();
if (lblEmpPortionFund.Text.Trim() != string.Empty)
{
providentFundRegister.EmployeeID = Convert.ToString(Request.QueryString["ID"]);
providentFundRegister.PayrollMonthDate = DateTime.Now;
providentFundRegister.WithdrawAmount = Convert.ToDecimal(lblEmpPortionFund.Text.Trim());
providentFundRegister.WithdrawLastDate = DateTime.Now;
providentFundRegister.AddedBy = userID;
providentFundRegister.AddedDate = DateTime.Now;
}
bool isUpdate = HR_EmployeeManager.UpdateHR_EmployeeResignInfo(employee);
if (isUpdate)
{
if (providentFundRegister.EmployeeID != string.Empty)
{
HR_ProvidentFundRegisterManager.InsertHR_ProvidentFundRegisterWithdrawAmount(providentFundRegister);
}
lblMessage.Text = "Information is saved successfully";
lblMessage.ForeColor = System.Drawing.Color.Green;
}
if (Convert.ToDecimal(txtRemainingSalary.Text) > 0)
{
ACC_EmployPayRoleSalary paySalary = new ACC_EmployPayRoleSalary();
paySalary.AddedBy = userID;
paySalary.AddedDate = DateTime.Now;
paySalary.UpdatedBy = userID;
paySalary.UpdatedDate = DateTime.Now;
paySalary.EmployeeID = Request.QueryString["ID"];
paySalary.SalaryAmount = Convert.ToDecimal(txtRemainingSalary.Text);
paySalary.PaidSalaryAmount = Convert.ToDecimal("0");
paySalary.UnpaidSalaryAmount = Convert.ToDecimal(txtRemainingSalary.Text);
paySalary.Status = 35;
paySalary.RowStatusID = 1;
paySalary.SalaryOfDate = DateTime.Parse(txtResignDate.Text).ToString("MMMM, yyyy");
paySalary.ExtraField1 = lblSalaryBreakDown.Text;
paySalary.ExtraField2 = paySalary.SalaryAmount.ToString("00");
paySalary.ExtraField3 = string.Empty;
paySalary.ExtraField4 = string.Empty;
paySalary.ExtraField5 = string.Empty;
paySalary.ExtraField6 = string.Empty;
paySalary.ExtraField7 = string.Empty;
paySalary.ExtraField8 = string.Empty;
paySalary.ExtraField9 = string.Empty;
paySalary.ExtraField10 = string.Empty;
int insertedID = ACC_EmployPayRoleSalaryManager.InsertEmployPayRoleSalary(paySalary);
}
#endregion
#region Journal entry
List<ACC_Journal> doubleEntry = new List<ACC_Journal>();
doubleEntry = (List<ACC_Journal>)Session["doubleEntry"];
List<ACC_CUCCheck> cucChecks = new List<ACC_CUCCheck>();
if (Session["cucCheck"] != null) cucChecks = (List<ACC_CUCCheck>)Session["cucCheck"];
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = "";
aCC_JournalMaster.AddedBy = Profile.card_id;
aCC_JournalMaster.AddedDate = DateTime.Now;
aCC_JournalMaster.UpdatedBy = Profile.card_id;
aCC_JournalMaster.UpdateDate = DateTime.Now;
aCC_JournalMaster.RowStatusID = 1;
aCC_JournalMaster.JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
if (doubleEntry != null)
{
foreach (ACC_Journal eachJournal in doubleEntry)
{
int temp = eachJournal.JournalID;
string checkno = eachJournal.JournalVoucherNo;
eachJournal.JournalVoucherNo = "";
eachJournal.JournalMasterID = aCC_JournalMaster.JournalMasterID;
eachJournal.JournalID = ACC_JournalManager.InsertACC_Journal(eachJournal);
foreach (ACC_CUCCheck cucCheck in cucChecks)
{
if (temp == cucCheck.PaytoHeadID)
{
cucCheck.PaytoHeadID = eachJournal.JournalID;
ACC_CUCCheckManager.InsertACC_CUCCheck(cucCheck);
}
}
}
}
if (Session["cucCheck"] != null) Session.Remove("cucCheck");
if (Session["doubleEntry"] != null) Session.Remove("doubleEntry");
#endregion
/*
* <option value="46">Employee Provident Fund</option>
* <option value="47" selected="selected">Company Provident Fund</option>
* <option value="3" selected="selected">Advance Salary</option>
* <option value="17" selected="selected">Employee(Fulltime) Salary</option>
* <option value="49" selected="selected">Allowance (Provident Fund)</option>
*/
decimal advanceSalaryAmount = decimal.Parse(txtAdvanceSalary.Text);
decimal salaryOfthisMonth = decimal.Parse(txtSalaryOfThisMonth.Text);
decimal totalJournalEntryMoney = decimal.Parse(txtFinalAmountToWithDraw.Text);
decimal EPFMoney = decimal.Parse(txtEmpContributionAmount.Text);
decimal CPFMoney =decimal.Parse(lblEmpPortionFund.Text) - decimal.Parse(txtEmpContributionAmount.Text);
//CPF need to process
//Refund CPF
if (decimal.Parse(lblReturnFundToCompany.Text) > 0)
{
processRefundCPF(decimal.Parse(lblReturnFundToCompany.Text));
}
#region Advance Salary process
//advance salary deduction form the fulltime salary
if (advanceSalaryAmount > 0)
{
if (salaryOfthisMonth > 0)
{
if (advanceSalaryAmount <= salaryOfthisMonth)
{
processAdvanceSalary(advanceSalaryAmount);
advanceSalaryAmount = 0;
salaryOfthisMonth -= advanceSalaryAmount;
}
else
{
processAdvanceSalary(salaryOfthisMonth);
salaryOfthisMonth = 0;
advanceSalaryAmount -= salaryOfthisMonth;
}
}
}
//remaining salary deduction from the Employee Provident fund contribution
if (advanceSalaryAmount > 0)
{
if (EPFMoney > 0)
{
if (advanceSalaryAmount <= EPFMoney)
{
processAdvanceSalaryFromEPF(advanceSalaryAmount);
advanceSalaryAmount = 0;
EPFMoney -= advanceSalaryAmount;
}
else
{
processAdvanceSalaryFromEPF(EPFMoney);
EPFMoney = 0;
advanceSalaryAmount -= EPFMoney;
}
}
}
bool IsNeedtoCollectMoneyFortheAdvanceSalary = false;
//remaining salary deduction from the Company Provident fund contribution
if (advanceSalaryAmount > 0)
{
if (CPFMoney > 0)
{
if (advanceSalaryAmount <= CPFMoney)
{
processAdvanceSalaryFromCPF(advanceSalaryAmount);
advanceSalaryAmount = 0;
CPFMoney -= advanceSalaryAmount;
}
else
{
processAdvanceSalaryFromCPF(EPFMoney);
CPFMoney = 0;
advanceSalaryAmount -= CPFMoney;
IsNeedtoCollectMoneyFortheAdvanceSalary = true;
}
}
}
#endregion
#region Fulltime Salary Process
if (salaryOfthisMonth > 0)
{
processFullTimeSalary(salaryOfthisMonth, aCC_JournalMaster.JournalMasterID);
totalJournalEntryMoney -= salaryOfthisMonth;
salaryOfthisMonth = 0;
}
#endregion
#region EPF Process
if (EPFMoney > 0)
{
processEPF(EPFMoney, aCC_JournalMaster.JournalMasterID);
totalJournalEntryMoney -= EPFMoney;
EPFMoney = 0;
}
#endregion
#region CPF Process
if (CPFMoney > 0)
{
processCPF(CPFMoney, aCC_JournalMaster.JournalMasterID);
totalJournalEntryMoney -= CPFMoney;
CPFMoney = 0;
}
#endregion
if (decimal.Parse(txtSalaryOfThisMonth.Text) > 0)
{
DataSet dsHeadUserFulltimeSalary = ACC_HeadUserManager.GetACC_UserByUserIDnUserTypeIDnAccountID(hfEmployeeID.Value, 2, int.Parse(ddlAccountForMoney.SelectedValue));
}
//if (IsNeedtoCollectMoneyFortheAdvanceSalary)
//{
// Response.Redirect("");
//}
btnJournalEntry.Visible = false;
}
}
public bool UpdateHR_ProvidentFundRegister(HR_ProvidentFundRegister hR_ProvidentFundRegister)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_ProvidentFundRegister", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ProvidentFundRegisterID", SqlDbType.Int).Value = hR_ProvidentFundRegister.ProvidentFundRegisterID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.EmployeeID;
cmd.Parameters.Add("@PayrollMonthDate", SqlDbType.DateTime).Value = hR_ProvidentFundRegister.PayrollMonthDate;
cmd.Parameters.Add("@EPF", SqlDbType.Money).Value = hR_ProvidentFundRegister.EPF;
cmd.Parameters.Add("@CPF", SqlDbType.Money).Value = hR_ProvidentFundRegister.CPF;
cmd.Parameters.Add("@TotalPFAmount", SqlDbType.Money).Value = hR_ProvidentFundRegister.TotalPFAmount;
cmd.Parameters.Add("@WithdrawAmount", SqlDbType.Money).Value = hR_ProvidentFundRegister.WithdrawAmount;
cmd.Parameters.Add("@WithdrawLastDate", SqlDbType.DateTime).Value = hR_ProvidentFundRegister.WithdrawLastDate;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField5;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_ProvidentFundRegister.ModifiedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = hR_ProvidentFundRegister.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertHR_ProvidentFundRegisterWithdrawAmount(HR_ProvidentFundRegister hR_ProvidentFundRegister)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertHR_ProvidentFundRegisterWithdrawAmount", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ProvidentFundRegisterID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.EmployeeID;
cmd.Parameters.Add("@PayrollMonthDate", SqlDbType.DateTime).Value = hR_ProvidentFundRegister.PayrollMonthDate;
cmd.Parameters.Add("@EPF", SqlDbType.Money).Value = 0;
cmd.Parameters.Add("@CPF", SqlDbType.Money).Value =0;
cmd.Parameters.Add("@TotalPFAmount", SqlDbType.Money).Value = 0;
cmd.Parameters.Add("@WithdrawAmount", SqlDbType.Money).Value = hR_ProvidentFundRegister.WithdrawAmount;
cmd.Parameters.Add("@WithdrawLastDate", SqlDbType.DateTime).Value = hR_ProvidentFundRegister.WithdrawLastDate;//hR_ProvidentFundRegister.WithdrawLastDate == DateTime.MinValue ? (object)DBNull.Value : hR_ProvidentFundRegister.WithdrawLastDate;
//cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField1;
//cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField2;
//cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField3;
//cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField4;
//cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_ProvidentFundRegister.AddedDate;
//cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_ProvidentFundRegister.ModifiedBy;
//cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_ProvidentFundRegister.ModifiedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = hR_ProvidentFundRegister.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
int outValue = (int)cmd.Parameters["@ProvidentFundRegisterID"].Value;
return outValue;
}
}
public HR_ProvidentFundRegister GetHR_ProvidentFundRegisterFromReader(IDataReader reader)
{
try
{
HR_ProvidentFundRegister hR_ProvidentFundRegister = new HR_ProvidentFundRegister
(
DataAccessObject.IsNULL<int>(reader["ProvidentFundRegisterID"]),
DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["PayrollMonthDate"]),
DataAccessObject.IsNULL<decimal>(reader["EPF"]),
DataAccessObject.IsNULL<decimal>(reader["CPF"]),
DataAccessObject.IsNULL<decimal>(reader["TotalPFAmount"]),
DataAccessObject.IsNULL<decimal>(reader["WithdrawAmount"]),
DataAccessObject.IsNULL<DateTime>(reader["WithdrawLastDate"]),
DataAccessObject.IsNULL<string>(reader["ExtraField1"]),
DataAccessObject.IsNULL<string>(reader["ExtraField2"]),
DataAccessObject.IsNULL<string>(reader["ExtraField3"]),
DataAccessObject.IsNULL<string>(reader["ExtraField4"]),
DataAccessObject.IsNULL<string>(reader["ExtraField5"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
return hR_ProvidentFundRegister;
}
catch(Exception ex)
{
return null;
}
}
public static int InsertHR_ProvidentFundRegister(HR_ProvidentFundRegister hR_ProvidentFundRegister)
{
SqlHR_ProvidentFundRegisterProvider sqlHR_ProvidentFundRegisterProvider = new SqlHR_ProvidentFundRegisterProvider();
return sqlHR_ProvidentFundRegisterProvider.InsertHR_ProvidentFundRegister(hR_ProvidentFundRegister);
}
public static bool UpdateHR_ProvidentFundRegister(HR_ProvidentFundRegister hR_ProvidentFundRegister)
{
SqlHR_ProvidentFundRegisterProvider sqlHR_ProvidentFundRegisterProvider = new SqlHR_ProvidentFundRegisterProvider();
return sqlHR_ProvidentFundRegisterProvider.UpdateHR_ProvidentFundRegister(hR_ProvidentFundRegister);
}
