protected void Load_Shopping_Cart(MySqlConnection dbconn,
Repeater lRepeater)
{
ShoppingCartClass.Create_Shopping_Cart(dbconn);
gQuantity.Clear();
string lUserId = null;
if (ClaimsPrincipal.Current.Identity.IsAuthenticated == true)
{
lUserId = ClaimsPrincipal.Current.FindFirst("user_id").Value;
}
CommonClass.FetchRecordsAndBind("GET_SHOPPING_CART_DETAILS",
new string[]
{
"P_SHOPPING_CART_ID",
"P_EXTERNAL_USER_ID"
},
new string[]
{
Session["SHOPPING_CART_ID"].ToString(),
lUserId
},
dbconn,
lRepeater);
double lTotal = 0.0;
double lTotalShippingCharges = 0.0;
double lShippingDiscounts = 0.0;
double lPromotionalDiscounts = 0.0;
foreach (RepeaterItem lRepeaterItem in lRepeater.Items)
{
double lQuantity = double.Parse((lRepeaterItem.FindControl("OLD_QUANTITY") as HiddenField).Value.ToString());
double lOrderAmount = double.Parse((lRepeaterItem.FindControl("PRICE") as HiddenField).Value.ToString());
double lShippingCharges = double.Parse(Shipping_Charge.Value);
double lSize = double.Parse((lRepeaterItem.FindControl("MEASUREMENT_UNIT") as HiddenField).Value.ToString());
lTotal += lOrderAmount * lQuantity;
lTotalShippingCharges += lShippingCharges * lQuantity;
string lMeasurementId = (lRepeaterItem.FindControl("MEASUREMENT_ID") as HiddenField).Value;
if (gQuantity.ContainsKey(lMeasurementId))
{
gQuantity[lMeasurementId] = gQuantity[lMeasurementId] + (lQuantity * lSize);
}
else
{
gQuantity[lMeasurementId] = lQuantity * lSize;
}
}
ViewState["COUNTER"] = gQuantity;
Shipping_Charges.Text = lTotalShippingCharges.ToString();
Shipping_Discounts.Text = lShippingDiscounts.ToString();
Promotional_Discounts.Text = lPromotionalDiscounts.ToString();
Total_Amount.Text = lTotal.ToString();
if (Session["PROMOTION_CODE"] != null)
{
Coupon_Code.Text = Session["PROMOTION_CODE"].ToString();
}
Apply_Coupon_Button_Click(new object { }, EventArgs.Empty);
}
protected void Session_Start(object sender, EventArgs e)
{
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
ShoppingCartClass.Create_Shopping_Cart(dbconn);
dbconn.Close();
}
protected void Apply_Promotions(MySqlConnection dbconn)
{
ShoppingCartClass.Create_Shopping_Cart(dbconn);
if (Is_COD(dbconn))
{
Shipping_Discounts.Text = Shipping_Charges.Text;
}
else
{
string[] lRecords = CommonClass.FetchRecords("GET_ACTIVE_PROMOTIONS",
new string[]
{
"PROMOTION_TYPE"
},
new string[]
{
"GLOBAL"
},
new string[]
{
"P_PROMOTION_ID",
"P_TOTAL_QUANTITY",
"P_TOTAL_ORDER"
},
dbconn);
if (lRecords != null)
{
gQuantity = ViewState["COUNTER"] as Dictionary <string, double>;
if (gQuantity.ContainsKey("4"))
{
if (gQuantity["4"] >= double.Parse(lRecords[1]))
{
Shipping_Discounts.Text = Shipping_Charges.Text;
}
}
}
}
Surprise_Discount_PlaceHolder.Visible = false;
if (Session["SURPRISE_DISCOUNT_PERCENTAGE"] != null && Surprise_Discount_Eligible.Value == "1")
{
double lSurpriseDiscount = Math.Round(((double.Parse(Total_Amount.Text) * double.Parse(Session["SURPRISE_DISCOUNT_PERCENTAGE"].ToString())) / 100));
Promotional_Discounts.Text = (double.Parse(Promotional_Discounts.Text) +
lSurpriseDiscount).ToString();
Surprise_Discount.Text = lSurpriseDiscount.ToString();
if (lSurpriseDiscount != 0)
{
Surprise_Discount_PlaceHolder.Visible = true;
}
}
Compute_Grand_Total();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
ShoppingCartClass.Create_Shopping_Cart(dbconn);
//Load_States(dbconn);
Load_Shopping_Cart(dbconn,
Cart_Details_Repeater);
AddressBook1.Load_Address(dbconn, true);
dbconn.Close();
Change_View("Order_Info");
}
}
protected void Next_Address_Book_Button_Click(object sender, EventArgs e)
{
AddressBook_Message.Visible = false;
AddressBook_Message1.Visible = false;
if (AddressBook1.GetDeliveryAddressId != "")
{
Change_View("Review_Order_Info");
MultiView1.SetActiveView(Review_Order_View);
Session["DELIVERY_ADDRESS_ID"] = AddressBook1.GetDeliveryAddressId.ToString();
Session["SHIPPING_STATE"] = AddressBook1.GetDeliveryState.ToString();
Session["PIN_CODE"] = AddressBook1.GetDeliveryPinCode.ToString();
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
ShoppingCartClass.Create_Shopping_Cart(dbconn);
CommonClass.ExecuteQuery("UPDATE_SHOPPING_DELIVERY_ADDRESS",
new string[]
{
"P_SHOPPING_CART_ID",
"P_DELIVERY_ADDRESS_ID",
"P_PIN_CODE"
},
new string[]
{
Session["SHOPPING_CART_ID"].ToString(),
AddressBook1.GetDeliveryAddressId.ToString(),
AddressBook1.GetDeliveryPinCode.ToString()
},
dbconn);
Get_Shipping_Charge(dbconn);
Load_Shopping_Cart(dbconn,
Review_Order_Repeater);
dbconn.Close();
}
else
{
AddressBook_Message.Visible = true;
AddressBook_Message1.Visible = true;
Session["SHIPPING_STATE"] = null;
Session["DELIVERY_ADDRESS_ID"] = null;
Session["PIN_CODE"] = null;
}
}