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