Beispiel #1
0
		public long Insert(PaymentsDebitDetails Details)
		{
			try 
			{
				string SQL = "INSERT INTO tblPaymentDebit (" +
								"PaymentID, " +
								"ChartOfAccountID, " +
								"Amount" +
							") VALUES (" +
								"@PaymentID, " +
								"@ChartOfAccountID, " +
								"@Amount" +
							");";
	 			
				MySqlCommand cmd = new MySqlCommand();
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;

				MySqlParameter prmPaymentID = new MySqlParameter("@PaymentID",MySqlDbType.Int64);			
				prmPaymentID.Value = Details.PaymentID;
				cmd.Parameters.Add(prmPaymentID);

				MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID",MySqlDbType.Int64);			
				prmChartOfAccountID.Value = Details.ChartOfAccountID;
				cmd.Parameters.Add(prmChartOfAccountID);

				MySqlParameter prmAmount = new MySqlParameter("@Amount",MySqlDbType.Decimal);			
				prmAmount.Value = Details.Amount;
				cmd.Parameters.Add(prmAmount);
     
				base.ExecuteNonQuery(cmd);

                SQL = "SELECT LAST_INSERT_ID();";

                cmd.Parameters.Clear();
                cmd.CommandText = SQL;

                string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
                base.MySqlDataAdapterFill(cmd, dt);

                Int64 iID = 0;

                foreach (System.Data.DataRow dr in dt.Rows)
                {
                    iID = Int64.Parse(dr[0].ToString());
                }

				return iID;
			}

			catch (Exception ex)
			{
				throw base.ThrowException(ex);
			}	
		}
