예제 #1
0
        public void Post(long GJournalID)
        {
            try
            {
                GetConnection();
                ChartOfAccounts clsChartOfAccount = new ChartOfAccounts(Connection, Transaction);

                MySqlDataReader myReader = List(GJournalID, "GJournalDebitID", SortOption.Ascending);
                while (myReader.Read())
                {
                    int     ChartOfAccountID = myReader.GetInt32("ChartOfAccountID");
                    decimal Amount           = myReader.GetDecimal("Amount");

                    clsChartOfAccount.UpdateDebit(ChartOfAccountID, Amount);
                }
                myReader.Close();
            }

            catch (Exception ex)
            {
                {
                }

                throw base.ThrowException(ex);
            }
        }
예제 #2
0
        private void UpdateAccounts(long CreditMemoID)
        {
            try
            {
                CreditMemoDetails clsCreditMemoDetails = Details(CreditMemoID);
                ChartOfAccounts   clsChartOfAccount    = new ChartOfAccounts(base.Connection, base.Transaction);

                // update ChartOfAccountIDARTracking as credit
                clsChartOfAccount.UpdateCredit(clsCreditMemoDetails.ChartOfAccountIDARTracking, clsCreditMemoDetails.SubTotal);

                // update Deposit & APContra
                clsChartOfAccount.UpdateDebit(clsCreditMemoDetails.ChartOfAccountIDARContra, clsCreditMemoDetails.Discount);

                // update Freight & APTracking
                clsChartOfAccount.UpdateDebit(clsCreditMemoDetails.ChartOfAccountIDARTracking, clsCreditMemoDetails.Freight);
                clsChartOfAccount.UpdateCredit(clsCreditMemoDetails.ChartOfAccountIDARFreight, clsCreditMemoDetails.Freight);

                // update Deposit & APTracking
                clsChartOfAccount.UpdateDebit(clsCreditMemoDetails.ChartOfAccountIDARTracking, clsCreditMemoDetails.Deposit);
                clsChartOfAccount.UpdateCredit(clsCreditMemoDetails.ChartOfAccountIDARVDeposit, clsCreditMemoDetails.Deposit);

                CreditMemoItems       clsCreditMemoItems = new CreditMemoItems(base.Connection, base.Transaction);
                System.Data.DataTable dt = clsCreditMemoItems.ListAsDataTable(CreditMemoID);
                foreach (System.Data.DataRow dr in dt.Rows)
                {
                    int iChartOfAccountIDPurchase    = Int16.Parse(dr["ChartOfAccountIDPurchase"].ToString());
                    int iChartOfAccountIDTaxPurchase = Int16.Parse(dr["ChartOfAccountIDTaxPurchase"].ToString());

                    decimal decVAT           = decimal.Parse(dr["VAT"].ToString());
                    decimal decVATABLEAmount = decimal.Parse(dr["Amount"].ToString()) - decVAT;

                    // update purchase as debit
                    clsChartOfAccount.UpdateCredit(iChartOfAccountIDPurchase, decVATABLEAmount);
                    // update tax as debit
                    clsChartOfAccount.UpdateCredit(iChartOfAccountIDTaxPurchase, decVAT);
                }
                //myReader.Close();
            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
예제 #3
0
        public void Post(long BankDepositID, decimal Amount)
        {
            try
            {
                string SQL = "UPDATE tblBankDeposit SET " +
                             "DepositStatus      = @DepositStatus " +
                             "WHERE BankDepositID    = @BankDepositID;";



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@DepositStatus", BankDepositStatus.Posted.ToString("d"));
                cmd.Parameters.AddWithValue("@BankDepositID", BankDepositID);

                base.ExecuteNonQuery(cmd);

                BankDepositDetails clsBankDepositDetails = Details(BankDepositID);
                ChartOfAccounts    clsChartOfAccount     = new ChartOfAccounts(base.Connection, base.Transaction);

                clsChartOfAccount.UpdateDebit(clsBankDepositDetails.DepositInAccountID, clsBankDepositDetails.DepositItemAmount);
                clsChartOfAccount.UpdateCredit(clsBankDepositDetails.DepositInAccountID, clsBankDepositDetails.CashBackAmount);

                clsChartOfAccount.UpdateDebit(clsBankDepositDetails.CashBackAccountID, clsBankDepositDetails.CashBackAmount);

                clsChartOfAccount.UpdateCredit(clsBankDepositDetails.DepositItemAccountID, clsBankDepositDetails.DepositItemAmount);
            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
예제 #4
0
		public void Post(long BankDepositID, decimal Amount)
		{
			try 
			{
                string SQL = "UPDATE tblBankDeposit SET " +
                                "DepositStatus      = @DepositStatus " +
                            "WHERE BankDepositID    = @BankDepositID;";

                

                MySqlCommand cmd = new MySqlCommand();
                
                
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@DepositStatus", BankDepositStatus.Posted.ToString("d"));
                cmd.Parameters.AddWithValue("@BankDepositID", BankDepositID);

                base.ExecuteNonQuery(cmd);

                BankDepositDetails clsBankDepositDetails = Details(BankDepositID);
                ChartOfAccounts clsChartOfAccount = new ChartOfAccounts(base.Connection, base.Transaction);
                
                clsChartOfAccount.UpdateDebit(clsBankDepositDetails.DepositInAccountID, clsBankDepositDetails.DepositItemAmount);
                clsChartOfAccount.UpdateCredit(clsBankDepositDetails.DepositInAccountID, clsBankDepositDetails.CashBackAmount);

                clsChartOfAccount.UpdateDebit(clsBankDepositDetails.CashBackAccountID, clsBankDepositDetails.CashBackAmount);

                clsChartOfAccount.UpdateCredit(clsBankDepositDetails.DepositItemAccountID, clsBankDepositDetails.DepositItemAmount);

			}

			catch (Exception ex)
			{
			    throw base.ThrowException(ex);
			}	
		}
예제 #5
0
		public void Post(long GJournalID)
		{
			try 
			{
				GetConnection();
				ChartOfAccounts clsChartOfAccount = new ChartOfAccounts(Connection, Transaction);

				MySqlDataReader myReader = List(GJournalID, "GJournalDebitID",SortOption.Ascending);
				while (myReader.Read())
				{
					int ChartOfAccountID = myReader.GetInt32("ChartOfAccountID");
					decimal Amount = myReader.GetDecimal("Amount");

					clsChartOfAccount.UpdateDebit(ChartOfAccountID, Amount);
				}
				myReader.Close();

			}

			catch (Exception ex)
			{
				
				
				{
					
					 
					
					
				}

				throw base.ThrowException(ex);
			}	
		}
예제 #6
0
        private void UpdateAccounts(long DebitMemoID)
        {
            try
            {
                DebitMemoDetails clsDebitMemoDetails = Details(DebitMemoID);
                ChartOfAccounts clsChartOfAccount = new ChartOfAccounts(base.Connection, base.Transaction);

                // update ChartOfAccountIDAPTracking as credit
                clsChartOfAccount.UpdateCredit(clsDebitMemoDetails.ChartOfAccountIDAPTracking, clsDebitMemoDetails.SubTotal);

                // update Deposit & APContra
                clsChartOfAccount.UpdateCredit(clsDebitMemoDetails.ChartOfAccountIDAPContra, clsDebitMemoDetails.Discount);

                // update Freight & APTracking
                clsChartOfAccount.UpdateDebit(clsDebitMemoDetails.ChartOfAccountIDAPTracking, clsDebitMemoDetails.Freight);
                clsChartOfAccount.UpdateCredit(clsDebitMemoDetails.ChartOfAccountIDAPFreight, clsDebitMemoDetails.Freight);

                // update Deposit & APTracking
                clsChartOfAccount.UpdateDebit(clsDebitMemoDetails.ChartOfAccountIDAPTracking, clsDebitMemoDetails.Deposit);
                clsChartOfAccount.UpdateCredit(clsDebitMemoDetails.ChartOfAccountIDAPVDeposit, clsDebitMemoDetails.Deposit);

                DebitMemoItems clsDebitMemoItems = new DebitMemoItems(base.Connection, base.Transaction);
                System.Data.DataTable dt = clsDebitMemoItems.ListAsDataTable(DebitMemoID);
                foreach(System.Data.DataRow dr in dt.Rows)
                {
                    int iChartOfAccountIDPurchase = Int16.Parse(dr["ChartOfAccountIDPurchase"].ToString());
                    int iChartOfAccountIDTaxPurchase = Int16.Parse(dr["ChartOfAccountIDTaxPurchase"].ToString());

                    decimal decVAT = decimal.Parse(dr["VAT"].ToString());
                    decimal decVATABLEAmount = decimal.Parse(dr["Amount"].ToString())-decVAT;

                    // update purchase as debit
                    clsChartOfAccount.UpdateCredit(iChartOfAccountIDPurchase, decVATABLEAmount);
                    // update tax as debit
                    clsChartOfAccount.UpdateCredit(iChartOfAccountIDTaxPurchase, decVAT);

                }

            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
예제 #7
0
파일: SO.cs 프로젝트: marioricci/erp-luma
		private void UpdateAccounts(long SOID)
		{
			try
			{
				SODetails clsSODetails = Details(SOID);
				ChartOfAccounts clsChartOfAccount = new ChartOfAccounts(base.Connection, base.Transaction);

				// update ChartOfAccountIDARTracking as credit
				clsChartOfAccount.UpdateCredit(clsSODetails.ChartOfAccountIDARTracking, clsSODetails.SubTotal);

				// update Deposit & APContra
				clsChartOfAccount.UpdateCredit(clsSODetails.ChartOfAccountIDARContra, clsSODetails.Discount);

				// update Freight & APTracking
				clsChartOfAccount.UpdateCredit(clsSODetails.ChartOfAccountIDARTracking, clsSODetails.Freight);
				clsChartOfAccount.UpdateDebit(clsSODetails.ChartOfAccountIDARFreight, clsSODetails.Freight);

				// update Deposit & APTracking
				clsChartOfAccount.UpdateCredit(clsSODetails.ChartOfAccountIDARTracking, clsSODetails.Deposit);
				clsChartOfAccount.UpdateDebit(clsSODetails.ChartOfAccountIDARVDeposit, clsSODetails.Deposit);

				SOItem clsSOItem = new SOItem(base.Connection, base.Transaction);
                System.Data.DataTable dt = clsSOItem.ListAsDataTable(SOID, "SOItemID", SortOption.Ascending);
                foreach (System.Data.DataRow dr in dt.Rows)
				{
					int iChartOfAccountIDSold = Int16.Parse(dr["ChartOfAccountIDSold"].ToString());
                    int iChartOfAccountIDTaxSold = Int16.Parse(dr["ChartOfAccountIDTaxSold"].ToString());

					decimal decVAT = decimal.Parse(dr["VAT"].ToString());
                    decimal decVATABLEAmount = decimal.Parse(dr["Amount"].ToString()) - decVAT;

					// update purchase as debit
					clsChartOfAccount.UpdateDebit(iChartOfAccountIDSold, decVATABLEAmount);
					// update tax as debit
					clsChartOfAccount.UpdateDebit(iChartOfAccountIDTaxSold, decVAT);
				}

			}

			catch (Exception ex)
			{
				base.ThrowException(ex);
			}
		}
예제 #8
0
파일: PO.cs 프로젝트: marioricci/erp-luma
        private void UpdateAccounts(long POID)
        {
            try
            {
                PODetails clsPODetails = Details(POID);
                ChartOfAccounts clsChartOfAccount = new ChartOfAccounts(base.Connection, base.Transaction);

                // update ChartOfAccountIDAPTracking as credit
                clsChartOfAccount.UpdateCredit(clsPODetails.ChartOfAccountIDAPTracking, clsPODetails.SubTotal);

                // update Deposit & APContra
                clsChartOfAccount.UpdateCredit(clsPODetails.ChartOfAccountIDAPContra, clsPODetails.Discount);

                // update Freight & APTracking
                clsChartOfAccount.UpdateCredit(clsPODetails.ChartOfAccountIDAPTracking, clsPODetails.Freight);    
                clsChartOfAccount.UpdateDebit(clsPODetails.ChartOfAccountIDAPFreight, clsPODetails.Freight);

                // update Deposit & APTracking
                clsChartOfAccount.UpdateCredit(clsPODetails.ChartOfAccountIDAPTracking, clsPODetails.Deposit);
                clsChartOfAccount.UpdateDebit(clsPODetails.ChartOfAccountIDAPVDeposit, clsPODetails.Deposit);

                POItem clsPOItem = new POItem(base.Connection, base.Transaction);
                System.Data.DataTable dt = clsPOItem.ListAsDataTable(POID, "POItemID", SortOption.Ascending);
                foreach (System.Data.DataRow dr in dt.Rows)
                { 
                    int iChartOfAccountIDPurchase = Convert.ToInt16(dr["ChartOfAccountIDPurchase"]);
                    int iChartOfAccountIDTaxPurchase = Convert.ToInt16(dr["ChartOfAccountIDTaxPurchase"]);
                    
                    decimal decVAT = Convert.ToDecimal(dr["VAT"]);
                    decimal decVATABLEAmount = Convert.ToDecimal(dr["Amount"]) - decVAT;

                    // update purchase as debit
                    clsChartOfAccount.UpdateDebit(iChartOfAccountIDPurchase, decVATABLEAmount);
                    // update tax as debit
                    clsChartOfAccount.UpdateDebit(iChartOfAccountIDTaxPurchase, decVAT);
                }

            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }	
        }