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));
}
}
