IEnumerable <Events> GetAll() { using (DAL.GerminmedContext db = new GerminmedContext()) { return(db.Event.ToList <Events>()); } }
public ActionResult AddOrEdit(Promotions promo) { try { using (GerminmedContext db = new GerminmedContext()) { if (promo.Id == 0) { db.Promotion.Add(promo); db.SaveChanges(); } else { db.Entry(promo).State = EntityState.Modified; db.SaveChanges(); } } return(Json(data: new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", model: GetAll()), message = "Submitted Successfully" }, behavior: JsonRequestBehavior.AllowGet)); //RedirectToAction("ViewAll"); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
IEnumerable <Clients> GetAll() { using (GerminmedContext db = new GerminmedContext()) { return(db.Client.ToList <Clients>()); } }
public ActionResult Delete(int Id) { try { using (GerminmedContext db = new GerminmedContext()) { Products prod = db.Product.Where(x => x.Id == Id).FirstOrDefault <Products>(); string fullPath = Request.MapPath(prod.ImagePath); if (prod.ImagePath != "~/AppFiles/Images/Default.png") { if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); } } if (prod.Catalogue != null) { string fullPathCatalog = Request.MapPath(prod.Catalogue); if (System.IO.File.Exists(fullPathCatalog)) { System.IO.File.Delete(fullPathCatalog); } } db.Product.Remove(prod); db.SaveChanges(); } return(Json(data: new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", model: GetAllProducts()), message = "Deleted Successfully" }, behavior: JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Register(Users userModel) { using (GerminmedContext db = new GerminmedContext()) { userModel.IsAdmin = false; userModel.ActivationCode = Guid.NewGuid().ToString(); userModel.IsEmailVerified = false; userModel.IsActive = false; if (db.User.Any(x => x.UserName == userModel.UserName)) { ViewBag.DuplicateMessage = "Username already exist."; return(View("Register", userModel)); } db.User.Add(userModel); db.SaveChanges(); SendVerificationLinkEmail(userModel.Email, userModel.ActivationCode.ToString(), "VerifyAccount"); ViewBag.SuccessMessage = "Germin MED Welcome you to Our online shopping. Email verification link " + " has been sent to your email :" + userModel.Email; } ModelState.Clear(); // ViewBag.SuccessMessage = "Registration Successful."; return(View("Success")); }
IEnumerable <Brands> GeAllBrandsList() { using (GerminmedContext db = new GerminmedContext()) { return(db.Brand.ToList <Brands>()); } }
IEnumerable <Branches> GetAll() { using (GerminmedContext db = new GerminmedContext()) { return(db.Branch.ToList <Branches>()); } }
IEnumerable <Category> GetAllCat() { using (GerminmedContext db = new GerminmedContext()) { return(db.Category.ToList <Category>()); } }
IEnumerable <NewsLetter> GetAll() { using (GerminmedContext db = new GerminmedContext()) { return(db.NewsLetters.ToList <NewsLetter>()); } }
public ActionResult ResetPassword(ResetPasswordModel model) { var message = ""; if (ModelState.IsValid) { using (GerminmedContext db = new GerminmedContext()) { var user = db.User.Where(a => a.ResetPasswordCode == model.ResetCode).FirstOrDefault(); if (user != null) { user.Password = model.NewPassword; user.ResetPasswordCode = ""; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); message = "New password updated successfully"; } } } else { message = "Something invalid"; } ViewBag.Message = message; return(View(model)); }
IEnumerable <Category> GetAllCatByRootCat(int?id) { List <Category> catList = new List <Category>(); List <Category> catListcopy = new List <Category>(); using (GerminmedContext db = new GerminmedContext()) { if (id != null) { catList = db.Category.SqlQuery(Category.sqlQuery1).Where(x => x.ParentId == id).ToList <Category>(); //foreach (var item in catList) //{ // catListcopy.AddRange(db.Category.SqlQuery(Category.sqlQuery1).Where(x => x.ParentId == item.Id).ToList<Category>()); //} catList.AddRange(catListcopy); return(catList); } else { return(null); } } }
public ActionResult ForgotPassword(string EmailID) { //Verify Email ID //Generate Reset password link //Send Email string message = ""; bool status = false; using (GerminmedContext db = new GerminmedContext()) { var account = db.User.Where(a => a.Email == EmailID).FirstOrDefault(); if (account != null) { //Send email for reset password string resetCode = Guid.NewGuid().ToString(); SendVerificationLinkEmail(account.Email, resetCode, "ResetPassword"); account.ResetPasswordCode = resetCode; //This line I have added here to avoid confirm password not match issue , as we had added a confirm password property //in our model class in part 1 db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); message = "Reset password link has been sent to your email id."; } else { message = "Account not found"; } } ViewBag.Message = message; return(View()); }
public ActionResult ResetPassword(string id) { //Verify the reset password link //Find account associated with this link //redirect to reset password page if (string.IsNullOrWhiteSpace(id)) { return(HttpNotFound()); } using (GerminmedContext db = new GerminmedContext()) { var user = db.User.Where(a => a.ResetPasswordCode == id).FirstOrDefault(); if (user != null) { ResetPasswordModel model = new ResetPasswordModel(); model.ResetCode = id; return(View(model)); } else { return(HttpNotFound()); } } }
IEnumerable <Banner> GetAll() { using (GerminmedContext db = new GerminmedContext()) { return(db.Banners.ToList <Banner>()); } }
public ActionResult DeleteImage(int Id, int productid) { try { using (GerminmedContext db = new GerminmedContext()) { ProductImage img = db.ProductImage.Where(x => x.Id == Id).FirstOrDefault <ProductImage>(); string fullPath = Request.MapPath(img.ImageUrl); if (img.ImageUrl != "~/AppFiles/Images/Default.png") { if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); } } db.ProductImage.Remove(img); db.SaveChanges(); } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewImagesByProduct", GetAllImagesByProduct(productid)), message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
IEnumerable <ProductImage> GetAllImagesByProduct(int id) { using (GerminmedContext db = new GerminmedContext()) { return(db.ProductImage.Where(x => x.ProductId == id).ToList <ProductImage>()); } }
IEnumerable <Users> GetAllRegisteredUser() { using (GerminmedContext db = new GerminmedContext()) { return(db.User.Where(x => x.UserTypeId == 1).ToList <Users>()); } }
public ActionResult OrederConfirm(UserViewModel uvm) { if (Session["cart"] != null && Session["UserId"] != null) { string firstName = uvm.FirstName; string userName = Session["userName"].ToString(); string phone = uvm.Phone; string cartTableForEmail = ""; string ToEmail = uvm.Email; List <Cart> cart = (List <Cart>)Session["cart"]; List <Order> orderList = new List <Order>(); foreach (var item in cart) { Order orderModel = new Order(); orderModel.ProductId = item.Product.Id; orderModel.UserId = (int)Session["UserId"]; orderModel.Qty = item.Quantity; orderList.Add(orderModel); cartTableForEmail = cartTableForEmail + "<tr><td>" + item.Product.ProductName + "</td><td>" + item.Quantity + "</td><td>" + item.Product.Price + "</td></tr>"; } using (GerminmedContext db = new GerminmedContext()) { db.Orders.AddRange(orderList); db.SaveChanges(); } SendEmail(firstName, userName, phone, cartTableForEmail); SendEmail(firstName, userName, phone, cartTableForEmail, ToEmail); } Session["cart"] = null; return(View()); }
public ActionResult Index1() { using (GerminmedContext db = new GerminmedContext()) { return(View(db.Banners.ToList <Banner>())); } }
public ActionResult ChangePassword(UserViewModel usr) { try { using (GerminmedContext db = new GerminmedContext()) { var currentItem = db.User.Where(b => b.Id == usr.Id).FirstOrDefault <Users>(); if (currentItem.Password == usr.OldPassword) { currentItem.Password = usr.Password; // currentItem.OldPassword = usr.OldPassword; currentItem.ConfirmPassword = usr.ConfirmPassword; db.Entry(currentItem).State = EntityState.Modified; db.SaveChanges(); return(Json(data: new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ChangePassword", model: usr), message = "Password changed Successfully" }, behavior: JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = "Wrong Old password" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ProductSub(int Id = 0, string Name = "") { if (Id > 0) { ViewBag.CategoryId = Id; } else if (string.IsNullOrEmpty(Name) == false) { Id = GetCategoryId(Name); Url.RequestContext.RouteData.Values["id"] = Id; } using (GerminmedContext db = new GerminmedContext()) { ViewBag.CategoryInnerBanner = db.Category.Where(x => x.Id == Id).FirstOrDefault(); } IEnumerable <Category> cat = GetAllCatByParent(Id); return(View(cat)); //if (cat.Count() != 0) // return View(cat); //else //{ // return RedirectToAction("Products", "Product",new {Id=Id }); //} }
IEnumerable <Promotions> GetAll() { using (GerminmedContext db = new GerminmedContext()) { return(db.Promotion.ToList <Promotions>()); } }
public ActionResult Delete(int Id) { try { using (GerminmedContext db = new GerminmedContext()) { NewsLetter news = db.NewsLetters.Where(x => x.Id == Id).FirstOrDefault <NewsLetter>(); string fullPath = Request.MapPath(news.ImageUrl); if (news.ImageUrl != "~/AppFiles/Images/Default.png") { if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); } } db.NewsLetters.Remove(news); db.SaveChanges(); } return(Json(data: new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", model: GetAll()), message = "Deleted Successfully" }, behavior: JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Approve(int Id) { try { using (GerminmedContext db = new GerminmedContext()) { db.Configuration.ValidateOnSaveEnabled = false; Users usr = db.User.Where(x => x.Id == Id).FirstOrDefault <Users>(); if (usr.IsActive == false) { usr.IsActive = true; } // //entities.Entry(user).Property(u => u.LastActivity).IsModified = true; //entities.SaveChanges(); db.User.Attach(usr); db.Entry(usr).Property(x => x.IsActive).IsModified = true; db.SaveChanges(); SendVerificationLinkEmail(usr.Email, "", "Approve"); } return(Json(data: new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAllRegisteredUser", model: GetAllRegisteredUser()), message = "Updated Successfully" }, behavior: JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index(string name, string email, string phone, string message) { string fromEmail, toEmail, password, server; int port; bool isSslEnable; MailSettings mailmodel = new MailSettings(); using (GerminmedContext db = new GerminmedContext()) { mailmodel = db.MailSetting.FirstOrDefault(); } if (mailmodel != null) { fromEmail = mailmodel.Username; toEmail = mailmodel.Contact; password = mailmodel.Password; server = mailmodel.Server; port = mailmodel.Port; isSslEnable = mailmodel.IsSSLEnabled; } else { fromEmail = ConfigurationManager.AppSettings["EmailFromAddress"]; toEmail = ConfigurationManager.AppSettings["MailAuthUser"]; password = ConfigurationManager.AppSettings["MailAuthPass"]; server = ConfigurationManager.AppSettings["MailServer"]; port = int.Parse(ConfigurationManager.AppSettings["Port"]); isSslEnable = Convert.ToBoolean(ConfigurationManager.AppSettings["EnableSSL"]); } try { using (MailMessage mm = new MailMessage(fromEmail, toEmail)) { mm.Subject = "GerminMed Contact Customer Information "; mm.Body = CreateBody(name, email, phone, message); mm.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = server; smtp.EnableSsl = isSslEnable; NetworkCredential NetworkCred = new NetworkCredential(fromEmail, password); smtp.UseDefaultCredentials = isSslEnable; smtp.Credentials = NetworkCred; smtp.Port = port; smtp.Send(mm); ViewBag.Succcess = "Contact Mail Send, Thank you for your Time."; } return(View()); } catch (Exception ex) { ViewBag.Error = "Error : " + ex.Message; return(View()); } }
// GET: AboutUs public ActionResult Index() { using (GerminmedContext db = new GerminmedContext()) { InnerBanner bnr = new InnerBanner(); bnr = db.InnerBanners.Where(x => x.PageName == "AboutUs").FirstOrDefault(); return(View(bnr)); } }
IEnumerable <Events> GetAll() { using (GerminmedContext db = new GerminmedContext()) { InnerBanner bnr = new InnerBanner(); ViewBag.InnerBanner = db.InnerBanners.Where(x => x.PageName == "Events").FirstOrDefault(); return(db.Event.ToList <Events>()); } }
IEnumerable <ProductViewModel> GetAllProductsByBrands(int?brandId, int categoryId) { List <ProductViewModel> ProductVMlist = new List <ProductViewModel>(); allSubCats = new List <int>(); using (GerminmedContext db = new GerminmedContext()) { if (brandId > 0) { GetChilds(categoryId); } var productlist = (from prod1 in db.Product join img in db.ProductImage on prod1.Id equals img.ProductId join brnd in db.Brand on prod1.BrandId equals brnd.Id orderby img.DisplayOrder ascending select new { prod1.Id, prod1.ProductName, prod1.Description, prod1.IsFeatured, prod1.IsOffer, prod1.OfferPercentage, prod1.ShowInHomePage, img.ImageUrl, brnd.Title, prod1.BrandId, prod1.CategoryId }).ToList(); if (brandId > 0) { productlist = productlist.Where(p => (allSubCats.Contains(p.CategoryId) || p.CategoryId == categoryId) && p.BrandId == brandId).ToList(); } else if (categoryId > 0) { productlist = productlist.Where(p => p.CategoryId == categoryId).ToList(); } foreach (var item in productlist) { ProductViewModel objHome = new ProductViewModel();// ViewModel objHome.Id = item.Id; objHome.ProductName = item.ProductName; objHome.Description = item.Description; objHome.IsFeatured = item.IsFeatured; objHome.IsOffer = item.IsOffer; objHome.OfferPercentage = item.OfferPercentage; objHome.ShowInHomePage = item.ShowInHomePage; objHome.ImageUrl = item.ImageUrl; objHome.BrandTitle = item.Title; ProductVMlist.Add(objHome); } return(ProductVMlist); } }
IEnumerable <Brands> GetAll() { using (GerminmedContext db = new GerminmedContext()) { InnerBanner bnr = new InnerBanner(); ViewBag.InnerBanner = db.InnerBanners.Where(x => x.PageName == "Brand").FirstOrDefault(); return(db.Brand.Where(x => x.ShowInBrandPage == true).ToList <Brands>()); } }
// GET: Contact public ActionResult Index() { using (GerminmedContext db = new GerminmedContext()) { InnerBanner bnr = new InnerBanner(); ViewBag.InnerBanner = db.InnerBanners.Where(x => x.PageName == "ContactUs").FirstOrDefault(); } return(View("Index")); }