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