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 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));
}
}
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 AddOrEdit(Products prod)
{
try
{
if (prod.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(prod.ImageUpload.FileName);
string extension = Path.GetExtension(prod.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
prod.ImagePath = "~/AppFiles/Images/" + fileName;
prod.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
if (prod.ImageUpload1 != null)
{
string fileName = Path.GetFileNameWithoutExtension(prod.ImageUpload1.FileName);
string extension = Path.GetExtension(prod.ImageUpload1.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
prod.InnerBannerImage = "/AppFiles/Images/" + fileName;
prod.ImageUpload1.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
if (prod.CatalogueUplaoder != null)
{
string fileName = Path.GetFileNameWithoutExtension(prod.CatalogueUplaoder.FileName);
string extension = Path.GetExtension(prod.CatalogueUplaoder.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
prod.Catalogue = "/AppFiles/docs/" + fileName;
prod.CatalogueUplaoder.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/docs/"), fileName));
}
using (GerminmedContext db = new GerminmedContext())
{
if (prod.Id == 0)
{
prod.Description = prod.Description == null ? " " : prod.Description;
db.Product.Add(prod);
db.SaveChanges();
}
else
{
prod.Description = prod.Description == null ? " " : prod.Description;
db.Entry(prod).State = EntityState.Modified;
db.SaveChanges();
}
}
return(Json(data: new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", model: GetAllProducts()), message = "Submitted Successfully" }, behavior: JsonRequestBehavior.AllowGet));
//RedirectToAction("ViewAll");
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(NewsLetter news)
{
try
{
HttpPostedFileBase attach = null;
string fileName = "";
using (GerminmedContext db = new GerminmedContext())
{
news.UserList = db.User.Where(x => x.UserTypeId == 1).ToList();
if (news.Id == 0)
{
if (news.ImageUpload != null)
{
attach = news.ImageUpload;
fileName = Path.GetFileNameWithoutExtension(news.ImageUpload.FileName);
string extension = Path.GetExtension(news.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
news.ImageUrl = "~/AppFiles/Images/" + fileName;
news.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
sendEmail(news.Subject, news.Message, news.Recipients, attach, fileName);
db.NewsLetters.Add(news);
db.SaveChanges();
}
else
{
var currentItem = db.NewsLetters.Where(b => b.Id == news.Id).FirstOrDefault <NewsLetter>();
currentItem.Message = news.Message;
currentItem.Message = news.Message;
currentItem.Recipients = news.Recipients;
sendEmail(news.Subject, news.Message, news.Recipients, attach, fileName);
db.Entry(currentItem).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 (DataException ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddImage(ProductImage img)
{
try
{
if (Session["ProductId"] != null)
{
img.ProductId = (int)Session["ProductId"];
}
if (img.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(img.ImageUpload.FileName);
string extension = Path.GetExtension(img.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
img.ImageUrl = "~/AppFiles/Images/" + fileName;
//img.ProductId = img.txtProductId;
img.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
// ResizeSettings resizeSetting = new ResizeSettings(560,305,FitMode.Max,"png");
//{
// Width = 560,
// Height = 305,
// Format = "png"
//};
// ImageBuilder.Current.Build(Path.Combine(Server.MapPath("~/AppFiles/Images/"),fileName), Path.Combine(Server.MapPath("~/AppFiles/Images/"),fileName), resizeSetting);
}
using (GerminmedContext db = new GerminmedContext())
{
if (img.Id == 0)
{
db.ProductImage.Add(img);
db.SaveChanges();
}
else
{
var currentItem = db.ProductImage.Where(b => b.Id == img.Id).FirstOrDefault <ProductImage>();
currentItem.DisplayOrder = img.DisplayOrder;
db.Entry(currentItem).State = EntityState.Modified;
db.SaveChanges();
}
}
return(Json(data: new { id = img.ProductId, success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewImagesByProduct", model: GetAllImagesByProduct(img.ProductId)), message = "Submitted Successfully" }, behavior: JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Users usr)
{
try
{
using (GerminmedContext db = new GerminmedContext())
{
if (usr.Id == 0)
{
if (db.User.Any(x => x.UserName == usr.UserName))
{
return(Json(new { success = false, message = "Username already exist." }, JsonRequestBehavior.AllowGet));
}
db.User.Add(usr);
db.SaveChanges();
}
else
{
var currentItem = db.User.Where(b => b.Id == usr.Id).FirstOrDefault <Users>();
currentItem.UserName = usr.UserName;
currentItem.FirstName = usr.FirstName;
currentItem.Email = usr.Email;
currentItem.IsAdmin = usr.IsAdmin;
currentItem.ConfirmPassword = currentItem.Password;
if (db.User.Any(x => x.UserName == currentItem.UserName && x.Id != currentItem.Id))
{
return(Json(new { success = false, message = "Username already exist." }, JsonRequestBehavior.AllowGet));
}
db.Entry(currentItem).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 (DataException ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Branches brnch)
{
try
{
using (GerminmedContext db = new GerminmedContext())
{
if (brnch.Id == 0)
{
if (brnch.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(brnch.ImageUpload.FileName);
string extension = Path.GetExtension(brnch.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
brnch.ImageUrl = "~/AppFiles/Images/" + fileName;
brnch.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
db.Branch.Add(brnch);
db.SaveChanges();
}
else
{
var currentItem = db.Branch.Where(b => b.Id == brnch.Id).FirstOrDefault <Branches>();
currentItem.Phone = brnch.Phone;
currentItem.Title = brnch.Title;
currentItem.Fax = brnch.Fax;
currentItem.Email = brnch.Email;
currentItem.Location = brnch.Location;
currentItem.PoBox = brnch.PoBox;
db.Entry(currentItem).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 (DataException ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Clients clns)
{
try
{
using (GerminmedContext db = new GerminmedContext())
{
if (clns.Id == 0)
{
if (clns.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(clns.ImageUpload.FileName);
string extension = Path.GetExtension(clns.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
clns.ImageUrl = "~/AppFiles/Images/" + fileName;
clns.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
db.Client.Add(clns);
db.SaveChanges();
}
else
{
var currentItem = db.Client.Where(b => b.Id == clns.Id).FirstOrDefault <Clients>();
currentItem.Url = clns.Url;
currentItem.DisplayOrder = clns.DisplayOrder;
db.Entry(currentItem).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));
}
}
public ActionResult MailSettings(MailSettings mail)
{
try
{
using (GerminmedContext db = new GerminmedContext())
{
if (mail.Id == 0)
{
db.MailSetting.Add(mail);
db.SaveChanges();
}
else
{
db.Entry(mail).State = EntityState.Modified;
db.SaveChanges();
}
return(Json(data: new { success = true, html = GlobalClass.RenderRazorViewToString(this, "MailSettings", model: mail), message = "Mail Settings submitted Successfully" }, behavior: JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Category catg, FormCollection fobj)
{
try
{
using (GerminmedContext db = new GerminmedContext())
{
if (catg.InnerBannerImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(catg.InnerBannerImageUpload.FileName);
string extension = Path.GetExtension(catg.InnerBannerImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
catg.InnerBannerImageUrl = "~/AppFiles/Images/" + fileName;
catg.InnerBannerImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
else
{
catg.InnerBannerImageUrl = null;
}
if (catg.Id == 0)
{
if (catg.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(catg.ImageUpload.FileName);
string extension = Path.GetExtension(catg.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
catg.ImageUrl = "~/AppFiles/Images/" + fileName;
catg.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
else
{
catg.ImageUrl = null;
}
db.Category.Add(catg);
db.SaveChanges();
}
else
{
//if (catg.ImageUpload != null)
//{
// string fileName = Path.GetFileNameWithoutExtension(catg.ImageUpload.FileName);
// string extension = Path.GetExtension(catg.ImageUpload.FileName);
// fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
// catg.ImageUrl = "~/AppFiles/Images/" + fileName;
// catg.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
//}
//else
//{
// catg.ImageUrl = null;
//}
var currentItem = db.Category.Where(b => b.Id == catg.Id).FirstOrDefault <Category>();
currentItem.Title = catg.Title;
currentItem.ParentId = catg.ParentId;
currentItem.Description = catg.Description;
currentItem.InnerBannerImageUrl = catg.InnerBannerImageUrl;
// currentItem.ImageUrl = catg.ImageUrl;
db.Entry(currentItem).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));
}
}