public static IDictionary <string, string> GetConfigurationSetting()
{
IDictionary <string, string> Configurations = new Dictionary <string, string>();
try
{
using (var context = new PickeringsContext())
{
var ConfigurationSetting = context.ConfigurationSettings.ToList <ConfigurationSetting>();
Configurations.Add("PickeringsEmailID", ConfigurationSetting.Where(p => p.Name == "PickeringsEmailID").FirstOrDefault().Value);
Configurations.Add("PickeringsEmailPassword", ConfigurationSetting.Where(p => p.Name == "PickeringsEmailPassword").FirstOrDefault().Value);
Configurations.Add("ToAddress", ConfigurationSetting.Where(p => p.Name == "ToAJGEmailAddress").FirstOrDefault().Value);
Configurations.Add("SmtpClient", ConfigurationSetting.Where(p => p.Name == "SmtpClient").FirstOrDefault().Value);
Configurations.Add("PortId", ConfigurationSetting.Where(p => p.Name == "PortId").FirstOrDefault().Value);
Configurations.Add("EmailToAJGrecoveryPath", ConfigurationSetting.Where(p => p.Name == "EmailToAJGrecoveryPath").FirstOrDefault().Value);
Configurations.Add("EmailToInitiatorRecoveryPath", ConfigurationSetting.Where(p => p.Name == "EmailToInitiatorRecoveryPath").FirstOrDefault().Value);
Configurations.Add("DatabaseRecoveryPath", ConfigurationSetting.Where(p => p.Name == "DatabaseRecoveryPath").FirstOrDefault().Value);
}
}
catch (Exception ex)
{
WriteCustomErrorLog.WriteLog("Database error while fetching configuration settings");
throw new Exception(ex.Message);
}
return(Configurations);
}
public static ClaimAdvice StoreClaimAdvice(ClaimAdvice claimAdvice, List <string> filePaths, string databaseRecoveryPath)
{
try
{
int isSaved;
using (var context = new PickeringsContext())
{
context.ClaimAdvices.Add(claimAdvice);
isSaved = context.SaveChanges();
claimAdvice.ReferenceNumber = "PCAF" + claimAdvice.id;
context.SaveChanges();
}
if (isSaved == 0)
{
WriteCustomErrorLog.WriteLog("An error occured while saving claim advice - Email-" + claimAdvice.ContactEmail.ToString());
CsvGenerator.SaveAsCsV(claimAdvice, @databaseRecoveryPath, filePaths, true);
}
}
catch (Exception ex)
{
WriteCustomErrorLog.WriteLog("An error occured while saving claim advice - Email-" + claimAdvice.ContactEmail.ToString());
CsvGenerator.SaveAsCsV(claimAdvice, @databaseRecoveryPath, filePaths, true);
if (filePaths.Count > 0)
{
string serverPath = Path.GetDirectoryName(filePaths[0]);
new FileHandler().DeleteFiles(serverPath);
}
throw new Exception(ex.Message);
}
return(claimAdvice);
}
public List <InsuredDropDown> GetAllInsured()
{
List <InsuredDropDown> InsuredDropDowns = new List <InsuredDropDown>();
try
{
using (PickeringsContext context = new PickeringsContext())
{
InsuredDropDowns = context.InsuredDropDowns.ToList <InsuredDropDown>();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(InsuredDropDowns);
}