private void LoadContact() { Data.ContactColumns clsContactColumns = new Data.ContactColumns(); clsContactColumns.ContactName = true; Data.ContactColumns clsSearchColumns = new Data.ContactColumns(); clsContactColumns.ContactName = true; clsContactColumns.ContactCode = true; Data.Contacts clsContact = new Data.Contacts(); cboSupplier.DataTextField = Data.ContactColumnNames.ContactName; cboSupplier.DataValueField = Data.ContactColumnNames.ContactID; cboSupplier.DataSource = clsContact.Suppliers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsSearchColumns, txtSupplier.Text, 100, false, Data.ContactColumnNames.ContactName, System.Data.SqlClient.SortOrder.Ascending).DefaultView; cboSupplier.DataBind(); clsContact.CommitAndDispose(); cboSupplier.Items.Add(new ListItem("All Suppliers", "0")); cboSupplier.SelectedIndex = cboSupplier.Items.Count - 1; }
private static void ProcessCreditBillWG(string CardTypeName) { Event clsEvent = new Event(); clsEvent.AddEventLn(""); Console.WriteLine(ConsoleMonitor() + ""); LocalDB clsLocalDB = new LocalDB(); clsLocalDB.GetConnection(ConnectionTimeOut: 100000); mConnection = clsLocalDB.Connection; mTransaction = clsLocalDB.Transaction; Data.Billing clsBilling = new Data.Billing(mConnection, mTransaction); mConnection = clsBilling.Connection; mTransaction = clsBilling.Transaction; Data.Contacts clsContacts = new Data.Contacts(mConnection, mTransaction); mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction; Data.SysConfig clsSysConfig = new Data.SysConfig(mConnection, mTransaction); mConnection = clsSysConfig.Connection; mTransaction = clsSysConfig.Transaction; bool boWillProcessCreditBillerInProgram = clsSysConfig.get_WillProcessCreditBillerInProgram(); Data.CardType clsCardType = new Data.CardType(mConnection, mTransaction); mConnection = clsCardType.Connection; mTransaction = clsCardType.Transaction; Data.CardTypeDetails clsCreditCardTypeInfo = clsCardType.Details(CardTypeName); // check billingdate Data.ContactColumns clsContactColumns = new Data.ContactColumns() { ContactID = true, ContactCode = true, ContactName = true, CreditDetails = true }; Data.ContactColumns clsSearchColumns = new Data.ContactColumns() { ContactCode = true, ContactName = true }; System.Data.DataTable dtGuarantors; try { if (clsCreditCardTypeInfo.BillingDate == Constants.C_DATE_MIN_VALUE) { clsLocalDB.CommitAndDispose(); WriteProcessToMonitor("Will not process group credit bill. There is no BillingDate set in the database. Please contact your System Administrator."); return; } else if (clsCreditCardTypeInfo.BillingDate >= DateTime.Now) { WriteProcessToMonitor("Will not process group credit bill. Next processing date must be after BillingDate: [" + clsCreditCardTypeInfo.BillingDate.ToString("dd-MMM-yyyy") + "]. System will only process after billing date."); WriteProcessToMonitor("Printing unprinted OR's instead. "); clsContacts = new Data.Contacts(mConnection, mTransaction); mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction; foreach (Data.CardTypeDetails clsCardTypeDetails in clsBilling.ListUnPrintedCreditCardTypes(CreditType.Group)) { dtGuarantors = clsContacts.Guarantors(clsContactColumns, CreditCardTypeID: clsCardTypeDetails.CardTypeID); PrintORsWG(dtGuarantors, clsCardTypeDetails); } clsLocalDB.CommitAndDispose(); return; } // Check PurchaseEndDate if lower than today then do not execute. if (clsCreditCardTypeInfo.CreditPurcEndDateToProcess >= DateTime.Now) { WriteProcessToMonitor("Will not process group credit bill. CreditPurcEndDateToProcess: " + clsCreditCardTypeInfo.CreditPurcEndDateToProcess.ToString("dd-MMM-yyyy") + " should be lower than current date."); WriteProcessToMonitor("Printing unprinted OR's instead. "); clsContacts = new Data.Contacts(mConnection, mTransaction); mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction; foreach (Data.CardTypeDetails clsCardTypeDetails in clsBilling.ListUnPrintedCreditCardTypes(CreditType.Group)) { dtGuarantors = clsContacts.Guarantors(clsContactColumns, CreditCardTypeID: clsCardTypeDetails.CardTypeID); PrintORsWG(dtGuarantors, clsCardTypeDetails); } clsLocalDB.CommitAndDispose(); return; } // 19Feb2015 : ByPass execution, put in the event instead. Just put the printing here. if (boWillProcessCreditBillerInProgram) { WriteProcessToMonitor("Processing group credit bill for BillingDate: [" + clsCreditCardTypeInfo.BillingDate.ToString("dd-MMM-yyyy") + "]. "); clsBilling.ProcessCurrentBill(CreditType.Group, clsCreditCardTypeInfo.CardTypeCode); // print SOA first before closing the billing date to make sure all are printed clsContacts = new Data.Contacts(mConnection, mTransaction); mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction; dtGuarantors = clsContacts.Guarantors(clsContactColumns, CreditCardTypeID: clsCreditCardTypeInfo.CardTypeID); clsBilling.CommitAndDispose(); PrintORsWG(dtGuarantors, clsCreditCardTypeInfo); WriteProcessToMonitor("Closing group current billing date..."); clsBilling = new Data.Billing(mConnection, mTransaction); mConnection = clsBilling.Connection; mTransaction = clsBilling.Transaction; clsBilling.CloseCurrentBill(CreditType.Group, clsCreditCardTypeInfo.CardTypeCode); WriteProcessToMonitor("Done."); } else { WriteProcessToMonitor("Will not process group credit bill. WillProcessCreditBillerInProgram : false"); WriteProcessToMonitor("Done."); } } catch (Exception ex) { WriteProcessToMonitor("PLEASE CALL RETAILPLUS IMMEDIATELY... PROCESS-CreditBillWithGuarantor error:" + Environment.NewLine + ex.ToString()); clsLocalDB.ThrowException(ex); } finally { clsLocalDB.CommitAndDispose(); } }