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 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 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); }
// 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 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 SaveCategory(Ent_Category entGuest, SafeTransaction trans) { int dataResult = 0; try { Dal_Category dal = new Dal_Category(); dataResult = dal.SaveCategory(entGuest, trans); return(dataResult); } catch { return(0); } }
public int ActivateGuest(Ent_Guest entGuest, string token, SafeTransaction trans) { int dataResult = 0; try { Dal_Guest dal = new Dal_Guest(); dataResult = dal.ActivateGuest(entGuest, token, trans); return(dataResult); } catch { return(0); } }
public int SaveGuest(Ent_Guest entGuest, SafeTransaction trans) { int dataResult = 0; try { Dal_Guest dal = new Dal_Guest(); dataResult = dal.SaveGuest(entGuest, trans); return(dataResult); } catch { return(0); } }
public int UpdateAddress(Ent_GuestAddress entGuest, SafeTransaction trans) { int dataResult = 0; try { Dal_Guest dal = new Dal_Guest(); dataResult = dal.UpdateAddress(entGuest, trans); return(dataResult); } catch { return(0); } }
public int DeleteProduct(Ent_Product ent, SafeTransaction trans) { int dataResult; try { Dal_Product dal = new Dal_Product(); dataResult = dal.DeleteProduct(ent, trans); return(dataResult); } catch { return(-1); } }
public int SaveOrder(Ent_Order ent, SafeTransaction trans) { int dataResult = 0; try { Dal_Order dal = new Dal_Order(); dataResult = dal.SaveOrder(ent, trans); return(dataResult); } catch { return(0); } }
public int DeleteBrand(Ent_Brand ent, SafeTransaction trans) { int dataResult; try { Dal_Master dal = new Dal_Master(); dataResult = dal.DeleteBrand(ent, trans); return(dataResult); } catch { return(-1); } }
public int UpdatePayment(Ent_Order entOrder, SafeTransaction trans) { int dataResult = 0; try { Dal_Order dal = new Dal_Order(); dataResult = dal.UpdatePayment(entOrder, trans); return(dataResult); } catch { return(0); } }
public int DeleteCategory(Ent_Category ent, SafeTransaction trans) { int dataResult; try { Dal_Category dal = new Dal_Category(); dataResult = dal.DeleteCategory(ent, trans); return(dataResult); } catch { return(-1); } }
public int SaveBrand(Ent_Brand entGuest, SafeTransaction trans) { int dataResult = 0; try { Dal_Master dal = new Dal_Master(); dataResult = dal.SaveBrand(entGuest, trans); return(dataResult); } catch { return(0); } }
public int InsertCart(Ent_OrderDetail entGuest, SafeTransaction trans) { int dataResult = 0; try { Dal_Order dal = new Dal_Order(); dataResult = dal.InsertCart(entGuest, trans); return(dataResult); } catch { return(0); } }
public int DeleteCart(int productId, int GuestID, SafeTransaction trans) { int dataResult = 0; try { Dal_Order dal = new Dal_Order(); dataResult = dal.DeleteCart(productId, GuestID, trans); return(dataResult); } catch { return(0); } }
public int InsertCartList(List <Ent_OrderDetail> entGuest, int guestID, SafeTransaction trans) { int dataResult = 0; try { Dal_Order dal = new Dal_Order(); dataResult = dal.InsertCartList(entGuest, guestID, trans); return(dataResult); } catch { return(0); } }
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 int UpdateAddress(Ent_GuestAddress ent, SafeTransaction trans) { int dataresult = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlCommand cmd = new SqlCommand("EC_UpdateAddress", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Address_ID", ent.Address_ID)); cmd.Parameters.Add(new SqlParameter("@Guest_ID", ent.Guest_ID)); cmd.Parameters.Add(new SqlParameter("@First_Name", ent.First_Name)); cmd.Parameters.Add(new SqlParameter("@Last_Name", ent.Last_Name)); cmd.Parameters.Add(new SqlParameter("@Guest_Address1", ent.Guest_Address1)); cmd.Parameters.Add(new SqlParameter("@Guest_Address2", ent.Guest_Address2)); cmd.Parameters.Add(new SqlParameter("@Guest_Town", ent.Guest_Town)); cmd.Parameters.Add(new SqlParameter("@Guest_State", ent.Guest_State)); cmd.Parameters.Add(new SqlParameter("@Guest_Country", ent.Guest_Country)); cmd.Parameters.Add(new SqlParameter("@Address_Type", ent.Address_Type)); cmd.Parameters.Add(new SqlParameter("@Address_Default", ent.Address_Default)); try { dataresult = Convert.ToInt32(cmd.ExecuteScalar()); if (dataresult > 0) { cmd.Dispose(); } } catch (Exception ex) { dataresult = -2; InsertException(ex.Message, "UpdateAddress", ent.Guest_ID); } } } catch (Exception e) { dataresult = -2; } finally { con.Close(); } return(dataresult); }
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); }
public int InsertCartList(List <Ent_OrderDetail> ent, int guestID, SafeTransaction trans) { int dataresult = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } for (int k = 0; k < ent.Count; k++) { using (SqlCommand cmd = new SqlCommand("EC_InsertCart", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Cart_ID", ent[k].Cart_ID)); cmd.Parameters.Add(new SqlParameter("@Product_ID", ent[k].Product_ID)); cmd.Parameters.Add(new SqlParameter("@Quantity", ent[k].Quantity)); cmd.Parameters.Add(new SqlParameter("@Guest_ID", guestID)); try { dataresult = Convert.ToInt32(cmd.ExecuteScalar()); if (dataresult > 0) { cmd.Dispose(); } } catch (Exception ex) { dataresult = -2; } } } } catch (Exception e) { dataresult = -2; } finally { con.Close(); } return(dataresult); }
// 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 int ActivateGuest(Ent_Guest ent, string token, SafeTransaction trans) { int dataresult = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlCommand cmd = new SqlCommand("EC_ActivateGuest", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date)); cmd.Parameters.Add(new SqlParameter("@token", token)); try { dataresult = Convert.ToInt32(cmd.ExecuteScalar()); if (dataresult > 0) { cmd.Dispose(); } } catch (Exception ex) { dataresult = -2; InsertException(ex.Message, "ActivateGuest", 0); } } } catch (Exception e) { dataresult = -2; } finally { con.Close(); } return(dataresult); }
public int UpdateOrderStatus(Ent_Order ent, SafeTransaction trans) { int dataresult = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlCommand cmd = new SqlCommand("EC_UpdateOrderStatus", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date)); cmd.Parameters.Add(new SqlParameter("@status", ent.Is_Active)); cmd.Parameters.Add(new SqlParameter("@Order_ID", ent.Order_ID)); try { dataresult = Convert.ToInt32(cmd.ExecuteScalar()); if (dataresult > 0) { cmd.Dispose(); } } catch (Exception ex) { dataresult = -2; } } } catch (Exception e) { dataresult = -2; } finally { con.Close(); } return(dataresult); }
public int DeleteCart(int productId, int GuestID, SafeTransaction trans) { int dataResult = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlCommand cmd = new SqlCommand("EC_DeleteCart", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Product_ID", productId)); cmd.Parameters.Add(new SqlParameter("@Guest_ID", GuestID)); try { dataResult = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); } catch (Exception e) { InsertException(e.Message, "DeleteCart", GuestID); dataResult = -1; } } } catch (Exception) { dataResult = -1; } finally { con.Close(); } return(dataResult); }
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(); }
public int DeleteUser(Ent_User ent, SafeTransaction trans) { int dataResult = 0; int dataresult1 = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlCommand cmd = new SqlCommand("EC_DeleteUser", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@User_ID", ent.User_ID)); cmd.Parameters.Add(new SqlParameter("@Modified_By", ent.Modified_By)); cmd.Parameters.Add(new SqlParameter("@Modified_Date", ent.Modified_Date)); try { dataResult = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); } catch (Exception e) { InsertException(e.Message, "DeleteUser", ent.User_ID); dataResult = -1; } } if (dataResult > 0) { using (SqlCommand cmd = new SqlCommand("EC_InsertLog", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Created_By", ent.Modified_By)); cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Modified_Date)); cmd.Parameters.Add(new SqlParameter("@Primary_Id", ent.User_ID)); cmd.Parameters.Add(new SqlParameter("@Log_Action", "Delete User")); cmd.Parameters.Add(new SqlParameter("@Log_Status", "Admin")); try { dataresult1 = Convert.ToInt32(cmd.ExecuteScalar()); if (dataresult1 > 0) { cmd.Dispose(); } } catch (Exception ex) { dataresult1 = -2; } } } } catch (Exception) { dataResult = -1; } finally { con.Close(); } return(dataResult); }