public async Task <IActionResult> Add(CitizensAppeal citizensAppeal, ScheduleForWeek scheduleForWeek)
{
citizensAppeal.ScheduleForWeekID = db.SchedulesForWeek.Where(o => o.StartTime == scheduleForWeek.StartTime).FirstOrDefault().ScheduleForWeekID;
if (citizensAppeal == null)
{
return(View());
}
try
{
db.CitizensAppeals.Add(citizensAppeal);
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CitizensAppealExists(citizensAppeal.CitizensAppealID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
public IActionResult Index(CitizensAppeal citizensAppeal)
{
var sessionSortState = HttpContext.Session.GetString("SortStateCitizensAppeal");
SortState sortOrder = new SortState();
if (sessionSortState != null)
{
sortOrder = (SortState)Enum.Parse(typeof(SortState), sessionSortState);
}
int?page = HttpContext.Session.GetInt32("CitizensAppealPage");
if (page == null)
{
page = 0;
HttpContext.Session.SetInt32("CitizensAppealPage", 0);
}
IQueryable <CitizensAppeal> citizensAppeals = Sort(db.CitizensAppeals, sortOrder,
citizensAppeal.LFO, (int)page);
HttpContext.Session.SetObject("CitizensAppeal", citizensAppeal);
CitizensAppealsViewModel citizensAppealsView = new CitizensAppealsViewModel
{
CitizensAppealViewModel = citizensAppeal,
PageViewModel = citizensAppeals,
PageNumber = (int)page
};
return(View(citizensAppealsView));
}
public static void AddCitizensAppeal(CitizensAppeal citizensAppealToAdd)
{
using (Context db = new Context())
{
db.CitizensAppeals.Add(citizensAppealToAdd);
db.SaveChanges();
}
}
public static CitizensAppeal FindCitizensAppeal(int id)
{
CitizensAppeal citizensAppeal = null;
using (Context db = new Context())
{
citizensAppeal = db.CitizensAppeals.Where(k => k.CitizensAppealID == id).ToList().FirstOrDefault();
}
return(citizensAppeal);
}
public static void DeleteCitizensAppeal(CitizensAppeal citizensAppealToDelete)
{
using (Context db = new Context())
{
if (citizensAppealToDelete != null)
{
db.CitizensAppeals.Remove(citizensAppealToDelete);
db.SaveChanges();
}
}
}
public static void UpdataCitizensAppeal(CitizensAppeal citizensAppeal)
{
using (Context db = new Context())
{
if (citizensAppeal != null)
{
db.CitizensAppeals.Update(citizensAppeal);
db.SaveChanges();
}
}
}
public IActionResult Index(SortState sortOrder = SortState.No, int index = 0)
{
CitizensAppeal sessionCitizensAppeal = HttpContext.Session.GetObject <CitizensAppeal>("Treatment");
string sessionSortState = HttpContext.Session.GetString("SortStateCitizensAppeal");
int? page = HttpContext.Session.GetInt32("Page");
if (page == null)
{
page = 0;
HttpContext.Session.SetInt32("Page", 0);
}
else
{
if (!(page < 1 && index < 0))
{
page += index;
}
HttpContext.Session.SetInt32("Page", (int)page);
}
if (sessionCitizensAppeal != null)
{
_citizensAppeal = sessionCitizensAppeal;
}
if (sessionSortState != null)
{
if (sortOrder == SortState.No)
{
sortOrder = (SortState)Enum.Parse(typeof(SortState), sessionSortState);
}
}
ViewData["NameSort"] = sortOrder == SortState.NameDesc ? SortState.NameAsc : SortState.NameDesc;
HttpContext.Session.SetString("SortState", sortOrder.ToString());
IQueryable <CitizensAppeal> CitizensAppeals = Sort(db.CitizensAppeals, sortOrder,
_citizensAppeal.LFO, (int)page);
CitizensAppealsViewModel CitizensAppealsView = new CitizensAppealsViewModel
{
CitizensAppealViewModel = _citizensAppeal,
PageViewModel = CitizensAppeals,
PageNumber = (int)page
};
return(View(CitizensAppealsView));
}
public IActionResult Index(int page, SortState sortOrder)
{
CitizensAppeal sessionCitizensAppeal = HttpContext.Session.GetObject <CitizensAppeal>("CitizensAppeal");
string sessionSortState = HttpContext.Session.GetString("SortStateCitizensAppeal");
if (sessionCitizensAppeal != null)
{
_citizensAppeal = sessionCitizensAppeal;
}
if (sessionSortState != null)
{
if (sortOrder == SortState.No)
{
sortOrder = (SortState)Enum.Parse(typeof(SortState), sessionSortState);
}
}
ViewData["NameSort"] = sortOrder == SortState.NameDesc ? SortState.NameAsc : SortState.NameDesc;
HttpContext.Session.SetString("SortState", sortOrder.ToString());
IQueryable <CitizensAppeal> CitizensAppeals = Sort(db.CitizensAppeals, sortOrder,
_citizensAppeal.LFO, (int)page);
PageViewModel pageViewModel = new PageViewModel(NoteCount(db.CitizensAppeals,
_citizensAppeal.LFO), page, pageSize);
foreach (var item in CitizensAppeals)
{
item.ScheduleForWeek = db.SchedulesForWeek.Where(o => o.ScheduleForWeekID == item.ScheduleForWeekID).FirstOrDefault();
}
CitizensAppealsViewModel CitizensAppealsView = new CitizensAppealsViewModel
{
CitizensAppealViewModel = _citizensAppeal,
PageViewModel = CitizensAppeals,
PageNumber = (int)page
};
return(View(CitizensAppealsView));
}
public IActionResult Edit(CitizensAppeal citizensAppeal)
{
if (ModelState.IsValid)
{
try
{
db.Update(citizensAppeal);
db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CitizensAppealExists(citizensAppeal.CitizensAppealID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(citizensAppeal));
}
