//
// GET: /ListTable/Delete/5
public ActionResult Delete(int ListTableID)
{
ViewBag.ListTableID = ListTableID;
listtable listtable = ListTableRepository.GetListByID(ListTableID);
return(PartialView(listtable));
}
public bool AddRecord(listtable Record)
{
myRecords.Add(Record);
context.listtables.Add(Record);
context.SaveChanges();
return(true);
}
public ActionResult Create(int ListTableID)
{
GetData();
ViewBag.BeginDate = DateTime.Today;
ViewBag.ListTableID = ListTableID;
listtable table = ListTableRepository.GetListByID(ListTableID);
if (table == null)
{
return(Content("Table not found"));
}
ViewBag.TableName = string.Format("Add record to table ({0})", table.Title);
listheader header = ListHeaderRepository.GetByListTableID(ListTableID);
ViewBag.TableHeaderID = header.ListHeaderID;
ViewBag.Type1 = header.Type1;
ViewBag.Type2 = header.Type2;
ViewBag.Type3 = header.Type3;
ViewBag.Type4 = header.Type4;
ViewBag.Type5 = header.Type5;
ViewBag.Type6 = header.Type6;
ViewBag.Type7 = header.Type7;
ViewBag.Type8 = header.Type8;
ViewBag.Type9 = header.Type9;
ViewBag.Type10 = header.Type10;
return(PartialView(new listitem {
DateEntered = System.DateTime.Today, EnteredBy = User.Identity.Name.ToString(), listTableID = ListTableID, Status = "Active"
}));
}
public ActionResult ListStatus(int ListTableID, string Status)
{
ViewBag.ListTableID = ListTableID;
listtable table = ListTableRepository.GetListByID(ListTableID);
listheader header = ListHeaderRepository.GetByListTableID(ListTableID);
ViewBag.Header = header;
IEnumerable <listitem> ListItem;
ListItem = ListItemRepository.GetListItemByListStatus(ListTableID, Status);
ViewBag.RecordCount = ListItem.Count();
//security
ViewBag.Supervisor = false;
int memberID = Convert.ToInt16(System.Web.HttpContext.Current.Session["personID"]);
if (MembershipRepositroy.IsUser(memberID))
{
user user = MembershipRepositroy.GetUserByID(memberID);
if ((user.role.Name == "WebMaster") || (user.role.Name == "Officer") || (user.role.Name == "Admin")) //creator access
{
ViewBag.Supervisor = true;
}
}
return(PartialView(ListItem));
}
public ActionResult Edit(int ListTableID)
{
listtable listtable = ListTableRepository.GetListByID(ListTableID);
GetData(listtable.ministryID);
ViewBag.TableHeader = string.Format("Edit Table ({0})", listtable.Title);
return(PartialView(listtable));
}
public void HideListTable(int ListTableID = 0)
{
listtable table = ListTableRepository.GetListByID(ListTableID);
if (table != null)
{
table.Status = "Inactive";
table.EnteredBy = User.Identity.Name.ToString();
table.DateEntered = DateTime.Now;
db.Entry(table).State = EntityState.Modified;
db.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int ListTableID)
{
listtable listtable = ListTableRepository.GetListByID(ListTableID);
IEnumerable <listitem> litems = ListItemRepository.GetAllListItemByListTable(ListTableID);
ListItemRepository.DeleteAllRecords(litems);
listheader header = ListHeaderRepository.GetByListTableID(ListTableID);
ListHeaderRepository.DeleteRecord(header);
ListTableRepository.DeleteRecord(listtable);
//return RedirectToAction("List");
return(Content("Table deleted successfully"));
}
public ActionResult List(int ListTableID, bool canEdit = true)
{
ViewBag.CanEdit = canEdit;
ViewBag.ListTableID = ListTableID;
listtable table = ListTableRepository.GetListByID(ListTableID);
ViewBag.TableName = table.Title;
listheader header = ListHeaderRepository.GetByListTableID(ListTableID);
ViewBag.Header = header;
IEnumerable <listitem> ListItem = null;
// ListItem = ListItemRepository.GetListItemByList(ListTableID);
//ViewBag.RecordCount = ListItem.Count();
//security
ViewBag.Supervisor = false;
int memberID = Convert.ToInt16(System.Web.HttpContext.Current.Session["personID"]);
if (MembershipRepositroy.IsUser(memberID))
{
user user = MembershipRepositroy.GetUserByID(memberID);
if ((user.role.Name == "WebMaster") || (user.role.Name == "Officer") || (user.role.Name == "Admin")) //creator access
{
ViewBag.Supervisor = true;
ListItem = ListItemRepository.GetAllListItemByListTable(ListTableID);
ViewBag.RecordCount = ListItem.Count();
}
else
{
ListItem = ListItemRepository.GetActiveListItemByListTable(ListTableID);
ViewBag.RecordCount = ListItem.Count();
}
}
ViewBag.HasComment = false;
foreach (listitem i in ListItem)
{
if (i.Comment.Trim() != "")
{
ViewBag.HasComment = true;
}
}
return(PartialView(ListItem));
}
public ActionResult Display(int ListTableID, bool canEdit = true)
{
ViewBag.CanEdit = canEdit;
ViewBag.ListTableID = ListTableID;
listtable table = ListTableRepository.GetListByID(ListTableID);
listheader header = ListHeaderRepository.GetByListTableID(ListTableID);
IEnumerable <listitem> items = ListItemRepository.GetAllListItemByListTable(ListTableID);
ViewBag.HasHeader = false;
if (header != null)
{
ViewBag.HasHeader = true;
}
return(PartialView(table));
}
public ActionResult Edit(listtable listtable)
{
try
{
//if (contribution.CheckNumber == null) { contribution.CheckNumber = ""; }
if (ModelState.IsValid)
{
db.Entry(listtable).State = EntityState.Modified;
db.SaveChanges();
TempData["Message2"] = string.Format("Table update successfully.");
GetData(listtable.ministryID);
return(RedirectToAction("Create", "ListItem", new { ListTableID = listtable.listTableID }));
}
}
catch (Exception ex)
{
TempData["Message2"] = string.Format("Error editing {0} table data.", listtable.Title);
}
GetData(listtable.ministryID);
return(PartialView(listtable));
}
public ActionResult DisableTable(int ListTableID)
{
listtable listtable = ListTableRepository.GetListByID(ListTableID);
try
{
listtable.Status = "Deleted";
//if (contribution.CheckNumber == null) { contribution.CheckNumber = ""; }
if (ModelState.IsValid)
{
db.Entry(listtable).State = EntityState.Modified;
db.SaveChanges();
return(Content("Table deleted successfully"));
}
}
catch (Exception ex)
{
TempData["Message2"] = string.Format("Error deleteing {0} table.", listtable.Title);
}
GetData();
return(PartialView(listtable));
}
public ActionResult Create(listtable listtable)
{
try
{
//if (contribution.CheckNumber == null) { contribution.CheckNumber = ""; }
if (ModelState.IsValid)
{
db.listtables.Add(listtable);
db.SaveChanges();
//ListTableRepository.AddRecord(listtable);
TempData["Message2"] = "Table record added successfully.";
GetData();
return(Content("Table record added successfully"));
}
}
catch (Exception ex)
{
TempData["Message2"] = "Error adding table";
}
GetData();
return(PartialView(listtable));
}
public ActionResult Edit(int ListItemID)
{
listitem listitem = ListItemRepository.GetListItemByID(ListItemID);
GetData();
listtable table = ListTableRepository.GetListByID(listitem.listTableID);
ViewBag.TableName = string.Format("Add new record to the{0}", table.Title);
listheader header = ListHeaderRepository.GetByListTableID(listitem.listTableID);
ViewBag.Type1 = header.Type1;
ViewBag.Type2 = header.Type2;
ViewBag.Type3 = header.Type3;
ViewBag.Type4 = header.Type4;
ViewBag.Type5 = header.Type5;
ViewBag.Type6 = header.Type6;
ViewBag.Type7 = header.Type7;
ViewBag.Type8 = header.Type8;
ViewBag.Type9 = header.Type9;
ViewBag.Type10 = header.Type10;
return(PartialView(listitem));
}
public ActionResult Create(listheader listheader)
{
try
{
// if (listheader.Type1 == null) { listheader.Type1 = ""; }
if (listheader.Type2 == null)
{
listheader.Type2 = "";
}
if (listheader.Type3 == null)
{
listheader.Type3 = "";
}
if (listheader.Type4 == null)
{
listheader.Type4 = "";
}
if (listheader.Type5 == null)
{
listheader.Type5 = "";
}
if (listheader.Type6 == null)
{
listheader.Type6 = "";
}
if (listheader.Type7 == null)
{
listheader.Type7 = "";
}
if (listheader.Type8 == null)
{
listheader.Type8 = "";
}
if (listheader.Type9 == null)
{
listheader.Type9 = "";
}
if (listheader.Type10 == null)
{
listheader.Type10 = "";
}
// if (listheader.FieldName1 == null) { listheader.FieldName1 = ""; }
if (listheader.FieldName2 == null)
{
listheader.FieldName2 = "";
}
if (listheader.FieldName3 == null)
{
listheader.FieldName3 = "";
}
if (listheader.FieldName4 == null)
{
listheader.FieldName4 = "";
}
if (listheader.FieldName5 == null)
{
listheader.FieldName5 = "";
}
if (listheader.FieldName6 == null)
{
listheader.FieldName6 = "";
}
if (listheader.FieldName7 == null)
{
listheader.FieldName7 = "";
}
if (listheader.FieldName8 == null)
{
listheader.FieldName8 = "";
}
if (listheader.FieldName9 == null)
{
listheader.FieldName9 = "";
}
if (listheader.FieldName10 == null)
{
listheader.FieldName10 = "";
}
if (ModelState.IsValid)
{
listtable table = new listtable();
table.ministryID = listheader.ministryID;
table.Title = listheader.TableName;
table.Status = "Active";
table.ministryID = listheader.ministryID;
table.EnteredBy = User.Identity.Name.ToString();
table.DateEntered = System.DateTime.Today;
table.DateCreated = System.DateTime.Today;
ListTableRepository.AddRecord(table);
listheader.ListTableID = table.listTableID;
db.listheaders.Add(listheader);
db.SaveChanges();
ListHeaderRepository.AddRecord(listheader);
TempData["Message2"] = "Table header added successfully.";
GetData();
return(RedirectToAction("Create", "ListItem", new { ListTableID = listheader.ListTableID }));
}
}
catch (Exception ex)
{
TempData["Message2"] = "Error adding table header";
}
GetData();
return(PartialView(listheader));
}
public void DeleteRecord(listtable record)
{
myRecords.Remove(record);
context.listtables.Remove(record);
context.SaveChanges();
}
/*
*
* public Lookup<int, listtable> GetList(int ministryID)
* {
* // Dictionary<string, int> aList;
*
* var aList = myRecords
* .Where(e => e.ministryID == ministryID)
* .OrderBy(e => (string)e.Title)
* .ToLookup(e =>e.listTableID,e => e);
*
* return (aList);
* }
*/
public listtable GetListByID(int listID)
{
record = myRecords.FirstOrDefault(e => e.listTableID == listID);
return(record);
}
