public ActionResult AddType(int?ID) { if (Session["ID"] != null) { int id = Convert.ToInt32(Session["ID"]); int RoleMember = Convert.ToInt32(Enums.UserRoleId.Member); User user = db.Users.Where(x => x.ID == id).FirstOrDefault(); if (user.RoleID != RoleMember) { ManageTypeViewModel Model = new ManageTypeViewModel(); if (ID != null) { NoteType countryData = db.NoteTypes.Where(x => x.ID == ID).FirstOrDefault(); Model.Type = countryData.Name; Model.Description = countryData.Description; return(View(Model)); } return(View()); } else { return(RedirectToAction("Index", "Home")); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult AddType(ManageTypeViewModel model) { if (ModelState.IsValid) { NoteType countryData = db.NoteTypes.Where(x => x.Name.Equals(model.Type)).FirstOrDefault(); int AddedBy = Convert.ToInt32(Session["ID"]); if (countryData != null) { countryData.Name = model.Type; countryData.Description = model.Description; countryData.ModifiedDate = DateTime.Now; countryData.ModifiedBy = AddedBy; countryData.IsActive = true; db.SaveChanges(); } else { NoteType NewEntry = new NoteType() { Name = model.Type, Description = model.Description, CreatedBy = AddedBy, CreatedDate = DateTime.Now, IsActive = true, }; db.NoteTypes.Add(NewEntry); db.SaveChanges(); } return(RedirectToAction("ManageType", "Type")); } else { return(View(model)); } }
public ActionResult EditType(int id) { ViewBag.Settings = "active"; ViewBag.managetype = "active"; var user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); var detail = db.NoteTypes.FirstOrDefault(x => x.ID == id); ManageTypeViewModel typeModel = new ManageTypeViewModel(); typeModel.ID = detail.ID; typeModel.typeName = detail.Name; typeModel.description = detail.Description; return(View(typeModel)); }
public ActionResult EditType(ManageTypeViewModel typModel) { var user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); var model = db.NoteTypes.Where(x => x.ID == typModel.ID).FirstOrDefault(); if (ModelState.IsValid) { model.Name = typModel.typeName; model.Description = typModel.description; model.ModifiedDate = DateTime.Now; model.ModifiedBy = user.ID; model.IsActive = true; db.SaveChanges(); return(RedirectToAction("ManageType")); } return(View()); }
public ActionResult ManageType() { if (Session["ID"] != null) { int id = Convert.ToInt32(Session["ID"]); int RoleMember = Convert.ToInt32(Enums.UserRoleId.Member); User user = db.Users.Where(x => x.ID == id).FirstOrDefault(); if (user.RoleID != RoleMember) { ManageTypeViewModel Model = new ManageTypeViewModel(); Model.getNoteTypeData_Results = db.GetNoteTypeData().ToList(); return(View(Model)); } else { return(RedirectToAction("Index", "Home")); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult AddType(ManageTypeViewModel type) { var user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); if (ModelState.IsValid) { //add data to notetype table NoteTypes Types = new NoteTypes(); Types.Name = type.typeName; Types.Description = type.description; Types.CreatedDate = DateTime.Now; Types.CreatedBy = user.ID; Types.IsActive = true; db.NoteTypes.Add(Types); db.SaveChanges(); return(RedirectToAction("ManageType")); } return(View()); }
public ActionResult ManageType(string SortOrder, string Type_search, int Type_page = 1) { ViewBag.Settings = "active"; ViewBag.managetype = "active"; //sortorder ViewBag.TypeSortParm = SortOrder == "Type" ? "Type_desc" : "Type"; ViewBag.DescriptionSortParm = SortOrder == "Description" ? "Description_desc" : "Description"; ViewBag.AddedBySortParm = SortOrder == "AddedBy" ? "AddedBy_desc" : "AddedBy"; ViewBag.ActiveSortParm = SortOrder == "Active" ? "Active_desc" : "Active"; ViewBag.DateSortParm = SortOrder == "Date" ? "Date_desc" : "Date"; ManageTypeViewModel Types = new ManageTypeViewModel(); //Query string var type = from typ in db.NoteTypes join ur in db.Users on typ.CreatedBy equals ur.ID select new ManageType { Type = typ, users = ur }; //searching if (Type_search != null) { type = type.Where(x => x.Type.Name.Contains(Type_search) || x.Type.Description.Contains(Type_search) || x.Type.CreatedDate.ToString().Contains(Type_search) || x.users.FirstName.Contains(Type_search) || x.users.LastName.Contains(Type_search)); } //sorting switch (SortOrder) { case "Type_desc": type = type.OrderByDescending(s => s.Type.Name); break; case "Type": type = type.OrderBy(s => s.Type.Name); break; case "Description_desc": type = type.OrderByDescending(s => s.Type.Description); break; case "Description": type = type.OrderBy(s => s.Type.Description); break; case "AddedBy_desc": type = type.OrderByDescending(s => s.users.FirstName); break; case "AddedBy": type = type.OrderBy(s => s.users.FirstName); break; case "Active_desc": type = type.OrderByDescending(s => s.Type.IsActive); break; case "Active": type = type.OrderBy(s => s.Type.IsActive); break; case "Date_desc": type = type.OrderByDescending(s => s.Type.CreatedDate); break; case "Date": type = type.OrderBy(s => s.Type.CreatedDate); break; default: type = type.OrderByDescending(s => s.Type.CreatedDate); break; } //assign data to model Types.NoteTypes = type; //pagination var pager = new Pager(type.Count(), Type_page, 10); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.totalPage = type.Count(); Types.NoteTypes = type.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize); return(View(Types)); }