public async Task <PbxExcelMappingAC> GetPbxExcelMappingById(long excelMappingId) { try { PbxExcelMappingAC excelMapping = new PbxExcelMappingAC(); MappingexcelPbx mapExcel = new MappingexcelPbx(); mapExcel = await _dbTeleBilling_V01Context.MappingexcelPbx.Include(x => x.Device).FirstOrDefaultAsync(x => x.Id == excelMappingId); if (mapExcel != null) { excelMapping.Id = mapExcel.Id; excelMapping.Device = mapExcel.Device.Name; excelMapping.DeviceId = mapExcel.Device.Id; excelMapping.HaveHeader = mapExcel.HaveHeader; excelMapping.HaveTitle = mapExcel.HaveTitle; excelMapping.TitleName = mapExcel.TitleName; excelMapping.WorkSheetNo = mapExcel.WorkSheetNo; excelMapping.ExcelColumnNameForTitle = mapExcel.ExcelColumnNameForTitle; excelMapping.ExcelReadingColumn = mapExcel.ExcelReadingColumn; // sweta List <MappingServiceTypeFieldAC> dbfieldlst = new List <MappingServiceTypeFieldAC>(); List <MappingservicetypefieldPbx> lstofMappingColmns = new List <MappingservicetypefieldPbx>(); lstofMappingColmns = await _dbTeleBilling_V01Context.MappingservicetypefieldPbx.Where(x => x.DeviceId == mapExcel.DeviceId).ToListAsync(); List <MappingexcelcolumnPbx> mapexcelcolumn = await _dbTeleBilling_V01Context.MappingexcelcolumnPbx.Where(x => x.MappingExcelId == excelMappingId).ToListAsync(); foreach (var item in lstofMappingColmns) { MappingServiceTypeFieldAC dbfield = new MappingServiceTypeFieldAC(); var objMapexcelcolumn = mapexcelcolumn.FirstOrDefault(x => x.MappingServiceTypeFieldId == item.Id); if (objMapexcelcolumn != null) { dbfield.ColumnAddress = objMapexcelcolumn.ExcelcolumnName; dbfield.FormatField = objMapexcelcolumn.FormatField; } dbfield.Id = item.Id; dbfield.DisplayFieldName = item.DisplayFieldName; dbfield.IsRequired = item.IsRequired; dbfield.IsSpecial = item.IsSpecial; dbfieldlst.Add(dbfield); } excelMapping.dbfieldList = dbfieldlst; // ................................ //List<MappingexcelcolumnPbx> mapexcelcolumn = new List<MappingexcelcolumnPbx>(); //mapexcelcolumn = await _dbTeleBilling_V01Context.MappingexcelcolumnPbx.Include(x => x.MappingServiceTypeField).Where(x => x.MappingExcelId == mapExcel.Id).OrderBy(x => x.MappingServiceTypeField.DisplayOrder).ToListAsync(); //List<MappingServiceTypeFieldAC> dbfieldlst = new List<MappingServiceTypeFieldAC>(); //foreach (var item in mapexcelcolumn) //{ // MappingServiceTypeFieldAC dbfield = new MappingServiceTypeFieldAC(); // dbfield.Id = item.MappingServiceTypeFieldId; // dbfield.ColumnAddress = item.ExcelcolumnName; // dbfield.DisplayFieldName = item.MappingServiceTypeField.DisplayFieldName; // dbfield.IsRequired = item.MappingServiceTypeField.IsRequired; // dbfield.IsSpecial = item.MappingServiceTypeField.IsSpecial; // dbfield.FormatField = item.FormatField; // dbfieldlst.Add(dbfield); //} //excelMapping.dbfieldList = dbfieldlst; return(excelMapping); } } catch (Exception e) { return(new PbxExcelMappingAC()); } return(new PbxExcelMappingAC()); }
public async Task <ExcelMappingAC> GetExcelMappingById(long excelMappingId) { try { ExcelMappingAC excelMapping = new ExcelMappingAC(); Mappingexcel mapExcels = new Mappingexcel(); var mappingData = await _dbTeleBilling_V01Context.Mappingexcel.FirstOrDefaultAsync(x => x.Id == excelMappingId); var mapExcel = await _dbTeleBilling_V01Context.Mappingexcel.Include(x => x.Provider).Include(x => x.ServiceType).FirstOrDefaultAsync(x => x.Id == excelMappingId); if (mapExcel != null) { excelMapping.Id = mapExcel.Id; excelMapping.Provider = mapExcel.Provider.Name; excelMapping.ServiceType = mapExcel.ServiceType.Name; excelMapping.ProviderId = mapExcel.ProviderId; excelMapping.ServiceTypeId = mapExcel.ServiceTypeId; excelMapping.HaveHeader = mapExcel.HaveHeader; excelMapping.HaveTitle = mapExcel.HaveTitle; excelMapping.TitleName = mapExcel.TitleName; excelMapping.WorkSheetNo = mapExcel.WorkSheetNo; excelMapping.ExcelColumnNameForTitle = mapExcel.ExcelColumnNameForTitle; excelMapping.ExcelReadingColumn = mapExcel.ExcelReadingColumn; List <Mappingexcel> CommonMappingData = new List <Mappingexcel>(); CommonMappingData = await _dbTeleBilling_V01Context.Mappingexcel.Include(x => x.ServiceType).Where(x => x.MappedMappingId == excelMappingId && x.MappedServiceTypeId == mapExcel.ServiceTypeId && x.IsCommonMapped == true).ToListAsync(); if (CommonMappingData != null) { if (CommonMappingData.Count() > 0) { string joined = string.Join(",", CommonMappingData.Select(x => x.ServiceType.Name).ToArray()); var ServiceTypeIdInline = from pro in CommonMappingData select new DrpResponseAC() { Name = pro.ServiceType.Name, Id = pro.ServiceType.Id }; excelMapping.ServiceTypeIdInline = ServiceTypeIdInline.ToList(); excelMapping.ServiceTypesInline = joined; } } List <MappingServiceTypeFieldAC> dbfieldlst = new List <MappingServiceTypeFieldAC>(); List <Mappingservicetypefield> lstofMappingServiceType = await _dbTeleBilling_V01Context.Mappingservicetypefield.Where(x => x.ServiceTypeId == mapExcel.ServiceTypeId).ToListAsync(); List <Mappingexcelcolumn> mapexcelcolumn = await _dbTeleBilling_V01Context.Mappingexcelcolumn.Where(x => x.MappingExcelId == excelMappingId).ToListAsync(); foreach (var item in lstofMappingServiceType) { MappingServiceTypeFieldAC dbfield = new MappingServiceTypeFieldAC(); var objMapexcelcolumn = mapexcelcolumn.FirstOrDefault(x => x.MappingServiceTypeFieldId == item.Id); if (objMapexcelcolumn != null) { dbfield.ColumnAddress = objMapexcelcolumn.ExcelcolumnName; dbfield.FormatField = objMapexcelcolumn.FormatField; } dbfield.Id = item.Id; dbfield.DisplayFieldName = item.DisplayFieldName; dbfield.IsRequired = item.IsRequired; dbfield.IsSpecial = item.IsSpecial; dbfieldlst.Add(dbfield); } excelMapping.dbfieldList = dbfieldlst; return(excelMapping); } } catch (Exception e) { return(new ExcelMappingAC()); } return(new ExcelMappingAC()); }