private void createPaymentRecord(ArrayList alOrderDetailID)
{
using (WebDL.Team2_BookDBEntities bke = new WebDL.Team2_BookDBEntities())
{
payment addPayment = new payment();
for (int i = 0; i < alOrderDetailID.Count; i++)
{
addPayment.userID = userId;
addPayment.ordersDetailID = Convert.ToInt32(alOrderDetailID[i]);
addPayment.paymentStatus = "pending";
addPayment.paymentAmount = Convert.ToDouble(lbTotal.Text);
addPayment.paymentDescription = "";
addPayment.paymentMode = rblPaymentMode.SelectedValue.ToString();
addPayment.paymentDate = DateTime.Now.Date;
bke.payments.Add(addPayment);
bke.SaveChanges();
}
}
}
protected void btnAddToCart_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
string productName = btn.CssClass;
using (WebDL.Team2_BookDBEntities context = new WebDL.Team2_BookDBEntities())
{
string userNameFromSession = Session["userName"].ToString();
var data = from p in context.products where p.productName == productName select p;
var data2 = from u in context.users where u.userName == userNameFromSession select u;
WebDL.user userGetFromSession = data2.First();
WebDL.product pToBeAdded = data.First();
WebDL.shoppingCart sc = new WebDL.shoppingCart();
sc.product = pToBeAdded;
sc.quantity = 1;
sc.userID = userGetFromSession.userID;
sc.shoppingCartExpiredDate = DateTime.Now.Date;
context.shoppingCarts.Add(sc);
context.SaveChanges();
lbMsg.Text = "product: " + productName + " is added to shopping cart";
}
}