Beispiel #1
0
 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;
     }
 }
Beispiel #2
0
 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;
     }
 }
Beispiel #3
0
 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;
     }
 }
Beispiel #4
0
        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);
            }
        }
Beispiel #5
0
        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);
        }
Beispiel #7
0
        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));
        }
Beispiel #8
0
 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;
     }
 }
Beispiel #9
0
 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;
     }
 }
Beispiel #10
0
        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;
     }
 }
Beispiel #14
0
 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;
     }
 }
Beispiel #15
0
 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;
     }
 }
Beispiel #16
0
 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;
     }
 }
Beispiel #17
0
        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;
            }
        }
Beispiel #18
0
        protected void Page_Load(object sender, EventArgs e)
        {
            PAWDStoreEntities context = new PAWDStoreEntities();

            if (Session["User"] == null)
            {
                Response.RedirectToRoute("home", null);
            }
        }
Beispiel #19
0
 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));
 }
Beispiel #20
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));
        }
Beispiel #21
0
        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));
        }
Beispiel #22
0
        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);
            }
        }
Beispiel #23
0
        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);
        }
Beispiel #24
0
 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;
     }
 }
Beispiel #25
0
 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;
     }
 }
Beispiel #26
0
 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;
     }
 }
Beispiel #27
0
 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;
     }
 }
Beispiel #28
0
 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;
     }
 }
Beispiel #30
0
 public static string Getategory()
 {
     try
     {
         PAWDStoreEntities context = new PAWDStoreEntities();
         var status = context.RGetCategory().ToList();
         return(JsonConvert.SerializeObject(status));
     }
     catch (Exception ex)
     {
         throw ex.InnerException;
     }
 }