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));
}
