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));
}
