Example #1
0
 public bool UpdateDashboardTable(DashboardTable_Model DashboardTable)
 {
     using (var _context = new SalesTrackingSystemEntities())
     {
         try
         {
             var data = _context.DashboardTables.Where(dashboardTable => dashboardTable.DashboardTableId == DashboardTable.DashboardTableId).FirstOrDefault();
             data.DashboardTableId = DashboardTable.DashboardTableId;
             data.TableName        = DashboardTable.TableName;
             data.DateUpdated      = DateTime.Now;
             _context.SaveChanges();
             return(true);
         }
         catch (Exception)
         {
             return(false);
         }
     }
 }
        public ActionResult TableDelete(DashboardTable_Model table_Model)
        {
            var Type_Name = table_Model.TableName;

            try
            {
                if (DashboardTable_Interface.DeleteDashboardTable(table_Model.DashboardTableId))
                {
                    return(Json(Type_Name + " type has been deleted successfully"));
                }
                else
                {
                    return(Json("Error"));
                }
            }
            catch (Exception e)
            {
                return(Json("Error" + e.ToString()));
            }
        }
 public ActionResult TableAdd(DashboardTable_Model table_Model)
 {
     if (string.IsNullOrEmpty(table_Model.TableName))
     {
         ViewBag.TableAddError = "Error";
         return(View("Settings"));
     }
     else
     {
         if (DashboardTable_Interface.SaveDashboardTable(table_Model))
         {
             Session["Success"] = table_Model.TableName + " added successfully!!";
         }
         else
         {
             Session["Error"] = table_Model.TableName + " couldn't be added please retry!!";
         }
         return(RedirectToAction("Settings"));
     }
 }
 public ActionResult TableUpdate(DashboardTable_Model table_Model)
 {
     if (string.IsNullOrEmpty(table_Model.TableName))
     {
         ViewBag.UpdateTableError = "Error";
         ViewBag.UpdateTableData  = table_Model.DashboardTableId;
         return(View("Settings"));
     }
     else
     {
         if (DashboardTable_Interface.UpdateDashboardTable(table_Model))
         {
             Session["Success"] = table_Model.TableName + " updated successfully!!";
             return(RedirectToAction("Settings"));
         }
         else
         {
             Session["Error"] = table_Model.TableName + " couldn't be updated please retry!!";
             return(View("Settings"));
         }
     }
 }
Example #5
0
 public bool SaveDashboardTable(DashboardTable_Model DashboardTable)
 {
     using (var _dbContext = new SalesTrackingSystemEntities())
     {
         try
         {
             var data = new DashboardTable()
             {
                 DashboardTableId = GetNewDashboardTableID(),
                 TableName        = DashboardTable.TableName,
                 DateCreated      = DateTime.Now
             };
             _dbContext.DashboardTables.Add(data);
             _dbContext.SaveChanges();
             return(true);
         }
         catch (Exception)
         {
             throw;
         }
     }
 }