protected void Undo_Click(object sender, EventArgs e)
{
DBFilter filter = sbinding.createFilter();
filter.add("EmpID", true);
filter.add(new IN("PayRecID", "Select PayRecID from " + EPaymentRecord.db.dbclass.tableName + " pr", new DBFilter()));
ArrayList CNDList = EClaimsAndDeductions.db.select(dbConn, filter);
if (CNDList.Count > 0)
{
PageErrors errors = PageErrors.getErrors(db, Page.Master);
errors.clear();
int curEmpID = 0;
errors.addError(HROne.Translation.PageErrorMessage.ERROR_CND_IMPORT_BATCH_PAYROLL_PROCESSING);
foreach (EClaimsAndDeductions CND in CNDList)
{
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = CND.EmpID;
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
if (curEmpID != CND.EmpID)
{
errors.addError("- " + empInfo.EmpNo + ", " + empInfo.EmpEngFullName);
curEmpID = CND.EmpID;
}
}
}
errors.addError(HROne.Translation.PageErrorMessage.ERROR_ACTION_ABORT);
return;
}
else
{
CNDList = EClaimsAndDeductions.db.select(dbConn, sbinding.createFilter());
WebUtils.StartFunction(Session, FUNCTION_CODE);
foreach (EClaimsAndDeductions CND in CNDList)
{
db.delete(dbConn, CND);
}
EClaimsAndDeductionsImportBatch batch = new EClaimsAndDeductionsImportBatch();
batch.CNDImportBatchID = CurID;
if (EClaimsAndDeductionsImportBatch.db.select(dbConn, batch))
{
EClaimsAndDeductionsImportBatch.db.delete(dbConn, batch);
}
WebUtils.EndFunction(dbConn);
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Payroll_CND_Import_History.aspx");
}
}
protected bool loadObject()
{
EClaimsAndDeductionsImportBatch obj = new EClaimsAndDeductionsImportBatch();
bool isNew = WebFormWorkers.loadKeys(EClaimsAndDeductionsImportBatch.db, obj, DecryptedRequest);
if (!EClaimsAndDeductionsImportBatch.db.select(dbConn, obj))
{
return(false);
}
Hashtable values = new Hashtable();
EClaimsAndDeductionsImportBatch.db.populate(obj, values);
binding.toControl(values);
return(true);
}
public override void ImportToDatabase()
{
DataTable dataTable = GetImportDataFromTempDatabase(null);
if (dataTable.Rows.Count > 0)
{
EClaimsAndDeductionsImportBatch batchDetail = new EClaimsAndDeductionsImportBatch();
batchDetail.CNDImportBatchDateTime = AppUtils.ServerDateTime();
//batchDetail.CNDImportBatchOriginalFilename = OriginalBatchFilename;
batchDetail.CNDImportBatchRemark = Remark;
batchDetail.CNDImportBatchUploadedBy = m_UserID;
EClaimsAndDeductionsImportBatch.db.insert(dbConn, batchDetail);
foreach (DataRow row in dataTable.Rows)
{
EUploadClaimsAndDeductions obj = new EUploadClaimsAndDeductions();
EUploadClaimsAndDeductions.db.toObject(row, obj);
EClaimsAndDeductions CND = new EClaimsAndDeductions();
CND.CNDAmount = obj.CNDAmount;
CND.CNDEffDate = obj.CNDEffDate;
CND.CNDNumOfDayAdj = obj.CNDNumOfDayAdj;
CND.CNDPayMethod = obj.CNDPayMethod;
CND.CNDRemark = obj.CNDRemark;
CND.CurrencyID = obj.CurrencyID;
CND.EmpAccID = obj.EmpAccID;
CND.EmpID = obj.EmpID;
CND.PayCodeID = obj.PayCodeID;
CND.CostCenterID = obj.CostCenterID;
CND.CNDIsRestDayPayment = obj.CNDIsRestDayPayment;
CND.CNDImportBatchID = batchDetail.CNDImportBatchID;
EClaimsAndDeductions.db.insert(dbConn, CND);
EUploadClaimsAndDeductions.db.delete(dbConn, obj);
//DBFilter dbfilter = new DBFilter();
//dbfilter.add(new Match("EmpID", obj.EmpID));
//dbfilter.add(new Match("CNDEffDate", obj.CNDEffDate));
//dbfilter.add(new Match("PayCodeID", obj.PayCodeID));
//dbfilter.add(new Match("CNDPayMethod", obj.CNDPayMethod));
//dbfilter.add(new Match("EmpAccID", obj.EmpAccID));
//dbfilter.add(new Match("
}
}
}
