public bool UpdateDashboardGivenColumnn(DashboardGivenColumn_Model GivenColumn)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.DashboardGivenColumns.Where(givenColumn => givenColumn.DashboardGivenColumnId == GivenColumn.DashboardGivenColumnId).FirstOrDefault();
data.DashboardTableId = GivenColumn.DashboardTableId;
data.ColumnName = GivenColumn.ColumnName;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public ActionResult ColumnDelete(DashboardGivenColumn_Model dashboardGivenColumn)
{
var Column_Name = dashboardGivenColumn.ColumnName;
try
{
if (DashboardGivenColumn_Interface.DeleteDashboardGivenColumn(dashboardGivenColumn.DashboardGivenColumnId))
{
return(Json(Column_Name + " type has been deleted successfully"));
}
else
{
return(Json("Error"));
}
}
catch (Exception e)
{
return(Json("Error" + e.ToString()));
}
}
public ActionResult ColumnAdd(DashboardGivenColumn_Model dashboardGivenColumn)
{
if (string.IsNullOrEmpty(dashboardGivenColumn.ColumnName) || dashboardGivenColumn.DashboardTableId == 0)
{
ViewBag.ColumnAddError = "Error";
return(View("Settings"));
}
else
{
if (DashboardGivenColumn_Interface.SaveDashboardGivenColumn(dashboardGivenColumn))
{
Session["Success"] = dashboardGivenColumn.ColumnName + " added successfully!!";
}
else
{
Session["Error"] = dashboardGivenColumn.ColumnName + " couldn't be added please retry!!";
}
return(RedirectToAction("Settings"));
}
}
public ActionResult ColumnUpdate(DashboardGivenColumn_Model dashboardGivenColumn)
{
if (string.IsNullOrEmpty(dashboardGivenColumn.ColumnName) || dashboardGivenColumn.DashboardTableId == 0)
{
ViewBag.UpdateColumnError = "Error";
ViewBag.UpdateColumnData = dashboardGivenColumn.DashboardGivenColumnId;
return(View("Settings"));
}
else
{
if (DashboardGivenColumn_Interface.UpdateDashboardGivenColumnn(dashboardGivenColumn))
{
Session["Success"] = dashboardGivenColumn.ColumnName + " updated successfully!!";
return(RedirectToAction("Settings"));
}
else
{
Session["Error"] = dashboardGivenColumn.ColumnName + " couldn't be updated please retry!!";
return(View("Settings"));
}
}
}
public bool SaveDashboardGivenColumn(DashboardGivenColumn_Model GivenColumn)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = new DashboardGivenColumn()
{
DashboardGivenColumnId = GetNewDashboardGivenColumnID(),
DashboardTableId = GivenColumn.DashboardTableId,
ColumnName = GivenColumn.ColumnName,
DateCreated = DateTime.Now
};
_dbContext.DashboardGivenColumns.Add(data);
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
}
