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; } }
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 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 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; } }
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 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 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 CreateUser_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Email.Text) && !string.IsNullOrEmpty(Password.Text) && !string.IsNullOrEmpty(ConfirmPassword.Text) && !string.IsNullOrEmpty(Name.Text)) { bool IsEmailAlreadyUsed = context.AdminLoginMasters.Any(x => x.EmailID.Trim().ToLower().Equals(Email.Text.ToLower().Trim())); if (Password.Text.Equals(ConfirmPassword.Text)) { if (!IsEmailAlreadyUsed) { var obj = new AdminLoginMaster() { EmailID = Email.Text.Trim(), IsAdmin = false, Password = Password.Text, UserName = Name.Text.Trim(), JoinDate = DateTime.Now }; context.AdminLoginMasters.Add(obj); context.SaveChanges(); Response.RedirectToRoute("login"); } else { EmailAlreadyMessage.Visible = true; EmailAlreadyMessage.Text = Email.Text + " email is already taken"; } } } }
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 AddUserDetails(string FirstName, string LastName, string Website, string ProfileImage, string Bio, string Image_binary) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var user = HttpContext.Current.Session["User"] as AdminLoginMaster; var IsThereUser = context.UserDetails_Master.FirstOrDefault(x => x.User_Id == user.User_ID); byte[] ImageFile = null; if (Image_binary != null && !string.IsNullOrEmpty(Image_binary)) { ImageFile = Convert.FromBase64String(Image_binary); } if (ImageFile != null) { string filePath = HttpContext.Current.Server.MapPath(string.Format("~/ProfileImage/" + ProfileImage + "")); File.WriteAllBytes(filePath, ImageFile); } if (IsThereUser != null) { IsThereUser.FirstName = FirstName; IsThereUser.LastName = LastName; IsThereUser.WebSite = Website; IsThereUser.Bio = Bio; IsThereUser.ProfilePhoto = ProfileImage; context.SaveChanges(); } else { var U = new UserDetails_Master { FirstName = FirstName, LastName = LastName, Bio = Bio, ProfilePhoto = ProfileImage, WebSite = Website, User_Id = user.User_ID }; context.UserDetails_Master.Add(U); context.SaveChanges(); } return(JsonConvert.SerializeObject("success")); } catch (Exception ex) { return(JsonConvert.SerializeObject("fail")); } }
public static string ShowOnHomePage(bool IsShowHomePage, int SubCategoryID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); if (IsShowHomePage == true) { var AllSubCategoory = context.SubCategory_Master.Where(x => x.IsHomePage == true).ToList(); if (AllSubCategoory.Count <= 12) { var Data = context.SubCategory_Master.Where(x => x.SubCategory_ID == SubCategoryID).SingleOrDefault(); if (Data != null) { Data.IsHomePage = IsShowHomePage; context.SaveChanges(); } var status = "success"; return(JsonConvert.SerializeObject(status)); } else { var status = "Limit for only 12 image show on home page"; return(JsonConvert.SerializeObject(status)); } } else { var Data = context.SubCategory_Master.Where(x => x.SubCategory_ID == SubCategoryID).SingleOrDefault(); if (Data != null) { Data.IsHomePage = IsShowHomePage; context.SaveChanges(); } var status = "This category remove on to the home page"; return(JsonConvert.SerializeObject(status)); } } catch (Exception ex) { throw ex.InnerException; } }
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)); }
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 EditSubCategory(int SubCategoryID, string SubCategoryName, int CategoryID, bool IsDelete, string Image, string ImageName, string Heading, string Description, string Page_Image, string Page_Image_Name) { try { PAWDStoreEntities context = new PAWDStoreEntities(); byte[] ImageFile = null; byte[] PageImage = null; if (Image != null && !string.IsNullOrEmpty(Image)) { ImageFile = Convert.FromBase64String(Image); } if (Page_Image != null && !string.IsNullOrEmpty(Page_Image)) { PageImage = Convert.FromBase64String(Page_Image); } var SubCat = context.SubCategory_Master.Where(x => x.SubCategory_ID == SubCategoryID).SingleOrDefault(); if (SubCat != null) { SubCat.SubCategory_Name = SubCategoryName; SubCat.Category_ID = CategoryID; SubCat.IsDeleted = IsDelete; SubCat.Image = null; SubCat.ImageName = ImageName; SubCat.Heading = Heading; SubCat.Description = Description; SubCat.Page_Image = null; SubCat.Page_Image_Name = Page_Image_Name; context.SaveChanges(); } if (ImageFile != null) { string filePath = HttpContext.Current.Server.MapPath(string.Format("~/SubCategoryImage/{0}", ImageName)); File.WriteAllBytes(filePath, ImageFile); } if (PageImage != null) { string filePath = HttpContext.Current.Server.MapPath(string.Format("~/SubCategoryHeaderImage/{0}", Page_Image_Name)); File.WriteAllBytes(filePath, PageImage); } var status = "success"; 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 UpdateQuantity(int Cart_ID, int Qty) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var CartItem = context.Cart_Master.FirstOrDefault(x => x.Cart_ID == Cart_ID); if (CartItem != null) { CartItem.Quantity = Qty; context.SaveChanges(); } return(JsonConvert.SerializeObject(true)); } catch (Exception ex) { return(JsonConvert.SerializeObject(false)); } }
public static string DeleteInfo(int Info_ID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Information_Master.Where(x => x.Information_ID == Info_ID).SingleOrDefault(); if (data != null) { context.Information_Master.Remove(data); context.SaveChanges(); } var status = "success"; return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string AddInformation(string Title, string Description) { try { PAWDStoreEntities context = new PAWDStoreEntities(); Information_Master obj = new Information_Master(); obj.Title = Title; obj.Description = Description; obj.CreatedDate = DateTime.Now; context.Information_Master.Add(obj); context.SaveChanges(); var status = "success"; return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string DeleteSubCategorys(int SubCategoryID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var SubCat = context.SubCategory_Master.Where(x => x.SubCategory_ID == SubCategoryID).SingleOrDefault(); if (SubCat != null) { context.SubCategory_Master.Remove(SubCat); context.SaveChanges(); } var status = "success"; return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string AddSubCategory(string SubCategoryName, int CategoryID, bool IsDelete, string Image, string ImageName, string Heading, string Description, string Page_Image, string Page_Image_Name) { try { PAWDStoreEntities context = new PAWDStoreEntities(); byte[] ImageFile = null; byte[] PageImage = null; if (Image != null && !string.IsNullOrEmpty(Image)) { ImageFile = Convert.FromBase64String(Image); } if (Page_Image != null && !string.IsNullOrEmpty(Page_Image)) { PageImage = Convert.FromBase64String(Page_Image); } var get_all_sub_cat = context.SubCategory_Master.OrderBy(x => x.Sortable).ToList(); int sort = 2; foreach (var i in get_all_sub_cat) { i.Sortable = sort++; context.SaveChanges(); } if (ImageFile != null) { //string filePath = HttpContext.Current.Server.MapPath(string.Format("~/SubCategoryImage/{0}", ImageFile)); string filePath = HttpContext.Current.Server.MapPath(string.Format("~/SubCategoryImage/" + ImageName + "")); File.WriteAllBytes(filePath, ImageFile); } if (PageImage != null) { //string filePath = HttpContext.Current.Server.MapPath(string.Format("~/SubCategoryHeaderImage/{0}", PageImage)); string filePath = HttpContext.Current.Server.MapPath(string.Format("~/SubCategoryHeaderImage/" + Page_Image_Name + "")); File.WriteAllBytes(filePath, ImageFile); } var status = context.SubCategoryInsert(SubCategoryName, CategoryID, IsDelete, null, false, ImageName, 1, Heading, Description, null, Page_Image_Name, string.Empty).FirstOrDefault(); return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string EditMenu(int MenuID, string MenuName, bool IsDelete) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var OldMenu = context.MainMenu_Master.Where(x => x.Menu_ID == MenuID).SingleOrDefault(); if (OldMenu != null) { OldMenu.Menu_Name = MenuName; OldMenu.IsDeleted = IsDelete; context.SaveChanges(); } var status = "success"; return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string UpdateInformation(int Info_ID, string Title, string Description) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Information_Master.Where(x => x.Information_ID == Info_ID).SingleOrDefault(); if (data != null) { data.Title = Title; data.Description = Description; data.CreatedDate = DateTime.Now; context.SaveChanges(); } var status = "success"; return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string EditCategory(int CategoryID, string CategoryName, int MenuID, bool IsDelete) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var OldCat = context.Category_Master.Where(x => x.Category_ID == CategoryID).SingleOrDefault(); if (OldCat != null) { OldCat.Category_Name = CategoryName; OldCat.Menu_ID = MenuID; OldCat.IsDeleted = IsDelete; context.SaveChanges(); } var status = "success"; return(JsonConvert.SerializeObject(status)); } catch (Exception ex) { throw ex.InnerException; } }
public static string UpdateProductsImg(int Image_ID, int PID, string Image_binary, string Image_name) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Product_Image_Master.Where(x => x.Procut_image_ID == Image_ID).SingleOrDefault(); if (data != null) { byte[] ImageFile = null; if (!string.IsNullOrEmpty(Image_binary) && Image_binary != null) { ImageFile = Convert.FromBase64String(Image_binary); } data.Product_ID = PID; data.Image_name = Image_name; data.Product_image = null; data.Updated_date = DateTime.Now; context.SaveChanges(); if (ImageFile != null) { string filePath = HttpContext.Current.Server.MapPath(string.Format("~/ProductImage/" + Image_name + "")); File.WriteAllBytes(filePath, ImageFile); } var status = "success"; return(JsonConvert.SerializeObject(status)); } else { var status = "No Record Found"; return(JsonConvert.SerializeObject(status)); } } catch (Exception ex) { throw ex.InnerException; } }
public static string UpdateProductsSpecGrp(int SID, int PID, string Spec_group) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Specification_Group_Master.Where(x => x.Specification_GroupID == SID).SingleOrDefault(); if (data != null) { data.Specification_Group_Name = Spec_group; context.SaveChanges(); var status = "success"; return(JsonConvert.SerializeObject(status)); } else { var status = "Record not foound"; return(JsonConvert.SerializeObject(status)); } } catch (Exception ex) { throw ex.InnerException; } }
public static string DeleteProductCK(int P_ck_id) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Product_CK_Master.Where(x => x.Product_CK_ID == P_ck_id).SingleOrDefault(); if (data != null) { context.Product_CK_Master.Remove(data); 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 delete_spec_grp(int Spec_Grp_Id) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Specification_Group_Master.Where(x => x.Specification_GroupID == Spec_Grp_Id).SingleOrDefault(); if (data != null) { context.Specification_Group_Master.Remove(data); 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 AddContact(string Name, string Mobile, string Address, string Email, string Subject, string Message) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var obj = new ContactUS_Master { Name = Name, Address = Address, Email = Email, Message = Message, Mobile = Mobile, Subject = Subject, CreatedDate = DateTime.Now }; context.ContactUS_Master.Add(obj); context.SaveChanges(); return(null); } catch (Exception ex) { throw ex.InnerException; } }
public static string DeleteEmail(int SubscriberID) { try { PAWDStoreEntities context = new PAWDStoreEntities(); var data = context.Subscribe_Master.Where(x => x.Subscribe_ID == SubscriberID).SingleOrDefault(); if (data != null) { data.IsDeleted = true; context.SaveChanges(); var status = "success"; return(JsonConvert.SerializeObject(status)); } else { var status = "not found"; return(JsonConvert.SerializeObject(status)); } } catch (Exception ex) { throw ex.InnerException; } }
public static string PlaceOrder(OrderViewModel model) { int O_ID = 0; try { PAWDStoreEntities context = new PAWDStoreEntities(); int UserID = (HttpContext.Current.Session["User"] as AdminLoginMaster).User_ID; Random generator = new Random(); string Order_NO = generator.Next(0, 999999).ToString("D6"); if (model.User_Address_ID == 0) { var address = new User_Address_Master { BName = model.BName, BAddress = model.BAddress, BCity = model.BCity, BEmail = model.BEmail, BMobile = model.BMobile, BState = model.BState, BZipcode = model.BZipcode, CreatedDate = DateTime.Now, SName = !string.IsNullOrEmpty(model.SName) ? model.SName : model.BName, SCity = !string.IsNullOrEmpty(model.SCity) ? model.SCity : model.BCity, SAddress = !string.IsNullOrEmpty(model.SAddress) ? model.SAddress : model.BAddress, SEmail = !string.IsNullOrEmpty(model.SEmail) ? model.SEmail : model.BEmail, SMobile = !string.IsNullOrEmpty(model.SMobile) ? model.SMobile : model.BMobile, SState = !string.IsNullOrEmpty(model.SState) ? model.SState : model.BState, SZipcode = !string.IsNullOrEmpty(model.SZipcode) ? model.SZipcode : model.BZipcode, User_ID = UserID }; context.User_Address_Master.Add(address); context.SaveChanges(); model.User_Address_ID = address.User_Address_ID; } var obj = new Order_Master { Order_No = Order_NO, Order_Status = "Processing", Order_Type = model.paymentMethod, CreatedDate = DateTime.Now, User_Address_ID = model.User_Address_ID, User_ID = UserID }; context.Order_Master.Add(obj); context.SaveChanges(); var CartItem = context.Cart_Master.Where(x => x.User_ID == UserID).ToList(); var Items = CartItem.Select(x => new Order_Item_Master() { Order_ID = obj.Order_ID, Quantity = x.Quantity, Price = x.Product_Master.Product_Price, Size = x.Size, Product_ID = x.Product_ID }).ToList(); context.Order_Item_Master.AddRange(Items); context.Cart_Master.RemoveRange(CartItem); context.SaveChanges(); O_ID = obj.Order_ID; SendMail.SendConfirmationMail(model, obj, Items); return(JsonConvert.SerializeObject(obj.Order_ID)); } catch (Exception ex) { return(JsonConvert.SerializeObject(O_ID)); } }