public static int Save(PrepaidBottleTransaction pBTransaction) { 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.InsertUpdatePBTransaction"; if (pBTransaction.TransactionID == -1) { cmd.Parameters.Add("@TransactionID", SqlDbType.Int).Value = DBNull.Value; } else { cmd.Parameters.Add("@TransactionID", SqlDbType.Int).Value = pBTransaction.TransactionID; } cmd.Parameters.Add("@TransactionType", SqlDbType.VarChar).Value = pBTransaction.TransactionType; if (pBTransaction.PrepaidBottleID == null) { cmd.Parameters.Add("@PrepaidBottleID", SqlDbType.Int).Value = DBNull.Value; } else { cmd.Parameters.Add("@PrepaidBottleID", SqlDbType.Int).Value = pBTransaction.PrepaidBottleID; } cmd.Parameters.Add("@LastUpdatedBalance", SqlDbType.Int).Value = pBTransaction.LastUpdatedBalance; cmd.Parameters.Add("@DeductQty", SqlDbType.Int).Value = pBTransaction.DeductQty; cmd.Parameters.Add("@TopUpQty", SqlDbType.Int).Value = pBTransaction.TopUpQty; cmd.Parameters.Add("@LastTransactionDate", SqlDbType.DateTime).Value = pBTransaction.LastTransactionDate; cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = pBTransaction.CreatedDate; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = pBTransaction.ModifiedDate; cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = pBTransaction.CreatedBy; cmd.Parameters.Add("@ModifiedBy", SqlDbType.VarChar).Value = pBTransaction.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); }
private static PrepaidBottleTransaction FillDataRecord(IDataRecord dr) { PrepaidBottleTransaction pBTransaction = new PrepaidBottleTransaction(); pBTransaction.TransactionID = dr.GetInt32(dr.GetOrdinal("TransactionID")); pBTransaction.TransactionType = dr.GetString(dr.GetOrdinal("TransactionType")); pBTransaction.PrepaidBottleID = dr.GetInt32(dr.GetOrdinal("PrepaidBottleID")); pBTransaction.LastUpdatedBalance = dr.GetInt32(dr.GetOrdinal("LastUpdatedBalance")); pBTransaction.DeductQty = dr.GetInt32(dr.GetOrdinal("DeductQty")); pBTransaction.TopUpQty = dr.GetInt32(dr.GetOrdinal("TopUpQty")); pBTransaction.LastTransactionDate = dr.GetDateTime(dr.GetOrdinal("LastTransactionDate")); pBTransaction.CreatedDate = dr.GetDateTime(dr.GetOrdinal("CreatedDate")); pBTransaction.ModifiedDate = dr.GetDateTime(dr.GetOrdinal("ModifiedDate")); pBTransaction.CreatedBy = dr.GetString(dr.GetOrdinal("CreatedBy")); pBTransaction.ModifiedBy = dr.GetString(dr.GetOrdinal("ModifiedBy")); return(pBTransaction); }
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); } } }
protected void lnkDeductPrepaid_OnCommand(object sender, CommandEventArgs e) { //get the deduct qty from the formview int deductQty = Convert.ToInt32((fview_DeductPrepaidBottle.FindControl("txtDeductQty") as TextBox).Text); selectedPrepaidBottle.DeductBalance(deductQty); selectedPrepaidBottle.ModifiedBy = User.Identity.Name.ToString(); selectedPrepaidBottle.ModifiedDate = DateTime.Now.ToLocalTime(); PrepaidBottleManager.Save(selectedPrepaidBottle); PrepaidBottleTransaction pTransaction = new PrepaidBottleTransaction(); pTransaction.PrepaidBottleID = selectedPrepaidBottle.PrepaidBottleID; pTransaction.LastUpdatedBalance = selectedPrepaidBottle.Balance; pTransaction.DeductQty = deductQty; pTransaction.TransactionType = "deduct"; pTransaction.CreatedBy = User.Identity.Name.ToString(); pTransaction.LastTransactionDate = DateTime.Now.ToLocalTime(); PrepaidBottleTransactionManager.Save(pTransaction); //refresh the Prepaid Water Gridview DisplayPrepaidWater(); }
public static int Save(PrepaidBottleTransaction pBTransaction) { return(PrepaidBottleTransactionDB.Save(pBTransaction)); }