public static PrepaidBottle GetPrepaidBottleByID(int prepaidBottleID) { // Account account = new Account(); PrepaidBottle pBottle = null; MyDBConnection myConn = new MyDBConnection(); SqlConnection conn = new SqlConnection(); SqlDataReader dr; SqlCommand cmd = null; string sql = "Select * from AquaOne.dbo.PrepaidBottle where PrepaidBottleID = @prepaidBottleID"; try { // Open the connection conn = myConn.OpenDB(); cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@prepaidBottleID", SqlDbType.Int).Value = prepaidBottleID; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.Read()) { pBottle = FillDataRecord(dr); } dr.Close(); cmd.Dispose(); } finally { //close the connection myConn.CloseDB(conn); } return(pBottle); }
private static PrepaidBottle FillDataRecord(IDataRecord dr) { PrepaidBottle prepaidBottle = new PrepaidBottle(); prepaidBottle.PrepaidBottleID = dr.GetInt32(dr.GetOrdinal("PrepaidBottleID")); prepaidBottle.AccountID = dr.GetInt32(dr.GetOrdinal("AccountID")); prepaidBottle.Balance = dr.GetInt32(dr.GetOrdinal("Balance")); prepaidBottle.PrepaidBottleType = dr.GetInt32(dr.GetOrdinal("PrepaidBottleType")); prepaidBottle.CreatedDate = dr.GetDateTime(dr.GetOrdinal("CreatedDate")); prepaidBottle.ModifiedDate = dr.GetDateTime(dr.GetOrdinal("ModifiedDate")); prepaidBottle.CreatedBy = dr.GetString(dr.GetOrdinal("CreatedBy")); prepaidBottle.ModifiedBy = dr.GetString(dr.GetOrdinal("ModifiedBy")); return(prepaidBottle); }
public static int Save(PrepaidBottle prepaidBottle) { int result; MyDBConnection myConn = new MyDBConnection(); SqlConnection conn = new SqlConnection(); try { conn = myConn.OpenDB(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "dbo.InsertUpdatePrepaidBottle"; if (prepaidBottle.PrepaidBottleID == -1) { cmd.Parameters.Add("@PrepaidBottleID", SqlDbType.Int).Value = DBNull.Value; } else { cmd.Parameters.Add("@PrepaidBottleID", SqlDbType.Int).Value = prepaidBottle.PrepaidBottleID; } cmd.Parameters.Add("@AccountID", SqlDbType.Int).Value = prepaidBottle.AccountID; cmd.Parameters.Add("@PrepaidBottleType", SqlDbType.Int).Value = prepaidBottle.PrepaidBottleType; cmd.Parameters.Add("@Balance", SqlDbType.Int).Value = prepaidBottle.Balance; cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = prepaidBottle.CreatedDate; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = prepaidBottle.ModifiedDate; cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = prepaidBottle.CreatedBy; cmd.Parameters.Add("@ModifiedBy", SqlDbType.VarChar).Value = prepaidBottle.ModifiedBy; DbParameter returnValue = cmd.CreateParameter(); returnValue.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(returnValue); cmd.ExecuteNonQuery(); result = Convert.ToInt32(returnValue.Value); cmd.Dispose(); } finally { myConn.CloseDB(conn); } return(result); }
protected void imgBtnShowDeductBalance_OnCommand(object sender, CommandEventArgs e) { this.mPopUpShowDeductPrepaidPkg.Show(); selectedPrepaidBottle = PrepaidBottleManager.GetPrepaidBottleByID(Convert.ToInt32(e.CommandArgument.ToString())); PrepaidBottleList pList = new PrepaidBottleList(); pList.Add(selectedPrepaidBottle); //populate formview fview_DeductPrepaidBottle.DataSource = pList; fview_DeductPrepaidBottle.DataBind(); //display current balance (fview_DeductPrepaidBottle.FindControl("lblCurrentBalanceValue") as Label).Text = selectedPrepaidBottle.Balance.ToString(); //set the focus on the deduct qty textbox (fview_DeductPrepaidBottle.FindControl("txtDeductQty") as TextBox).Focus(); }
private void HandlePrepaidWaterPackages(Invoice newInvoice, InvoiceLineItem lineItem) { if ((lineItem.ProductCode).Contains("WAT PKG")) { if (newInvoice.AccountID != null) { // check if the account has an existing prepaid bottle account // if not, create a new one int bottleTypeID = ExtractBottleTypeID(lineItem.ProductCode); PrepaidBottle p = PrepaidBottleManager.GetPrepaidBottle(_accountID, bottleTypeID); if (p == null) //create a new one { p = new PrepaidBottle(); p.AccountID = _accountID; p.PrepaidBottleType = bottleTypeID; p.CreatedBy = User.Identity.Name.ToString(); p.TopUpBalance(ProductManager.GetTopUpQty(lineItem.ProductCode) * lineItem.Quantity); p.PrepaidBottleID = PrepaidBottleManager.Save(p); } else { p.TopUpBalance(ProductManager.GetTopUpQty(lineItem.ProductCode)); p.ModifiedBy = User.Identity.Name.ToString(); PrepaidBottleManager.Save(p); } // save the prepaid bottle transaction PrepaidBottleTransaction pBTransaction = new PrepaidBottleTransaction(); pBTransaction.PrepaidBottleID = p.PrepaidBottleID; pBTransaction.TransactionType = "topUp"; pBTransaction.TopUpQty = ProductManager.GetTopUpQty(lineItem.ProductCode) * lineItem.Quantity; pBTransaction.LastUpdatedBalance = p.Balance; pBTransaction.CreatedBy = User.Identity.Name.ToString(); pBTransaction.TransactionID = PrepaidBottleTransactionManager.Save(pBTransaction); } } }
public static int Save(PrepaidBottle p) { return(PrepaidBottleDB.Save(p)); }