public ActionResult manageReqType(managementVM management, int? ReqTypeID, string Search) { if (ModelState.IsValid) { if (management.ReqType != null) { var reqtype = new ReqType { ReqType1 = management.ReqType.ReqType1 }; db.ReqType.Add(reqtype); db.SaveChanges(); LoadReqType(); return RedirectToAction("manageReqType"); } else if (ReqTypeID != null) { var mydeletetype = db.ReqType.Find(ReqTypeID); db.ReqType.Remove(mydeletetype); db.SaveChanges(); LoadReqType(); return RedirectToAction("manageReqType"); } else if (Search != null || Search != "") { string FN = string.Empty; string LN = string.Empty; string[] m = Search.Split(null);//if the splitting char is null it is assume that the delimiter is a whie space var mymanagement = new managementVM(); if (m.Length > 1) { FN = m[0]; LN = m[1]; mymanagement.Tenants = db.Tenant.Where(c => c.FirstName.Contains(Search) || c.LastName.Contains(Search) || c.FirstName.Contains(FN) && c.LastName.Contains(LN)) .Select(c => new TenantVM { ID = c.ID, FirstName = c.FirstName, LastName = c.LastName, aptID = (int)c.aptID, Phone = c.Phone, created = c.Created }).ToList(); } else { mymanagement.Tenants = db.Tenant.Where(c => c.FirstName.Contains(Search) || c.LastName.Contains(Search)) .Select(c => new TenantVM { ID = c.ID, FirstName = c.FirstName, LastName = c.LastName, aptID = (int)c.aptID, Phone = c.Phone, created = c.Created }).ToList(); } LoadReqType(); return View(mymanagement); } } return View(); }
//this is use forthe search guess list public JsonResult getKeyupSearch(string mysearch) { var Search = new List<TenantSearch>(); if(mysearch!=null || mysearch!="") { string FN = string.Empty; string LN = string.Empty; string[] m = mysearch.Split(null);//if the splitting char is null it is assume that the delimiter is a whie space var mymanagement = new managementVM(); if (m.Length > 1) { FN = m[0]; LN = m[1]; Search = db.Tenant .Join(db.Apartment, c => c.aptID, a => a.ID, (c, a) => new { c,a}) .Join(db.Buildings, ca=> ca.a.BuildingID, b=> b.ID, (ca, b) => new TenantSearch { FirstName = ca.c.FirstName, LastName = ca.c.LastName, Apt = ca.a.ApartmentNumber, Address = b.Address, city = b.City, zipcode = b.Zipcode, ApartmentID = ca.a.ID, TenantID = ca.c.ID, BuildingID = b.ID }) .Where(c => c.FirstName.Contains(mysearch) || c.LastName.Contains(mysearch) || c.FirstName.Contains(FN) && c.LastName.Contains(LN) ) .OrderByDescending(c=> c.FirstName) .Take(10) .ToList(); return new JsonResult { Data = Search, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } else { Search = db.Tenant .Join(db.Apartment, c => c.aptID, a => a.ID, (c, a) => new { c, a }) .Join(db.Buildings, ca => ca.a.BuildingID, b => b.ID, (ca, b) => new TenantSearch { FirstName = ca.c.FirstName, LastName = ca.c.LastName, Apt = ca.a.ApartmentNumber, Address = b.Address, city = b.City, zipcode = b.Zipcode, ApartmentID = ca.a.ID, TenantID = ca.c.ID, BuildingID = b.ID }) .Where(c => c.FirstName.Contains(mysearch) || c.LastName.Contains(mysearch)) .OrderByDescending(c=> c.FirstName) .Take(10) .ToList(); return new JsonResult { Data = Search, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } } return new JsonResult { Data = Search, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
public ActionResult manageReqType(managementVM managementModel) { LoadReqType(); return View(managementModel); }