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();
}
}
public static void Create_Order(MySqlConnection dbconn,
string CustomerId,
string GrandTotal,
string ShippingCharges,
string Discounts,
string AddressId,
string PromotionId,
string PaymentType,
string Status,
string DeliveryMethod)
{
string[] lRecords = CommonClass.ExecuteQuery("ADD_ORDER",
new string[]
{
"P_USER_ID",
"P_EXTERNAL_USER_ID",
"P_ORDER_TOTAL",
"P_SHIPPING_CHARGE",
"P_DISCOUNTS",
"P_ADDRESS_ID",
"P_PROMOTION_ID",
"P_PAYMENT_TYPE",
"P_ORDER_STATUS",
"P_DELIVERY_METHOD",
"P_SHOPPING_CART_ID"
},
new string[]
{
CustomerId,
ClaimsPrincipal.Current.FindFirst("user_id").Value,
GrandTotal,
ShippingCharges,
Discounts,
AddressId,
PromotionId,
PaymentType,
Status,
DeliveryMethod,
HttpContext.Current.Session["SHOPPING_CART_ID"].ToString()
},
new string[]
{
"P_ORDER_ID"
},
dbconn);
string lOrderid = lRecords[0];
if (PaymentType == "Others")
{
UserModel lUserModel = CommonClass.Get_External_User_Profile(dbconn);
PaymentClass.Initiate_CCAvenue_Order(lOrderid,
GrandTotal,
lUserModel.Email_Address,
lUserModel.Mobile_Number,
AddressId,
dbconn);
dbconn.Close();
}
else
{
Confirm_Order(dbconn,
lOrderid);
dbconn.Close();
HttpContext.Current.Session.Abandon();
HttpContext.Current.Session.Clear();
HttpContext.Current.Response.Redirect("~/OrderSummary.aspx?Order_Id=" + lOrderid);
}
}
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 MigrateUser(MySqlConnection dbconn,
string pUserid,
string pFullName,
string pEmail,
string pEmailValidated)
{
Guid lGuid = Guid.NewGuid();
Guid lUserGuid = Guid.NewGuid();
string[] lRecords = CommonClass.ExecuteQuery("MIGRATE_USER",
new string[]
{
"P_EXTERNAL_USER_ID",
"P_USER_NAME",
"P_EMAIL_ADDRESS",
"P_GUID",
"P_USERID_GUID",
"P_EMAIL_VALIDATED_BY_PROVIDER"
},
new string[]
{
pUserid,
pFullName,
pEmail,
lGuid.ToString(),
lUserGuid.ToString(),
pEmailValidated
},
new string[]
{
"P_USER_ID",
"P_NEW_USER",
"P_EMAIL_ADDRESS_VALIDATED",
"P_USER_TYPE_ID"
},
dbconn);
if (lRecords[1] == "1")
{
if (pEmailValidated == "0")
{
Messages.Send_Welcome_Email_Validate_Message(pEmail,
pFullName,
lGuid.ToString(),
lUserGuid.ToString(),
dbconn);
}
else
{
Add_To_MailChimp(pEmail,
pFullName);
Messages.Send_Welcome_Message(pEmail,
pFullName,
dbconn);
}
// Messages.Send_Mobile_Validate_Message("9980075754", "Karpaga Kumar", "12345", dbconn);
Messages.send_sms("9980075754", "Dear Karpaga Kumar," + pEmail + " - " + "New User has been registered-Thanks");
}
}
