public ActionResult DeleteConfirmed(int id) { ReportColumnValue reportColumnValue = db.ReportColumnValues.Find(id); db.ReportColumnValues.Remove(reportColumnValue); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: Business/ReportColumnValues/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ReportColumnValue reportColumnValue = db.ReportColumnValues.Find(id); if (reportColumnValue == null) { return(HttpNotFound()); } return(View(reportColumnValue)); }
public ActionResult Edit([Bind(Include = "Id,ColumnId,ReportId,Value,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy")] ReportColumnValue reportColumnValue) { if (ModelState.IsValid) { reportColumnValue.UpdatedBy = CurrentUserId; reportColumnValue.UpdatedOn = System.DateTime.UtcNow; db.Entry(reportColumnValue).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CreatedBy = new SelectList(db.Users, "Id", "FirstName", reportColumnValue.CreatedBy); ViewBag.UpdatedBy = new SelectList(db.Users, "Id", "FirstName", reportColumnValue.UpdatedBy); ViewBag.ReportId = new SelectList(db.ReportMasters, "Id", "Id", reportColumnValue.ReportId); ViewBag.ColumnId = new SelectList(db.ReportColumns, "Id", "ColumnName", reportColumnValue.ColumnId); return(View(reportColumnValue)); }
public ActionResult Create([Bind(Include = "Id,ColumnId,ReportId,Value,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy")] ReportColumnValue reportColumnValue) { if (ModelState.IsValid) { reportColumnValue.CreatedBy = CurrentUserId; reportColumnValue.CreatedOn = System.DateTime.UtcNow; db.ReportColumnValues.Add(reportColumnValue); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CreatedBy = new SelectList(db.Users, "Id", "FirstName", reportColumnValue.CreatedBy); ViewBag.UpdatedBy = new SelectList(db.Users, "Id", "FirstName", reportColumnValue.UpdatedBy); ViewBag.ReportId = new SelectList(db.ReportMasters.Where(a => a.BusinessId == CurrentBusinessId), "Id", "Id", reportColumnValue.ReportId); ViewBag.ColumnId = new SelectList(db.ReportColumns.Where(a => a.BusinessId == CurrentBusinessId), "Id", "ColumnName", reportColumnValue.ColumnId); return(View(reportColumnValue)); }
// GET: Business/ReportColumnValues/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ReportColumnValue reportColumnValue = db.ReportColumnValues.Find(id); if (reportColumnValue == null) { return(HttpNotFound()); } ViewBag.CreatedBy = new SelectList(db.Users, "Id", "FirstName", reportColumnValue.CreatedBy); ViewBag.UpdatedBy = new SelectList(db.Users, "Id", "FirstName", reportColumnValue.UpdatedBy); ViewBag.ReportId = new SelectList(db.ReportMasters, "Id", "Id", reportColumnValue.ReportId); ViewBag.ColumnId = new SelectList(db.ReportColumns, "Id", "ColumnName", reportColumnValue.ColumnId); return(View(reportColumnValue)); }