protected override void doSaveNoTransaction(EventJournal e) { try { DateTime trDate = DateTime.Today; string codesample = AutoNumberSetupRepository.GetCodeSampleByDomainName(m_command, "ARCreditNote"); EventJournal codeDate = FindLastCodeAndTransactionDate(codesample); string lastCode = codeDate == null ? string.Empty : codeDate.CODE; DateTime lastDate = codeDate == null ? trDate : codeDate.TRANSACTION_DATE; int trCount = RecordCount(); e.CODE = AutoNumberSetupRepository.GetAutoNumberByDomainName(m_command, "ARCreditNote", e.CODE, lastCode, lastDate, trDate, trCount == 0); ARCreditNote stk = (ARCreditNote)e; m_command.CommandText = stk.GetInsertSQL(); m_command.ExecuteNonQuery(); m_command.CommandText = ARCreditNote.SelectMaxIDSQL(); stk.ID = Convert.ToInt32(m_command.ExecuteScalar()); foreach (ARCreditNoteItem item in stk.EVENT_JOURNAL_ITEMS) { m_command.CommandText = item.GetInsertSQL(); m_command.ExecuteNonQuery(); m_command.CommandText = ARCreditNoteItem.SelectMaxIDSQL(); item.ID = Convert.ToInt32(m_command.ExecuteScalar()); } } catch (Exception x) { e.ID = 0; foreach (EventJournalItem item in e.EVENT_JOURNAL_ITEMS) { item.ID = 0; } throw x; } }
protected override void doDeleteNoTransaction(EventJournal e) { Receipt st = (Receipt)this.Get(e.ID); try { if (getEventStatus(st.ID) == EventStatus.Confirm) { throw new Exception("Revise before delete"); } foreach (ReceiptItem sti in e.EVENT_JOURNAL_ITEMS) { if (sti.PAYMENT_TYPE == ReceiptType.ARCreditNote) { m_command.CommandText = ARCreditNote.UpdateUsedForReceipt(sti.AR_CREDIT_NOTE.ID, false); m_command.ExecuteNonQuery(); } } m_command.CommandText = ReceiptItem.DeleteAllByEventSQL(st.ID); m_command.ExecuteNonQuery(); m_command.CommandText = Receipt.DeleteSQL(st.ID); m_command.ExecuteNonQuery(); } catch (Exception x) { throw x; } }
protected override EventJournal doGet(int ID) { m_command.CommandText = ARCreditNote.GetByIDSQL(ID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); ARCreditNote st = ARCreditNote.TransformReader(r); r.Close(); m_command.CommandText = ARCreditNoteItem.GetByEventIDSQL(ID); r = m_command.ExecuteReader(); IList stis = ARCreditNoteItem.TransformReaderList(r); r.Close(); foreach (ARCreditNoteItem sti in stis) { sti.EVENT_JOURNAL = st; //sti.VENDOR = PartRepository.GetByID(m_command, sti.PART.ID); sti.VENDOR_BALANCE_ENTRY = VendorBalanceEntryRepository.FindVendorBalanceEntryByEventItem(m_command, sti.ID, sti.VENDOR_BALANCE_ENTRY_TYPE); //sti.GRN_ITEM = GoodReceiveNoteRepository.FindGoodReceiveNoteItem(m_command, sti.GRN_ITEM.ID); //sti.GRN_ITEM.PART = PartRepository.GetByID(m_command, sti.GRN_ITEM.PART.ID); if (sti.SALES_RETURN != null) { if (sti.SALES_RETURN.ID > 0) { sti.SALES_RETURN = SalesReturnRepository.GetSalesReturnForCreditNote(m_command, sti.SALES_RETURN); } } st.EVENT_JOURNAL_ITEMS.Add(sti); } return(st); }
protected override void doUpdateNoTransaction(EventJournal en) { try { ARCreditNote e = (ARCreditNote)en; m_command.CommandText = e.GetUpdateSQL(); m_command.ExecuteNonQuery(); foreach (ARCreditNoteItem sti in e.EVENT_JOURNAL_ITEMS) { if (sti.ID > 0) { m_command.CommandText = sti.GetUpdateSQL(); m_command.ExecuteNonQuery(); } else { m_command.CommandText = sti.GetInsertSQL(); m_command.ExecuteNonQuery(); m_command.CommandText = ARCreditNoteItem.SelectMaxIDSQL(); sti.ID = Convert.ToInt32(m_command.ExecuteScalar()); } } m_command.CommandText = ARCreditNoteItem.DeleteUpdate(e.ID, e.EVENT_JOURNAL_ITEMS); m_command.ExecuteNonQuery(); } catch (Exception x) { throw x; } }
public static ARCreditNote TransformReader(MySql.Data.MySqlClient.MySqlDataReader r) { ARCreditNote tr = null; if (r.HasRows) { r.Read(); tr = new ARCreditNote(); tr.ID = Convert.ToInt32(r["arcr_id"]); tr.CODE = r["arcr_code"].ToString(); tr.TRANSACTION_DATE = Convert.ToDateTime(r["arcr_date"]); tr.VENDOR = new Customer(Convert.ToInt32(r["cus_id"])); tr.CURRENCY = new Currency(Convert.ToInt32(r["ccy_id"])); tr.VENDOR_BALANCE_ENTRY_TYPE = VendorBalanceEntryType.ARCreditNote; tr.NOTES = r["arcr_notes"].ToString(); tr.POSTED = Convert.ToBoolean(r["arcr_posted"]); tr.EVENT_STATUS = (EventStatus)Enum.Parse(typeof(EventStatus), r["arcr_eventstatus"].ToString()); tr.SUBTOTAL_AMOUNT = Convert.ToDouble(r["arcr_subtotalamount"]); tr.DISC_PERCENT = Convert.ToDouble(r["arcr_discpercent"]); tr.AMOUNT_AFTER_DISC_PERCENT = Convert.ToDouble(r["arcr_amountafterdiscpercent"]); tr.DISC_AMOUNT = Convert.ToDouble(r["arcr_discamount"]); tr.AMOUNT_AFTER_DISC_AMOUNT = Convert.ToDouble(r["arcr_amountafterdiscamount"]); tr.OTHER_EXPENSE = Convert.ToDouble(r["arcr_otherexpense"]); tr.NET_AMOUNT = Convert.ToDouble(r["arcr_netamount"]); tr.EMPLOYEE = new Employee(Convert.ToInt32(r["emp_id"])); tr.USED_FOR_RECEIPT = Convert.ToBoolean(r["arcr_usedforreceipt"]); tr.MODIFIED_BY = r["modified_by"].ToString(); tr.MODIFIED_DATE = Convert.ToDateTime(r["modified_date"].ToString()); tr.MODIFIED_COMPUTER_NAME = r["modified_computer"].ToString(); } return(tr); }
protected override void doUpdate(EventJournal en) { MySql.Data.MySqlClient.MySqlTransaction trc = m_connection.BeginTransaction(); m_command.Transaction = trc; try { ARCreditNote e = (ARCreditNote)en; m_command.CommandText = e.GetUpdateSQL(); m_command.ExecuteNonQuery(); foreach (ARCreditNoteItem sti in e.EVENT_JOURNAL_ITEMS) { if (sti.ID > 0) { m_command.CommandText = sti.GetUpdateSQL(); m_command.ExecuteNonQuery(); } else { m_command.CommandText = sti.GetInsertSQL(); m_command.ExecuteNonQuery(); m_command.CommandText = ARCreditNoteItem.SelectMaxIDSQL(); sti.ID = Convert.ToInt32(m_command.ExecuteScalar()); } } m_command.CommandText = ARCreditNoteItem.DeleteUpdate(e.ID, e.EVENT_JOURNAL_ITEMS); m_command.ExecuteNonQuery(); trc.Commit(); } catch (Exception x) { trc.Rollback(); throw x; } }
protected override void doDelete(EventJournal e) { Receipt st = (Receipt)e; MySql.Data.MySqlClient.MySqlTransaction trc = m_connection.BeginTransaction(); m_command.Transaction = trc; try { if (getEventStatus(st.ID) == EventStatus.Confirm) { throw new Exception("Revise before delete"); } foreach (ReceiptItem sti in e.EVENT_JOURNAL_ITEMS) { if (sti.PAYMENT_TYPE == ReceiptType.ARCreditNote) { m_command.CommandText = ARCreditNote.UpdateUsedForReceipt(sti.AR_CREDIT_NOTE.ID, false); m_command.ExecuteNonQuery(); } } m_command.CommandText = ReceiptItem.DeleteAllByEventSQL(st.ID); m_command.ExecuteNonQuery(); m_command.CommandText = Receipt.DeleteSQL(st.ID); m_command.ExecuteNonQuery(); trc.Commit(); } catch (Exception x) { trc.Rollback(); throw x; } }
public int RecordCount() { m_command.CommandText = ARCreditNote.RecordCount(); int result = Convert.ToInt32(m_command.ExecuteScalar()); return(result); }
private EventStatus getEventStatus(int id) { m_command.CommandText = ARCreditNote.GetEventStatus(id); object b = m_command.ExecuteScalar(); EventStatus m = (EventStatus)Enum.Parse(typeof(EventStatus), b.ToString()); return(m); }
public static ARCreditNote FindARCRForReceipt(MySql.Data.MySqlClient.MySqlCommand m_command, int apdnID) { m_command.CommandText = ARCreditNote.GetByIDSQL(apdnID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); ARCreditNote reuslt = ARCreditNote.TransformReader(r); r.Close(); return(reuslt); }
public override EventJournal FindLastCodeAndTransactionDate(string codesample) { m_command.CommandText = ARCreditNote.FindLastCodeAndTransactionDate(codesample); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); EventJournal e = ARCreditNote.TransformReader(r); r.Close(); return(e); }
protected override void doUpdate(EventJournal en) { MySql.Data.MySqlClient.MySqlTransaction trc = m_connection.BeginTransaction(); m_command.Transaction = trc; try { Receipt e = (Receipt)en; m_command.CommandText = e.GetUpdateSQL(); m_command.ExecuteNonQuery(); foreach (ReceiptItem sti in e.EVENT_JOURNAL_ITEMS) { sti.VENDOR_BALANCE_CUSTOMER_INVOICE_TYPE = sti.CUSTOMER_INVOICE_JOURNAL_ITEM.GET_EVENT_JOURNAL.VENDOR_BALANCE_ENTRY_TYPE; if (sti.ID > 0) { m_command.CommandText = sti.GetUpdateSQL(); m_command.ExecuteNonQuery(); } else { m_command.CommandText = sti.GetInsertSQL(); m_command.ExecuteNonQuery(); m_command.CommandText = ReceiptItem.SelectMaxIDSQL(); sti.ID = Convert.ToInt32(m_command.ExecuteScalar()); } if (sti.PAYMENT_TYPE == ReceiptType.ARCreditNote) { m_command.CommandText = ARCreditNote.UpdateUsedForReceipt(sti.AR_CREDIT_NOTE.ID, true); m_command.ExecuteNonQuery(); } } m_command.CommandText = ReceiptItem.GetNotInTypeARCR(e.ID, e.EVENT_JOURNAL_ITEMS); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); IList pymnts = ReceiptItem.TransformReaderList(r); r.Close(); foreach (ReceiptItem itm in pymnts) { m_command.CommandText = ARCreditNote.UpdateUsedForReceipt(itm.AR_CREDIT_NOTE.ID, false); m_command.ExecuteNonQuery(); } m_command.CommandText = ReceiptItem.DeleteUpdate(e.ID, e.EVENT_JOURNAL_ITEMS); m_command.ExecuteNonQuery(); trc.Commit(); } catch (Exception x) { trc.Rollback(); throw x; } }
protected override bool doIsCodeExist(string code) { try { m_command.CommandText = ARCreditNote.SelectCountByCode(code); int t = Convert.ToInt32(m_command.ExecuteScalar()); return(t > 0); } catch (Exception x) { throw x; } }
//public static ARCreditNoteItem FindGRNItem(MySql.Data.MySqlClient.MySqlCommand cmd, int grnIID) //{ // cmd.CommandText = ARCreditNoteItem.FindByGrnItemIDSQL(grnIID); // MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); // ARCreditNoteItem res = ARCreditNoteItem.TransformReader(r); // r.Close(); // cmd.CommandText = ARCreditNote.GetByIDSQL(res.EVENT.ID); // r = cmd.ExecuteReader(); // res.EVENT = ARCreditNote.TransformReader(r); // r.Close(); // return res; //} protected override IList doSearch(string find) { try { m_command.CommandText = ARCreditNote.GetSearch(find); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); IList rest = ARCreditNote.TransformReaderList(r); r.Close(); return(rest); } catch (Exception x) { throw x; } }
internal static IList FindARCRBySalesReturn(MySql.Data.MySqlClient.MySqlCommand cmd, int prID) { cmd.CommandText = ARCreditNoteItem.GetARCRItemBySRID(prID); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); IList result = ARCreditNoteItem.TransformReaderList(r); r.Close(); foreach (ARCreditNoteItem i in result) { cmd.CommandText = ARCreditNote.GetByIDSQL(i.EVENT_JOURNAL.ID); r = cmd.ExecuteReader(); i.EVENT_JOURNAL = ARCreditNote.TransformReader(r); r.Close(); } return(result); }
protected override void doSave(EventJournal e) { MySql.Data.MySqlClient.MySqlTransaction trc = m_connection.BeginTransaction(); try { m_command.Transaction = trc; DateTime trDate = DateTime.Today; string codesample = AutoNumberSetupRepository.GetCodeSampleByDomainName(m_command, "Receipt"); EventJournal codeDate = FindLastCodeAndTransactionDate(codesample); string lastCode = codeDate == null ? string.Empty : codeDate.CODE; DateTime lastDate = codeDate == null ? trDate : codeDate.TRANSACTION_DATE; int trCount = RecordCount(); e.CODE = AutoNumberSetupRepository.GetAutoNumberByDomainName(m_command, "Receipt", e.CODE, lastCode, lastDate, trDate, trCount == 0); Receipt stk = (Receipt)e; m_command.CommandText = stk.GetInsertSQL(); m_command.ExecuteNonQuery(); m_command.CommandText = Receipt.SelectMaxIDSQL(); stk.ID = Convert.ToInt32(m_command.ExecuteScalar()); foreach (ReceiptItem item in stk.EVENT_JOURNAL_ITEMS) { item.VENDOR_BALANCE_CUSTOMER_INVOICE_TYPE = item.CUSTOMER_INVOICE_JOURNAL_ITEM.GET_EVENT_JOURNAL.VENDOR_BALANCE_ENTRY_TYPE; m_command.CommandText = item.GetInsertSQL(); m_command.ExecuteNonQuery(); m_command.CommandText = ReceiptItem.SelectMaxIDSQL(); item.ID = Convert.ToInt32(m_command.ExecuteScalar()); if (item.PAYMENT_TYPE == ReceiptType.ARCreditNote) { m_command.CommandText = ARCreditNote.UpdateUsedForReceipt(item.AR_CREDIT_NOTE.ID, true); m_command.ExecuteNonQuery(); } } trc.Commit(); } catch (Exception x) { e.ID = 0; foreach (EventJournalItem item in e.EVENT_JOURNAL_ITEMS) { item.ID = 0; } trc.Rollback(); throw x; } }
public IList FindARCRForReceipt(int supID, DateTime trdate, string find, IList notInID) { StringBuilder poisSB = new StringBuilder(); foreach (int i in notInID) { poisSB.Append(i.ToString()); poisSB.Append(','); } string pois = poisSB.ToString(); pois = notInID.Count > 0 ? pois.Substring(0, pois.Length - 1) : ""; m_command.CommandText = ARCreditNote.GetForReceipt(supID, trdate, find, pois); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); IList reuslt = ARCreditNote.TransformReaderList(r); r.Close(); return(reuslt); }
protected override void doDeleteNoTransaction(EventJournal e) { ARCreditNote st = (ARCreditNote)e; try { if (getEventStatus(st.ID) == EventStatus.Confirm) { throw new Exception("Revise before delete"); } m_command.CommandText = ARCreditNoteItem.DeleteAllByEventSQL(st.ID); m_command.ExecuteNonQuery(); m_command.CommandText = ARCreditNote.DeleteSQL(st.ID); m_command.ExecuteNonQuery(); } catch (Exception x) { throw x; } }
protected override void doDelete(EventJournal e) { ARCreditNote st = (ARCreditNote)e; MySql.Data.MySqlClient.MySqlTransaction trc = m_connection.BeginTransaction(); m_command.Transaction = trc; try { if (getEventStatus(st.ID) == EventStatus.Confirm) { throw new Exception("Revise before delete"); } m_command.CommandText = ARCreditNoteItem.DeleteAllByEventSQL(st.ID); m_command.ExecuteNonQuery(); m_command.CommandText = ARCreditNote.DeleteSQL(st.ID); m_command.ExecuteNonQuery(); trc.Commit(); } catch (Exception x) { trc.Rollback(); throw x; } }
public IList GetAllTransactions(int supID) { ArrayList result = new ArrayList(); OpenConnection(); MySql.Data.MySqlClient.MySqlDataReader r; m_cmd.CommandText = SalesOrder.GetByCustomerSQL(supID); r = m_cmd.ExecuteReader(); IList po = SalesOrder.TransformReaderList(r); r.Close(); foreach (Event e in po) { result.Add(e); } m_cmd.CommandText = DeliveryOrder.GetByCustomerSQL(supID); r = m_cmd.ExecuteReader(); IList grn = DeliveryOrder.TransformReaderList(r); r.Close(); foreach (Event e in grn) { result.Add(e); } m_cmd.CommandText = CustomerInvoice.GetByCustomerSQL(supID); r = m_cmd.ExecuteReader(); IList si = CustomerInvoice.TransformReaderList(r); r.Close(); foreach (Event e in si) { result.Add(e); } m_cmd.CommandText = POS.GetByCustomerSQL(supID); r = m_cmd.ExecuteReader(); IList pos = POS.TransformReaderList(r); r.Close(); foreach (Event e in pos) { result.Add(e); } m_cmd.CommandText = SalesReturn.GetByCustomerSQL(supID); r = m_cmd.ExecuteReader(); IList pr = SalesReturn.TransformReaderList(r); r.Close(); foreach (Event e in pr) { result.Add(e); } m_cmd.CommandText = ARCreditNote.GetByCustomerSQL(supID); r = m_cmd.ExecuteReader(); IList apdn = ARCreditNote.TransformReaderList(r); r.Close(); foreach (EventJournal e in apdn) { result.Add(e); } m_cmd.CommandText = Receipt.GetByCustomerSQL(supID); r = m_cmd.ExecuteReader(); IList py = Receipt.TransformReaderList(r); r.Close(); foreach (EventJournal e in py) { result.Add(e); } m_cmd.CommandText = CustomerOutStandingInvoice.GetByCustomerSQL(supID); r = m_cmd.ExecuteReader(); IList soi = CustomerOutStandingInvoice.TransformReaderList(r); r.Close(); foreach (EventJournal e in soi) { result.Add(e); } result.Sort(new EventDateComparer()); return(result); }
protected override void doUpdateStatus(EventJournal e, bool posted) { m_command.CommandText = ARCreditNote.GetUpdateStatusSQL(e); m_command.ExecuteNonQuery(); }