// GET:
public ActionResult ViewPeriodTable(FormCollection frm)
{
ApplicationDbContext context = new ApplicationDbContext();
var userid = User.Identity.GetUserId();
var username = User.Identity.GetUserName();
string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup;
RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.SingleOrDefault(m => m.UserName == username);
ViewBag.IsValidRole = roleAssignmentMatrix.Period;
if (frm.Count == 0)
{
SearchBillingPeriodViewModel SearchPeriodViewModels = new SearchBillingPeriodViewModel();
SearchPeriodViewModels.BillPeriodList = db.BillingPeriod.Where(m => m.groupCode == ZoneGroup).OrderByDescending(n => n.DateFrom).ToList();
return(View(SearchPeriodViewModels));
}
else if (frm.Count >= 1)
{
int parsedID = int.Parse(frm["ID"]);
BillingPeriod period = db.BillingPeriod.Find(parsedID);
db.BillingPeriod.Remove(period);
db.SaveChanges();
return(RedirectToAction("ViewPeriodTable"));
}
return(View());
}
public ActionResult ViewPeriodTablePRG(FormCollection frm)
{
ApplicationDbContext context = new ApplicationDbContext();
var userid = User.Identity.GetUserId();
var username = User.Identity.GetUserName();
string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup;
RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.SingleOrDefault(m => m.UserName == username);
ViewBag.IsValidRole = roleAssignmentMatrix.Period;
//ViewBag.Groups = new SelectList(db.ZoneGroup.ToList(), "ZoneGroupCode", "ZoneGroupName");
SearchBillingPeriodViewModel SearchPeriodViewModels = new SearchBillingPeriodViewModel();
//SearchPeriodViewModels.BillPeriodList = db.BillingPeriod.ToList();
SearchPeriodViewModels.BillPeriodList = db.BillingPeriod.Where(m => m.groupCode == ZoneGroup).OrderByDescending(n => n.DateFrom).ToList();
//return View(SearchPeriodViewModels);
ViewBag.TransactionSuccess = TempData["TransactionSuccess"] as string;
return(View("ViewPeriodTable", SearchPeriodViewModels));
}
