public Int32 Insert(PesoDenominationDetails Details) { try { string SQL = "INSERT INTO tblPesoDenominations (" + "CashierID, " + "CashierName, " + "TerminalNo, " + "DenominationDate, " + "OneThousandPesos, " + "FiveHundredPesos, " + "OneHundredPesos, " + "FiftyPesos, " + "TwentyPesos, " + "TenPesos, " + "FivePesos, " + "OnePeso, " + "TwentyFiveCents, " + "Others " + ") VALUES (" + "@CashierID, " + "@CashierName, " + "@TerminalNo, " + "@DenominationDate, " + "@OneThousandPesos, " + "@FiveHundredPesos, " + "@OneHundredPesos, " + "@FiftyPesos, " + "@TwentyPesos, " + "@TenPesos, " + "@FivePesos, " + "@OnePeso, " + "@TwentyFiveCents, " + "@Others);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; // MySqlParameter prmDenominationID = new MySqlParameter("@DenominationID",MySqlDbType.Int32); // prmDenominationID.Value = Details.DenominationID; // cmd.Parameters.Add(prmDenominationID); MySqlParameter prmCashierID = new MySqlParameter("@CashierID", MySqlDbType.Int32); prmCashierID.Value = Details.CashierID; cmd.Parameters.Add(prmCashierID); MySqlParameter prmCashierName = new MySqlParameter("@CashierName", MySqlDbType.String); prmCashierName.Value = Details.CashierName; cmd.Parameters.Add(prmCashierName); MySqlParameter prmTerminalNo = new MySqlParameter("@TerminalNo", MySqlDbType.String); prmTerminalNo.Value = Details.TerminalNo; cmd.Parameters.Add(prmTerminalNo); MySqlParameter prmDenominationDate = new MySqlParameter("@DenominationDate", MySqlDbType.DateTime); prmDenominationDate.Value = Details.DenominationDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmDenominationDate); MySqlParameter prmOneThousandPesos = new MySqlParameter("@OneThousandPesos", MySqlDbType.Int16); prmOneThousandPesos.Value = Details.OneThousandPesos; cmd.Parameters.Add(prmOneThousandPesos); MySqlParameter prmFiveHundredPesos = new MySqlParameter("@FiveHundredPesos", MySqlDbType.Int16); prmFiveHundredPesos.Value = Details.FiveHundredPesos; cmd.Parameters.Add(prmFiveHundredPesos); MySqlParameter prmOneHundredPesos = new MySqlParameter("@OneHundredPesos", MySqlDbType.Int16); prmOneHundredPesos.Value = Details.OneHundredPesos; cmd.Parameters.Add(prmOneHundredPesos); MySqlParameter prmFiftyPesos = new MySqlParameter("@FiftyPesos", MySqlDbType.Int16); prmFiftyPesos.Value = Details.FiftyPesos; cmd.Parameters.Add(prmFiftyPesos); MySqlParameter prmTwentyPesos = new MySqlParameter("@TwentyPesos", MySqlDbType.Int16); prmTwentyPesos.Value = Details.TwentyPesos; cmd.Parameters.Add(prmTwentyPesos); MySqlParameter prmTenPesos = new MySqlParameter("@TenPesos", MySqlDbType.Int16); prmTenPesos.Value = Details.TenPesos; cmd.Parameters.Add(prmTenPesos); MySqlParameter prmFivePesos = new MySqlParameter("@FivePesos", MySqlDbType.Int16); prmFivePesos.Value = Details.FivePesos; cmd.Parameters.Add(prmFivePesos); MySqlParameter prmOnePeso = new MySqlParameter("@OnePeso", MySqlDbType.Int16); prmOnePeso.Value = Details.OnePeso; cmd.Parameters.Add(prmOnePeso); MySqlParameter prmTwentyFiveCents = new MySqlParameter("@TwentyFiveCents", MySqlDbType.Int16); prmTwentyFiveCents.Value = Details.TwentyFiveCents; cmd.Parameters.Add(prmTwentyFiveCents); MySqlParameter prmOthers = new MySqlParameter("@Others", MySqlDbType.Decimal); prmOthers.Value = Details.Others; cmd.Parameters.Add(prmOthers); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); cmd.CommandText = SQL; MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); Int32 iID = 0; while (myReader.Read()) { iID = myReader.GetInt32(0); } myReader.Close(); return(iID); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public PesoDenominationDetails Details(Int32 DenominationID) { try { string SQL = "SELECT " + "DenominationID, " + "CashierID, " + "CashierName, " + "TerminalNo, " + "DenominationDate, " + "OneThousandPesos, " + "FiveHundredPesos, " + "OneHundredPesos, " + "FiftyPesos, " + "TwentyPesos, " + "TenPesos, " + "FivePesos, " + "OnePeso, " + "TwentyFiveCents, " + "Others " + "FROM tblPesoDenominations " + "WHERE DenominationID = @DenominationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmDenominationID = new MySqlParameter("@DenominationID", MySqlDbType.Int32); prmDenominationID.Value = DenominationID; cmd.Parameters.Add(prmDenominationID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); PesoDenominationDetails Details = new PesoDenominationDetails(); while (myReader.Read()) { Details.DenominationID = DenominationID; Details.CashierID = myReader.GetInt32(1); Details.CashierName = myReader.GetString(2); Details.TerminalNo = myReader.GetString(3); Details.DenominationDate = myReader.GetDateTime(4); Details.OneThousandPesos = myReader.GetInt16(5); Details.FiveHundredPesos = myReader.GetInt16(6); Details.OneHundredPesos = myReader.GetInt16(7); Details.FiftyPesos = myReader.GetInt16(8); Details.TwentyPesos = myReader.GetInt16(9); Details.TenPesos = myReader.GetInt16(10); Details.FivePesos = myReader.GetInt16(11); Details.OnePeso = myReader.GetInt16(12); Details.TwentyFiveCents = myReader.GetInt16(13); Details.Others = myReader.GetDecimal(14); } myReader.Close(); return(Details); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public void Update(PesoDenominationDetails Details) { try { string SQL = "UPDATE tblPesoDenominations SET " + "CashierID = @CashierID, " + "CashierName = @CashierName, " + "TerminalNo = @TerminalNo, " + "DenominationDate = @DenominationDate, " + "OneThousandPesos = @OneThousandPesos, " + "FiveHundredPesos = @FiveHundredPesos, " + "OneHundredPesos = @OneHundredPesos, " + "FiftyPesos = @FiftyPesos, " + "TwentyPesos = @TwentyPesos, " + "TenPesos = @TenPesos, " + "FivePesos = @FivePesos, " + "OnePeso = @OnePeso, " + "TwentyFiveCents = @TwentyFiveCents, " + "Others = @Others " + "WHERE DenominationID = @DenominationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmCashierID = new MySqlParameter("@CashierID", MySqlDbType.Int32); prmCashierID.Value = Details.CashierID; cmd.Parameters.Add(prmCashierID); MySqlParameter prmCashierName = new MySqlParameter("@CashierName", MySqlDbType.String); prmCashierName.Value = Details.CashierName; cmd.Parameters.Add(prmCashierName); MySqlParameter prmTerminalNo = new MySqlParameter("@TerminalNo", MySqlDbType.String); prmTerminalNo.Value = Details.TerminalNo; cmd.Parameters.Add(prmTerminalNo); MySqlParameter prmDenominationDate = new MySqlParameter("@DenominationDate", MySqlDbType.DateTime); prmDenominationDate.Value = Details.DenominationDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmDenominationDate); MySqlParameter prmOneThousandPesos = new MySqlParameter("@OneThousandPesos", MySqlDbType.Int16); prmOneThousandPesos.Value = Details.OneThousandPesos; cmd.Parameters.Add(prmOneThousandPesos); MySqlParameter prmFiveHundredPesos = new MySqlParameter("@FiveHundredPesos", MySqlDbType.Int16); prmFiveHundredPesos.Value = Details.FiveHundredPesos; cmd.Parameters.Add(prmFiveHundredPesos); MySqlParameter prmOneHundredPesos = new MySqlParameter("@OneHundredPesos", MySqlDbType.Int16); prmOneHundredPesos.Value = Details.OneHundredPesos; cmd.Parameters.Add(prmOneHundredPesos); MySqlParameter prmFiftyPesos = new MySqlParameter("@FiftyPesos", MySqlDbType.Int16); prmFiftyPesos.Value = Details.FiftyPesos; cmd.Parameters.Add(prmFiftyPesos); MySqlParameter prmTwentyPesos = new MySqlParameter("@TwentyPesos", MySqlDbType.Int16); prmTwentyPesos.Value = Details.TwentyPesos; cmd.Parameters.Add(prmTwentyPesos); MySqlParameter prmTenPesos = new MySqlParameter("@TenPesos", MySqlDbType.Int16); prmTenPesos.Value = Details.TenPesos; cmd.Parameters.Add(prmTenPesos); MySqlParameter prmFivePesos = new MySqlParameter("@FivePesos", MySqlDbType.Int16); prmFivePesos.Value = Details.FivePesos; cmd.Parameters.Add(prmFivePesos); MySqlParameter prmOnePeso = new MySqlParameter("@OnePeso", MySqlDbType.Int16); prmOnePeso.Value = Details.OnePeso; cmd.Parameters.Add(prmOnePeso); MySqlParameter prmDenominationID = new MySqlParameter("@DenominationID", MySqlDbType.Int32); prmDenominationID.Value = Details.DenominationID; cmd.Parameters.Add(prmDenominationID); MySqlParameter prmTwentyFiveCents = new MySqlParameter("@TwentyFiveCents", MySqlDbType.Int16); prmTwentyFiveCents.Value = Details.TwentyFiveCents; cmd.Parameters.Add(prmTwentyFiveCents); MySqlParameter prmOthers = new MySqlParameter("@Others", MySqlDbType.Decimal); prmOthers.Value = Details.Others; cmd.Parameters.Add(prmOthers); base.ExecuteNonQuery(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public Int32 Insert(PesoDenominationDetails Details) { try { string SQL = "INSERT INTO tblPesoDenominations (" + "CashierID, " + "CashierName, " + "TerminalNo, " + "DenominationDate, " + "OneThousandPesos, " + "FiveHundredPesos, " + "OneHundredPesos, " + "FiftyPesos, " + "TwentyPesos, " + "TenPesos, " + "FivePesos, " + "OnePeso, " + "TwentyFiveCents, " + "Others " + ") VALUES (" + "@CashierID, " + "@CashierName, " + "@TerminalNo, " + "@DenominationDate, " + "@OneThousandPesos, " + "@FiveHundredPesos, " + "@OneHundredPesos, " + "@FiftyPesos, " + "@TwentyPesos, " + "@TenPesos, " + "@FivePesos, " + "@OnePeso, " + "@TwentyFiveCents, " + "@Others);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; // MySqlParameter prmDenominationID = new MySqlParameter("@DenominationID",MySqlDbType.Int32); // prmDenominationID.Value = Details.DenominationID; // cmd.Parameters.Add(prmDenominationID); MySqlParameter prmCashierID = new MySqlParameter("@CashierID",MySqlDbType.Int32); prmCashierID.Value = Details.CashierID; cmd.Parameters.Add(prmCashierID); MySqlParameter prmCashierName = new MySqlParameter("@CashierName",MySqlDbType.String); prmCashierName.Value = Details.CashierName; cmd.Parameters.Add(prmCashierName); MySqlParameter prmTerminalNo = new MySqlParameter("@TerminalNo",MySqlDbType.String); prmTerminalNo.Value = Details.TerminalNo; cmd.Parameters.Add(prmTerminalNo); MySqlParameter prmDenominationDate = new MySqlParameter("@DenominationDate",MySqlDbType.DateTime); prmDenominationDate.Value = Details.DenominationDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmDenominationDate); MySqlParameter prmOneThousandPesos = new MySqlParameter("@OneThousandPesos",MySqlDbType.Int16); prmOneThousandPesos.Value = Details.OneThousandPesos; cmd.Parameters.Add(prmOneThousandPesos); MySqlParameter prmFiveHundredPesos = new MySqlParameter("@FiveHundredPesos",MySqlDbType.Int16); prmFiveHundredPesos.Value = Details.FiveHundredPesos; cmd.Parameters.Add(prmFiveHundredPesos); MySqlParameter prmOneHundredPesos = new MySqlParameter("@OneHundredPesos",MySqlDbType.Int16); prmOneHundredPesos.Value = Details.OneHundredPesos; cmd.Parameters.Add(prmOneHundredPesos); MySqlParameter prmFiftyPesos = new MySqlParameter("@FiftyPesos",MySqlDbType.Int16); prmFiftyPesos.Value = Details.FiftyPesos; cmd.Parameters.Add(prmFiftyPesos); MySqlParameter prmTwentyPesos = new MySqlParameter("@TwentyPesos",MySqlDbType.Int16); prmTwentyPesos.Value = Details.TwentyPesos; cmd.Parameters.Add(prmTwentyPesos); MySqlParameter prmTenPesos = new MySqlParameter("@TenPesos",MySqlDbType.Int16); prmTenPesos.Value = Details.TenPesos; cmd.Parameters.Add(prmTenPesos); MySqlParameter prmFivePesos = new MySqlParameter("@FivePesos",MySqlDbType.Int16); prmFivePesos.Value = Details.FivePesos; cmd.Parameters.Add(prmFivePesos); MySqlParameter prmOnePeso = new MySqlParameter("@OnePeso",MySqlDbType.Int16); prmOnePeso.Value = Details.OnePeso; cmd.Parameters.Add(prmOnePeso); MySqlParameter prmTwentyFiveCents = new MySqlParameter("@TwentyFiveCents",MySqlDbType.Int16); prmTwentyFiveCents.Value = Details.TwentyFiveCents; cmd.Parameters.Add(prmTwentyFiveCents); MySqlParameter prmOthers = new MySqlParameter("@Others",MySqlDbType.Decimal); prmOthers.Value = Details.Others; cmd.Parameters.Add(prmOthers); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); cmd.CommandText = SQL; MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); Int32 iID = 0; while (myReader.Read()) { iID = myReader.GetInt32(0); } myReader.Close(); return iID; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public PesoDenominationDetails Details(Int32 DenominationID) { try { string SQL = "SELECT " + "DenominationID, " + "CashierID, " + "CashierName, " + "TerminalNo, " + "DenominationDate, " + "OneThousandPesos, " + "FiveHundredPesos, " + "OneHundredPesos, " + "FiftyPesos, " + "TwentyPesos, " + "TenPesos, " + "FivePesos, " + "OnePeso, " + "TwentyFiveCents, " + "Others " + "FROM tblPesoDenominations " + "WHERE DenominationID = @DenominationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmDenominationID = new MySqlParameter("@DenominationID",MySqlDbType.Int32); prmDenominationID.Value = DenominationID; cmd.Parameters.Add(prmDenominationID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); PesoDenominationDetails Details = new PesoDenominationDetails(); while (myReader.Read()) { Details.DenominationID = DenominationID; Details.CashierID = myReader.GetInt32(1); Details.CashierName = myReader.GetString(2); Details.TerminalNo = myReader.GetString(3); Details.DenominationDate = myReader.GetDateTime(4); Details.OneThousandPesos = myReader.GetInt16(5); Details.FiveHundredPesos = myReader.GetInt16(6); Details.OneHundredPesos = myReader.GetInt16(7); Details.FiftyPesos = myReader.GetInt16(8); Details.TwentyPesos = myReader.GetInt16(9); Details.TenPesos = myReader.GetInt16(10); Details.FivePesos = myReader.GetInt16(11); Details.OnePeso = myReader.GetInt16(12); Details.TwentyFiveCents = myReader.GetInt16(13); Details.Others = myReader.GetDecimal(14); } myReader.Close(); return Details; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public void Update(PesoDenominationDetails Details) { try { string SQL = "UPDATE tblPesoDenominations SET " + "CashierID = @CashierID, " + "CashierName = @CashierName, " + "TerminalNo = @TerminalNo, " + "DenominationDate = @DenominationDate, " + "OneThousandPesos = @OneThousandPesos, " + "FiveHundredPesos = @FiveHundredPesos, " + "OneHundredPesos = @OneHundredPesos, " + "FiftyPesos = @FiftyPesos, " + "TwentyPesos = @TwentyPesos, " + "TenPesos = @TenPesos, " + "FivePesos = @FivePesos, " + "OnePeso = @OnePeso, " + "TwentyFiveCents = @TwentyFiveCents, " + "Others = @Others " + "WHERE DenominationID = @DenominationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmCashierID = new MySqlParameter("@CashierID",MySqlDbType.Int32); prmCashierID.Value = Details.CashierID; cmd.Parameters.Add(prmCashierID); MySqlParameter prmCashierName = new MySqlParameter("@CashierName",MySqlDbType.String); prmCashierName.Value = Details.CashierName; cmd.Parameters.Add(prmCashierName); MySqlParameter prmTerminalNo = new MySqlParameter("@TerminalNo",MySqlDbType.String); prmTerminalNo.Value = Details.TerminalNo; cmd.Parameters.Add(prmTerminalNo); MySqlParameter prmDenominationDate = new MySqlParameter("@DenominationDate",MySqlDbType.DateTime); prmDenominationDate.Value = Details.DenominationDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmDenominationDate); MySqlParameter prmOneThousandPesos = new MySqlParameter("@OneThousandPesos",MySqlDbType.Int16); prmOneThousandPesos.Value = Details.OneThousandPesos; cmd.Parameters.Add(prmOneThousandPesos); MySqlParameter prmFiveHundredPesos = new MySqlParameter("@FiveHundredPesos",MySqlDbType.Int16); prmFiveHundredPesos.Value = Details.FiveHundredPesos; cmd.Parameters.Add(prmFiveHundredPesos); MySqlParameter prmOneHundredPesos = new MySqlParameter("@OneHundredPesos",MySqlDbType.Int16); prmOneHundredPesos.Value = Details.OneHundredPesos; cmd.Parameters.Add(prmOneHundredPesos); MySqlParameter prmFiftyPesos = new MySqlParameter("@FiftyPesos",MySqlDbType.Int16); prmFiftyPesos.Value = Details.FiftyPesos; cmd.Parameters.Add(prmFiftyPesos); MySqlParameter prmTwentyPesos = new MySqlParameter("@TwentyPesos",MySqlDbType.Int16); prmTwentyPesos.Value = Details.TwentyPesos; cmd.Parameters.Add(prmTwentyPesos); MySqlParameter prmTenPesos = new MySqlParameter("@TenPesos",MySqlDbType.Int16); prmTenPesos.Value = Details.TenPesos; cmd.Parameters.Add(prmTenPesos); MySqlParameter prmFivePesos = new MySqlParameter("@FivePesos",MySqlDbType.Int16); prmFivePesos.Value = Details.FivePesos; cmd.Parameters.Add(prmFivePesos); MySqlParameter prmOnePeso = new MySqlParameter("@OnePeso",MySqlDbType.Int16); prmOnePeso.Value = Details.OnePeso; cmd.Parameters.Add(prmOnePeso); MySqlParameter prmDenominationID = new MySqlParameter("@DenominationID",MySqlDbType.Int32); prmDenominationID.Value = Details.DenominationID; cmd.Parameters.Add(prmDenominationID); MySqlParameter prmTwentyFiveCents = new MySqlParameter("@TwentyFiveCents",MySqlDbType.Int16); prmTwentyFiveCents.Value = Details.TwentyFiveCents; cmd.Parameters.Add(prmTwentyFiveCents); MySqlParameter prmOthers = new MySqlParameter("@Others",MySqlDbType.Decimal); prmOthers.Value = Details.Others; cmd.Parameters.Add(prmOthers); base.ExecuteNonQuery(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }