public BankDepositDetails Details(long BankDepositID) { try { string SQL = SQLSelect() + "WHERE BankDepositID = @BankDepositID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmBankDepositID = new MySqlParameter("@BankDepositID", MySqlDbType.Int64); prmBankDepositID.Value = BankDepositID; cmd.Parameters.Add(prmBankDepositID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); BankDepositDetails Details = new BankDepositDetails(); while (myReader.Read()) { Details.BankDepositID = BankDepositID; Details.TransactionDate = myReader.GetDateTime("TransactionDate"); Details.DepositStatus = (BankDepositStatus)Enum.Parse(typeof(BankDepositStatus), myReader.GetString("DepositStatus")); Details.DepositInAccountID = myReader.GetInt32("DepositInAccountID"); Details.DepositInAccountName = "" + myReader["DepositInAccountName"].ToString(); Details.DepositMemo = "" + myReader["DepositMemo"].ToString(); Details.DepositItemDate = myReader.GetDateTime("DepositItemDate"); Details.DepositItemType = (BankDepositType)Enum.Parse(typeof(BankDepositType), myReader.GetString("DepositItemType")); Details.DepositItemAccountID = myReader.GetInt32("DepositItemAccountID"); Details.DepositItemAccountName = "" + myReader["DepositItemAccountName"].ToString(); Details.DepositItemReference = "" + myReader["DepositItemReference"].ToString(); Details.DepositItemAmount = myReader.GetDecimal("DepositItemAmount"); Details.CashBackAccountID = myReader.GetInt32("CashBackAccountID"); Details.CashBackAccountName = "" + myReader["CashBackAccountName"].ToString(); Details.CashBackAmount = myReader.GetDecimal("CashBackAmount"); Details.CashBackMemo = "" + myReader["CashBackMemo"].ToString(); Details.CreatedByID = myReader.GetInt64("CreatedByID"); } myReader.Close(); return(Details); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public void Update(BankDepositDetails Details) { try { string SQL = "UPDATE tblBankDeposit SET " + "TransactionDate = @TransactionDate, " + "DepositStatus = @DepositStatus, " + "DepositInAccountID = @DepositInAccountID, " + "DepositMemo = @DepositMemo, " + "DepositItemDate = @DepositItemDate, " + "DepositItemType = @DepositItemType, " + "DepositItemAccountID = @DepositItemAccountID, " + "DepositItemReference = @DepositItemReference, " + "DepositItemAmount = @DepositItemAmount, " + "CashBackAccountID = @CashBackAccountID, " + "CashBackAmount = @CashBackAmount, " + "CashBackMemo = @CashBackMemo " + "WHERE BankDepositID = @BankDepositID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@TransactionDate", Details.TransactionDate); cmd.Parameters.AddWithValue("@DepositStatus", Details.DepositStatus.ToString("d")); cmd.Parameters.AddWithValue("@DepositInAccountID", Details.DepositInAccountID); cmd.Parameters.AddWithValue("@DepositMemo", Details.DepositMemo); cmd.Parameters.AddWithValue("@DepositItemDate", Details.DepositItemDate); cmd.Parameters.AddWithValue("@DepositItemType", Details.DepositItemType.ToString("d")); cmd.Parameters.AddWithValue("@DepositItemAccountID", Details.DepositItemAccountID); cmd.Parameters.AddWithValue("@DepositItemReference", Details.DepositItemReference); cmd.Parameters.AddWithValue("@DepositItemAmount", Details.DepositItemAmount); cmd.Parameters.AddWithValue("@CashBackAccountID", Details.CashBackAccountID); cmd.Parameters.AddWithValue("@CashBackAmount", Details.CashBackAmount); cmd.Parameters.AddWithValue("@CashBackMemo", Details.CashBackMemo); cmd.Parameters.AddWithValue("@CreatedByID", Details.CreatedByID); cmd.Parameters.AddWithValue("@BankDepositID", Details.BankDepositID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
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); } }
public Int32 Insert(BankDepositDetails Details) { try { string SQL = "INSERT INTO tblBankDeposit (" + "TransactionDate, " + "DepositStatus, " + "DepositInAccountID, " + "DepositMemo, " + "DepositItemDate, " + "DepositItemType, " + "DepositItemAccountID, " + "DepositItemReference, " + "DepositItemAmount, " + "CashBackAccountID, " + "CashBackAmount, " + "CashBackMemo, " + "CreatedByID" + ") VALUES (" + "@TransactionDate, " + "@DepositStatus, " + "@DepositInAccountID, " + "@DepositMemo, " + "@DepositItemDate, " + "@DepositItemType, " + "@DepositItemAccountID, " + "@DepositItemReference, " + "@DepositItemAmount, " + "@CashBackAccountID, " + "@CashBackAmount, " + "@CashBackMemo, " + "@CreatedByID" + ");"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@TransactionDate", Details.TransactionDate); cmd.Parameters.AddWithValue("@DepositStatus", Details.DepositStatus.ToString("d")); cmd.Parameters.AddWithValue("@DepositInAccountID", Details.DepositInAccountID); cmd.Parameters.AddWithValue("@DepositMemo", Details.DepositMemo); cmd.Parameters.AddWithValue("@DepositItemDate", Details.DepositItemDate); cmd.Parameters.AddWithValue("@DepositItemType", Details.DepositItemType.ToString("d")); cmd.Parameters.AddWithValue("@DepositItemAccountID", Details.DepositItemAccountID); cmd.Parameters.AddWithValue("@DepositItemReference", Details.DepositItemReference); cmd.Parameters.AddWithValue("@DepositItemAmount", Details.DepositItemAmount); cmd.Parameters.AddWithValue("@CashBackAccountID", Details.CashBackAccountID); cmd.Parameters.AddWithValue("@CashBackAmount", Details.CashBackAmount); cmd.Parameters.AddWithValue("@CashBackMemo", Details.CashBackMemo); cmd.Parameters.AddWithValue("@CreatedByID", Details.CreatedByID); 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); Int32 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int32.Parse(dr[0].ToString()); } return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
public BankDepositDetails Details(long BankDepositID) { try { string SQL = SQLSelect() + "WHERE BankDepositID = @BankDepositID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmBankDepositID = new MySqlParameter("@BankDepositID",MySqlDbType.Int64); prmBankDepositID.Value = BankDepositID; cmd.Parameters.Add(prmBankDepositID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); BankDepositDetails Details = new BankDepositDetails(); while (myReader.Read()) { Details.BankDepositID = BankDepositID; Details.TransactionDate = myReader.GetDateTime("TransactionDate"); Details.DepositStatus = (BankDepositStatus) Enum.Parse(typeof(BankDepositStatus), myReader.GetString("DepositStatus")); Details.DepositInAccountID = myReader.GetInt32("DepositInAccountID"); Details.DepositInAccountName = "" + myReader["DepositInAccountName"].ToString(); Details.DepositMemo = "" + myReader["DepositMemo"].ToString(); Details.DepositItemDate = myReader.GetDateTime("DepositItemDate"); Details.DepositItemType = (BankDepositType)Enum.Parse(typeof(BankDepositType), myReader.GetString("DepositItemType")); Details.DepositItemAccountID = myReader.GetInt32("DepositItemAccountID"); Details.DepositItemAccountName = "" + myReader["DepositItemAccountName"].ToString(); Details.DepositItemReference = "" + myReader["DepositItemReference"].ToString(); Details.DepositItemAmount = myReader.GetDecimal("DepositItemAmount"); Details.CashBackAccountID = myReader.GetInt32("CashBackAccountID"); Details.CashBackAccountName = "" + myReader["CashBackAccountName"].ToString(); Details.CashBackAmount = myReader.GetDecimal("CashBackAmount"); Details.CashBackMemo = "" + myReader["CashBackMemo"].ToString(); Details.CreatedByID = myReader.GetInt64("CreatedByID"); } myReader.Close(); return Details; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public void Update(BankDepositDetails Details) { try { string SQL = "UPDATE tblBankDeposit SET " + "TransactionDate = @TransactionDate, " + "DepositStatus = @DepositStatus, " + "DepositInAccountID = @DepositInAccountID, " + "DepositMemo = @DepositMemo, " + "DepositItemDate = @DepositItemDate, " + "DepositItemType = @DepositItemType, " + "DepositItemAccountID = @DepositItemAccountID, " + "DepositItemReference = @DepositItemReference, " + "DepositItemAmount = @DepositItemAmount, " + "CashBackAccountID = @CashBackAccountID, " + "CashBackAmount = @CashBackAmount, " + "CashBackMemo = @CashBackMemo " + "WHERE BankDepositID = @BankDepositID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@TransactionDate", Details.TransactionDate); cmd.Parameters.AddWithValue("@DepositStatus", Details.DepositStatus.ToString("d")); cmd.Parameters.AddWithValue("@DepositInAccountID", Details.DepositInAccountID); cmd.Parameters.AddWithValue("@DepositMemo", Details.DepositMemo); cmd.Parameters.AddWithValue("@DepositItemDate", Details.DepositItemDate); cmd.Parameters.AddWithValue("@DepositItemType", Details.DepositItemType.ToString("d")); cmd.Parameters.AddWithValue("@DepositItemAccountID", Details.DepositItemAccountID); cmd.Parameters.AddWithValue("@DepositItemReference", Details.DepositItemReference); cmd.Parameters.AddWithValue("@DepositItemAmount", Details.DepositItemAmount); cmd.Parameters.AddWithValue("@CashBackAccountID", Details.CashBackAccountID); cmd.Parameters.AddWithValue("@CashBackAmount", Details.CashBackAmount); cmd.Parameters.AddWithValue("@CashBackMemo", Details.CashBackMemo); cmd.Parameters.AddWithValue("@CreatedByID", Details.CreatedByID); cmd.Parameters.AddWithValue("@BankDepositID", Details.BankDepositID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public Int32 Insert(BankDepositDetails Details) { try { string SQL = "INSERT INTO tblBankDeposit (" + "TransactionDate, " + "DepositStatus, " + "DepositInAccountID, " + "DepositMemo, " + "DepositItemDate, " + "DepositItemType, " + "DepositItemAccountID, " + "DepositItemReference, " + "DepositItemAmount, " + "CashBackAccountID, " + "CashBackAmount, " + "CashBackMemo, " + "CreatedByID" + ") VALUES (" + "@TransactionDate, " + "@DepositStatus, " + "@DepositInAccountID, " + "@DepositMemo, " + "@DepositItemDate, " + "@DepositItemType, " + "@DepositItemAccountID, " + "@DepositItemReference, " + "@DepositItemAmount, " + "@CashBackAccountID, " + "@CashBackAmount, " + "@CashBackMemo, " + "@CreatedByID" + ");"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@TransactionDate", Details.TransactionDate); cmd.Parameters.AddWithValue("@DepositStatus", Details.DepositStatus.ToString("d")); cmd.Parameters.AddWithValue("@DepositInAccountID", Details.DepositInAccountID); cmd.Parameters.AddWithValue("@DepositMemo", Details.DepositMemo); cmd.Parameters.AddWithValue("@DepositItemDate", Details.DepositItemDate); cmd.Parameters.AddWithValue("@DepositItemType", Details.DepositItemType.ToString("d")); cmd.Parameters.AddWithValue("@DepositItemAccountID", Details.DepositItemAccountID); cmd.Parameters.AddWithValue("@DepositItemReference", Details.DepositItemReference); cmd.Parameters.AddWithValue("@DepositItemAmount", Details.DepositItemAmount); cmd.Parameters.AddWithValue("@CashBackAccountID", Details.CashBackAccountID); cmd.Parameters.AddWithValue("@CashBackAmount", Details.CashBackAmount); cmd.Parameters.AddWithValue("@CashBackMemo", Details.CashBackMemo); cmd.Parameters.AddWithValue("@CreatedByID", Details.CreatedByID); 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); Int32 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int32.Parse(dr[0].ToString()); } return(iID); } catch (Exception ex) { throw base.ThrowException(ex); } }