public async Task <AssignTelephoneDetailAC> GetAssignedTelephoneById(long id) { AssignTelephoneDetailAC assignTelephoneDetailAC = new AssignTelephoneDetailAC(); Telephonenumberallocation telephoneNumberAllocation = await _dbTeleBilling_V01Context.Telephonenumberallocation.Include(x => x.Employee).Include(x => x.TelephoneNumberNavigation).Include(x => x.TelephoneNumberNavigation.Provider).Include(x => x.Employee.Department).FirstAsync(x => x.Id == id); assignTelephoneDetailAC = _mapper.Map(telephoneNumberAllocation, assignTelephoneDetailAC); assignTelephoneDetailAC.EmployeeData = new EmployeeAC(); assignTelephoneDetailAC.TelephoneNumberData = new TelephoneNumberAC(); assignTelephoneDetailAC.EmployeeData.Department = telephoneNumberAllocation.Employee.Department.Name; assignTelephoneDetailAC.EmployeeData.EmpPfnumber = telephoneNumberAllocation.EmpPfnumber; assignTelephoneDetailAC.EmployeeData.UserId = telephoneNumberAllocation.EmployeeId; assignTelephoneDetailAC.EmployeeData.FullName = telephoneNumberAllocation.Employee.FullName; assignTelephoneDetailAC.AssignTypeId = telephoneNumberAllocation.AssignTypeId; assignTelephoneDetailAC.TelephoneNumberData.Id = telephoneNumberAllocation.TelephoneNumberId; assignTelephoneDetailAC.TelephoneNumberData.TelephoneNumber1 = telephoneNumberAllocation.TelephoneNumber; assignTelephoneDetailAC.TelephoneNumberData.ProviderId = telephoneNumberAllocation.TelephoneNumberNavigation.ProviderId; assignTelephoneDetailAC.TelephoneNumberData.ProviderName = telephoneNumberAllocation.TelephoneNumberNavigation.Provider.Name; List <Telephonenumberallocationpackage> telePhoneNumberAllocationPackages = await _dbTeleBilling_V01Context.Telephonenumberallocationpackage.Where(x => x.TelephoneNumberAllocationId == telephoneNumberAllocation.Id && !x.IsDelete).ToListAsync(); assignTelephoneDetailAC.TelePhonePackageDetails = _mapper.Map <List <TelePhonePackageDetails> >(telePhoneNumberAllocationPackages); return(assignTelephoneDetailAC); }
public async Task <bool> DeleteAssignedTelephone(long userId, long id, string loginUserName) { Telephonenumberallocation telephonenumberallocation = await _dbTeleBilling_V01Context.Telephonenumberallocation.FirstAsync(x => x.Id == id); int employeeBillStatus = Convert.ToInt16(EnumList.EmployeeBillStatus.CloseBill); if (!await _dbTeleBilling_V01Context.Employeebillmaster.AnyAsync(x => !x.IsDelete && x.EmployeeBillStatus != employeeBillStatus && x.TelephoneNumber == telephonenumberallocation.TelephoneNumber)) { telephonenumberallocation.IsDelete = true; telephonenumberallocation.UpdatedBy = userId; telephonenumberallocation.UpdatedDate = DateTime.Now; _dbTeleBilling_V01Context.Update(telephonenumberallocation); await _dbTeleBilling_V01Context.SaveChangesAsync(); List <Telephonenumberallocationpackage> telephonenumberallocationpackages = await _dbTeleBilling_V01Context.Telephonenumberallocationpackage.Where(x => x.TelephoneNumberAllocationId == id && !x.IsDelete).ToListAsync(); if (telephonenumberallocationpackages.Any()) { telephonenumberallocationpackages = telephonenumberallocationpackages.Select(c => { c.IsDelete = true; c.UpdatedBy = userId; c.UpdatedDate = DateTime.Now; return(c); }).ToList(); _dbTeleBilling_V01Context.UpdateRange(telephonenumberallocationpackages); await _dbTeleBilling_V01Context.SaveChangesAsync(); } await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.DeleteAssignTelephone, loginUserName, userId, "Assign Telephone(" + telephonenumberallocation.TelephoneNumber + ")", (int)EnumList.ActionTemplateTypes.Delete, telephonenumberallocation.Id); return(true); } return(false); }
public async Task <List <TelephoneNumberAC> > GetNumberList(string number, long id) { List <TelephoneNumberAC> lstTelePhoneNmber = new List <TelephoneNumberAC>(); if (!string.IsNullOrEmpty(number)) { lstTelePhoneNmber = await(from tn in _dbTeleBilling_V01Context.Telephonenumber.Include(x => x.Provider) join tnx in _dbTeleBilling_V01Context.Telephonenumberallocation.Where(x => !x.IsDelete).ToList() on tn.TelephoneNumber1 equals tnx.TelephoneNumber into numberInfo from numbers in numberInfo.DefaultIfEmpty() where tn.TelephoneNumber1.Contains(number) && (numbers.TelephoneNumber == null) && !tn.IsDelete && tn.IsActive orderby tn.CreatedDate descending select new TelephoneNumberAC { Id = tn.Id, TelephoneNumber1 = tn.TelephoneNumber1, IsDelete = numbers.IsDelete, ProviderName = tn.Provider.Name, ProviderId = tn.ProviderId }).Take(10).ToListAsync(); if (id != 0 && lstTelePhoneNmber.Any()) {//When call on edit mode at that time already assigned telephone number is added on list Telephonenumberallocation telephoneAllocation = await _dbTeleBilling_V01Context.Telephonenumberallocation.FirstOrDefaultAsync(x => x.Id == id); TelephoneNumberAC telNumber = new TelephoneNumberAC(); telNumber.Id = telephoneAllocation.TelephoneNumberId; telNumber.TelephoneNumber1 = telephoneAllocation.TelephoneNumber; lstTelePhoneNmber.Add(telNumber); } } return(lstTelePhoneNmber.OrderByDescending(x => x.Id).ToList()); }
public async Task <ResponseAC> UpdateAssignedTelephone(long userId, AssignTelephoneDetailAC assignTelephoneDetailAC, string loginUserName) { ResponseAC responseAC = new ResponseAC(); Telephonenumberallocation telephoneNumberAllocation = await _dbTeleBilling_V01Context.Telephonenumberallocation.FirstAsync(x => x.Id == assignTelephoneDetailAC.Id); #region Transaction Log Entry if (telephoneNumberAllocation.TransactionId == null) { telephoneNumberAllocation.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID(); } var jsonSerailzeObj = JsonConvert.SerializeObject(telephoneNumberAllocation); await _iLogManagement.SaveRequestTraseLog(Convert.ToInt64(telephoneNumberAllocation.TransactionId), userId, Convert.ToInt64(EnumList.TransactionTraseLog.UpdateRecord), jsonSerailzeObj); #endregion telephoneNumberAllocation = _mapper.Map(assignTelephoneDetailAC, telephoneNumberAllocation); telephoneNumberAllocation.UpdatedBy = userId; telephoneNumberAllocation.UpdatedDate = DateTime.Now; _dbTeleBilling_V01Context.Update(telephoneNumberAllocation); await _dbTeleBilling_V01Context.SaveChangesAsync(); List <Telephonenumberallocationpackage> telePhoneNumberAllocationPackages = await _dbTeleBilling_V01Context.Telephonenumberallocationpackage.Where(x => x.TelephoneNumberAllocationId == telephoneNumberAllocation.Id && !x.IsDelete).ToListAsync(); foreach (var item in telePhoneNumberAllocationPackages) { item.IsDelete = true; item.UpdatedBy = userId; item.UpdatedDate = DateTime.Now; } _dbTeleBilling_V01Context.UpdateRange(telePhoneNumberAllocationPackages); _dbTeleBilling_V01Context.SaveChanges(); #region Update Packages telePhoneNumberAllocationPackages = new List <Telephonenumberallocationpackage>(); foreach (var item in assignTelephoneDetailAC.TelePhonePackageDetails) { Telephonenumberallocationpackage telePhoneNumberAllocationPackage = new Telephonenumberallocationpackage(); telePhoneNumberAllocationPackage.PackageId = item.PackageId; telePhoneNumberAllocationPackage.ServiceId = item.ServiceId; telePhoneNumberAllocationPackage.StartDate = item.StartDate.AddDays(1); telePhoneNumberAllocationPackage.EndDate = item.EndDate.AddDays(1); telePhoneNumberAllocationPackage.TelephoneNumberAllocationId = telephoneNumberAllocation.Id; telePhoneNumberAllocationPackages.Add(telePhoneNumberAllocationPackage); } await _dbTeleBilling_V01Context.AddRangeAsync(telePhoneNumberAllocationPackages); await _dbTeleBilling_V01Context.SaveChangesAsync(); #endregion await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.EditAssignTelephone, loginUserName, userId, "Assign Telephone(" + telephoneNumberAllocation.TelephoneNumber + ")", (int)EnumList.ActionTemplateTypes.Edit, telephoneNumberAllocation.Id); responseAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success); responseAC.Message = _iStringConstant.AssignedTelePhoneEditSuccessfully; return(responseAC); }
public async Task <bool> ChangeTelephoneStatus(long userId, long id, string loginUserName) { Telephonenumber telephoneNumber = await _dbTeleBilling_V01Context.Telephonenumber.FirstOrDefaultAsync(x => x.Id == id); #region telephone already assigned it will not deactivated. if (telephoneNumber.IsActive) { Telephonenumberallocation telephonenumberallocation = await _dbTeleBilling_V01Context.Telephonenumberallocation.FirstOrDefaultAsync(x => !x.IsDelete && x.IsActive && x.TelephoneNumberId == id); if (telephonenumberallocation != null) { return(false); } } #endregion #region Transaction Log Entry if (telephoneNumber.TransactionId == null) { telephoneNumber.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID(); } var jsonSerailzeObj = JsonConvert.SerializeObject(telephoneNumber); await _iLogManagement.SaveRequestTraseLog(Convert.ToInt64(telephoneNumber.TransactionId), userId, Convert.ToInt64(EnumList.TransactionTraseLog.ChangeStatus), jsonSerailzeObj); #endregion telephoneNumber.IsActive = !telephoneNumber.IsActive; telephoneNumber.UpdatedBy = userId; telephoneNumber.UpdatedDate = DateTime.Now; _dbTeleBilling_V01Context.Update(telephoneNumber); await _dbTeleBilling_V01Context.SaveChangesAsync(); if (telephoneNumber.IsActive) { await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.ActiveTelephone, loginUserName, userId, "Telephone(" + telephoneNumber.TelephoneNumber1 + ")", (int)EnumList.ActionTemplateTypes.Active, telephoneNumber.Id); } else { await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.DeactiveTelephone, loginUserName, userId, "Telephone(" + telephoneNumber.TelephoneNumber1 + ")", (int)EnumList.ActionTemplateTypes.Deactive, telephoneNumber.Id); } return(true); }
public async Task <ResponseAC> AddAssignedTelephone(long userId, AssignTelephoneDetailAC assignTelephoneDetailAC, string loginUserName) { ResponseAC responseAC = new ResponseAC(); try { Telephonenumberallocation telephoneNumberAllocation = _mapper.Map <Telephonenumberallocation>(assignTelephoneDetailAC); telephoneNumberAllocation.CreatedBy = userId; telephoneNumberAllocation.CreatedDate = DateTime.Now; telephoneNumberAllocation.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID(); telephoneNumberAllocation.IsActive = true; await _dbTeleBilling_V01Context.AddAsync(telephoneNumberAllocation); await _dbTeleBilling_V01Context.SaveChangesAsync(); List <Telephonenumberallocationpackage> telePhoneNumberAllocationPackages = new List <Telephonenumberallocationpackage>(); foreach (var item in assignTelephoneDetailAC.TelePhonePackageDetails) { Telephonenumberallocationpackage telePhoneNumberAllocationPackage = new Telephonenumberallocationpackage(); telePhoneNumberAllocationPackage.PackageId = item.PackageId; telePhoneNumberAllocationPackage.ServiceId = item.ServiceId; telePhoneNumberAllocationPackage.StartDate = item.StartDate.AddDays(1); telePhoneNumberAllocationPackage.EndDate = item.EndDate.AddDays(1); telePhoneNumberAllocationPackage.TelephoneNumberAllocationId = telephoneNumberAllocation.Id; telePhoneNumberAllocationPackages.Add(telePhoneNumberAllocationPackage); } await _dbTeleBilling_V01Context.AddRangeAsync(telePhoneNumberAllocationPackages); await _dbTeleBilling_V01Context.SaveChangesAsync(); await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AssignTelephone, loginUserName, userId, "Assign Telephone(" + telephoneNumberAllocation.TelephoneNumber + ")", (int)EnumList.ActionTemplateTypes.Assign, telephoneNumberAllocation.Id); responseAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success); responseAC.Message = _iStringConstant.TelephoneAssignedSuccessfully; } catch (Exception ex) { throw ex; } return(responseAC); }
public async Task <BulkAssignTelephoneResponseAC> UploadBulkAssignTelePhone(long userId, ExcelUploadResponseAC exceluploadDetail, string loginUserName) { BulkAssignTelephoneResponseAC bulkAssignTelephoneResponseAC = new BulkAssignTelephoneResponseAC(); List <ExcelUploadResult> excelUploadResultList = new List <ExcelUploadResult>(); FileInfo fileinfo = new FileInfo(Path.Combine(exceluploadDetail.FilePath, exceluploadDetail.FileNameGuid)); try { using (ExcelPackage package = new ExcelPackage(fileinfo)) { for (int i = 1; i <= package.Workbook.Worksheets.Count(); i++) { ExcelWorksheet workSheet = package.Workbook.Worksheets[i]; string sheetName = package.Workbook.Worksheets[i].Name; int totalRows = workSheet.Dimension.Rows; int totalColums = workSheet.Dimension.Columns; for (int j = 1; j <= totalRows - 1; j++) { string mobileNumber = workSheet.Cells[j + 1, 1].Value != null ? workSheet.Cells[j + 1, 1].Value.ToString() : string.Empty; string assignType = workSheet.Cells[j + 1, 2].Value != null ? workSheet.Cells[j + 1, 2].Value.ToString() : string.Empty; string pfNumber = workSheet.Cells[j + 1, 3].Value != null ? workSheet.Cells[j + 1, 3].Value.ToString() : string.Empty; string packageName = workSheet.Cells[j + 1, 4].Value != null ? workSheet.Cells[j + 1, 4].Value.ToString() : string.Empty; string startDate = workSheet.Cells[j + 1, 5].Value != null ? workSheet.Cells[j + 1, 5].Value.ToString() : string.Empty; string endDate = workSheet.Cells[j + 1, 6].Value != null ? workSheet.Cells[j + 1, 6].Value.ToString() : string.Empty; if (!string.IsNullOrEmpty(mobileNumber) && !string.IsNullOrEmpty(assignType) && !string.IsNullOrEmpty(pfNumber) && !string.IsNullOrEmpty(startDate) && !string.IsNullOrEmpty(packageName) && !string.IsNullOrEmpty(endDate)) { Telephonenumberallocation telephoneNumberAllocation = new Telephonenumberallocation(); Telephonenumberallocationpackage telePhoneNumberAllocationPackage = new Telephonenumberallocationpackage(); bulkAssignTelephoneResponseAC.TotalRecords += 1; Telephonenumber telephoneNumber = await _dbTeleBilling_V01Context.Telephonenumber.FirstOrDefaultAsync(x => x.TelephoneNumber1.ToLower().Trim() == mobileNumber.ToLower().Trim() && x.IsActive && !x.IsDelete); if (telephoneNumber != null) { FixAssigntype fixAssigntype = await _dbTeleBilling_V01Context.FixAssigntype.FirstOrDefaultAsync(x => x.IsActive && x.Name == assignType); if (fixAssigntype != null) { MstEmployee mstEmployee = await _dbTeleBilling_V01Context.MstEmployee.FirstOrDefaultAsync(x => x.IsActive && !x.IsDelete && x.EmpPfnumber.ToLower().Trim() == pfNumber.ToLower().Trim()); if (mstEmployee != null) { Providerpackage providerPackage = await _dbTeleBilling_V01Context.Providerpackage.FirstOrDefaultAsync(x => x.IsActive && !x.IsDelete && x.Name.ToLower().Trim() == packageName.ToLower().Trim()); if (providerPackage != null) { if (!string.IsNullOrEmpty(startDate)) { if (!string.IsNullOrEmpty(endDate)) { DateTime newStartDate; DateTime newEndDate; if (DateTime.TryParse(startDate, out newStartDate)) { String.Format("{0:d/MM/yyyy}", newStartDate); if (DateTime.TryParse(endDate, out newEndDate)) { String.Format("{0:d/MM/yyyy}", newEndDate); string lineStatus = workSheet.Cells[j + 1, 7].Value != null ? workSheet.Cells[j + 1, 7].Value.ToString() : ""; FixLinestatus fixLineStatus = await _dbTeleBilling_V01Context.FixLinestatus.FirstOrDefaultAsync(x => x.IsActive && x.Name.ToLower().Trim() == lineStatus.ToLower().Trim()); if (fixLineStatus != null) { if (telephoneNumber.ProviderId == providerPackage.ProviderId) { Telephonenumberallocation newTelephoneNumberAllocation = _dbTeleBilling_V01Context.Telephonenumberallocation.FirstOrDefault(x => x.TelephoneNumberId == telephoneNumber.Id && !x.IsDelete); if (newTelephoneNumberAllocation != null) { Telephonenumberallocationpackage newTelePhoneNumberAllocationPackage = await _dbTeleBilling_V01Context.Telephonenumberallocationpackage.FirstOrDefaultAsync(x => x.TelephoneNumberAllocationId == newTelephoneNumberAllocation.Id && x.PackageId == providerPackage.Id && !x.IsDelete); if (newTelePhoneNumberAllocationPackage == null) { newTelePhoneNumberAllocationPackage = new Telephonenumberallocationpackage(); newTelePhoneNumberAllocationPackage.ServiceId = providerPackage.ServiceTypeId; newTelePhoneNumberAllocationPackage.StartDate = newStartDate; newTelePhoneNumberAllocationPackage.EndDate = newEndDate; newTelePhoneNumberAllocationPackage.PackageId = providerPackage.Id; bulkAssignTelephoneResponseAC.SuccessRecords += 1; newTelePhoneNumberAllocationPackage.TelephoneNumberAllocationId = newTelephoneNumberAllocation.Id; await _dbTeleBilling_V01Context.AddAsync(newTelePhoneNumberAllocationPackage); await _dbTeleBilling_V01Context.SaveChangesAsync(); await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AssignBulkTelephone, loginUserName, userId, "Telephone Assign(" + newTelephoneNumberAllocation.TelephoneNumber + ")", (int)EnumList.ActionTemplateTypes.Upload, newTelephoneNumberAllocation.Id); } else { //TelphoneNumbeAlready Assigned bulkAssignTelephoneResponseAC.SkipRecords += 1; string message = _iStringConstant.TelphoneNumberPackageAlreadyAssigned.Replace("{{$telephonenumber$}}", mobileNumber); excelUploadResultList = AddedFileDataResponse(1, j + 1, packageName, message, sheetName, excelUploadResultList); } } else { telephoneNumberAllocation.EmployeeId = mstEmployee.UserId; telephoneNumberAllocation.EmpPfnumber = mstEmployee.EmpPfnumber; telephoneNumberAllocation.TelephoneNumberId = telephoneNumber.Id; telephoneNumberAllocation.TelephoneNumber = telephoneNumber.TelephoneNumber1; telephoneNumberAllocation.LineStatusId = fixLineStatus.Id; telephoneNumberAllocation.IsActive = true; telephoneNumberAllocation.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID(); telephoneNumberAllocation.CreatedBy = userId; telephoneNumberAllocation.CreatedDate = DateTime.Now; telephoneNumberAllocation.AssignTypeId = fixAssigntype.Id; bulkAssignTelephoneResponseAC.SuccessRecords += 1; await _dbTeleBilling_V01Context.AddAsync(telephoneNumberAllocation); await _dbTeleBilling_V01Context.SaveChangesAsync(); telePhoneNumberAllocationPackage.ServiceId = providerPackage.ServiceTypeId; telePhoneNumberAllocationPackage.StartDate = newStartDate; telePhoneNumberAllocationPackage.EndDate = newEndDate; telePhoneNumberAllocationPackage.PackageId = providerPackage.Id; telePhoneNumberAllocationPackage.TelephoneNumberAllocationId = telephoneNumberAllocation.Id; await _dbTeleBilling_V01Context.AddAsync(telePhoneNumberAllocationPackage); await _dbTeleBilling_V01Context.SaveChangesAsync(); await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AssignBulkTelephone, loginUserName, userId, "Telephone Assign(" + newTelephoneNumberAllocation.TelephoneNumber + ")", (int)EnumList.ActionTemplateTypes.Upload, newTelephoneNumberAllocation.Id); } } else { //Packge not same bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(4, j + 1, "Given package not valid for mobilenumber(" + mobileNumber + ")", _iStringConstant.PackageNotMatchWithTelephoneNumber, sheetName, excelUploadResultList); } } else { //LineStatus Not Exists bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(7, j + 1, lineStatus, _iStringConstant.LineStatusNotExists, sheetName, excelUploadResultList); } } else { //End Date Not Valid bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(6, j + 1, endDate, _iStringConstant.EndDateNotValid, sheetName, excelUploadResultList); } } else { //Start Date Not Valid bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(5, j + 1, startDate, _iStringConstant.StartDateNotValid, sheetName, excelUploadResultList); } } else { //End Date Is Empty bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(6, j + 1, endDate, _iStringConstant.EndDateIsEmpty, sheetName, excelUploadResultList); } } else { //Start Date Is Empty bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(5, j, startDate, _iStringConstant.StartDateIsEmpty, sheetName, excelUploadResultList); } } else { //Package Not Exists bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(4, j + 1, packageName, _iStringConstant.PackageNotExists, sheetName, excelUploadResultList); } } else { //Employee Not Exists bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(3, j, pfNumber, _iStringConstant.EmployeeNotExists, sheetName, excelUploadResultList); } //else //{ //TelphoneNumbeAlready Assigned //bulkAssignTelephoneResponseAC.SkipRecords += 1; //excelUploadResultList = AddedFileDataResponse(1, j + 1, mobileNumber, _iStringConstant.TelphoneNumberAlreadyAssigned, sheetName, excelUploadResultList); //} } else { //Employee Not Exists bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(2, j, assignType, _iStringConstant.AssignTypeNotExists, sheetName, excelUploadResultList); } } else { //PhoneNumber Not Exists bulkAssignTelephoneResponseAC.SkipRecords += 1; excelUploadResultList = AddedFileDataResponse(1, j + 1, mobileNumber, _iStringConstant.PhoneNumberNotExists, sheetName, excelUploadResultList); } } } } } if (File.Exists(Path.Combine(exceluploadDetail.FilePath, exceluploadDetail.FileNameGuid))) { File.Delete(Path.Combine(exceluploadDetail.FilePath, exceluploadDetail.FileNameGuid)); } bulkAssignTelephoneResponseAC.excelUploadResultList = excelUploadResultList; return(bulkAssignTelephoneResponseAC); } catch (Exception ex) { if (File.Exists(Path.Combine(exceluploadDetail.FilePath, exceluploadDetail.FileNameGuid))) { File.Delete(Path.Combine(exceluploadDetail.FilePath, exceluploadDetail.FileNameGuid)); } throw ex; } }