示例#1
0
        public int RecordCount()
        {
            m_command.CommandText = SupplierInvoiceJournal.RecordCount();
            int result = Convert.ToInt32(m_command.ExecuteScalar());

            return(result);
        }
示例#2
0
        internal static SupplierInvoiceJournalItem FindSIJournalItemlistForPayment(MySql.Data.MySqlClient.MySqlCommand cmd, int supinvItemID)
        {
            cmd.CommandText = SupplierInvoiceJournalItem.GetByIDSQL(supinvItemID);
            MySql.Data.MySqlClient.MySqlDataReader r      = cmd.ExecuteReader();
            SupplierInvoiceJournalItem             result = SupplierInvoiceJournalItem.TransformReader(r);

            r.Close();
            cmd.CommandText = SupplierInvoiceJournal.GetByIDSQL(result.EVENT_JOURNAL.ID);
            r = cmd.ExecuteReader();
            result.EVENT_JOURNAL = SupplierInvoiceJournal.TransformReader(r);
            r.Close();

            cmd.CommandText = Currency.GetByIDSQLStatic(result.CURRENCY.ID);
            r = cmd.ExecuteReader();
            result.CURRENCY = Currency.GetCurrency(r);
            r.Close();

            cmd.CommandText = TermOfPayment.GetByIDSQLStatic(result.TOP.ID);
            r          = cmd.ExecuteReader();
            result.TOP = TermOfPayment.GetTOP(r);
            r.Close();

            cmd.CommandText = Employee.GetByIDSQLStatic(result.EMPLOYEE.ID);
            r = cmd.ExecuteReader();
            result.EMPLOYEE = Employee.GetEmployee(r);
            r.Close();


            return(result);
        }
示例#3
0
        protected override void doSaveNoTransaction(EventJournal e)
        {
            try
            {
                DateTime     trDate     = DateTime.Today;
                string       codesample = AutoNumberSetupRepository.GetCodeSampleByDomainName(m_command, "SupplierInvoiceJournal");
                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, "SupplierInvoiceJournal", e.CODE, lastCode, lastDate, trDate, trCount == 0);

                SupplierInvoiceJournal stk = (SupplierInvoiceJournal)e;
                m_command.CommandText = stk.GetInsertSQL();
                m_command.ExecuteNonQuery();
                m_command.CommandText = SupplierInvoiceJournal.SelectMaxIDSQL();
                stk.ID = Convert.ToInt32(m_command.ExecuteScalar());
                foreach (SupplierInvoiceJournalItem item in stk.EVENT_JOURNAL_ITEMS)
                {
                    m_command.CommandText = item.GetInsertSQL();
                    m_command.ExecuteNonQuery();
                    m_command.CommandText = SupplierInvoiceJournalItem.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;
            }
        }
