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