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