public async Task <bool> SaveRequestTraseLog(long TransactionId, long Addedby, long actionId = 0, string description = null)
{
bool result = false;
Requesttracelog requestlog = new Requesttracelog();
try
{
requestlog.TransactionId = TransactionId;
requestlog.CreatedById = Addedby;
//requestlog.IsMobile = HttpContext.Current.Request.Browser.IsMobileDevice;
//requestlog.Browser = HttpContext.Current.Request.Browser.Browser;
requestlog.CreatedDate = DateTime.Now;
requestlog.ActionId = actionId;
requestlog.Description = description;
await _dbTeleBilling_V01Context.AddAsync(requestlog);
await _dbTeleBilling_V01Context.SaveChangesAsync();
result = true;
}
catch (Exception)
{
result = false;
}
return(result);
}
public async Task <ResponseAC> AddTelephone(long userId, TelephoneDetailAC telephoneDetailAC, string loginUserName)
{
ResponseAC responseAC = new ResponseAC();
if (!await _dbTeleBilling_V01Context.Telephonenumber.AnyAsync(x => x.TelephoneNumber1.Trim() == telephoneDetailAC.TelephoneNumber1.Trim() && !x.IsDelete))
{
Telephonenumber telephoneNumber = _mapper.Map <Telephonenumber>(telephoneDetailAC);
telephoneNumber.CreatedBy = userId;
telephoneNumber.CreatedDate = DateTime.Now;
telephoneNumber.IsActive = true;
telephoneNumber.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
await _dbTeleBilling_V01Context.AddAsync(telephoneNumber);
await _dbTeleBilling_V01Context.SaveChangesAsync();
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddTelephone, loginUserName, userId, "Telephone(" + telephoneNumber.TelephoneNumber1 + ")", (int)EnumList.ActionTemplateTypes.Add, telephoneNumber.Id);
responseAC.StatusCode = Convert.ToInt32(EnumList.ResponseType.Success);
responseAC.Message = _iStringConstant.TelphoneAddedSuccessfully;
}
else
{
responseAC.StatusCode = Convert.ToInt32(EnumList.ResponseType.Error);
responseAC.Message = _iStringConstant.TelphoneAlreadyExists;
}
return(responseAC);
}
public async Task <ResponseAC> AddProvider(long userId, ProviderAC providerAC, string loginUserName)
{
ResponseAC responeAC = new ResponseAC();
if (!await _dbTeleBilling_V01Context.Provider.AnyAsync(x => x.ContractNumber.ToLower() == providerAC.ContractNumber.ToLower() && !x.IsDelete))
{
TeleBillingUtility.Models.Provider provider = new TeleBillingUtility.Models.Provider();
provider = _mapper.Map <TeleBillingUtility.Models.Provider>(providerAC);
provider.IsActive = true;
provider.CreatedDate = DateTime.Now;
provider.CreatedBy = userId;
provider.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
await _dbTeleBilling_V01Context.AddAsync(provider);
await _dbTeleBilling_V01Context.SaveChangesAsync();
foreach (var serviceType in providerAC.ServiceTypes)
{
Providerservice providerService = new Providerservice();
providerService.ProviderId = provider.Id;
providerService.ServiceTypeId = serviceType.Id;
await _dbTeleBilling_V01Context.AddAsync(providerService);
await _dbTeleBilling_V01Context.SaveChangesAsync();
}
#region Added Provider Contact Detail
List <Providercontactdetail> providerContactDetails = new List <Providercontactdetail>();
foreach (var item in providerAC.ProviderContactDetailACList)
{
Providercontactdetail providerContectDatail = new Providercontactdetail();
providerContectDatail = _mapper.Map <Providercontactdetail>(item);
providerContectDatail.ProviderId = provider.Id;
providerContactDetails.Add(providerContectDatail);
}
await _dbTeleBilling_V01Context.AddRangeAsync(providerContactDetails);
await _dbTeleBilling_V01Context.SaveChangesAsync();
#endregion
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddProvider, loginUserName, userId, "Provider(" + provider.Name + ")", (int)EnumList.ActionTemplateTypes.Add, provider.Id);
responeAC.Message = _iStringConstant.ProviderAddedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
}
else
{
responeAC.Message = _iStringConstant.ContractNumberExists;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
}
return(responeAC);
}
public async Task <ResponseAC> AddRole(RoleAC roleAC, long userId, string loginUserName)
{
ResponseAC responeAC = new ResponseAC();
if (!await _dbTeleBilling_V01Context.MstRole.AnyAsync(x => x.RoleName.ToLower() == roleAC.RoleName.Trim().ToLower() && !x.IsDelete))
{
MstRole mstRole = new MstRole();
mstRole.IsActive = true;
mstRole.RoleName = roleAC.RoleName.Trim();
mstRole.CreatedBy = userId;
mstRole.CreatedDate = DateTime.Now;
mstRole.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
try
{
await _dbTeleBilling_V01Context.AddAsync(mstRole);
await _dbTeleBilling_V01Context.SaveChangesAsync();
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddRole, loginUserName, userId, "Role(" + roleAC.RoleName.Trim() + ")", (int)EnumList.ActionTemplateTypes.Add, mstRole.RoleId);
}
catch (Exception e)
{
throw e;
}
responeAC.Message = _iStringConstant.RoleAddedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
}
else
{
responeAC.Message = _iStringConstant.RoleExists;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
}
return(responeAC);
}
public async Task <ResponseAC> AddDelegate(BillDelegatesAC billDelegatesAC, long userId, string loginUserName)
{
ResponseAC responeAC = new ResponseAC();
if (await _dbTeleBilling_V01Context.Billdelegate.FirstOrDefaultAsync(x => x.EmployeeId == billDelegatesAC.Employee.UserId && x.DelegateEmployeeId == billDelegatesAC.DelegateEmployee.UserId && !x.IsDelete) == null)
{
TeleBillingUtility.Models.Billdelegate delegateDetail = new TeleBillingUtility.Models.Billdelegate();
delegateDetail.EmployeeId = billDelegatesAC.Employee.UserId;
delegateDetail.DelegateEmployeeId = billDelegatesAC.DelegateEmployee.UserId;
delegateDetail.AllowBillApproval = billDelegatesAC.AllowBillApproval;
delegateDetail.AllowBillIdentification = billDelegatesAC.AllowBillIdentification;
delegateDetail.CreatedBy = userId;
delegateDetail.CreatedDate = DateTime.Now;
delegateDetail.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
await _dbTeleBilling_V01Context.AddAsync(delegateDetail);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responeAC.Message = _iStringConstant.DelegateAddedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddDelegate, loginUserName, userId, "Delegate user", (int)EnumList.ActionTemplateTypes.Add, delegateDetail.Id);
}
else
{
responeAC.Message = _iStringConstant.DelegateAlreadyExists;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
}
return(responeAC);
}
public async Task <ResponseAC> AddTemplate(long userId, TemplateDetailAC templateDetailAC, string loginUserName)
{
ResponseAC responseAC = new ResponseAC();
if (await _dbTeleBilling_V01Context.Emailtemplate.FirstOrDefaultAsync(x => x.EmailTemplateTypeId == templateDetailAC.EmailTemplateTypeId) == null)
{
Emailtemplate emailTemplate = _mapper.Map <Emailtemplate>(templateDetailAC);
emailTemplate.CreatedBy = userId;
emailTemplate.CreatedDate = DateTime.Now;
emailTemplate.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
await _dbTeleBilling_V01Context.AddAsync(emailTemplate);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responseAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
responseAC.Message = _iStringConstant.TemplateAddedSuccessfully;
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddEmailTemplate, loginUserName, userId, "Email template(" + emailTemplate.Subject + ")", (int)EnumList.ActionTemplateTypes.Add, emailTemplate.Id);
}
else
{
responseAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
responseAC.Message = _iStringConstant.TemplateTypeAlreadyExists;
}
return(responseAC);
}
public async Task <ResponseAC> AddHandset(HandsetDetailAC handsetDetailAC, long userId, string loginUserName)
{
ResponseAC responeAC = new ResponseAC();
if (!await _dbTeleBilling_V01Context.MstHandsetdetail.AnyAsync(x => x.Name.ToLower().Trim() == handsetDetailAC.Name.ToLower().Trim() && !x.IsDelete))
{
MstHandsetdetail mstHandsetDetail = new MstHandsetdetail();
mstHandsetDetail.Name = handsetDetailAC.Name.Trim();
mstHandsetDetail.CreatedBy = userId;
mstHandsetDetail.CreatedDate = DateTime.Now;
mstHandsetDetail.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
await _dbTeleBilling_V01Context.AddAsync(mstHandsetDetail);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responeAC.Message = _iStringConstant.HandsetAddedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddHandset, loginUserName, userId, "Handset(" + mstHandsetDetail.Name + ")", (int)EnumList.ActionTemplateTypes.Add, mstHandsetDetail.Id);
}
else
{
responeAC.Message = _iStringConstant.HandsetAlreadyExists;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
}
return(responeAC);
}
private bool SaveRequestTraseLog(long TransactionId, long Addedby, long actionId = 0, string description = null)
{
bool result = false;
Requesttracelog requestlog = new Requesttracelog();
try
{
using (var _dbTeleBillingContext = new telebilling_v01Context())
{
requestlog.TransactionId = TransactionId;
requestlog.CreatedById = Addedby;
requestlog.CreatedDate = DateTime.Now;
requestlog.ActionId = actionId;
requestlog.Description = description;
_dbTeleBillingContext.AddAsync(requestlog);
_dbTeleBillingContext.SaveChangesAsync();
}
result = true;
}
catch (Exception)
{
result = false;
}
return(result);
}
public async Task <ResponseAC> AddPackage(long userId, PackageDetailAC packageDetailAC, string loginUserName)
{
ResponseAC responseAC = new ResponseAC();
if (!await _dbTeleBilling_V01Context.Providerpackage.AnyAsync(x => x.Name.ToLower() == packageDetailAC.Name.ToLower() && !x.IsDelete))
{
Providerpackage providerPackage = new Providerpackage();
providerPackage = _mapper.Map <Providerpackage>(packageDetailAC);
providerPackage.CreatedBy = userId;
providerPackage.IsActive = true;
providerPackage.CreatedDate = DateTime.Now;
providerPackage.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
await _dbTeleBilling_V01Context.AddAsync(providerPackage);
await _dbTeleBilling_V01Context.SaveChangesAsync();
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddPackage, loginUserName, userId, "Package(" + providerPackage.Name + ")", (int)EnumList.ActionTemplateTypes.Add, providerPackage.Id);
responseAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
responseAC.Message = _iStringConstant.PackageAddedSuccessfully;
}
else
{
responseAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
responseAC.Message = _iStringConstant.PackageAlreadyExists;
}
return(responseAC);
}
public async Task <ResponseAC> AddConfiguration(long userId, TeleBillingUtility.Models.Configuration configuration, string loginUserName)
{
ResponseAC responseAC = new ResponseAC();
if (configuration.Id == 0)
{
configuration.CreatedBy = 1;
configuration.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
configuration.CreatedDate = DateTime.Now;
await _dbTeleBilling_V01Context.AddAsync(configuration);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responseAC.Message = _iStringConstant.ConfigurationAddedSuccessfully;
}
else
{
TeleBillingUtility.Models.Configuration configurationObj = await _dbTeleBilling_V01Context.Configuration.FirstAsync(x => x.Id == configuration.Id);
#region Transaction Log Entry
if (configurationObj.TransactionId == null)
{
configurationObj.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
}
var jsonSerailzeObj = JsonConvert.SerializeObject(configurationObj);
await _iLogManagement.SaveRequestTraseLog(Convert.ToInt64(configurationObj.TransactionId), userId, Convert.ToInt64(EnumList.TransactionTraseLog.UpdateRecord), jsonSerailzeObj);
#endregion
configurationObj = _mapper.Map(configuration, configurationObj);
configurationObj.UpdatedBy = 1;
configurationObj.UpdatedDate = DateTime.Now;
_dbTeleBilling_V01Context.Update(configurationObj);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responseAC.Message = _iStringConstant.ConfigurationUpdateSuccessfully;
}
responseAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.UpdateReminderNotificaiton, loginUserName, userId, "Reminder & notification", (int)EnumList.ActionTemplateTypes.ReminderNotificaiton, configuration.Id);
return(responseAC);
}
public async Task <ResponseAC> AddOperatorCallLog(long userId, OperatorCallLogDetailAC operatorCallLogDetailAC, string loginUserName)
{
ResponseAC response = new ResponseAC();
Operatorcalllog operatorCall = _mapper.Map <Operatorcalllog>(operatorCallLogDetailAC);
operatorCall.CreatedBy = userId;
operatorCall.CreatedDate = DateTime.Now;
operatorCall.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
await _dbTeleBilling_V01Context.AddAsync(operatorCall);
await _dbTeleBilling_V01Context.SaveChangesAsync();
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddOperatorCallLog, loginUserName, userId, "Operator call log(Dialed Number:" + operatorCall.DialedNumber + "Extensino Number:" + operatorCall.ExtensionNumber + ")", (int)EnumList.ActionTemplateTypes.Add, operatorCall.Id);
response.Message = _iStringConstant.OperatorCallLogAddedSuccessfully;
response.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
return(response);
}
public async Task AddedReminderNotificationLog(long emailTemplateTypeId, long?employeeBillId, bool isReminderMail, string emailTo)
{
Emailtemplate emailTemplate = await _dbTeleBilling_V01Context.Emailtemplate.FirstOrDefaultAsync(x => x.EmailTemplateTypeId == emailTemplateTypeId);
if (emailTemplate != null)
{
Emailreminderlog newEmailReminderLog = new Emailreminderlog();
newEmailReminderLog.CreatedDate = DateTime.Now;
newEmailReminderLog.IsReminderMail = isReminderMail;
newEmailReminderLog.TemplateId = emailTemplate.Id;
newEmailReminderLog.EmployeeBillId = employeeBillId;
newEmailReminderLog.EmailTo = emailTo != null ? emailTo : string.Empty;
await _dbTeleBilling_V01Context.AddAsync(newEmailReminderLog);
await _dbTeleBilling_V01Context.SaveChangesAsync();
}
}
public async Task <ResponseAC> AddEmployee(MstEmployeeAC employee, long userId, string loginUserName)
{
ResponseAC responeAC = new ResponseAC();
try
{
if (employee != null)
{
string pfNumber = employee.EmpPFNumber;
if (!await checkPFNumberUnique(pfNumber, 0))
{
MstEmployee mstEmployee = new MstEmployee();
mstEmployee.FullName = employee.FullName;
mstEmployee.ExtensionNumber = employee.ExtensionNumber;
mstEmployee.EmpPfnumber = employee.EmpPFNumber;
mstEmployee.EmailId = employee.EmailId;
string randomPassword = "******";
string randomPadding = CreatePassword(4);
mstEmployee.Password = randomPassword + randomPadding;
mstEmployee.RoleId = employee.RoleId;
mstEmployee.IsActive = true;
mstEmployee.IsSystemUser = true;
mstEmployee.DepartmentId = employee.DepartmentId;
mstEmployee.Designation = employee.Designation;
mstEmployee.Description = employee.Description;
mstEmployee.BusinessUnitId = employee.BusinessUnitId;
mstEmployee.CostCenterId = employee.CostCenterId;
mstEmployee.CountryId = employee.CountryId;
mstEmployee.IsPresidentOffice = employee.IsPresidentOffice;
if (employee.ManagerEmployee != null)
{
if (employee.ManagerEmployee.UserId > 0)
{
mstEmployee.LineManagerId = employee.ManagerEmployee.UserId;
}
}
if (mstEmployee.LineManagerId == 0)
{
responeAC.Message = "Line Manager is not valid !";
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
return(responeAC);
}
mstEmployee.CreatedBy = userId;
mstEmployee.CreatedDate = DateTime.Now;
mstEmployee.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
await _dbTeleBilling_V01Context.AddAsync(mstEmployee);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responeAC.Message = "Employee Added Successfully !";
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddEmployee, loginUserName, userId, "Employee(" + mstEmployee.FullName + ")", (int)EnumList.ActionTemplateTypes.Add, mstEmployee.UserId);
#region Send Email for Registration Confirmation
EmployeeProfileAC empDetail = new EmployeeProfileAC();
try
{
empDetail = await GetUserProfile(mstEmployee.UserId);
if (empDetail != null)
{
if (empDetail.UserProfileData.UserId > 0)
{
Dictionary <string, string> replacement = new Dictionary <string, string>();
replacement.Add("{newEmpName}", empDetail.UserProfileData.FullName);
replacement.Add("{PFNumber}", empDetail.UserProfileData.EmpPFNumber);
replacement.Add("{Email}", empDetail.UserProfileData.EmailId);
replacement.Add("{Password}", empDetail.UserProfileData.Password);
replacement.Add("{EmpDesignation}", empDetail.UserProfileData.Designation);
replacement.Add("{Emplocation}", empDetail.UserProfileData.Country);
replacement.Add("{lineManagerDepartment}", empDetail.UserProfileData.LineManager);
replacement.Add("{EmpDepartment}", empDetail.UserProfileData.Department);
replacement.Add("{EmpCostCenter}", empDetail.UserProfileData.CostCenter);
replacement.Add("{EmpBusinessUnit}", empDetail.UserProfileData.BusinessUnit);
bool issent = false;
string EmailId = empDetail.UserProfileData.EmailId;
if (!(string.IsNullOrEmpty(empDetail.UserProfileData.EmailId) || empDetail.UserProfileData.EmailId == "n/a"))
{
issent = await _iEmailSender.SendEmail(Convert.ToInt64(EnumList.EmailTemplateType.NewRegistrationConfirmation), replacement, employee.EmailId);
}
else
{// get line manager email
string linemanagerEmail = await _dbTeleBilling_V01Context.MstEmployee.Where(x => x.UserId == mstEmployee.LineManagerId).Select(x => x.EmailId).FirstOrDefaultAsync();
issent = await _iEmailSender.SendEmail(Convert.ToInt64(EnumList.EmailTemplateType.NewRegistrationInYourTeam), replacement, linemanagerEmail);
}
if (!issent)
{
responeAC.StatusCode = Convert.ToInt32(EnumList.ResponseType.Success);
responeAC.Message = "Employee Added Successfully! We Could Not Sent Mail Confirmation.";
}
}
}
}
catch (Exception e)
{
responeAC.StatusCode = Convert.ToInt32(EnumList.ResponseType.Success);
responeAC.Message = "Employee Added Successfully! Error :" + e.Message + " We Could Not Sent Mail Confirmation.";
}
#endregion
return(responeAC);
}
else
{
responeAC.Message = "PFNumber is already exists!";
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
return(responeAC);
}
}
else
{
responeAC.Message = _iStringConstant.DataNotFound;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
return(responeAC);
}
}
catch (Exception e)
{
responeAC.Message = "Error : " + e.Message;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
return(responeAC);
}
}
public async Task <ResponseAC> AddExcelMapping(ExcelMappingAC 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 (excelMappingAC != null)
{
bool IsExistsServices = false;
IsExistsServices = await checkExcelMappingExistsForServices(excelMappingAC);
if (IsExistsServices)
{
responeAC.Message = "excel mapping is already exists";
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
return(responeAC);
}
}
if ((await _dbTeleBilling_V01Context.Mappingexcel.FirstOrDefaultAsync(x => x.ProviderId == excelMappingAC.ProviderId && x.ServiceTypeId == excelMappingAC.ServiceTypeId && !x.IsDelete)) == null)
{
var providerData = await _dbTeleBilling_V01Context.Provider.FirstOrDefaultAsync(x => x.Id == excelMappingAC.ProviderId);
Mappingexcel mappingexcel = new Mappingexcel();
mappingexcel.Id = 0;
mappingexcel.IsActive = true;
mappingexcel.ProviderId = excelMappingAC.ProviderId;
mappingexcel.CurrencyId = providerData.CurrencyId;
mappingexcel.ServiceTypeId = excelMappingAC.ServiceTypeId;
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.IsCommonMapped = false;
mappingexcel.MappedMappingId = 0;
mappingexcel.MappedServiceTypeId = 0;
mappingexcel.IsDelete = false;
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.AddExcelMapping, loginUserName, userId, "Excel mapping", (int)EnumList.ActionTemplateTypes.Add, mappingexcel.Id);
if (mappingexcel.Id > 0)
{
#region ---> Add Common Servive if exists
foreach (var serviceType in excelMappingAC.ServiceTypeIdInline)
{
Mappingexcel mappingexcelCommon = new Mappingexcel();
mappingexcelCommon.Id = 0;
mappingexcelCommon.IsActive = true;
mappingexcelCommon.ProviderId = excelMappingAC.ProviderId;
mappingexcelCommon.CurrencyId = providerData.CurrencyId;
mappingexcelCommon.ServiceTypeId = serviceType.Id;
mappingexcelCommon.HaveHeader = excelMappingAC.HaveHeader;
mappingexcelCommon.HaveTitle = excelMappingAC.HaveTitle;
mappingexcelCommon.TitleName = excelMappingAC.TitleName;
mappingexcelCommon.WorkSheetNo = Convert.ToInt64(excelMappingAC.WorkSheetNo);
mappingexcelCommon.ExcelColumnNameForTitle = excelMappingAC.ExcelColumnNameForTitle;
mappingexcelCommon.ExcelReadingColumn = string.IsNullOrEmpty(excelMappingAC.ExcelReadingColumn) ? "" : excelMappingAC.ExcelReadingColumn;
mappingexcelCommon.CreatedBy = userId;
mappingexcelCommon.CreatedDate = DateTime.Now;
mappingexcelCommon.TransactionId = mappingexcel.TransactionId;
mappingexcelCommon.IsCommonMapped = true;
mappingexcelCommon.MappedMappingId = mappingexcel.Id;
mappingexcelCommon.MappedServiceTypeId = mappingexcel.ServiceTypeId;
await _dbTeleBilling_V01Context.AddAsync(mappingexcelCommon);
await _dbTeleBilling_V01Context.SaveChangesAsync();
}
#endregion
#region --> ADD Mapping column Details
if (excelMappingAC.dbfieldList.Count() > 0)
{
List <Mappingexcelcolumn> mappingExcelColumnslst = new List <Mappingexcelcolumn>();
foreach (var item in excelMappingAC.dbfieldList)
{
if (!string.IsNullOrEmpty(item.ColumnAddress))
{
Mappingexcelcolumn excelColumn = new Mappingexcelcolumn();
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);
}
}