public static void Swap_Shopping_Cart(MySqlConnection dbconn, string pUserId) { if (HttpContext.Current.Session["SHOPPING_CART_ID"] != null) { string[] lRecords = CommonClass.FetchRecords("SWAP_SHOPPING_CART", new string[] { "P_EXTERNAL_USER_ID", "P_SHOPPING_CART_ID" }, new string[] { pUserId, HttpContext.Current.Session["SHOPPING_CART_ID"].ToString() }, new string[] { "P_END_SESSION_FLAG" }, dbconn); if (lRecords[0] != null && lRecords[0] != "") { HttpContext.Current.Session.Abandon(); } } else { HttpContext.Current.Session.Abandon(); } }
public static UserModel Get_External_User_Profile(MySqlConnection dbconn) { UserModel lUserModel = new UserModel(); if (ClaimsPrincipal.Current.Identity.IsAuthenticated == true) { MySqlDataReader lMySqlDataReader = CommonClass.FetchRecords("GET_USER_BY_EXTERNAL_ID", new string[] { "P_EXTERNAL_ID" }, new string[] { ClaimsPrincipal.Current.FindFirst("user_id").Value }, dbconn); if (lMySqlDataReader.Read()) { lUserModel.User_Id = int.Parse(lMySqlDataReader["USER_ID"].ToString()); lUserModel.External_User_Id = lMySqlDataReader["EXTERNAL_USER_ID"].ToString(); lUserModel.User_Name = lMySqlDataReader["USER_NAME"].ToString(); if (lMySqlDataReader["MOBILE_NUMBER"] != null) { lUserModel.Mobile_Number = lMySqlDataReader["MOBILE_NUMBER"].ToString(); } lUserModel.Mobile_Validated = int.Parse(lMySqlDataReader["MOBILE_VALIDATED"].ToString()); lUserModel.Email_Address = lMySqlDataReader["EMAIL_ADDRESS"].ToString(); lUserModel.Email_Address_Validated = int.Parse(lMySqlDataReader["EMAIL_ADDRESS_VALIDATED"].ToString()); lUserModel.User_Type_Id = int.Parse(lMySqlDataReader["USER_TYPE_ID"].ToString()); lUserModel.Email_Address_Validated_Message = lMySqlDataReader["EMAIL_ADDRESS_VALIDATED_MESSAGE"].ToString(); lUserModel.Mobile_Delivery_Option = int.Parse(lMySqlDataReader["MOBILE_DELIVERY_OPTION"].ToString()); lUserModel.Email_Delivery_Option = int.Parse(lMySqlDataReader["EMAIL_DELIVERY_OPTION"].ToString()); } lMySqlDataReader.Close(); } return(lUserModel); }
public static string[] Get_Address_By_Id(string lAddressId) { MySqlConnection dbconn = new MySqlConnection(connectionstring); dbconn.Open(); MySqlDataReader lMySqlDataReader = CommonClass.FetchRecords("GET_ADDRESS_BY_ID", new string[] { "P_ADDRESS_ID" }, new string[] { lAddressId }, dbconn); string[] lAddress = null; if (lMySqlDataReader.Read()) { lAddress = new string[] { lMySqlDataReader["USER_NAME"].ToString(), lMySqlDataReader["MOBILE_NUMBER"].ToString(), lMySqlDataReader["SHIPPING_ADDRESS"].ToString(), lMySqlDataReader["CITY_NAME"].ToString(), lMySqlDataReader["STATE_NAME"].ToString(), lMySqlDataReader["PIN_CODE"].ToString() }; } lMySqlDataReader.Close(); dbconn.Close(); return(lAddress); }
public static UserAddress Get_User_Address(string p_AddressId, MySqlConnection dbconn) { UserAddress lUserAddress = new UserAddress(); MySqlDataReader lMySqlDataReader = CommonClass.FetchRecords("GET_ADDRESS_BY_ID", new string[] { "P_ADDRESS_ID" }, new string[] { p_AddressId }, dbconn); if (lMySqlDataReader.Read()) { lUserAddress.User_Name = lMySqlDataReader["USER_NAME"].ToString(); lUserAddress.Mobile_Number = lMySqlDataReader["MOBILE_NUMBER"].ToString(); lUserAddress.Address = lMySqlDataReader["SHIPPING_ADDRESS"].ToString(); lUserAddress.City = lMySqlDataReader["CITY_NAME"].ToString(); lUserAddress.State = lMySqlDataReader["STATE_NAME"].ToString(); lUserAddress.Pin_Code = lMySqlDataReader["PIN_CODE"].ToString(); } lMySqlDataReader.Close(); return(lUserAddress); }
public static List <PolicyModel> Get_All_Policies() { List <PolicyModel> lPolicies = new List <PolicyModel>(); MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); MySqlConnection dbconn1 = new MySqlConnection(CommonClass.connectionstring); MySqlConnection dbconn2 = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); MySqlDataReader reader = CommonClass.FetchRecords("GET_ALL_POLICIES", new string[] { }, new string[] { }, dbconn); while (reader.Read()) { PolicyModel lPolicy = new PolicyModel(); lPolicy.Policy_Id = int.Parse(reader["POLICY_ID"].ToString()); lPolicy.Policy_Name = reader["POLICY_NAME"].ToString(); lPolicy.Policy_Updated_Date = reader["LAST_UPDATED_DATE"].ToString(); dbconn1.Open(); MySqlDataReader reader1 = CommonClass.FetchRecords("GET_POLICY_HEADERS", new string[] { "P_POLICY_ID" }, new string[] { reader["POLICY_ID"].ToString() }, dbconn1); List <Policy_Details> lPolicyDetails = new List <Policy_Details>(); while (reader1.Read()) { Policy_Details lPolicyDetail = new Policy_Details(); lPolicyDetail.Policy_Header_Text = reader1["HEADER_TEXT"].ToString(); List <Policy_Contents> lPolicyContents = new List <Policy_Contents>(); dbconn2.Open(); MySqlDataReader reader2 = CommonClass.FetchRecords("GET_POLICY_CONTENT", new string[] { "P_POLICY_ID", "P_POLICY_HEADER_ID" }, new string[] { reader["POLICY_ID"].ToString(), reader1["POLICY_HEADER_ID"].ToString() }, dbconn2); while (reader2.Read()) { Policy_Contents lPolicyContent = new Policy_Contents(); lPolicyContent.Policy_Content = reader2["CONTENT"].ToString(); lPolicyContents.Add(lPolicyContent); } lPolicyDetail.Policy_Contents = lPolicyContents; reader2.Close(); dbconn2.Close(); lPolicyDetails.Add(lPolicyDetail); } lPolicy.Policy_Details = lPolicyDetails; reader1.Close(); dbconn1.Close(); lPolicies.Add(lPolicy); } reader.Close(); dbconn.Close(); return(lPolicies); }
public static void Generate_OTP(string pMobileNumber, string pUserName, Label pLabel, PlaceHolder pPlaceHolder, MySqlConnection dbconn) { MySqlTransaction Transaction = dbconn.BeginTransaction(); //Repeater lMobileNumberRepeater = User_FormView.FindControl("Mobile_Number_Repeater") as Repeater; //Label lOTPMessageLabel = User_FormView.FindControl("OTP_Message") as Label; //string lOTPMessageLabel; //lOTPMessageLabel.Visible = true; try { string lMobileNumber = HttpContext.Current.Server.HtmlEncode(pMobileNumber); string lUserName = HttpContext.Current.Server.HtmlEncode(pUserName); string[] lRecords = CommonClass.FetchRecords("GENERATE_MOBILE_ACTIVATION_CODE", new string[] { "P_USER_ID", "P_MOBILE_NUMBER" }, new string[] { ClaimsPrincipal.Current.FindFirst("user_id").Value, lMobileNumber }, new string[] { "P_ACTIVATION_CODE" }, dbconn); if (lRecords[0] != null) { Messages.Send_Mobile_Validate_Message(lMobileNumber, lUserName, lRecords[0], dbconn); pPlaceHolder.Visible = true; pLabel.Text = "OTP Successfully Generated"; pLabel.ForeColor = Color.Green; } else { pLabel.ForeColor = Color.Red; pLabel.Text = "Unable to Generate OTP"; } Transaction.Commit(); } catch { Transaction.Rollback(); pLabel.Text = "Server Error, Try after sometime"; pLabel.ForeColor = Color.Red; } }
public static string Refund_Order(MySqlConnection dbconn, string pOrderId, string pOrderNumber, string pCustomerId, string pRefundAmount, string pOriginalTransactionId, string pCancellationReason) { string lErrorMessage = null; string[] lRecords = CommonClass.FetchRecords("ADD_REFUND", new string[] { "P_ORDER_ID", "P_REFUND_AMOUNT", "P_EXTERNAL_USER_ID" }, new string[] { pOrderId, pRefundAmount, ClaimsPrincipal.Current.FindFirst("user_id").Value }, new string[] { "P_ERROR_STRING", "P_REFUND_ID" }, dbconn); if (lRecords[0] != null && lRecords[0] != "") // some error happened { lErrorMessage = lRecords[0]; } else { Messages.Send_Refund_Request_Message(pOrderNumber, pRefundAmount, pCustomerId, dbconn); Refund_PayTm_Order(pOrderId, pOriginalTransactionId, pRefundAmount, pCancellationReason, lRecords[1]); } return(lErrorMessage); }
public static string Reject_Refund_Order(MySqlConnection dbconn, string pOrderId, string pOrderNumber, string pRejectionReasonId, string pRejectionReason, string pCustomerId, string pRejectionReasonDisplay) { string lErrorMessage = null; string[] lRecords = CommonClass.FetchRecords("REJECT_REUND", new string[] { "P_CUSTOMER_ID", "P_EXTERNAL_USER_ID", "P_ORDER_ID", "P_REJECTION_REASON_ID", "P_REJECTION_REASON" }, new string[] { pCustomerId, ClaimsPrincipal.Current.FindFirst("user_id").Value, pOrderId, pRejectionReasonId, pRejectionReason }, new string[] { "P_ERROR_STRING" }, dbconn ); if (lRecords[0] != null && lRecords[0] != "") { lErrorMessage = lRecords[0]; } else { Messages.Send_Reject_Refund_Request_Message(pOrderNumber, pRejectionReasonDisplay, pCustomerId, dbconn); } return(lErrorMessage); }
public static string Undeliver_Order(MySqlConnection dbconn, string pOrderId, string pOrderNumber, string pCustomerId, string pUnDeliveredReasonId, string pUnDeliveredReason, string pUnDeliveredReasonDisplay) { string lErrorMessage = null; string[] lRecords = CommonClass.FetchRecords("ADD_DELIVERY_RETURN", new string[] { "P_CUSTOMER_ID", "P_EXTERNAL_USER_ID", "P_ORDER_ID", "P_UNDELIVERED_REASON_ID", "P_UNDELIVERED_REASON" }, new string[] { pCustomerId, ClaimsPrincipal.Current.FindFirst("user_id").Value, pOrderId, pUnDeliveredReasonId, HttpContext.Current.Server.HtmlEncode(pUnDeliveredReason), }, new string[] { "P_ERROR_STRING" }, dbconn); if (lRecords[0] != null && lRecords[0] != "") { lErrorMessage = lRecords[0]; } else { Messages.Send_Order_Undelivered_Message(pOrderNumber, pUnDeliveredReasonDisplay, pCustomerId, dbconn); } return(lErrorMessage); }
public static void Validate_Mobile(string pMobileNumber, string pMobileOTP, Label pLabel, PlaceHolder pPlaceHolder, MySqlConnection dbconn ) { //TextBox lMobile_Number_TextBox = User_FormView.FindControl("Mobile_Number") as TextBox; // Repeater lMobile_Number_Repeater = User_FormView.FindControl("Mobile_Number_Repeater") as Repeater; //RepeaterItem lRepeaterItem1 = lMobile_Number_Repeater.Items[0]; string[] lRecords = CommonClass.FetchRecords("VALIDATE_MOBILE", new string[] { "P_USER_ID", "P_MOBILE_NUMBER", "P_VALIDATION_CODE" }, new string[] { ClaimsPrincipal.Current.FindFirst("user_id").Value, pMobileNumber, pMobileOTP }, new string[] { "P_STATUS" }, dbconn); // Bind_Contacts("1", dbconn, lMobile_Number_Repeater); //Label OTP_Message_Label = User_FormView.FindControl("OTP_Message") as Label; pLabel.Visible = true; if (lRecords[0] != null) { pLabel.Text = lRecords[0]; pLabel.ForeColor = Color.Red; } else { pPlaceHolder.Visible = false; pLabel.Text = "OTP Successfully Validated"; pLabel.ForeColor = Color.Green; } }
public static string Add_Delivery_Information(MySqlConnection dbconn, string pOrderId, string pOrderNumber, string pCustomerId, string pOrderAmount, string pDeliveryDate, string pPaymentRef) { PaymentClass.CCAvenue_Confirm_Order(pPaymentRef, pOrderAmount); string lErrorMessage = null; string[] lRecords = CommonClass.FetchRecords("ADD_DELIVERY_INFO", new string[] { "P_ORDER_ID", "P_CUSTOMER_ID", "P_EXTERNAL_USER_ID", "P_DELIVERY_DATE" }, new string[] { pOrderId, pCustomerId, ClaimsPrincipal.Current.FindFirst("user_id").Value, pDeliveryDate }, new string[] { "P_ERROR_STRING" }, dbconn ); if (lRecords[0] != null && lRecords[0] != "") { lErrorMessage = lRecords[0]; } else { Messages.Send_Order_Delivered_Message(pOrderNumber, pCustomerId, pDeliveryDate, dbconn); } return(lErrorMessage); }
public static string Cancel_Order(MySqlConnection dbconn, string pOrderId, string pOrderNumber, string pCustomerId, string pCancellationReasonId, string pCancellationReason, string pCancellationReasonDisplay) { string lErrorMessage = null; string[] lRecords = CommonClass.FetchRecords("CANCEL_ORDER", new string[] { "P_CUSTOMER_ID", "P_EXTERNAL_USER_ID", "P_ORDER_ID", "P_CANCELLATION_REASON_ID", "P_CANCELLATION_REASON" }, new string[] { pCustomerId, ClaimsPrincipal.Current.FindFirst("user_id").Value, pOrderId, pCancellationReasonId, HttpContext.Current.Server.HtmlEncode(pCancellationReason), }, new string[] { "P_ERROR_STRING" }, dbconn); if (lRecords[0] != null && lRecords[0] != "") { lErrorMessage = lRecords[0]; } else { Messages.Send_Order_Cancellation_Request_Message(pOrderNumber, pCustomerId, dbconn); } return(lErrorMessage); }
public static List <ProductModel> Get_Active_Products() { List <ProductModel> Products = new List <ProductModel>(); MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); MySqlConnection dbconn1 = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); MySqlDataReader reader = CommonClass.FetchRecords("GET_ACIVE_PRODUCTS", new string[] { "PHOTO_IND" }, new string[] { "0" }, dbconn); while (reader.Read()) { ProductModel product = new ProductModel(); product.id = int.Parse(reader["PRODUCT_ID"].ToString()); product.Name = reader["PRODUCT_NAME"].ToString(); product.Picture = "http://www.gilldstore.in/img/" + reader["PHOTO_FILE_NAME"].ToString(); List <Product_Price> ProductPrices = new List <Product_Price>(); dbconn1.Open(); MySqlDataReader reader1 = CommonClass.FetchRecords("GET_PRODUCT_PRICE", new string[] { "P_PRODUCT_ID", "P_CUSTOMER_ID", "P_EXTERNAL_USER_ID" }, new string[] { reader["PRODUCT_ID"].ToString(), null, null }, dbconn1); while (reader1.Read()) { Product_Price productprice = new Product_Price(); productprice.Measurement_Name = reader1["MEASUREMENT_NAME"].ToString(); productprice.Measurement_Unit = double.Parse(reader1["MEASUREMENT_UNIT"].ToString()); productprice.Price = double.Parse(reader1["PRICE"].ToString()); productprice.ShippingCharge = double.Parse(reader1["SHIPPING_CHARGE"].ToString()); productprice.DisplayMeasurement = reader1["MEASUREMENT_UNIT"].ToString() + " " + reader1["MEASUREMENT_NAME"].ToString(); ProductPrices.Add(productprice); } reader1.Close(); dbconn1.Close(); product.Productrices = ProductPrices; Products.Add(product); } dbconn.Close(); return(Products); }
public static void Create_Cash_Payment(MySqlConnection dbconn, string lOrderAmount, string lCustomerId) { string[] lPaymentRecords = CommonClass.FetchRecords("ADD_CASH_PAYMENT", new string[] { "P_PAYMENT_AMOUNT", "P_EXTERNAL_USER_ID", "P_CUSTOMER_ID", }, new string[] { lOrderAmount, ClaimsPrincipal.Current.FindFirst("user_id").Value, lCustomerId }, new string[] { "P_ERROR_STRING" }, dbconn); Allocate_Order(dbconn, lCustomerId); }
public static void Confirm_Order(MySqlConnection dbconn, string lOrderId) { MySqlDataReader lMySqlDataReader = CommonClass.FetchRecords("GET_ORDER_BY_ID", new string[] { "P_ORDER_ID", "P_EXTERNAL_USER_ID" }, new string[] { lOrderId, ClaimsPrincipal.Current.FindFirst("user_id").Value }, dbconn ); string lAddress = ""; string lOrderDate = ""; string lOrderAmount = ""; string lSubtotal = ""; string lShippingCharges = ""; string lDiscount = ""; string lGrandTotal = ""; string lOrderNumber = ""; string lPaymentType = ""; string lUserId = null; string lDeliveryMethod = null; string[] lCodEligible = null; string lPinCode = null; string lPromotionApplied = "N"; if (lMySqlDataReader.Read()) { lOrderNumber = lMySqlDataReader["ORDER_NUMBER"].ToString(); if (lMySqlDataReader["ADDRESS_ID"] != null) { string[] lAddressArray = CommonClass.Get_Address_By_Id(lMySqlDataReader["ADDRESS_ID"].ToString()); lAddress = CommonClass.Format_Address(lAddressArray[0], lAddressArray[1], lAddressArray[2], lAddressArray[3], lAddressArray[4], lAddressArray[5]); lPinCode = lAddressArray[5]; } lOrderDate = lMySqlDataReader["ORDER_DATE"].ToString(); lOrderAmount = lMySqlDataReader["ORDER_TOTAL"].ToString(); lShippingCharges = lMySqlDataReader["SHIPPING_CHARGE"].ToString(); lDiscount = lMySqlDataReader["DISCOUNTS"].ToString(); lSubtotal = (double.Parse(lOrderAmount) - double.Parse(lShippingCharges) + double.Parse(lDiscount)).ToString(); lPaymentType = lMySqlDataReader["PAYMENT_TYPE"].ToString(); lGrandTotal = lOrderAmount; lUserId = lMySqlDataReader["USER_ID"].ToString(); lDeliveryMethod = lMySqlDataReader["DELIVERY_METHOD_ID"].ToString(); lPromotionApplied = lMySqlDataReader["PROMOTION_APPLIED"].ToString(); } lMySqlDataReader.Close(); if (lPinCode != null && lPromotionApplied == "N") { lCodEligible = CommonClass.FetchRecords("IS_COD", new string[] { "P_PIN_CODE" }, new string[] { lPinCode }, new string[] { "P_ELIGIBLE" }, dbconn); } PaymentClass.Allocate_Order(dbconn, lUserId); UserDetails lUserDetails = Messages.Get_Contact_Details(lUserId, dbconn); lMySqlDataReader = CommonClass.FetchRecords("GET_ORDER_DETAILS_BY_ID", new string[] { "P_ORDER_ID", "P_EXTERNAL_ID" }, new string[] { lOrderId, ClaimsPrincipal.Current.FindFirst("user_id").Value }, dbconn); string lOrderSummary = ""; while (lMySqlDataReader.Read()) { lOrderSummary += "<tr>"; lOrderSummary += "<td>" + lMySqlDataReader["PRODUCT_NAME"].ToString() + " </td>"; lOrderSummary += "<td>" + lMySqlDataReader["MEASUREMENT_UNIT"].ToString() + " </td>"; lOrderSummary += "<td>" + lMySqlDataReader["QUANTITY"].ToString() + " </td>"; lOrderSummary += "<td>₹ " + lMySqlDataReader["PRICE"].ToString() + " </td>"; lOrderSummary += "<td>₹ " + lMySqlDataReader["SUBTOTAL"].ToString() + " </td>"; lOrderSummary += "</tr>"; } lMySqlDataReader.Close(); Messages.Send_Order_Confirmation_Message(lUserDetails.Email, lUserDetails.User_Name, lAddress, lUserDetails.Mobile_Number, lOrderNumber, lOrderDate, lOrderAmount, lOrderSummary, lSubtotal, lShippingCharges, lGrandTotal, lDiscount, lPaymentType, dbconn); if (lDeliveryMethod == "3" && lCodEligible[0] != "1") { Messages.Send_Order_Confirmation_Message_To_Seller( lAddress, lOrderNumber, lOrderDate, lOrderAmount, lOrderSummary, lSubtotal, lShippingCharges, lGrandTotal, lDiscount, lPaymentType, dbconn); } }
public static void Allocate_Order( MySqlConnection dbconn, string p_UserId) { MySqlConnection dbconn1 = new MySqlConnection(CommonClass.connectionstring); MySqlConnection dbconn2 = new MySqlConnection(CommonClass.connectionstring); dbconn1.Open(); dbconn2.Open(); MySqlDataReader lMySqlDataReader1 = CommonClass.FetchRecords("GET_UNALLOCATED_PAYMENT_BY_USER_ID", new string[] { "P_USER_ID" }, new string[] { p_UserId }, dbconn1); MySqlDataReader lMySqlDataReader = CommonClass.FetchRecords("GET_DUE_ORDER_LIST_BY_USER_ID", new string[] { "P_USER_ID" }, new string[] { p_UserId }, dbconn); double lUnallocated_Amount = 0; string lPaymentId = null; while (lMySqlDataReader.Read()) { string lOrderId = lMySqlDataReader["ORDER_ID"].ToString(); double lOrderDue = double.Parse(lMySqlDataReader["ORDER_DUE"].ToString()); while (lOrderDue != 0) { double lAllocatedAmount = 0; if (lUnallocated_Amount == 0) { if (lMySqlDataReader1.Read()) { lUnallocated_Amount = double.Parse(lMySqlDataReader1["UNALLOCATED_AMOUNT"].ToString()); lPaymentId = lMySqlDataReader1["PAYMENT_ID"].ToString(); } else { break; } } if (lOrderDue >= lUnallocated_Amount) { lAllocatedAmount = lUnallocated_Amount; lOrderDue -= lUnallocated_Amount; lUnallocated_Amount = 0; } else { lUnallocated_Amount -= lOrderDue; lAllocatedAmount = lOrderDue; lOrderDue = 0; } CommonClass.ExecuteQuery("ADD_PAYMENT_ORDER", new string[] { "P_PAYMENT_ID", "P_ORDER_ID", "P_AMOUNT" }, new string[] { lPaymentId, lOrderId, lAllocatedAmount.ToString() }, dbconn2); } } lMySqlDataReader.Close(); lMySqlDataReader1.Close(); dbconn1.Close(); dbconn2.Close(); }
public static void Create_Shopping_Cart(MySqlConnection dbconn) { if (HttpContext.Current.Session["SHOPPING_CART_ID"] == null) { string lUserId = null; if (ClaimsPrincipal.Current.Identity.IsAuthenticated == true) { lUserId = ClaimsPrincipal.Current.FindFirst("user_id").Value; } Random rand = new Random(); string lSurprise_Discount_Percentage = rand.Next(1, 3).ToString(); int lNoOfShippingItems = 0; double lShippingValue = 0.0; string[] lRecords = CommonClass.FetchRecords("CREATE_SHOPPING_CART", new string[] { "P_EXTERNAL_USER_ID", "P_SESSION_ID", "P_SURPRISE_DISCOUNT_PERCENTAGE" }, new string[] { lUserId, HttpContext.Current.Session.SessionID, lSurprise_Discount_Percentage }, new string[] { "P_SHIPPING_CART_ID", "P_NO_OF_ITEMS", "P_ITEM_VALUE" }, dbconn); MySqlDataReader lMySqlDataReader = CommonClass.FetchRecords("GET_SHOPPING_CART", new string[] { "P_SHOPPING_CART_ID" }, new string[] { lRecords[0] }, dbconn); if (lMySqlDataReader.Read()) { HttpContext.Current.Session["SHIPPING_STATE"] = lMySqlDataReader["STATE_ID"].ToString(); HttpContext.Current.Session["SURPRISE_DISCOUNT_PERCENTAGE"] = lMySqlDataReader["SURPRISE_DISCOUNT_PERCENTAGE"].ToString(); HttpContext.Current.Session["PROMOTION_CODE"] = lMySqlDataReader["PROMOTION_CODE"].ToString(); HttpContext.Current.Session["DELIVERY_ADDRESS_ID"] = lMySqlDataReader["DELIVERY_ADDRESS_ID"].ToString(); } else { HttpContext.Current.Session["SURPRISE_DISCOUNT_PERCENTAGE"] = lSurprise_Discount_Percentage; } if (lRecords[1] != "" && lRecords[1] != null) { lNoOfShippingItems = int.Parse(lRecords[1]); lShippingValue = double.Parse(lRecords[2]); } HttpContext.Current.Session["SHOPPING_ITEMS"] = lNoOfShippingItems; HttpContext.Current.Session["SHOPPING_ITEMS_VALUE"] = lShippingValue; HttpContext.Current.Session["SHOPPING_CART_ID"] = lRecords[0]; lMySqlDataReader.Close(); } }