public ActionResult Source_edit(long id, ETSource updateSource) { TempData["messagealert"] = string.Empty; if (ModelState.IsValid) { Sourcee = new ETSource(); Sourcee = repSource.GetSource(id); if (repSource.SourceIsExist(updateSource.SourceName, id)) { ViewBag.messagealert = "Source already exist"; ViewBag.SourceTypes = repSource.getDataValues("SourceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"])); return(View(Sourcee)); } else { Sourcee.SourceName = updateSource.SourceName; Sourcee.SourceType = updateSource.SourceType; Sourcee.IsActive = updateSource.IsActive; Sourcee.ModifiedBy = Convert.ToInt64(Session["UserID"]); Sourcee.ModifiedDate = DateTime.Now; dbEntities.Entry(Sourcee).State = EntityState.Modified; dbEntities.SaveChanges(); if (Sourcee.SourceID != 0) { TempData["messagealert"] = Status.Update; } } return(RedirectToAction("Index", "Sources")); } return(View()); }
public ActionResult Source_add(ETSource Source) { TempData["messagealert"] = string.Empty; ViewBag.messagealert = string.Empty; if (ModelState.IsValid) { if (Source != null) { if (repSource.SourceIsExist(Source.SourceName, 0)) { ViewBag.messagealert = "Source already exist"; ViewBag.SourceTypes = repSource.getDataValues("SourceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"])); return(View(Source)); } else { Source.UserID = Convert.ToInt64(Session["UserID"]); Source.CreatedBy = Convert.ToInt64(Session["UserID"]); Source.CreatedDate = DateTime.Now; Source.ModifiedBy = Convert.ToInt64(Session["UserID"]); Source.ModifiedDate = DateTime.Now; dbEntities.ETSources.Add(Source); dbEntities.SaveChanges(); if (Source.SourceID != 0) { TempData["messagealert"] = Status.Save; } } } return(RedirectToAction("Index", "Sources")); } return(View()); }
public bool SourceUpdateStatus(bool status, long Sourceid) { Sourcee = new ETSource(); Sourcee = repSource.GetSource(Sourceid); if (Sourcee != null) { if (status) { Sourcee.IsActive = false; Sourcee.ModifiedBy = Convert.ToInt64(Session["UserID"]); Sourcee.ModifiedDate = DateTime.Now; } else { Sourcee.ModifiedBy = Convert.ToInt64(Session["UserID"]); Sourcee.ModifiedDate = DateTime.Now; Sourcee.IsActive = true; } dbEntities.Entry(Sourcee).State = EntityState.Modified; dbEntities.SaveChanges(); return(true); } return(false); }
public bool SourceDelete(long id) { if (!dbEntities.ETUsers.Where(x => x.UserID == 1).Any()) // Need to change { TempData["messagealert"] = Status.Delete; Sourcee = new ETSource(); Sourcee = dbEntities.ETSources.Where(x => x.SourceID == id).SingleOrDefault(); if (Sourcee != null) { dbEntities.ETSources.Remove(Sourcee); dbEntities.SaveChanges(); return(true); } } return(false); //if (!dbEntities.TBL_ADMIN_USER.Where(x => x.ROLE_ID == id).Any()) //{ // TempData["messagealert"] = Status.Delete; // role = new TBL_ROLE(); // role = dbEntities.TBL_ROLE.Where(x => x.ROLE_ID == id && x.ROLE_NAME != "superadmin").SingleOrDefault(); // if (role != null) // { // dbEntities.TBL_ROLE.Remove(role); // dbEntities.SaveChanges(); // return true; // } //} //return false; }
public ActionResult Category_view(long Id) { Category = repCategory.GetCategory(Id); ETSource SourceNames = dbEntities.ETSources.Where(x => x.SourceID == Category.SourceID).Single(); Category.SourceName = SourceNames.SourceName; return(View(Category)); }
public ActionResult Source_edit(long Id) { ViewBag.messagealert = string.Empty; Sourcee = new ETSource(); Sourcee = repSource.GetSource(Id); ViewBag.SourceTypes = repSource.getDataValues("SourceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"])); return(View(Sourcee)); }
// GET: Category #region Category List public ActionResult Index() { ViewBag.UserPermission = Session["UserLevel"].ToString().ToUpper(); ViewBag.messagealert = string.Empty; string messagealert = Convert.ToString(TempData["messagealert"]); if (!string.IsNullOrEmpty(messagealert)) { ViewBag.messagealert = messagealert; } Categories = new List <ETCategory>(); Categories = repCategory.GetAllCategory(Convert.ToInt64(Session["UserID"]), Session["UserLevel"].ToString()); foreach (var item in Categories) { //item.SourceName = dbEntities.ETSources.Where(x => x.SourceID == item.SourceID).Select(m => m.SourceName).ToString(); ETSource SourceNames = dbEntities.ETSources.Where(x => x.SourceID == item.SourceID).Single(); item.SourceName = SourceNames.SourceName; } return(View(Categories)); }
public ActionResult Source_view(long Id) { Sourcee = repSource.GetSource(Id); return(View(Sourcee)); }