示例#4
0
        public static IList TransformReaderList(MySql.Data.MySqlClient.MySqlDataReader r)
        {
            IList result = new ArrayList();

            while (r.Read())
            {
                SupplierInvoiceJournal tr = new SupplierInvoiceJournal();
                tr.ID                        = Convert.ToInt32(r["sij_id"]);
                tr.CODE                      = r["sij_code"].ToString();
                tr.TRANSACTION_DATE          = Convert.ToDateTime(r["sij_date"]);
                tr.VENDOR                    = new Supplier(Convert.ToInt32(r["sup_id"]));
                tr.CURRENCY                  = new Currency(Convert.ToInt32(r["ccy_id"]));
                tr.VENDOR_BALANCE_ENTRY_TYPE = VendorBalanceEntryType.SupplierInvoice;
                tr.NOTES                     = r["sij_notes"].ToString();
                tr.POSTED                    = Convert.ToBoolean(r["sij_posted"]);
                tr.EVENT_STATUS              = (EventStatus)Enum.Parse(typeof(EventStatus), r["sij_eventstatus"].ToString());
                tr.SUBTOTAL_AMOUNT           = Convert.ToDouble(r["sij_subtotalamount"]);
                tr.DISC_PERCENT              = Convert.ToDouble(r["sij_discpercent"]);
                tr.AMOUNT_AFTER_DISC_PERCENT = Convert.ToDouble(r["sij_amountafterdiscpercent"]);
                tr.DISC_AMOUNT               = Convert.ToDouble(r["sij_discamount"]);
                tr.AMOUNT_AFTER_DISC_AMOUNT  = Convert.ToDouble(r["sij_amountafterdiscamount"]);
                tr.OTHER_EXPENSE             = Convert.ToDouble(r["sij_otherexpense"]);
                tr.NET_AMOUNT                = Convert.ToDouble(r["sij_netamount"]);
                tr.EMPLOYEE                  = new Employee(Convert.ToInt32(r["emp_id"]));
                tr.SUPPLIER_INVOICE          = new SupplierInvoice(Convert.ToInt32(r["si_id"]));
                tr.AGAINST_PAYMENT_STATUS    = (AgainstStatus)Enum.Parse(typeof(AgainstStatus), r["sij_againstpaymentstatus"].ToString());
                tr.MODIFIED_BY               = r["modified_by"].ToString();
                tr.MODIFIED_DATE             = Convert.ToDateTime(r["modified_date"].ToString());
                tr.MODIFIED_COMPUTER_NAME    = r["modified_computer"].ToString();
                result.Add(tr);
            }
            return(result);
        }
示例#5
0
        protected override void doUpdateNoTransaction(EventJournal en)
        {
            try
            {
                SupplierInvoiceJournal e = (SupplierInvoiceJournal)en;
                m_command.CommandText = e.GetUpdateSQL();
                m_command.ExecuteNonQuery();

                foreach (SupplierInvoiceJournalItem 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 = SupplierInvoiceJournalItem.SelectMaxIDSQL();
                        sti.ID = Convert.ToInt32(m_command.ExecuteScalar());
                    }
                }
                m_command.CommandText = SupplierInvoiceJournalItem.DeleteUpdate(e.ID, e.EVENT_JOURNAL_ITEMS);
                m_command.ExecuteNonQuery();
            }
            catch (Exception x)
            {
                throw x;
            }
        }
示例#6
0
        private EventStatus getEventStatus(int id)
        {
            m_command.CommandText = SupplierInvoiceJournal.GetEventStatus(id);
            object      b = m_command.ExecuteScalar();
            EventStatus m = (EventStatus)Enum.Parse(typeof(EventStatus), b.ToString());

            return(m);
        }
示例#7
0
        public override EventJournal FindLastCodeAndTransactionDate(string codesample)
        {
            m_command.CommandText = SupplierInvoiceJournal.FindLastCodeAndTransactionDate(codesample);
            MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
            EventJournal e = SupplierInvoiceJournal.TransformReader(r);

            r.Close();
            return(e);
        }
示例#8
0
        public static void UpdateAgainstStatus(MySql.Data.MySqlClient.MySqlCommand cmd, EventJournal e, ISupplierInvoiceJournalItem ei)
        {
            SupplierInvoiceJournal     po  = (SupplierInvoiceJournal)e;
            SupplierInvoiceJournalItem poi = (SupplierInvoiceJournalItem)ei;

            cmd.CommandText = poi.UpdateAgainstStatus();
            cmd.ExecuteNonQuery();
            cmd.CommandText = po.UpdateAgainstStatus();
            cmd.ExecuteNonQuery();
        }
示例#9
0
        public SupplierInvoiceJournal FindPeriodSIJId(int SIId)
        {
            string sql = SupplierInvoiceJournal.FindPeriodSIJId(SIId);

            m_command.CommandText = sql;
            MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
            SupplierInvoiceJournal rest = SupplierInvoiceJournal.TransformReader(r);

            r.Close();
            return(rest);
        }
