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(" } } }