public override void ImportToDatabase() { DataTable dataTable = GetImportDataFromTempDatabase(null); if (dataTable.Rows.Count > 0) { EHitRateProcessImportBatch batchDetail = new EHitRateProcessImportBatch(); batchDetail.HitRateProcessImportBatchDateTime = AppUtils.ServerDateTime(); //batchDetail.HitRateProcessImportBatchOriginalFilename = OriginalBatchFilename; batchDetail.HitRateProcessImportBatchRemark = Remark; batchDetail.HitRateProcessImportBatchUploadedBy = m_UserID; EHitRateProcessImportBatch.db.insert(dbConn, batchDetail); foreach (DataRow row in dataTable.Rows) { EUploadHitRateProcess obj = new EUploadHitRateProcess(); EUploadHitRateProcess.db.toObject(row, obj); EHitRateProcess HitRateProcess = new EHitRateProcess(); HitRateProcess.HitRate = obj.HitRate; HitRateProcess.payCodeID = obj.payCodeID; HitRateProcess.EmpID = obj.EmpID; HitRateProcess.HitRateProcessImportBatchID = batchDetail.HitRateProcessImportBatchID; EHitRateProcess.db.insert(dbConn, HitRateProcess); EUploadHitRateProcess.db.delete(dbConn, obj); } } }
protected bool loadObject() { EHitRateProcessImportBatch obj = new EHitRateProcessImportBatch(); bool isNew = WebFormWorkers.loadKeys(EHitRateProcessImportBatch.db, obj, DecryptedRequest); if (!EHitRateProcessImportBatch.db.select(dbConn, obj)) { return(false); } Hashtable values = new Hashtable(); EHitRateProcessImportBatch.db.populate(obj, values); binding.toControl(values); return(true); }
//protected void init_PaymentCodeDropdown() //{ // if (PaymentCode.Items.Count <= 0) // { // PaymentCode.Items.Add(new ListItem("Not Selected", "-1")); // DBFilter m_filter = new DBFilter(); // m_filter.add("PaymentCode", true); // foreach (EPaymentCode o in EPaymentCode.db.select(dbConn, m_filter)) // { // PaymentCode.Items.Add(new ListItem(string.Format("{0} - {1}", o.PaymentCode, o.PaymentCodeDesc), o.PaymentCodeID.ToString())); // } // } //} protected DataSet GenerateCND(int ProcessID, DateTime PaymentDate) { EHitRateProcessImportBatch m_process = EHitRateProcessImportBatch.GetObject(dbConn, ProcessID); DataSet dataSet = new DataSet();//export.GetDataSet(); DataTable dataTable = new DataTable("ClaimsAndDeduction$"); dataSet.Tables.Add(dataTable); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_EMP_NO, typeof(string)); dataTable.Columns.Add("English Name", typeof(string)); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_EFFECTIVE_DATE, typeof(DateTime)); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_PAYMENT_CODE, typeof(string)); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_PAYMENT_METHOD, typeof(string)); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_BANK_ACCOUNT_NO, typeof(string)); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_AMOUNT, typeof(double)); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_NUM_OF_DAY_ADJUST, typeof(double)); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_REST_PAYMENT, typeof(string)); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_REMARK, typeof(string)); dataTable.Columns.Add(HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_COST_CENTER, typeof(string)); DBFilter m_detailFilter = new DBFilter(); m_detailFilter.add(new Match("HitRateProcessImportBatchID", ProcessID)); m_detailFilter.add("EmpID", true); foreach (EHitRateProcess m_detail in EHitRateProcess.db.select(dbConn, m_detailFilter)) { DBFilter m_rpFilter = new DBFilter(); m_rpFilter.add(new NullTerm("EmpRPEffTo")); m_rpFilter.add(new Match("PayCodeID", m_detail.payCodeID)); m_rpFilter.add(new Match("EmpID", m_detail.EmpID)); m_rpFilter.add("EmpRPEffTo", true); ArrayList m_empRPList = EEmpRecurringPayment.db.select(dbConn, m_rpFilter); if (m_empRPList.Count > 0) { EEmpRecurringPayment m_empRP = (EEmpRecurringPayment)m_empRPList[0]; double m_amount = m_empRP.EmpRPAmount * m_detail.HitRate / (double)100; string m_remarks; // if (m_amount > 0 && Math.Abs(m_amount) >= 0.01) { m_remarks = String.Format("{0}*{1}%", m_empRP.EmpRPAmount.ToString("#,##0.00"), m_detail.HitRate.ToString("#,##0.00")); EEmpPersonalInfo m_empInfo = new EEmpPersonalInfo(); m_empInfo.EmpID = m_empRP.EmpID; EEmpPersonalInfo.db.select(dbConn, m_empInfo); DataRow m_row = dataTable.NewRow(); m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_EMP_NO] = m_empInfo.EmpNo; m_row["English Name"] = m_empInfo.EmpEngFullName; m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_EFFECTIVE_DATE] = PaymentDate; EPaymentCode m_paymentCode = EPaymentCode.GetObject(dbConn, m_empRP.PayCodeID); m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_PAYMENT_CODE] = m_paymentCode.PaymentCode; switch (m_empRP.EmpRPMethod) { case "A": m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_PAYMENT_METHOD] = "Autopay"; break; case "Q": m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_PAYMENT_METHOD] = "Cheque"; break; case "C": m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_PAYMENT_METHOD] = "Cash"; break; default: m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_PAYMENT_METHOD] = "Other"; break; } m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_AMOUNT] = Math.Round(m_amount, 2); m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_NUM_OF_DAY_ADJUST] = 0; //DateTime.DaysInMonth(m_process.AsAtDate); m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_REST_PAYMENT] = "No"; m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_REMARK] = m_remarks; if (m_empRP.EmpAccID > 0) // account number specified { EEmpBankAccount m_bank = new EEmpBankAccount(); m_bank.EmpBankAccountID = m_empRP.EmpAccID; if (EEmpBankAccount.db.select(dbConn, m_bank)) { m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_BANK_ACCOUNT_NO] = m_bank.EmpAccountNo; } } //else //{ // // get default bank account // DBFilter m_bankAccFilter = new DBFilter(); // m_bankAccFilter.add(new Match("EmpID", m_empRP.EmpID)); // m_bankAccFilter.add(new Match("EmpAccDefault", true)); // m_bankAccFilter.add("empBankAccountID", true); // ArrayList m_bankAccList = EEmpBankAccount.db.select(dbConn, m_bankAccFilter); // if (m_bankAccList.Count > 0) // { // m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_BANK_ACCOUNT_NO] = ((EEmpBankAccount)m_bankAccList[0]).EmpAccountNo; // } //} ECostCenter m_costCenter = new ECostCenter(); m_costCenter.CostCenterID = m_empRP.CostCenterID; if (ECostCenter.db.select(dbConn, m_costCenter)) { m_row[HROne.Import.ImportClaimsAndDeductionsProcess.FIELD_COST_CENTER] = m_costCenter.CostCenterCode; } dataTable.Rows.Add(m_row); } } } return(dataSet); }