示例#10
0
 protected override bool doIsCodeExist(string code)
 {
     try
     {
         m_command.CommandText = SupplierInvoiceJournal.SelectCountByCode(code);
         int t = Convert.ToInt32(m_command.ExecuteScalar());
         return(t > 0);
     }
     catch (Exception x)
     {
         throw x;
     }
 }
        protected override void doRevise(Event events, Period p)
        {
            foreach (EventItem item in events.EVENT_ITEMS)
            {
                SetStockCard(item, p);
            }
            SupplierInvoiceJournal sij = (SupplierInvoiceJournal)r_sij.FindPeriodSIJId(events.ID);

            if (sij == null)
            {
                throw new Exception("Supplier Invoice Journal is missing");
            }
            r_sij.ReviseNoTransaction(sij.ID);
            r_sij.DeleteNoTransaction(sij);
        }
示例#12
0
        //public static SupplierInvoiceJournalItem FindGRNItem(MySql.Data.MySqlClient.MySqlCommand cmd, int grnIID)
        //{
        //    cmd.CommandText = SupplierInvoiceJournalItem.FindByGrnItemIDSQL(grnIID);
        //    MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
        //    SupplierInvoiceJournalItem res = SupplierInvoiceJournalItem.TransformReader(r);
        //    r.Close();
        //    cmd.CommandText = SupplierInvoiceJournal.GetByIDSQL(res.EVENT.ID);
        //    r = cmd.ExecuteReader();
        //    res.EVENT = SupplierInvoiceJournal.TransformReader(r);
        //    r.Close();
        //    return res;
        //}

        protected override IList doSearch(string find)
        {
            try
            {
                m_command.CommandText = SupplierInvoiceJournal.GetSearch(find);
                MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
                IList rest = SupplierInvoiceJournal.TransformReaderList(r);
                r.Close();
                return(rest);
            }
            catch (Exception x)
            {
                throw x;
            }
        }
        protected override void doConfirm(Event events, Period p)
        {
            foreach (EventItem item in events.EVENT_ITEMS)
            {
                SetStockCard(item, p);
            }
            SupplierInvoice si = (SupplierInvoice)events;

            SupplierInvoiceJournal sij = new SupplierInvoiceJournal();

            // sij.LastUpdate = DateTime.Now;
            // sij.ByTransaction = true;
            sij.CODE = si.CODE;
            //sij.ComputerName = si.ComputerName;
            sij.CURRENCY         = si.CURRENCY;
            sij.EVENT_STATUS     = EventStatus.Entry;
            sij.NOTES            = si.NOTES;
            sij.NOTICE_DATE      = si.NOTICE_DATE;
            sij.TRANSACTION_DATE = si.TRANSACTION_DATE;
            // sij.UserName = si.UserName;
            sij.VENDOR                    = si.SUPPLIER;
            sij.SUPPLIER_INVOICE          = si;
            sij.NET_AMOUNT                = si.NET_TOTAL;
            sij.EMPLOYEE                  = si.EMPLOYEE;
            sij.VENDOR_BALANCE_ENTRY_TYPE = VendorBalanceEntryType.SupplierInvoice;

            SupplierInvoiceJournalItem siji = new SupplierInvoiceJournalItem();

            siji.AMOUNT                    = si.NET_TOTAL;
            siji.CURRENCY                  = si.CURRENCY;
            siji.EVENT_JOURNAL             = sij;
            siji.VENDOR                    = si.SUPPLIER;
            siji.INVOICE_NO                = si.CODE;
            siji.INVOICE_DATE              = si.TRANSACTION_DATE;
            siji.TOP                       = si.TOP;
            siji.EMPLOYEE                  = si.EMPLOYEE;
            siji.DUE_DATE                  = si.DUE_DATE;
            siji.OUTSTANDING_AMOUNT        = si.NET_TOTAL;
            siji.VENDOR_BALANCE_ENTRY_TYPE = VendorBalanceEntryType.SupplierInvoice;

            sij.EVENT_JOURNAL_ITEMS.Add(siji);
            r_sij.SaveNoTransaction(sij);
            r_sij.ConfirmNoTransaction(sij.ID);
        }
