public async Task <IActionResult> EditPbxExcelMapping(PbxExcelMappingAC excelMappingAC)
{
string userId = "2";// HttpContext.User.Claims.FirstOrDefault(c => c.Type == "user_id").Value;
string fullname = HttpContext.User.Claims.FirstOrDefault(c => c.Type == "fullname").Value;
return(Ok(await _iExcelMappingRepository.EditPbxExcelMapping(excelMappingAC, Convert.ToInt64(userId), fullname)));
}
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 <ResponseAC> EditPbxExcelMapping(PbxExcelMappingAC excelMappingAC, long userId, string loginUserName)
{
ResponseAC responeAC = new ResponseAC();
try
{
if (excelMappingAC.dbfieldList.Count() == 0)
{
responeAC.Message = "Mapping Column Is Missing";
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
return(responeAC);
}
MappingexcelPbx mappingexcel = new MappingexcelPbx();
mappingexcel = await _dbTeleBilling_V01Context.MappingexcelPbx.FirstOrDefaultAsync(x => x.DeviceId == excelMappingAC.DeviceId && !x.IsDelete && x.Id == excelMappingAC.Id);
if (mappingexcel != null && mappingexcel.Id > 0)
{
#region Transaction Log Entry
if (mappingexcel.TransactionId == null)
{
mappingexcel.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
}
var jsonSerailzeObj = JsonConvert.SerializeObject(mappingexcel);
await _iLogManagement.SaveRequestTraseLog(Convert.ToInt64(mappingexcel.TransactionId), userId, Convert.ToInt64(EnumList.TransactionTraseLog.UpdateRecord), jsonSerailzeObj);
#endregion
mappingexcel.HaveHeader = excelMappingAC.HaveHeader;
mappingexcel.HaveTitle = excelMappingAC.HaveTitle;
mappingexcel.TitleName = excelMappingAC.TitleName;
mappingexcel.WorkSheetNo = Convert.ToInt64(excelMappingAC.WorkSheetNo);
mappingexcel.ExcelColumnNameForTitle = string.IsNullOrEmpty(excelMappingAC.ExcelColumnNameForTitle) ? "" : excelMappingAC.ExcelColumnNameForTitle;
mappingexcel.ExcelReadingColumn = string.IsNullOrEmpty(excelMappingAC.ExcelReadingColumn) ? "0" : excelMappingAC.ExcelReadingColumn;
mappingexcel.UpdatedBy = userId;
mappingexcel.UpdatedDate = DateTime.Now;
_dbTeleBilling_V01Context.Update(mappingexcel);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responeAC.Message = _iStringConstant.ExcelMappingUpdatedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.EditPbxExcelMapping, loginUserName, userId, "PBX Excel mapping", (int)EnumList.ActionTemplateTypes.Edit, mappingexcel.Id);
if (mappingexcel.Id > 0)
{
#region --> Update Mapping column Details
if (excelMappingAC.dbfieldList.Count() > 0)
{
#region --> remove old Mapping
List <MappingexcelcolumnPbx> excelcolumnlst = new List <MappingexcelcolumnPbx>();
excelcolumnlst = await _dbTeleBilling_V01Context.MappingexcelcolumnPbx.Where(x => x.MappingExcelId == mappingexcel.Id).ToListAsync();
if (excelcolumnlst != null)
{
if (excelcolumnlst.Count() > 0)
{
_dbTeleBilling_V01Context.RemoveRange(excelcolumnlst);
await _dbTeleBilling_V01Context.SaveChangesAsync();
}
}
#endregion
List <MappingexcelcolumnPbx> mappingExcelColumnslst = new List <MappingexcelcolumnPbx>();
foreach (var item in excelMappingAC.dbfieldList)
{
if (!string.IsNullOrEmpty(item.ColumnAddress))
{
MappingexcelcolumnPbx excelColumn = new MappingexcelcolumnPbx();
excelColumn.MappingExcelId = mappingexcel.Id;
excelColumn.MappingServiceTypeFieldId = item.Id;
excelColumn.ExcelcolumnName = item.ColumnAddress;
excelColumn.FormatField = item.FormatField;
mappingExcelColumnslst.Add(excelColumn);
}
}
await _dbTeleBilling_V01Context.AddRangeAsync(mappingExcelColumnslst);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responeAC.Message = _iStringConstant.ExcelMappingUpdatedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
}
#endregion
}
}
else
{
responeAC.Message = _iStringConstant.DataFound;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
}
return(responeAC);
}
catch (Exception e)
{
responeAC.Message = e.Message.ToString();
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
return(responeAC);
}
}
public async Task <ResponseAC> AddPbxExcelMapping(PbxExcelMappingAC excelMappingAC, long userId, string loginUserName)
{
ResponseAC responeAC = new ResponseAC();
try
{
if (excelMappingAC.dbfieldList.Count() == 0)
{
responeAC.Message = "Mapping Column Is Missing";
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
return(responeAC);
}
if (!await _dbTeleBilling_V01Context.MappingexcelPbx.AnyAsync(x => x.DeviceId == excelMappingAC.DeviceId && !x.IsDelete))
{
var deviceData = await _dbTeleBilling_V01Context.FixDevice.FirstOrDefaultAsync(x => x.Id == excelMappingAC.DeviceId);
MappingexcelPbx mappingexcel = new MappingexcelPbx();
mappingexcel.Id = 0;
mappingexcel.IsActive = true;
mappingexcel.DeviceId = excelMappingAC.DeviceId;
mappingexcel.CurrencyId = Convert.ToInt32(EnumList.CurrencyType.USD); // as per current files its given in $
mappingexcel.HaveHeader = excelMappingAC.HaveHeader;
mappingexcel.HaveTitle = excelMappingAC.HaveTitle;
mappingexcel.TitleName = excelMappingAC.TitleName;
mappingexcel.WorkSheetNo = Convert.ToInt64(excelMappingAC.WorkSheetNo);
mappingexcel.ExcelColumnNameForTitle = string.IsNullOrEmpty(excelMappingAC.ExcelColumnNameForTitle) ? "" : excelMappingAC.ExcelColumnNameForTitle;
mappingexcel.ExcelReadingColumn = string.IsNullOrEmpty(excelMappingAC.ExcelReadingColumn) ? "0" : excelMappingAC.ExcelReadingColumn;
mappingexcel.CreatedBy = userId;
mappingexcel.CreatedDate = DateTime.Now;
mappingexcel.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
await _dbTeleBilling_V01Context.AddAsync(mappingexcel);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responeAC.Message = _iStringConstant.ExcelMappingAddedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddPbxExcelMapping, loginUserName, userId, "PBX Excel mapping", (int)EnumList.ActionTemplateTypes.Add, mappingexcel.Id);
if (mappingexcel.Id > 0)
{
#region --> ADD Mapping column Details
if (excelMappingAC.dbfieldList.Count() > 0)
{
List <MappingexcelcolumnPbx> mappingExcelColumnslst = new List <MappingexcelcolumnPbx>();
foreach (var item in excelMappingAC.dbfieldList)
{
if (!string.IsNullOrEmpty(item.ColumnAddress))
{
MappingexcelcolumnPbx excelColumn = new MappingexcelcolumnPbx();
excelColumn.MappingExcelId = mappingexcel.Id;
excelColumn.MappingServiceTypeFieldId = item.Id;
excelColumn.ExcelcolumnName = item.ColumnAddress;
excelColumn.FormatField = item.FormatField;
mappingExcelColumnslst.Add(excelColumn);
}
}
await _dbTeleBilling_V01Context.AddRangeAsync(mappingExcelColumnslst);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responeAC.Message = _iStringConstant.ExcelMappingAddedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
}
#endregion
}
}
else
{
responeAC.Message = _iStringConstant.ExcelMappingExists;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
}
return(responeAC);
}
catch (Exception e)
{
responeAC.Message = e.Message.ToString();
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
return(responeAC);
}
}
