public JsonResult GetProjec() { var eList = new List <ProjectMaster>(); try { eList = _commonService.GetProjectNameList().ToList(); } catch (Exception ex) { } var objstate = eList.Select(x => new { value = x.ProjectName + "-" + CommonConversion.AddOrdinal(x.OrderNuber) + " Order", Id = x.ProjectMasterId, display = x.DisplaySize, ram = x.Ram, rom = x.Rom }).ToList(); return(Json(objstate.ToArray(), JsonRequestBehavior.AllowGet)); }
//for project Name Auto Complete public JsonResult GetProjectNameList(string term) { List <ProjectMaster> eList; try { eList = _commonService.GetProjectNameList().Where(x => x.ProjectName.ToLower().Contains(term.ToLower())).OrderBy(x => x.ProjectName).ThenByDescending(x => x.OrderNuber).ToList(); } catch (Exception ex) { return(Json(ex)); } var objstate = eList.Select(x => new { value = x.ProjectName + "-" + CommonConversion.AddOrdinal(x.OrderNuber) + " Order", Id = x.ProjectMasterId, display = x.DisplaySize, ram = x.Ram, rom = x.Rom }).ToList(); return(Json(objstate.ToArray(), JsonRequestBehavior.AllowGet)); }
public List <tblRework> GetIssueResult(tblRework rework) { var list = new List <tblRework>(); var fullList = new List <tblRework>(); try { list = _entity.tblRework.WhereIf(rework.MobileCode != null, x => x.MobileCode == rework.MobileCode) .WhereIf(rework.Imei1 != null, x => x.Imei1 == rework.Imei1) .WhereIf(rework.Imei2 != null, x => x.Imei2 == rework.Imei2) .WhereIf(rework.Status != null, x => x.Status == rework.Status) .WhereIf(rework.ReworkId != 0, x => x.ReworkId == rework.ReworkId) .WhereIf(rework.AddedBy != null, x => x.AddedBy == rework.AddedBy) .WhereIf(rework.FailedStation != null, x => x.FailedStation == rework.FailedStation) .WhereIf(rework.ProjectId != null, x => x.ProjectId == rework.ProjectId) .ToList(); var projectname = _wcmsCellPhoneProjectEntities.ProjectMasters.ToList(); fullList = (from li in list join proj in projectname on li.ProjectId equals proj.ProjectMasterId select new tblRework { ProjectId = li.ProjectId, ProjectName = proj.ProjectName + "-" + CommonConversion.AddOrdinal(proj.OrderNuber) + " Order", LineId = li.LineId, FailedStation = li.FailedStation, Issues = li.Issues, ReworkId = li.ReworkId, MobileCode = li.MobileCode, AddedDate = li.AddedDate }).ToList(); } catch (Exception ex) { throw ex; } return(fullList); }