示例#14
0
        protected override void doDeleteNoTransaction(EventJournal e)
        {
            SupplierInvoiceJournal st = (SupplierInvoiceJournal)e;

            try
            {
                if (getEventStatus(st.ID) == EventStatus.Confirm)
                {
                    throw new Exception("Revise before delete");
                }
                m_command.CommandText = SupplierInvoiceJournalItem.DeleteAllByEventSQL(st.ID);
                m_command.ExecuteNonQuery();
                m_command.CommandText = SupplierInvoiceJournal.DeleteSQL(st.ID);
                m_command.ExecuteNonQuery();
            }
            catch (Exception x)
            {
                throw x;
            }
        }
示例#15
0
        public IList FindSIJournalItemlistForPayment(string find, int ccyID, int supplier, DateTime trdate, IList notIn)
        {
            StringBuilder poisSB = new StringBuilder();

            foreach (int i in notIn)
            {
                poisSB.Append(i.ToString());
                poisSB.Append(',');
            }
            string pois = poisSB.ToString();

            pois = notIn.Count > 0 ? pois.Substring(0, pois.Length - 1) : "";
            m_command.CommandText = SupplierInvoiceJournalItem.GetSearchForPayment(find, ccyID, supplier, pois, trdate);
            MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
            IList result = SupplierInvoiceJournalItem.TransformReaderList(r);

            r.Close();
            foreach (SupplierInvoiceJournalItem t in result)
            {
                m_command.CommandText = SupplierInvoiceJournal.GetByIDSQL(t.EVENT_JOURNAL.ID);
                r = m_command.ExecuteReader();
                t.EVENT_JOURNAL = SupplierInvoiceJournal.TransformReader(r);
                r.Close();

                m_command.CommandText = Currency.GetByIDSQLStatic(t.CURRENCY.ID);
                r          = m_command.ExecuteReader();
                t.CURRENCY = Currency.GetCurrency(r);
                r.Close();

                m_command.CommandText = TermOfPayment.GetByIDSQLStatic(t.TOP.ID);
                r     = m_command.ExecuteReader();
                t.TOP = TermOfPayment.GetTOP(r);
                r.Close();

                m_command.CommandText = Employee.GetByIDSQLStatic(t.EMPLOYEE.ID);
                r          = m_command.ExecuteReader();
                t.EMPLOYEE = Employee.GetEmployee(r);
                r.Close();
            }
            return(result);
        }
示例#16
0
        protected override EventJournal doGet(int ID)
        {
            m_command.CommandText = SupplierInvoiceJournal.GetByIDSQL(ID);
            MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
            SupplierInvoiceJournal st = SupplierInvoiceJournal.TransformReader(r);

            r.Close();
            m_command.CommandText = SupplierInvoiceJournalItem.GetByEventIDSQL(ID);
            r = m_command.ExecuteReader();
            IList stis = SupplierInvoiceJournalItem.TransformReaderList(r);

            r.Close();
            foreach (SupplierInvoiceJournalItem 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);
                st.EVENT_JOURNAL_ITEMS.Add(sti);
            }
            return(st);
        }
示例#17
0
        protected override void doDelete(EventJournal e)
        {
            SupplierInvoiceJournal st = (SupplierInvoiceJournal)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 = SupplierInvoiceJournalItem.DeleteAllByEventSQL(st.ID);
                m_command.ExecuteNonQuery();
                m_command.CommandText = SupplierInvoiceJournal.DeleteSQL(st.ID);
                m_command.ExecuteNonQuery();
                trc.Commit();
            }
            catch (Exception x)
            {
                trc.Rollback();
                throw x;
            }
        }
示例#18
0
 protected override void doUpdateStatus(EventJournal e, bool posted)
 {
     m_command.CommandText = SupplierInvoiceJournal.GetUpdateStatusSQL(e);
     m_command.ExecuteNonQuery();
 }