public void filterRecord(int length, string property, string value, string value2, ref DentalMenu[] dentalMenu) { /* Fields that can be filter * Name * Desription * Status */ //Filter for a specific patient int fetch; dentalMenu = null; if (property.Equals("Name")) { value = value.ToLower(); var records = db.DentalMenus.Where(dm => dm.Name.ToLower().Contains(value) || dm.Name.ToLower().ToLower().Equals(value)).Count(); if (records > length) { if ((records - length) > pageSize) fetch = pageSize; else fetch = records - length; var getDentalMenu = db.DentalMenus.Where(dm => dm.Name.ToLower().Contains(value) || dm.Name.ToLower().ToLower().Equals(value)) .OrderBy(dm => dm.Id).Skip((length)).Take(fetch).ToArray(); dentalMenu = getDentalMenu; } } else if (property.Equals("Description")) { value = value.ToLower(); var records = db.DentalMenus.Where(dm => dm.Description.ToLower().Contains(value) || dm.Description.ToLower().ToLower().Equals(value)).Count(); if (records > length) { if ((records - length) > pageSize) fetch = pageSize; else fetch = records - length; var getDentalMenu = db.DentalMenus.Where(dm => dm.Description.ToLower().Contains(value) || dm.Description.ToLower().ToLower().Equals(value)) .OrderBy(dm => dm.Id).Skip((length)).Take(fetch).ToArray(); dentalMenu = getDentalMenu; } } else if (property.Equals("Url")) { value = value.ToLower(); var records = db.DentalMenus.Where(dm => dm.Url.ToLower().Contains(value) || dm.Url.ToLower().ToLower().Equals(value)).Count(); if (records > length) { if ((records - length) > pageSize) fetch = pageSize; else fetch = records - length; var getDentalMenu = db.DentalMenus.Where(dm => dm.Url.ToLower().Contains(value) || dm.Url.ToLower().ToLower().Equals(value)) .OrderBy(dm => dm.Id).Skip((length)).Take(fetch).ToArray(); dentalMenu = getDentalMenu; } } else if (property.Equals("ParentName")) { StringManipulation strManipulate = new StringManipulation(value, value2, "Integer"); var records = db.DentalMenus.Where(dm => dm.ParentId == strManipulate.intValue).Count(); if (records > length) { if ((records - length) > pageSize) fetch = pageSize; else fetch = records - length; var getDentalMenu = db.DentalMenus.Where(dm => dm.ParentId == strManipulate.intValue) .OrderBy(cs => cs.Id).Skip((length)).Take(fetch).ToArray(); dentalMenu = getDentalMenu; } } //status else { StringManipulation strManipulate = new StringManipulation(value, value2, "Integer"); var records = db.DentalMenus.Where(dm => dm.Status == strManipulate.intValue).Count(); if (records > length) { if ((records - length) > pageSize) fetch = pageSize; else fetch = records - length; var getDentalMenu = db.DentalMenus.Where(dm => dm.Status == strManipulate.intValue) .OrderBy(dm => dm.Id).Skip((length)).Take(fetch).ToArray(); dentalMenu = getDentalMenu; } } }
public IHttpActionResult PutDentalMenu(int id, DentalMenu dentalMenu) { response.status = "FAILURE"; if (!ModelState.IsValid || id != dentalMenu.Id) { response.message = "Bad request."; return Ok(response); } db.Entry(dentalMenu).State = EntityState.Modified; try { db.SaveChanges(); response.status = "SUCCESS"; response.objParam1 = dentalMenu; } catch (Exception e) { if (!DentalMenuExists(id)) { response.message = "Menu doesn't exist."; } else { response.message = e.InnerException.InnerException.Message.ToString(); } } return Ok(response); }
//Filtering for active menu public IHttpActionResult GetDentalMenu(int length, int status, string property, string value, string value2) { DentalMenu[] dentalMenu = new DentalMenu[pageSize]; this.filterRecord(length, status, property, value, value2, ref dentalMenu); if (dentalMenu != null) return Ok(dentalMenu); else return Ok(); }
public IHttpActionResult PostDentalMenu(DentalMenu dentalMenu) { response.status = "FAILURE"; if (!ModelState.IsValid) { response.message = "Bad request."; return Ok(response); } try { db.DentalMenus.Add(dentalMenu); db.SaveChanges(); response.status = "SUCCESS"; response.objParam1 = dentalMenu; } catch (Exception e) { response.message = e.InnerException.InnerException.Message.ToString(); } return Ok(response); }
public void filterRecord(int length, int status, string property, string value, string value2, ref DentalMenu[] dentalMenu) { /* Fields that can be filter * Name * Desription * Status */ //Filter for a specific patient int fetch; dentalMenu = null; if (property.Equals("Name")) { value = value.ToLower(); var records = db.DentalMenus.Where(dm => (dm.Name.ToLower().Contains(value) || dm.Name.ToLower().ToLower().Equals(value)) && dm.Status == status).Count(); if (records > length) { if ((records - length) > pageSize) fetch = pageSize; else fetch = records - length; var getDentalMenu = db.DentalMenus.Where(dm => (dm.Name.ToLower().Contains(value) || dm.Name.ToLower().ToLower().Equals(value)) && dm.Status == status).OrderBy(dm => dm.Id).Skip((length)).Take(fetch).ToArray(); dentalMenu = getDentalMenu; } } //Description else { value = value.ToLower(); var records = db.DentalMenus.Where(dm => (dm.Description.ToLower().Contains(value) || dm.Description.ToLower().ToLower().Equals(value)) && dm.Status == status).Count(); if (records > length) { if ((records - length) > pageSize) fetch = pageSize; else fetch = records - length; var getDentalMenu = db.DentalMenus.Where(dm => (dm.Description.ToLower().Contains(value) || dm.Description.ToLower().ToLower().Equals(value)) && dm.Status == status).OrderBy(dm => dm.Id).Skip((length)).Take(fetch).ToArray(); dentalMenu = getDentalMenu; } } }