public static void RecreateGroupsGarantiesSanteFromPresta()
{
try
{
//truncate table GroupGarantySante
GroupGarantySante.TruncateTable();
//get data from PrestSante
List <GroupesGarantiesSante> GroupGarantyList = PrestSante.GetGroupGarantyList();
//add data to GroupGarantySante
// ### Paramètres par défaut
foreach (GroupesGarantiesSante item in GroupGarantyList)
{
int id = GroupGarantySante.InsertGroupGaranty(new GroupGarantySante
{
AssureurName = item.AssureurName,
GroupName = item.GroupName,
GarantyName = item.GarantyName,
CodeActe = item.CodeActe,
OrderNumber = 1
});
}
}
catch (Exception ex)
{
log.Error(ex.Message);
throw ex;
}
}
public static void ImportGroupsGarantiesSanteForAssureur(string assureurName, string excelFilePath, bool firstRowAsColumnNames)
{
try
{
string groupName;
string garantyName;
string codeActe;
int orderNumber;
//read Excel file into datatable
DataTable dt = G.ExcelToDataTable(excelFilePath, firstRowAsColumnNames);
// delete all rows in DB Tables with the specified assurName
GroupGarantySante.DeleteGroupsWithSpecificAssureurName(assureurName);
foreach (DataRow row in dt.Rows)
{
//### validate => all fields must be specified
groupName = row[C.eExcelGroupsGaranties.GroupName.ToString()].ToString();
garantyName = row[C.eExcelGroupsGaranties.GarantyName.ToString()].ToString();
codeActe = row[C.eExcelGroupsGaranties.CodeActe.ToString()].ToString();
if (!Int32.TryParse(row[C.eExcelGroupsGaranties.OrderNumber.ToString()].ToString(), out orderNumber))
{
orderNumber = 9999;
}
int id = GroupGarantySante.InsertGroupGaranty(new GroupGarantySante
{
AssureurName = assureurName,
GroupName = groupName,
GarantyName = garantyName,
CodeActe = codeActe,
OrderNumber = orderNumber
});
}
}
catch (Exception ex)
{
log.Error(ex.Message);
throw ex;
}
}