Beispiel #2
0
        public long Insert(PaymentsDebitDetails Details)
        {
            try
            {
                string SQL = "INSERT INTO tblPaymentDebit (" +
                             "PaymentID, " +
                             "ChartOfAccountID, " +
                             "Amount" +
                             ") VALUES (" +
                             "@PaymentID, " +
                             "@ChartOfAccountID, " +
                             "@Amount" +
                             ");";

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

                MySqlParameter prmPaymentID = new MySqlParameter("@PaymentID", MySqlDbType.Int64);
                prmPaymentID.Value = Details.PaymentID;
                cmd.Parameters.Add(prmPaymentID);

                MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID", MySqlDbType.Int64);
                prmChartOfAccountID.Value = Details.ChartOfAccountID;
                cmd.Parameters.Add(prmChartOfAccountID);

                MySqlParameter prmAmount = new MySqlParameter("@Amount", MySqlDbType.Decimal);
                prmAmount.Value = Details.Amount;
                cmd.Parameters.Add(prmAmount);

                base.ExecuteNonQuery(cmd);

                SQL = "SELECT LAST_INSERT_ID();";

                cmd.Parameters.Clear();
                cmd.CommandText = SQL;

                string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
                base.MySqlDataAdapterFill(cmd, dt);

                Int64 iID = 0;

                foreach (System.Data.DataRow dr in dt.Rows)
                {
                    iID = Int64.Parse(dr[0].ToString());
                }

                return(iID);
            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
Beispiel #3
0
        public PaymentsDebitDetails Details(long PaymentDebitID)
        {
            try
            {
                string SQL = "SELECT " +
                             "PaymentDebitID, " +
                             "PaymentID, " +
                             "a.ChartOfAccountID, " +
                             "ChartOfAccountCode, " +
                             "ChartOfAccountName, " +
                             "Amount " +
                             "FROM tblPaymentDebit a INNER JOIN tblChartOfAccount b " +
                             "ON a.ChartOfAccountID = b.ChartOfAccountID " +
                             "WHERE PaymentDebitID = @PaymentDebitID;";

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

                MySqlParameter prmPaymentDebitID = new MySqlParameter("@PaymentDebitID", MySqlDbType.Int64);
                prmPaymentDebitID.Value = PaymentDebitID;
                cmd.Parameters.Add(prmPaymentDebitID);

                string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
                base.MySqlDataAdapterFill(cmd, dt);

                PaymentsDebitDetails Details = new PaymentsDebitDetails();

                foreach (System.Data.DataRow dr in dt.Rows)
                {
                    Details.PaymentDebitID   = PaymentDebitID;
                    Details.PaymentID        = Int64.Parse(dr["PaymentID"].ToString());
                    Details.ChartOfAccountID = Int32.Parse(dr["ChartOfAccountID"].ToString());
                    Details.Amount           = decimal.Parse(dr["Amount"].ToString());
                }

                return(Details);
            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
Beispiel #4
0
        public void Update(PaymentsDebitDetails Details)
        {
            try
            {
                string SQL = "UPDATE tblPaymentDebit SET " +
                             "PaymentID			=	@PaymentID, "+
                             "ChartOfAccountID	=	@ChartOfAccountID, "+
                             "Amount				=	@Amount "+
                             "WHERE PaymentDebitID	=	@PaymentDebitID;";

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

                MySqlParameter prmPaymentID = new MySqlParameter("@PaymentID", MySqlDbType.Int64);
                prmPaymentID.Value = Details.PaymentID;
                cmd.Parameters.Add(prmPaymentID);

                MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID", MySqlDbType.Int64);
                prmChartOfAccountID.Value = Details.ChartOfAccountID;
                cmd.Parameters.Add(prmChartOfAccountID);

                MySqlParameter prmAmount = new MySqlParameter("@Amount", MySqlDbType.Decimal);
                prmAmount.Value = Details.Amount;
                cmd.Parameters.Add(prmAmount);

                MySqlParameter prmPaymentDebitID = new MySqlParameter("@PaymentDebitID", MySqlDbType.Int64);
                prmPaymentDebitID.Value = Details.PaymentDebitID;
                cmd.Parameters.Add(prmPaymentDebitID);

                base.ExecuteNonQuery(cmd);
            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
Beispiel #5
0
		public PaymentsDebitDetails Details(long PaymentDebitID)
		{
			try
			{
				string SQL =	"SELECT " +
									"PaymentDebitID, " +
									"PaymentID, " +
									"a.ChartOfAccountID, " +
									"ChartOfAccountCode, " +
									"ChartOfAccountName, " +
									"Amount " +
								"FROM tblPaymentDebit a INNER JOIN tblChartOfAccount b " +
									"ON a.ChartOfAccountID = b.ChartOfAccountID " +
								"WHERE PaymentDebitID = @PaymentDebitID;";
				  
				MySqlCommand cmd = new MySqlCommand();
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;

				MySqlParameter prmPaymentDebitID = new MySqlParameter("@PaymentDebitID",MySqlDbType.Int64);			
				prmPaymentDebitID.Value = PaymentDebitID;
				cmd.Parameters.Add(prmPaymentDebitID);

                string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
                base.MySqlDataAdapterFill(cmd, dt);

                PaymentsDebitDetails Details = new PaymentsDebitDetails();

                foreach (System.Data.DataRow dr in dt.Rows)
                {
                    Details.PaymentDebitID = PaymentDebitID;
                    Details.PaymentID = Int64.Parse(dr["PaymentID"].ToString());
                    Details.ChartOfAccountID = Int32.Parse(dr["ChartOfAccountID"].ToString());
                    Details.Amount = decimal.Parse(dr["Amount"].ToString());
                }

				return Details;
			}

			catch (Exception ex)
			{
				throw base.ThrowException(ex);
			}	
		}
Beispiel #6
0
		public void Update(PaymentsDebitDetails Details)
		{
			try 
			{
				string SQL = "UPDATE tblPaymentDebit SET " + 
								"PaymentID			=	@PaymentID, " +
								"ChartOfAccountID	=	@ChartOfAccountID, " +
								"Amount				=	@Amount " +
							"WHERE PaymentDebitID	=	@PaymentDebitID;";
				  
				MySqlCommand cmd = new MySqlCommand();
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;

				MySqlParameter prmPaymentID = new MySqlParameter("@PaymentID",MySqlDbType.Int64);			
				prmPaymentID.Value = Details.PaymentID;
				cmd.Parameters.Add(prmPaymentID);

				MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID",MySqlDbType.Int64);			
				prmChartOfAccountID.Value = Details.ChartOfAccountID;
				cmd.Parameters.Add(prmChartOfAccountID);

				MySqlParameter prmAmount = new MySqlParameter("@Amount",MySqlDbType.Decimal);			
				prmAmount.Value = Details.Amount;
				cmd.Parameters.Add(prmAmount);

				MySqlParameter prmPaymentDebitID = new MySqlParameter("@PaymentDebitID",MySqlDbType.Int64);				
				prmPaymentDebitID.Value = Details.PaymentDebitID;
				cmd.Parameters.Add(prmPaymentDebitID);

				base.ExecuteNonQuery(cmd);
			}

			catch (Exception ex)
			{
				throw base.ThrowException(ex);
			}	
		}
Beispiel #7
0
		private void SaveDebit()
		{
			PaymentsDebitDetails clsDetails = new PaymentsDebitDetails();
			
			clsDetails.PaymentID = Convert.ToInt64(lblPaymentID.Text);
			clsDetails.ChartOfAccountID = Convert.ToInt32(cboAccount.SelectedItem.Value);
			clsDetails.Amount = Convert.ToDecimal(txtAmount.Text);

			PaymentsDebit clsPaymentsDebit = new PaymentsDebit();
			clsPaymentsDebit.Insert(clsDetails);
			clsPaymentsDebit.CommitAndDispose();
		}