public async Task <bool> Delete(object id) { var model = _repoAuditType.FindById(id); _repoAuditType.Remove(model); return(await _repoAuditType.SaveAll()); }
public async Task <PagedList <AuditRecDto> > GetAllAuditRecViewModel(PaginationParams param) { var listAuditRecM = _repoAuditRecM.FindAll(); var listAuditRecD = _repoAuditRecD.FindAll(); // var listAuditRecDto = (from b in listAuditRecD // join a in listAuditRecM on b.Record_ID equals a.Record_ID into c // from m in c.DefaultIfEmpty() // select new AuditRecDto() // { // Record_ID = m.Record_ID, Record_Time = m.Record_Time, // Line = m.Line, Model_Name = m.Model_Name, // Model_No = m.Model_No, Item_no = b.Item_no, // Status = b.Status, ERCS = b.ERCS, // //Audit_Type_ID = b.Audit_Type_ID, // Audit_Type_ID = _repoAuditTypeM.FindById(b.Audit_Type_ID.ToString()).Audit_Type1, // Audit_Item = b.Audit_Item, Issue_ZW = b.Issue_ZW, // Issue_LL = b.Issue_LL, Issue_EN = b.Issue_EN, // Before_Picture = b.Before_Picture, After_Picture = b.After_Picture, // PD_PIC = b.PD_PIC, PD_RESP = b.PD_RESP, // ME_PIC = b.ME_PIC, Finished_Date = b.Finished_Date, // Implement_User = b.Implement_User,Implement_Time = b.Implement_Time // }).Distinct().OrderByDescending(x => x.Implement_Time); var listAuditRecDto = listAuditRecD.Join(listAuditRecM, x => x.Record_ID, y => y.Record_ID, (x, y) => new AuditRecDto { Record_ID = x.Record_ID, Record_Time = y.Record_Time, After_Picture = x.After_Picture, Audit_Item = x.Audit_Item, Audit_Type_ID = x.Audit_Type_ID, Audit_Type = _repoAuditTypeM.FindById(x.Audit_Type_ID).Audit_Type1 + "-" + _repoAuditTypeM.FindById(x.Audit_Type_ID).Audit_Type2, Before_Picture = x.Before_Picture, Finished_Date = x.Finished_Date, ERCS = x.ERCS, Implement_Time = x.Implement_Time, Implement_User = x.Implement_User, Issue_EN = x.Issue_EN, Issue_LL = x.Issue_LL, Issue_ZW = x.Issue_ZW, Building = y.Building, PDC = y.PDC, Line = y.Line, ME_PIC = x.ME_PIC, Model_Name = y.Model_Name, Model_No = y.Model_No, Chief = y.Chief, Recorder = y.Recorder, Attendees = y.Attendees, PD_PIC = x.PD_PIC, PD_RESP = x.PD_RESP, Remark = x.Remark, Status = x.Status, Item_no = x.Item_no, Updated_By = x.Updated_By, Updated_Time = y.Updated_Time }); return(await PagedList <AuditRecDto> .CreateAsync(listAuditRecDto, param.PageNumber, param.PageSize)); }
public async Task <PagedList <AuditRecDto> > GetAllAuditRecViewModel(PaginationParams param) { var listAuditRecM = _repoM.FindAll(); var listAuditRecD = _repoD.FindAll(); var listAuditMes = _repoMes.FindAll(x => x.Status == 1); var listAuditRecDto = listAuditRecD.Join(listAuditRecM, x => x.Record_ID, y => y.Record_ID, (x, y) => new { x, y }) .Join(listAuditMes, z => z.y.Line, t => t.Line_ID_2, (z, t) => new AuditRecDto { Record_ID = z.x.Record_ID, Record_Time = z.y.Record_Time, After_Picture = z.x.After_Picture, Audit_Item = z.x.Audit_Item, Audit_Type_ID = z.x.Audit_Type_ID, Audit_Type = (z.x == null || z.x.Audit_Type_ID == "") ? "" : _repoAuditTypeM.FindById(z.x.Audit_Type_ID).Audit_Type1 + "-" + _repoAuditTypeM.FindById(z.x.Audit_Type_ID).Audit_Type2, Before_Picture = z.x.Before_Picture, Finished_Date = z.x.Finished_Date, ERCS = z.x.ERCS, Implement_Time = z.x.Implement_Time, Implement_User = z.x.Implement_User, Issue_EN = z.x.Issue_EN, Issue_LL = z.x.Issue_LL, Issue_ZW = z.x.Issue_ZW, Building = z.y.Building, PDC = z.y.PDC, Line = z.y.Line, Line_Name = t.Line_ID_2_Name, ME_PIC = z.x.ME_PIC, Model_Name = z.y.Model_Name, Model_No = z.y.Model_No, Chief = z.y.Chief, Recorder = z.y.Recorder, Attendees = z.y.Attendees, PD_PIC = z.x.PD_PIC, PD_Department = z.x.PD_Department, PD_Building = z.x.PD_Building, Remark = z.x.Remark, Status = z.x.Status, Item_no = z.x.Item_no, Updated_By = z.x.Updated_By, Updated_Time = z.x.Updated_Time, }).OrderBy(x => x.Audit_Type_ID); return(await PagedList <AuditRecDto> .CreateAsync(listAuditRecDto, param.PageNumber, param.PageSize)); }
public async Task <PagedList <AuditRecDto> > SearchByModel(PaginationParams param, AuditRecSearch model) { var listAuditRecM = _repoAuditRecM.FindAll(); var listAuditRecD = _repoAuditRecD.FindAll(); var listAuditMes = _mesAuditOrg.FindAll().Where(x => x.Status == 1); var listAuditRecDto = listAuditRecD.Join(listAuditRecM, x => x.Record_ID, y => y.Record_ID, (x, y) => new { x, y }).Join(listAuditMes, z => z.y.Line, t => t.Line_ID_2, (z, t) => new AuditRecDto { Record_ID = z.x.Record_ID, Record_Time = z.y.Record_Time, After_Picture = z.x.After_Picture, Audit_Item = z.x.Audit_Item, Audit_Type_ID = z.x.Audit_Type_ID, Audit_Type = z.x.Audit_Type_ID == null || z.x.Audit_Type_ID == "" ? "" : _repoAuditTypeM.FindById(z.x.Audit_Type_ID).Audit_Type1 + "-" + _repoAuditTypeM.FindById(z.x.Audit_Type_ID).Audit_Type2, Before_Picture = z.x.Before_Picture, Finished_Date = z.x.Finished_Date, ERCS = z.x.ERCS, Implement_Time = z.x.Implement_Time, Implement_User = z.x.Implement_User, Issue_EN = z.x.Issue_EN, Issue_LL = z.x.Issue_LL, Issue_ZW = z.x.Issue_ZW, Building = z.y.Building, PDC = z.y.PDC, Line = z.y.Line, Line_Name = t.Line_ID_2_Name, ME_PIC = z.x.ME_PIC, Model_Name = z.y.Model_Name, Model_No = z.y.Model_No, Chief = z.y.Chief, Recorder = z.y.Recorder, Attendees = z.y.Attendees, PD_PIC = z.x.PD_PIC, PD_Department = z.x.PD_Department, PD_Building = z.x.PD_Building, Remark = z.x.Remark, Status = z.x.Status, Item_no = z.x.Item_no, Updated_By = z.x.Updated_By, Updated_Time = z.x.Updated_Time }).ToList(); if (model.Status != "") { listAuditRecDto = listAuditRecDto.Where(x => x.Status.Trim() == model.Status.Trim()).ToList(); } if (model.Building != "") { listAuditRecDto = listAuditRecDto.Where(x => x.Building.Trim() == model.Building.Trim()).ToList(); } if (model.Line != "") { listAuditRecDto = listAuditRecDto.Where(x => x.Line.Trim() == model.Line.Trim()).ToList(); } if (model.PDC != "") { listAuditRecDto = listAuditRecDto.Where(x => x.PDC.Trim() == model.PDC.Trim()).ToList(); } if (model.Model_No != "") { listAuditRecDto = listAuditRecDto.Where(x => x.Model_No.Trim() == model.Model_No.Trim()).ToList(); } if (model.Model_Name != "") { listAuditRecDto = listAuditRecDto.Where(x => x.Model_Name.Trim() == model.Model_Name.Trim()).ToList(); } if (model.Audit_Type_1 != "") { var auditTypeMFind = await _repoAuditTypeM.FindAll(x => x.Audit_Type1.Trim() == model.Audit_Type_1.Trim() && x.Audit_Type2.Trim() == model.Audit_Type_2.Trim()).FirstOrDefaultAsync(); listAuditRecDto = listAuditRecDto.Where(x => x.Audit_Type_ID.Trim() == auditTypeMFind.Audit_Type_ID).ToList(); } listAuditRecDto = listAuditRecDto.Select( x => { x.ME_PIC_Name = GetMePicByID(x.ME_PIC); x.PD_PIC = GetPdPicByID(x.PD_PIC); return(x); }).OrderByDescending(x => x.Record_Time).ThenBy(x => x.Item_no).ToList(); return(PagedList <AuditRecDto> .Create(listAuditRecDto, param.PageNumber, param.PageSize)); }
public async Task <List <AuditRecDto> > SearchExcel(AuditRecSearch model) { var auditTypeMs = await _repoAuditTypeM.GetAll().ToListAsync(); var listAuditRecM = _repoAuditRecM.FindAll(); var listAuditRecD = _repoAuditRecD.FindAll(); var listAuditOrg = _mesAuditOrg.FindAll().Where(x => x.Status == 1); var listAuditRecDto = await listAuditRecD.Join(listAuditRecM, x => x.Record_ID, y => y.Record_ID, (x, y) => new AuditRecDto { Record_ID = x.Record_ID, Record_Time = y.Record_Time, After_Picture = x.After_Picture, Audit_Item = x.Audit_Item, Audit_Type_ID = x.Audit_Type_ID, Audit_Type = x.Audit_Type_ID == null || x.Audit_Type_ID == "" ? "" : _repoAuditTypeM.FindById(x.Audit_Type_ID).Audit_Type1 + "-" + _repoAuditTypeM.FindById(x.Audit_Type_ID).Audit_Type2, Before_Picture = x.Before_Picture, Finished_Date = x.Finished_Date, ERCS = x.ERCS, Implement_Time = x.Implement_Time, Implement_User = x.Implement_User, Issue_EN = x.Issue_EN, Issue_LL = x.Issue_LL, Issue_ZW = x.Issue_ZW, PDC = y.PDC, PDC_Name = listAuditOrg.Where(t => t.PDC_ID == y.PDC).FirstOrDefault().PDC_Name, Line = y.Line, Building = y.Building, ME_PIC = x.ME_PIC, Model_Name = y.Model_Name, Model_No = y.Model_No, Chief = y.Chief, Recorder = y.Recorder, Attendees = y.Attendees, PD_PIC = x.PD_PIC, PD_Department = x.PD_Department, PD_Building = x.PD_Building, Remark = x.Remark, Status = x.Status, Item_no = x.Item_no, Updated_By = x.Updated_By, Updated_Time = x.Updated_Time }).ToListAsync(); listAuditRecDto = listAuditRecDto.Select(x => { x.ME_PIC = GetMePicByID(x.ME_PIC); x.PD_PIC = GetPdPicByID(x.PD_PIC); return(x); }).ToList(); if (model.Status != "") { listAuditRecDto = listAuditRecDto.Where(x => x.Status.Trim() == model.Status.Trim()).ToList(); } if (model.Line != "") { listAuditRecDto = listAuditRecDto.Where(x => x.Line.Trim() == model.Line.Trim()).ToList(); } if (model.From_Date != "" && model.To_Date != "") { listAuditRecDto = listAuditRecDto.Where(x => x.Record_Time >= Convert.ToDateTime(model.From_Date + " 00:00") && x.Record_Time <= Convert.ToDateTime(model.To_Date + " 00:00")).ToList(); } if (model.Model_No != "") { listAuditRecDto = listAuditRecDto.Where(x => x.Model_No.Trim() == model.Model_No.Trim()).ToList(); } if (model.Model_Name != "" && model.Model_Name != string.Empty && model.Model_Name != null) { listAuditRecDto = listAuditRecDto.Where(x => x.Model_Name.Contains(model.Model_Name)).ToList(); } if (model.Audit_Type_1 != "") { // Lấy AuditTypeM Có Version lớn nhất var auditTypeM = auditTypeMs.Where(x => x.Audit_Type_ID.Trim() == model.Audit_Type_1.Trim()).FirstOrDefault(); var auditTypeMVersion = auditTypeMs.Where(x => x.Audit_Kind == auditTypeM.Audit_Kind && x.Audit_Type1 == auditTypeM.Audit_Type1 && x.Audit_Type2 == auditTypeM.Audit_Type2) .OrderByDescending(x => x.Version).FirstOrDefault(); listAuditRecDto = listAuditRecDto.Where(x => x.Audit_Type_ID.Trim() == auditTypeMVersion.Audit_Type_ID).ToList(); } return(listAuditRecDto); }