public ActionResult DisplayPoleRentalList(int CompanyId, FormCollection frmcollection) { var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Pole; ViewBag.CompanySelected = "OK"; if (frmcollection.Count == 0) { SearchPoleInformationViewModel SearchCompanyViewModels = new SearchPoleInformationViewModel(); SearchCompanyViewModels.PoleInformationList = db.PoleInformation.SqlQuery("Select * from PoleInformations where CompanyId = '" + frmcollection["CompanyId"] + "'").ToList(); return(View(SearchCompanyViewModels)); } else if (frmcollection.Count >= 1) { int parsedID = int.Parse(frmcollection["PoleInformationId"]); SearchPoleInformationViewModel SearchPoleRentalViewModels = new SearchPoleInformationViewModel(); PoleInformation PoleRentalAssignment = new PoleInformation(); PoleInformation pole = db.PoleInformation.Find(parsedID); db.PoleInformation.Remove(pole); db.SaveChanges(); SearchPoleRentalViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); SearchPoleRentalViewModels.PoleInformationList = db.PoleInformation.Where(m => m.CompanyId == CompanyId).ToList(); return(View("ViewPoleRentals", SearchPoleRentalViewModels)); } return(View()); }
public ActionResult ViewPoleRentalsRPG() { var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Pole; ViewBag.CompanySelected = "OK"; SearchPoleInformationViewModel temp = TempData["SearchPoleRentalViewModels"] as SearchPoleInformationViewModel; ViewBag.TransactionSuccess = TempData["TransactionSuccess"] as string; TempData.Keep("SearchPoleRentalViewModels"); return(View("ViewPoleRentals", temp)); }
public ActionResult ViewPoleRentals(string SearchInput, FormCollection frm) { var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Pole; //Result of initial search button if (!string.IsNullOrEmpty(SearchInput)) { SearchPoleInformationViewModel searchcompany1 = new SearchPoleInformationViewModel(); ApplicationDbContext context = new ApplicationDbContext(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; List <Company> NewCompanies = new List <Company>(); NewCompanies = db.Company.SqlQuery("Select * from Companies where CompanyName like '%" + SearchInput + "%'").ToList(); SearchCompanyPerGroup searchCompanyPerGroup = new SearchCompanyPerGroup(NewCompanies, ZoneGroup); searchcompany1.CompanyList = searchCompanyPerGroup.Companies; //searchcompany1.SearchInput = SearchInput.ToString(); //searchcompany1.CompanyList = db.Company.SqlQuery("Select * from Companies where CompanyName like '%" + SearchInput + "%'").ToList(); return(View(searchcompany1)); } //Result of selected company shown by "Search button" else if (frm.Count == 2) { int OutParseValue; bool CanParse = int.TryParse(frm[1].ToString(), out OutParseValue); SearchPoleInformationViewModel searchcompany1 = new SearchPoleInformationViewModel(); if (CanParse) { int ParsedCompanyID = int.Parse(frm[1].ToString()); searchcompany1.PoleInformationList = db.PoleInformation.Where(m => m.CompanyId == ParsedCompanyID).ToList(); searchcompany1.CompanyList = db.Company.Where(m => m.CompanyID == ParsedCompanyID).ToList(); ViewBag.CompanySelected = "OK"; } return(View(searchcompany1)); } //Default value else { SearchPoleInformationViewModel searchcompany1 = new SearchPoleInformationViewModel(); return(View(searchcompany1)); } }
public ActionResult AddPoleRental(FormCollection frm) { var origamt = frm["Amount"]; var amt = frm["Amount"].Split(','); var newAmount = ""; foreach (var item in amt) { newAmount += item; } var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Pole; //SL.LogInfo(User.Identity.Name, Request.RawUrl, "User Added Item! (Data Entry Pole Rental) - from Terminal:" + ipaddress); string isEdit = frm["isEdit"].ToString(); SearchPoleInformationViewModel SearchPoleRentalViewModels = new SearchPoleInformationViewModel(); PoleInformation PoleRentalAssignment = new PoleInformation(); int CompanyId = int.Parse(frm["CompanyId"].ToString()); var errors = ModelState.Values.SelectMany(v => v.Errors); TryUpdateModel(PoleRentalAssignment); //if (ModelState.IsValid) //{ if (isEdit != "True") { PoleRentalAssignment.Amount = Convert.ToDecimal(origamt); PoleRentalAssignment.CreatedDate = DateTime.Now; PoleRentalAssignment.CreatedBy = userid; PoleRentalAssignment.BillMode = frm["BillMode"]; PoleRentalAssignment.BillingMonths = frm["billingMonths"]; //PoleRentalAssignment.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12"; db.PoleInformation.Add(PoleRentalAssignment); db.SaveChanges(); TempData["TransactionSuccess"] = "Add"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Pole Rental- Add - from Terminal:" + ipaddress); } else { int ParsedIntID = int.Parse(frm["ID"]); PoleRentalAssignment = db.PoleInformation.Find(ParsedIntID); //compinfo.CompanyCode = frmcollection["CompanyCode"].ToString(); PoleRentalAssignment.Amount = Convert.ToDecimal(newAmount); PoleRentalAssignment.StartDate = Convert.ToDateTime(frm["StartDate"].ToString()); PoleRentalAssignment.EndDate = Convert.ToDateTime(frm["EndDate"].ToString()); PoleRentalAssignment.UpdateDate = DateTime.Now; PoleRentalAssignment.UpdatedBy = userid; PoleRentalAssignment.BillingMonths = frm["billingMonths"]; //PoleRentalAssignment.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12"; PoleRentalAssignment.BillMode = frm["BillMode"]; db.Entry(PoleRentalAssignment).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["TransactionSuccess"] = "Edit"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Pole Rental- Edit - from Terminal:" + ipaddress); //ViewBag.TransactionSuccess = "Add"; } ViewBag.ValidatePostback = "True"; //} //else //{ // ViewBag.ValidatePostback = "False"; //} ViewBag.CompanySelected = "OK"; SearchPoleRentalViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); SearchPoleRentalViewModels.PoleInformationList = db.PoleInformation.Where(m => m.CompanyId == CompanyId).ToList(); TempData["SearchPoleRentalViewModels"] = SearchPoleRentalViewModels; return(RedirectToAction("ViewPoleRentalsRPG", "DataEntryPoleRental")); //return View("ViewPoleRentals", SearchPoleRentalViewModels); }
public ActionResult ViewPoleRentals() { SearchPoleInformationViewModel searchcompany = new SearchPoleInformationViewModel(); return(View(searchcompany)); }