protected void cmdDelete_Click(object sender, EventArgs e) { try { //handle the delete event string assurName = lbAssur.SelectedItem.Text.ToString(); Session["SelectedAssureurIndex"] = lbAssur.SelectedIndex; if (!string.IsNullOrWhiteSpace(assurName)) { GroupGarantySante.DeleteGroupsWithSpecificAssureurName(assurName); } else { throw new Exception("Please select the name of the 'Assureur' for which you want to delete groups and guarantees!"); } //refresh the tree lbAssur.DataBind(); if (ItemExists(assurName)) { SelectItem(assurName); UpdateTreeView(assurName); } else { if (lbAssur.Items.Count > 0) { SelectItem(lbAssur.Items[0].Text); UpdateTreeView(lbAssur.Items[0].Text); } else { tvGaranties.Nodes.Clear(); } } } catch (Exception ex) { log.Error(ex.Message); var myCustomValidator = new CustomValidator(); myCustomValidator.IsValid = false; myCustomValidator.ErrorMessage = ex.Message; Page.Validators.Add(myCustomValidator); } }
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; } }