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));
}
