public static string UpdateProducts(int ProductID, string Title, string Short_decription, string Long_description, int Category, int Sub_category, int Third_category, decimal Price) { try { Nullable <int> ThirdCatID = null; PAWDStoreEntities context = new PAWDStoreEntities(); var Product = context.Product_Master.Where(x => x.Product_ID == ProductID).SingleOrDefault(); if (Product != null) { Product.Product_Title = Title; Product.Product_short_description = Short_decription; Product.Product_long_description = Long_description; Product.Category_ID = Category; Product.SubCategory_ID = Sub_category; Product.ThirdCategory_ID = Third_category == 0 ? ThirdCatID : Third_category; Product.Product_Price = Price; Product.Updated_date = DateTime.Now; context.SaveChanges(); var status = "success"; return(JsonConvert.SerializeObject(status)); } else { var status = "fail"; return(JsonConvert.SerializeObject(status)); } } catch (Exception ex) { throw ex.InnerException; } }
public static string GetProductImageByID(int PID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var ImageList = context.Product_Image_Master.Where(x => x.Product_ID == PID).Select(y => new { y.Procut_image_ID, y.Product_ID, y.Product_image, y.Image_name, y.Created_date, y.Updated_date, y.Product_Master.Product_Title, y.Product_Master.Product_short_description, y.Product_Master.Product_long_description, y.Product_Master.Category_ID, y.Product_Master.SubCategory_ID, y.Product_Master.ThirdCategory_ID, y.Product_Master.Product_Price }).ToList(); return(JsonConvert.SerializeObject(ImageList)); } catch (Exception ex) { throw ex.InnerException; } }
public static string DeleteMenuByID(int MenuID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var Menu = context.MainMenu_Master.Where(x => x.Menu_ID == MenuID).SingleOrDefault(); if (Menu != null) { var category = context.Category_Master.Where(x => x.Menu_ID == Menu.Menu_ID).ToList(); foreach (var cat in category) { var SubCategory = context.SubCategory_Master.Where(x => x.Category_ID == cat.Category_ID).ToList(); foreach (var SubCat in SubCategory) { context.SubCategory_Master.Remove(SubCat); context.SaveChanges(); } context.Category_Master.Remove(cat); context.SaveChanges(); } context.MainMenu_Master.Remove(Menu); context.SaveChanges(); } var status = "success"; return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
protected void Page_Load(object sender, EventArgs e) { PAWDStoreEntities context = new PAWDStoreEntities(); if (Session["User"] != null) { var user = Session["User"] as AdminLoginMaster; bool IsAdmin = context.AdminLoginMasters.Any(x => x.IsAdmin == true && x.EmailID == user.EmailID); if (!IsAdmin) { Response.RedirectToRoute("home", null); } else { int Product_ID = Convert.ToInt32(Request.QueryString["ID"]); var all_spec_group = context.Specification_Group_Master.Where(x => x.Product_ID == Product_ID).Select(y => new { y.Product_ID, y.Product_Master.Product_Title, y.Specification_GroupID, y.Specification_Group_Name }).OrderByDescending(t => t.Specification_GroupID).ToList(); var jsonSerialiser = new JavaScriptSerializer(); jsonSerialiser.MaxJsonLength = int.MaxValue; var Data = jsonSerialiser.Serialize(all_spec_group); var PID = jsonSerialiser.Serialize(Product_ID); Page.ClientScript.RegisterStartupScript(this.GetType(), "ProductSpecificationGroup", "get_all_product_Specification_group_by_PID(" + Data + ", " + PID + ");", true); } } else { Response.RedirectToRoute("home", null); } }
public static string GetAllCartItems() { var Items = new List <CartViewModel>(); if (HttpContext.Current.Session["User"] == null) { return(JsonConvert.SerializeObject(Items)); } else { int UserID = (HttpContext.Current.Session["User"] as AdminLoginMaster).User_ID; PAWDStoreEntities context = new PAWDStoreEntities(); Items = context.Cart_Master.Where(x => x.User_ID == UserID).Select(y => new CartViewModel() { Cart_ID = y.Cart_ID, ProductImage = y.Product_Master.Product_Image_Master.FirstOrDefault().Image_name, Product_Price = (decimal)y.Product_Master.Product_Price, Quantity = (int)y.Quantity, Product_Title = y.Product_Master.Product_Title, Product_ID = y.Product_ID, Size = y.Size }).ToList(); } return(JsonConvert.SerializeObject(Items)); }
protected void Page_Load(object sender, EventArgs e) { PAWDStoreEntities context = new PAWDStoreEntities(); int PID = Convert.ToInt32(Request.QueryString["ID"]); var GetProduct = context.Product_Master.Where(x => x.Product_ID == PID).Select(y => new { y.Product_ID, y.Product_short_description, y.Product_long_description, y.Product_Price, y.Category_ID, y.Category_Master.Category_Name, y.SubCategory_ID, y.SubCategory_Master.SubCategory_Name, y.ThirdCategory_ID, y.ThirdCategory_Master.ThirdCategory_Name, y.Created_date, y.Updated_date, y.Product_Title }).SingleOrDefault(); var jsonSerialiser = new JavaScriptSerializer(); jsonSerialiser.MaxJsonLength = int.MaxValue; var Data = jsonSerialiser.Serialize(GetProduct); Page.ClientScript.RegisterStartupScript(this.GetType(), "SingleProduct", "Product_data_bind(" + Data + ");", true); }
public static string AddProductInCart(int Product_ID, int Qty, string Size) { PAWDStoreEntities context = new PAWDStoreEntities(); int User_ID = (HttpContext.Current.Session["User"] as AdminLoginMaster).User_ID; var IsThereInCart = context.Cart_Master.FirstOrDefault(x => x.User_ID == User_ID && x.Product_ID == Product_ID); if (IsThereInCart == null) { var obj = new Cart_Master { Product_ID = Product_ID, User_ID = User_ID, Quantity = Qty, Size = !string.IsNullOrEmpty(Size) ? Size : string.Empty, CreatedDate = DateTime.Now }; context.Cart_Master.Add(obj); context.SaveChanges(); } else { IsThereInCart.Quantity = (IsThereInCart.Quantity + Qty) > 10 ? 10 : (IsThereInCart.Quantity + Qty); context.SaveChanges(); } int CartItemCount = context.Cart_Master.Count(x => x.User_ID == User_ID); return(JsonConvert.SerializeObject(CartItemCount)); }
public static string FilterMenuWise(int MenuID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); if (MenuID != 0) { var data = context.Category_Master.Where(x => x.Menu_ID == MenuID).Select(y => new { y.Category_ID, y.Menu_ID, y.MainMenu_Master.Menu_Name, y.IsDeleted, y.Category_Name }).ToList(); return(JsonConvert.SerializeObject(data)); } else { var data = context.Category_Master.Select(y => new { y.Category_ID, y.Menu_ID, y.MainMenu_Master.Menu_Name, y.IsDeleted, y.Category_Name }).ToList(); return(JsonConvert.SerializeObject(data)); } } catch (Exception ex) { throw ex.InnerException; } }
public static string UpdateProductsSpec(int Pro_spec_id, int Speec_grpID, int PID, string Spec_title, string Spec_value) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Product_Specification_Master.Where(x => x.Product_Specification_ID == Pro_spec_id).SingleOrDefault(); if (data != null) { data.Specification_Title = Spec_title; data.Specification_Value = Spec_value; data.UpdatedDate = DateTime.Now; context.SaveChanges(); var status = "success"; return(JsonConvert.SerializeObject(status)); } else { var status = "No Record Found"; return(JsonConvert.SerializeObject(status)); } } catch (Exception ex) { throw ex.InnerException; } }
protected void Page_Load(object sender, EventArgs e) { PAWDStoreEntities context = new PAWDStoreEntities(); if (Session["User"] != null) { var user = Session["User"] as AdminLoginMaster; bool IsAdmin = context.AdminLoginMasters.Any(x => x.IsAdmin == true && x.EmailID == user.EmailID); if (!IsAdmin) { Response.RedirectToRoute("home", null); } } else { Response.RedirectToRoute("home", null); } //if (Session["User"] == null) //{ // Response.RedirectToRoute("home", null); //} //var user = Session["User"] as AdminLoginMaster; //bool IsAdmin = context.AdminLoginMasters.Any(x => x.IsAdmin == true && x.EmailID == user.EmailID); //if (!IsAdmin) //{ // Response.RedirectToRoute("home", null); //} }
public static string SortableChange(int Soratable, int SubCategoryID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var get_sub_cat_byID = context.SubCategory_Master.Where(x => x.SubCategory_ID == SubCategoryID).SingleOrDefault(); var all_subcar_without_one = context.SubCategory_Master.Where(x => x.SubCategory_ID != SubCategoryID).OrderBy(x => x.Sortable).ToList(); int sort = 2; get_sub_cat_byID.Sortable = 1; context.SaveChanges(); foreach (var i in all_subcar_without_one) { i.Sortable = sort++; context.SaveChanges(); } //var Cat = context.SubCategory_Master.Where(x => x.SubCategory_ID == SubCategoryID).SingleOrDefault(); //var MaxSort = context.SubCategory_Master.Max(x => x.Sortable); //var change_cat = context.SubCategory_Master.Where(x => x.Sortable == MaxSort).SingleOrDefault(); //Cat.Sortable = change_cat.Sortable; //change_cat.Sortable = Soratable; //context.SaveChanges(); var status = "success"; return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string GetAllSubCategorys() { try { PAWDStoreEntities context = new PAWDStoreEntities(); var status = (from C in context.SubCategory_Master join CC in context.Category_Master on C.Category_ID equals CC.Category_ID join M in context.MainMenu_Master on CC.Menu_ID equals M.Menu_ID select new { SubCategory_ID = C.SubCategory_ID, SubCategory_Name = C.SubCategory_Name, CategoryID = C.Category_ID, IsDeleted = C.IsDeleted, Category_Name = CC.Category_Name, Menu_ID = M.Menu_ID, Menu_Name = M.Menu_Name, Image = C.Image, IsHomePage = C.IsHomePage, ImageName = C.ImageName, Sortable = C.Sortable }).OrderBy(x => x.Sortable).ToList(); //var status = context.RGetSubCategory().ToList(); return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string GetSubCategoryByID(int SubCategoryID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var status = context.SubCategory_Master.Where(x => x.SubCategory_ID == SubCategoryID).Select(y => new { y.Category_ID, y.Category_Master.Category_Name, y.SubCategory_ID, y.SubCategory_Name, y.ImageName, y.Image, y.Heading, y.Description, y.Page_Image, y.Page_Image_Name, y.AlterText }).SingleOrDefault(); return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
protected void btnAdminLogin_Click(object sender, EventArgs e) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var Admin = context.AdminLoginMasters.Where(x => x.EmailID == txtEmail.Text).FirstOrDefault(); if (Admin != null) { if (Admin.Password == txtPassword.Text) { Session["UserName"] = Admin.UserName; Session["Email"] = Admin.EmailID; Session["UserID"] = Admin.User_ID; Response.RedirectToRoute("Dashboard", null); } else { errorLabel.Text = "Error: Invalid Password."; errorMessage.Visible = true; } } else { errorLabel.Text = "Error: Invalid Email or Password."; errorMessage.Visible = true; } } catch (Exception ex) { throw ex.InnerException; } }
public static string UpdateProductCK(int Ck_ID, int PID, string CK_Title, string Description) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Product_CK_Master.Where(x => x.Product_CK_ID == Ck_ID).SingleOrDefault(); if (data != null) { data.CK_Title = CK_Title; data.Description = Description; data.Updated_date = DateTime.Now; context.SaveChanges(); var status = "success"; return(JsonConvert.SerializeObject(status)); } else { var status = "Record not found"; return(JsonConvert.SerializeObject(status)); } } catch (Exception ex) { throw ex.InnerException; } }
public static string GetProductByID(int PID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var status = context.Product_Master.Where(x => x.Product_ID == PID).Select(y => new { y.Product_ID, y.Product_Title, y.Product_short_description, y.Product_long_description, y.Created_date, y.Updated_date, y.Category_ID, y.Category_Master.Category_Name, y.SubCategory_ID, y.SubCategory_Master.SubCategory_Name, y.ThirdCategory_ID, y.ThirdCategory_Master.ThirdCategory_Name, y.Product_Price }).SingleOrDefault(); return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string AddSubsribe(string Email) { try { PAWDStoreEntities context = new PAWDStoreEntities(); Subscribe_Master obj = new Subscribe_Master(); var Total_group = context.Email_Group_Master.Take(1).OrderByDescending(x => x.Email_Group_ID).SingleOrDefault(); if (Total_group != null) { var Total_Email = context.Subscribe_Master.Where(x => x.Email_Group_ID == Total_group.Email_Group_ID && x.IsDeleted == false).Count(); if (Total_Email < 200) { obj.EmailID = Email; obj.IsDeleted = false; obj.Email_Group_ID = Total_group.Email_Group_ID; context.Subscribe_Master.Add(obj); context.SaveChanges(); } else { var GroupName = Total_group.Email_Group_Name.Split('_'); var Group_name = GroupName[0] + "_" + GroupName[1] + "_"; int group_no = Convert.ToInt32(GroupName[2]) + 1; Group_name = Group_name + group_no.ToString(); Email_Group_Master Email_obj = new Email_Group_Master(); Email_obj.Email_Group_Name = Group_name; context.Email_Group_Master.Add(Email_obj); context.SaveChanges(); int Email_Group_ID = Email_obj.Email_Group_ID; obj.EmailID = Email; obj.IsDeleted = false; obj.Email_Group_ID = Email_Group_ID; context.Subscribe_Master.Add(obj); context.SaveChanges(); } } else { Email_Group_Master Obj_Email_Group = new Email_Group_Master(); Obj_Email_Group.Email_Group_Name = "Email_Group_1"; context.Email_Group_Master.Add(Obj_Email_Group); context.SaveChanges(); var id = Obj_Email_Group.Email_Group_ID; Subscribe_Master obj_subscribe = new Subscribe_Master(); obj_subscribe.EmailID = Email; obj_subscribe.Email_Group_ID = id; obj_subscribe.IsDeleted = false; context.Subscribe_Master.Add(obj_subscribe); context.SaveChanges(); } var status = "success"; return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
protected void Page_Load(object sender, EventArgs e) { PAWDStoreEntities context = new PAWDStoreEntities(); if (Session["User"] == null) { Response.RedirectToRoute("home", null); } }
public static string GetCartItemCount() { if (HttpContext.Current.Session["User"] != null) { PAWDStoreEntities context = new PAWDStoreEntities(); int UserID = (HttpContext.Current.Session["User"] as AdminLoginMaster).User_ID; int count = context.Cart_Master.Count(x => x.User_ID == UserID); return(JsonConvert.SerializeObject(count)); } return(JsonConvert.SerializeObject(0)); }
public static string DeleteProductInCart(int Cart_ID) { PAWDStoreEntities context = new PAWDStoreEntities(); var Item = context.Cart_Master.FirstOrDefault(x => x.Cart_ID == Cart_ID); if (Item != null) { context.Cart_Master.Remove(Item); context.SaveChanges(); } return(JsonConvert.SerializeObject(true)); }
public static string ChangeOrderStatus(int Order_ID, string Status) { PAWDStoreEntities context = new PAWDStoreEntities(); var Order = context.Order_Master.FirstOrDefault(x => x.Order_ID == Order_ID); if (Order != null) { Order.Order_Status = Status; context.SaveChanges(); } return(JsonConvert.SerializeObject(true)); }
protected void Page_Load(object sender, EventArgs e) { PAWDStoreEntities context = new PAWDStoreEntities(); if (Session["User"] != null) { int Order_ID = Convert.ToInt32(Request.QueryString["ID"]); var OrderItems = context.Order_Master.Where(x => x.Order_ID == Order_ID).Select(y => new OrderItemsViewModel() { Order_ID = y.Order_ID, BName = y.User_Address_Master.BName, BEmail = y.User_Address_Master.BEmail, BAddress = y.User_Address_Master.BAddress, BCity = y.User_Address_Master.BCity, BMobile = y.User_Address_Master.BMobile, BState = y.User_Address_Master.BState, BZipcode = y.User_Address_Master.BZipcode, SName = y.User_Address_Master.SName, SAddress = y.User_Address_Master.SAddress, SCity = y.User_Address_Master.SCity, SEmail = y.User_Address_Master.SEmail, SMobile = y.User_Address_Master.SMobile, SState = y.User_Address_Master.SState, SZipcode = y.User_Address_Master.SZipcode, OrderStatus = y.Order_Status, OrderDate = y.CreatedDate, OrderType = y.Order_Type, Order_No = y.Order_No, paymentMethod = y.Order_Type, OrderItem = y.Order_Item_Master.Select(c => new AdminOrderItemViewModel() { Order_Item_ID = c.Order_Item_ID, Order_ID = c.Order_ID, Product_ID = c.Product_ID, ImageName = c.Product_Master.Product_Image_Master.FirstOrDefault().Image_name, Product_Price = c.Price, Product_Title = c.Product_Master.Product_Title, Quantity = c.Quantity, ProductSize = c.Size, ProductShortDescription = c.Product_Master.Product_short_description }).ToList() }).FirstOrDefault(); var jsonSerialiser = new JavaScriptSerializer(); jsonSerialiser.MaxJsonLength = int.MaxValue; var Data = jsonSerialiser.Serialize(OrderItems); var OID = jsonSerialiser.Serialize(Order_ID); Page.ClientScript.RegisterStartupScript(this.GetType(), "OrderDetails", "GetOrderDetails(" + Data + ", " + OID + ");", true); } else { Response.RedirectToRoute("home", null); } }
protected void Page_Load(object sender, EventArgs e) { PAWDStoreEntities context = new PAWDStoreEntities(); int Information_ID = Convert.ToInt32(Request.QueryString["ID"]); var information = context.Information_Master.Where(x => x.Information_ID == Information_ID).SingleOrDefault(); var jsonSerialiser = new JavaScriptSerializer(); jsonSerialiser.MaxJsonLength = int.MaxValue; var Data = jsonSerialiser.Serialize(information); Page.ClientScript.RegisterStartupScript(this.GetType(), "Information", "get_single_latest_update(" + Data + ");", true); }
public static string add_hot_product(int ProductID, bool value) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var all_hot_product = context.Product_Master.Where(x => x.IsHotProduct == true).ToList(); if (value == true) { if (all_hot_product.Count() < 6) { var get_product = context.Product_Master.Where(x => x.Product_ID == ProductID).SingleOrDefault(); if (get_product != null) { get_product.IsHotProduct = value; context.SaveChanges(); var status = "success fully added in hot product"; return(JsonConvert.SerializeObject(status)); } else { var status = "record not found please try again"; return(JsonConvert.SerializeObject(status)); } } else { var status = "please remove some product in to the hot product and then try add"; return(JsonConvert.SerializeObject(status)); } } else { var get_product = context.Product_Master.Where(x => x.Product_ID == ProductID).SingleOrDefault(); if (get_product != null) { get_product.IsHotProduct = value; context.SaveChanges(); var status = "success fully removed in hot product"; return(JsonConvert.SerializeObject(status)); } else { var status = "record not found please try again"; return(JsonConvert.SerializeObject(status)); } } } catch (Exception ex) { throw ex.InnerException; } }
public static string DeleteThirdCategory(int ThirdCatID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var status = context.ThirdCategory_Master.Where(y => y.ThirdCategory_ID == ThirdCatID).SingleOrDefault(); if (status != null) { var Product = context.Product_Master.Where(x => x.ThirdCategory_ID == ThirdCatID).ToList(); if (Product.Count() > 0) { foreach (var P in Product) { var imapge = context.Product_Image_Master.Where(x => x.Product_ID == P.Product_ID).ToList(); if (imapge.Count() > 0) { context.Product_Image_Master.RemoveRange(imapge); context.SaveChanges(); } var P_CK = context.Product_CK_Master.Where(x => x.Product_ID == P.Product_ID).ToList(); if (P_CK.Count() > 0) { context.Product_CK_Master.RemoveRange(P_CK); context.SaveChanges(); } var Specification = context.Product_Specification_Master.Where(x => x.Product_ID == P.Product_ID).ToList(); if (Specification.Count() > 0) { context.Product_Specification_Master.RemoveRange(Specification); context.SaveChanges(); } var S_Grp = context.Specification_Group_Master.Where(x => x.Product_ID == P.Product_ID).ToList(); if (S_Grp.Count() > 0) { context.Specification_Group_Master.RemoveRange(S_Grp); context.SaveChanges(); } context.Product_Master.Remove(P); context.SaveChanges(); } } context.ThirdCategory_Master.Remove(status); context.SaveChanges(); } var status1 = "success"; return(JsonConvert.SerializeObject(status1)); } catch (Exception ex) { throw ex.InnerException; } }
public static string GetCategoryByID(int CategoryID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var status = context.Category_Master.Where(x => x.Category_ID == CategoryID).Select(y => new { y.Category_ID, y.Category_Name, y.Menu_ID, y.MainMenu_Master.Menu_Name }).SingleOrDefault(); return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string AddProductCK(int PID, string CK_Title, string Description) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var status = context.ProductCKInsert(PID, CK_Title, Description, DateTime.Now, null).SingleOrDefault(); return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string AddCategory(string CategoryName, int MenuID, bool IsDelete) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var status = context.CategoryInsert(CategoryName, MenuID, IsDelete).SingleOrDefault(); return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string GetInformation() { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Information_Master.Select(x => new { x.Information_ID, x.Title, x.CreatedDate, x.Description }).ToList(); return(JsonConvert.SerializeObject(data)); } catch (Exception ex) { throw ex.InnerException; } }
public static string Getategory() { try { PAWDStoreEntities context = new PAWDStoreEntities(); var status = context.RGetCategory().ToList(); return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }