// GET: Category public int SaveCategory(Ent_Category model) { SafeTransaction trans = new SafeTransaction(); DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); model.Created_Date = indiTime; HttpCookie C_UserID = Request.Cookies["User_ID"]; string User_ID = C_UserID != null?C_UserID.Value.Split('=')[1] : ""; model.Created_By = Convert.ToInt32(User_ID); int i = balCategory.SaveCategory(model, trans); if (i > 0) { trans.Commit(); } else { trans.Rollback(); } return(i); }
public int RegisterGuest(Ent_Guest model) { int result = 0; SafeTransaction trans = new SafeTransaction(); DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); model.Created_Date = indiTime; string uniqueId = Guid.NewGuid().ToString(); model.Unique_ID = uniqueId; result = balGuest.SaveGuest(model, trans); if (result > 0) { trans.Commit(); var lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("ActivateAccount", "Login", new { id = uniqueId }) + "' target='_blank' style='display: inline-block; padding: 16px 36px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; color: #ffffff; text-decoration: none; border-radius: 6px;'>Confirm Your Mail</a>"; string body = string.Empty; using (StreamReader reader = new StreamReader(Server.MapPath("~/confirm.html"))) { body = reader.ReadToEnd(); } body = body.Replace("{Url}", lnkHref); Email email = new Email(); email.SendMail(body, model.Guest_Username, "Account Activation"); } else { trans.Rollback(); } return(result); }
public int DeleteCategory(int Category_ID) { Ent_Category ent = new Ent_Category(); ent.Category_ID = Category_ID; HttpCookie UserID = Request.Cookies["User_ID"]; var UserId = UserID != null?UserID.Value.Split('=')[1] : ""; ent.Modified_By = Convert.ToInt32(UserId); DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); ent.Modified_Date = indiTime; SafeTransaction trans = new SafeTransaction(); int i = balCategory.DeleteCategory(ent, trans); if (i > 0) { trans.Commit(); } else { trans.Rollback(); } return(i); }
public int UpdateOrderStatus(Ent_Order ent) { int result = 0; SafeTransaction trans = new SafeTransaction(); DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); ent.Created_Date = indiTime; result = balOrder.UpdateOrderStatus(ent, trans); if (result > 0) { trans.Commit(); string body = string.Empty; var lnkHref = ""; if (ent.Is_Active == 2) { if (ent.Guest_ID == 0) { lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("TrackOrder", "Order", new { Order_ID = ent.Order_ID }) + "' target = '_blank' style = 'color: #fc7ca0;' > here </a>"; } else { lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("Register", "Login") + "' target = '_blank' style = 'color: #fc7ca0;' > here </a>"; } using (StreamReader reader = new StreamReader(Server.MapPath("~/Shipping.html"))) { body = reader.ReadToEnd(); } body = body.Replace("{Url}", lnkHref); Email em = new Email(); em.SendConfirmationMail(ent.Order_ID, body, "Order Shipped"); } else if (ent.Is_Active == 3) { if (ent.Guest_ID == 0) { lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("TrackOrder", "Order", new { Order_ID = ent.Order_ID }) + "' target = '_blank' style = 'color: #fc7ca0;' > here </a>"; } else { lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("Register", "Login") + "' target = '_blank' style = 'color: #fc7ca0;' > here </a>"; } using (StreamReader reader = new StreamReader(Server.MapPath("~/Delivered.html"))) { body = reader.ReadToEnd(); } body = body.Replace("{Url}", lnkHref); Email eml = new Email(); eml.SendConfirmationMail(ent.Order_ID, body, "Order Delivered"); } } else { trans.Rollback(); } return(result); }
public int UpdatePayment(Ent_Order entOrder) { SafeTransaction trans = new SafeTransaction(); HttpCookie Guest_ID = Request.Cookies["Guest_ID"]; int ID = Guest_ID != null?Convert.ToInt32(Guest_ID.Value.Split('=')[1]) : 0; entOrder.Guest_ID = ID; int i = balOrder.UpdatePayment(entOrder, trans); if (i > 0) { trans.Commit(); if (entOrder.Payment_Status == "CAPTURED") { string body = string.Empty; var lnkHref = ""; if (ID == 0) { lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("TrackOrder", "Order", new { Order_ID = entOrder.Order_ID }) + "' target = '_blank' style = 'color: #fc7ca0;' > here </ a >"; } else { lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("Register", "Login") + "' target = '_blank' style = 'color: #fc7ca0;' > here </ a >"; } using (StreamReader reader = new StreamReader(Server.MapPath("~/OrderConfirmation.html"))) { body = reader.ReadToEnd(); } body = body.Replace("{Url}", lnkHref); Email em = new Email(); em.SendConfirmationMail(entOrder.Order_ID, body, "Order Confirmation"); if (ID != 0) { SafeTransaction transac = new SafeTransaction(); int result = balOrder.DeleteCart(0, ID, transac); if (result > 0) { transac.Commit(); } else { transac.Rollback(); } } Session["Cart"] = null; Session["Total"] = null; Session["SubTotal"] = null; Session["Shipping"] = null; } } else { trans.Rollback(); } return(i); }
public int UpdateCart(List <Ent_Product> CartList) { float total = 0; List <Ent_OrderDetail> item = new List <Ent_OrderDetail>(); for (int i = 0; i < CartList.Count; i++) { item.Add(new Ent_OrderDetail() { Product_ID = CartList[i].Product_ID, Product_Name = CartList[i].Product_Name, Quantity = CartList[i].Quantity, Product_Price = CartList[i].Product_Price, Product_Image = CartList[i].Product_Image, Product_Total = CartList[i].Quantity * CartList[i].Product_Price, }); HttpCookie Guest_ID = Request.Cookies["Guest_ID"]; string GuestID = Guest_ID != null?Guest_ID.Value.Split('=')[1] : ""; if (!string.IsNullOrEmpty(GuestID)) { Ent_OrderDetail entP = new Ent_OrderDetail(); entP.Cart_ID = 1; entP.Product_ID = CartList[i].Product_ID; entP.Quantity = CartList[i].Quantity; entP.Guest_ID = Convert.ToInt32(GuestID); SafeTransaction trans = new SafeTransaction(); int result = balOrder.InsertCart(entP, trans); if (result > 0) { trans.Commit(); } else { trans.Rollback(); } } total = total + (CartList[i].Quantity * CartList[i].Product_Price); Session["Cart"] = item; item = (List <Ent_OrderDetail>)Session["Cart"]; } Session["SubTotal"] = Session["Total"] = total; return(1); }
public ActionResult DeleteCart(int CartID) { List <Ent_OrderDetail> list = (List <Ent_OrderDetail>)Session["Cart"]; Ent_Product ent = new Ent_Product(); ent = balProduct.SelectProduct(CartID); var qty = list.Where(l => l.Product_ID == CartID).FirstOrDefault().Quantity; Session["Cart"] = list.Where(l => l.Product_ID != CartID).ToList <Ent_OrderDetail>(); int count = list.Count - 1; Session["SubTotal"] = Convert.ToInt32(Session["SubTotal"]) - ((ent.Product_Price - ent.Product_Discount) * qty); Session["Total"] = Convert.ToInt32(Session["Total"]) - ((ent.Product_Price - ent.Product_Discount) * qty); if (list.Count == 1) { Session["Cart"] = null; Session["Total"] = "0.00"; Session["SubTotal"] = "0.00"; Session["Shipping"] = "0.00"; } HttpCookie Guest_ID = Request.Cookies["Guest_ID"]; string GuestID = Guest_ID != null?Guest_ID.Value.Split('=')[1] : ""; if (!string.IsNullOrEmpty(GuestID)) { SafeTransaction trans = new SafeTransaction(); int result = balOrder.DeleteCart(CartID, Convert.ToInt32(GuestID), trans); if (result > 0) { trans.Commit(); } else { trans.Rollback(); } } string[] Result = { count.ToString(), Session["Total"].ToString(), Session["SubTotal"].ToString() }; return(Json(Result, JsonRequestBehavior.AllowGet)); }
public int UpdateAddress(Ent_GuestAddress model) { int result = 0; HttpCookie Guest_ID = Request.Cookies["Guest_ID"]; int GuestID = Guest_ID != null?Convert.ToInt32(Guest_ID.Value.Split('=')[1]) : 0; model.Guest_ID = GuestID; SafeTransaction trans = new SafeTransaction(); result = balGuest.UpdateAddress(model, trans); if (result > 0) { trans.Commit(); } else { trans.Rollback(); } return(result); }
// GET: Category public int SaveProduct(Ent_Product model) { SafeTransaction trans = new SafeTransaction(); DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); model.Created_Date = indiTime; //HttpCookie C_UserID = Request.Cookies["User_ID"]; //string User_ID = C_UserID != null ? C_UserID.Value.Split('=')[1] : ""; //model.Created_By = Convert.ToInt32(User_ID); model.Created_By = 1; HttpFileCollectionBase files = Request.Files; if (files.Count > 0) { HttpPostedFileBase file = files["Product_ImageFile"]; if (file != null) { file.SaveAs(Server.MapPath("~/ProductImages/" + model.Product_Image)); model.Product_Image = model.Product_Image; } } else if (!System.IO.File.Exists(Server.MapPath("~/ProductImages/" + model.Product_Image))) { model.Product_Image = ""; } int i = balProduct.SaveProduct(model, trans); if (i > 0) { trans.Commit(); } else { trans.Rollback(); } return(i); }
public int SaveOrganization(Ent_Organization model) { int result = 0; SafeTransaction trans = new SafeTransaction(); DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); model.Created_Date = indiTime; //HttpCookie User_ID = Request.Cookies["User_ID"]; //model.Created_By = Convert.ToInt32(User_ID.Value.Split('=')[1]); model.Created_By = 1; result = balMaster.SaveOrganization(model, trans); if (result > 0) { trans.Commit(); } else { trans.Rollback(); } return(result); }
public ActionResult ActivateAccount(string id) { SafeTransaction trans = new SafeTransaction(); int result = 0; if (id != null) { Ent_Guest ent = new Ent_Guest(); DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); ent.Created_Date = indiTime; result = balGuest.ActivateGuest(ent, id, trans); if (result > 0) { trans.Commit(); } else { trans.Rollback(); } } string message = ""; if (result > 0) { message = "Your Email Has Been Confirmed ! Please Login."; } else if (result != -2) { message = "Your Email Not Confirmed."; } return(RedirectToAction("Register", new { msg = message })); //ViewBag.Result = result; //return View(); }
//Login public int CreateLogin(string Username, string Password) { int i = 0; if (Username != "" && Password != "") { Ent_Guest entu = new Ent_Guest(); Ent_Guest result = new Ent_Guest(); entu.Guest_Username = Username; entu.Guest_Password = Password; result = balGuest.SelectLogin(entu); if (result != null) { if (result.Guest_ID > 0) { //Login User ID HttpCookie Guest_ID = new HttpCookie("Guest_ID"); Guest_ID.Values["Guest_ID"] = Convert.ToString(result.Guest_ID); Guest_ID.Expires = DateTime.Now.AddMinutes(10); Response.Cookies.Add(Guest_ID); //Login User Name HttpCookie Guest_FirstName = new HttpCookie("Guest_FirstName"); if (result.Guest_FirstName != "") { Guest_FirstName.Values["Guest_FirstName"] = Convert.ToString(result.Guest_FirstName); } else { Guest_FirstName.Values["Guest_FirstName"] = Convert.ToString(result.Guest_Username); } Guest_FirstName.Expires = DateTime.Now.AddMinutes(10); Response.Cookies.Add(Guest_FirstName); List <Ent_OrderDetail> list = new List <Ent_OrderDetail>(); list = balOrder.SelectCart(result.Guest_ID); if (list.Count == 0 && Session["Cart"] != null) { List <Ent_OrderDetail> item = (List <Ent_OrderDetail>)Session["Cart"]; SafeTransaction trans = new SafeTransaction(); int r = balOrder.InsertCartList(item, result.Guest_ID, trans); if (r > 0) { trans.Commit(); } else { trans.Rollback(); } } else { Session["Cart"] = list; Session["Total"] = Session["SubTotal"] = list.Sum(y => y.Product_Total); } i = 1; } else { if (Request.Cookies["Guest_ID"] != null) { HttpCookie myCookie = new HttpCookie("Guest_ID"); myCookie.Expires = DateTime.Now.AddDays(-1); Response.Cookies.Add(myCookie); } if (Request.Cookies["Guest_FirstName"] != null) { HttpCookie myCookie = new HttpCookie("Guest_FirstName"); myCookie.Expires = DateTime.Now.AddDays(-1); Response.Cookies.Add(myCookie); } i = -1; } } else { i = -1; } } else { i = 0; } return(i); }
// GET: Order public int AddToCart(int Product_ID) { Ent_Product ent = new Ent_Product(); ent = balProduct.SelectProduct(Product_ID); HttpCookie Guest_ID = Request.Cookies["Guest_ID"]; int GuestID = Guest_ID != null?Convert.ToInt32(Guest_ID.Value.Split('=')[1]) : 0; int qty = 1; int cartid = 0; if (Session["Cart"] == null) { List <Ent_OrderDetail> item = new List <Ent_OrderDetail>(); item.Add(new Ent_OrderDetail() { Product_ID = Product_ID, Product_Name = ent.Product_Name, Quantity = 1, Product_Price = ent.Product_Price - ent.Product_Discount, Product_Image = ent.Product_Image, Product_Total = ent.Product_Price - ent.Product_Discount, }); Session["Cart"] = item; Session["SubTotal"] = ent.Product_Price - ent.Product_Discount; Session["Total"] = ent.Product_Price - ent.Product_Discount; } else { List <Ent_OrderDetail> item = (List <Ent_OrderDetail>)Session["Cart"]; bool has = item.Any(x => x.Product_ID == Product_ID); if (has == false) { item.Add(new Ent_OrderDetail() { Product_ID = Product_ID, Product_Name = ent.Product_Name, Quantity = 1, Product_Price = ent.Product_Price - ent.Product_Discount, Product_Image = ent.Product_Image, Product_Total = ent.Product_Price - ent.Product_Discount, }); } else { item.Where(w => w.Product_ID == Product_ID).ToList().ForEach(i => { i.Quantity = i.Quantity + 1; i.Product_Total = ((i.Quantity) * i.Product_Price); }); qty = item.Where(l => l.Product_ID == Product_ID).FirstOrDefault().Quantity; cartid = 1; } Session["Cart"] = item; Session["SubTotal"] = Convert.ToInt32(Session["SubTotal"]) + (ent.Product_Price - ent.Product_Discount); Session["Total"] = Convert.ToInt32(Session["Total"]) + (ent.Product_Price - ent.Product_Discount); } if (GuestID != 0) { Ent_OrderDetail entP = new Ent_OrderDetail(); entP.Cart_ID = cartid; entP.Product_ID = Product_ID; entP.Quantity = qty; entP.Guest_ID = Convert.ToInt32(GuestID); SafeTransaction trans = new SafeTransaction(); int result = balOrder.InsertCart(entP, trans); if (result > 0) { trans.Commit(); } else { trans.Rollback(); } } return(1); }
public int SaveOrder(Ent_Order model) { SafeTransaction trans = new SafeTransaction(); DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); model.Created_Date = indiTime; HttpCookie Guest_ID = Request.Cookies["Guest_ID"]; string GuestID = Guest_ID != null?Guest_ID.Value.Split('=')[1] : ""; if (!string.IsNullOrEmpty(GuestID)) { model.Guest_ID = Convert.ToInt32(GuestID); Ent_GuestAddress entAddress = new Ent_GuestAddress(); entAddress = balguest.SelectGuestAddress(Convert.ToInt32(GuestID)); if (entAddress.Guest_Address1 != "") { model.Billing_FirstName = entAddress.First_Name; model.Billing_LastName = entAddress.Last_Name; model.Billing_Address1 = entAddress.Guest_Address1; model.Billing_Address2 = entAddress.Guest_Address2; model.Billing_State = entAddress.Guest_State; model.Billing_Town = entAddress.Guest_Town; model.Billing_Country = entAddress.Guest_Country; } else { model.Billing_FirstName = model.Shipping_FirstName; model.Billing_LastName = model.Shipping_LastName; model.Billing_Address1 = model.Shipping_Address1; model.Billing_Address2 = model.Shipping_Address2; model.Billing_State = model.Shipping_State; model.Billing_Town = model.Shipping_Town; model.Billing_Country = model.Shipping_Country; } } else { model.Guest_ID = 0; model.Billing_FirstName = model.Shipping_FirstName; model.Billing_LastName = model.Shipping_LastName; model.Billing_Address1 = model.Shipping_Address1; model.Billing_Address2 = model.Shipping_Address2; model.Billing_State = model.Shipping_State; model.Billing_Town = model.Shipping_Town; model.Billing_Country = model.Shipping_Country; } model.Billing_Email = model.Shipping_Email; model.Billing_Phone = model.Shipping_Phone; model.Order_SubTotal = Convert.ToDouble(Session["SubTotal"]); model.Order_Shipping = 0; model.Order_Total = Convert.ToDouble(Session["Total"]); model.OrderDetailsList = (List <Ent_OrderDetail>)Session["Cart"]; int i = balOrder.SaveOrder(model, trans); if (i > 0) { trans.Commit(); if (model.Payment_COD == 1) { string body = string.Empty; var lnkHref = ""; if (string.IsNullOrEmpty(GuestID)) { lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("TrackOrder", "Order", new { Order_ID = i }) + "' target = '_blank' style = 'color: #fc7ca0;' > here </ a >"; } else { lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("Register", "Login") + "' target = '_blank' style = 'color: #fc7ca0;' > here </ a >"; } using (StreamReader reader = new StreamReader(Server.MapPath("~/OrderConfirmation.html"))) { body = reader.ReadToEnd(); } body = body.Replace("{Url}", lnkHref); Email em = new Email(); em.SendConfirmationMail(i, body, "Order Confirmation"); if (!string.IsNullOrEmpty(GuestID)) { SafeTransaction transac = new SafeTransaction(); int result = balOrder.DeleteCart(0, Convert.ToInt32(GuestID), transac); if (result > 0) { transac.Commit(); } else { transac.Rollback(); } } Session["Cart"] = null; Session["Total"] = null; Session["SubTotal"] = null; Session["Shipping"] = null; } } else { trans.Rollback(); } return(i); }