/// <summary>
/// Création du barème
/// </summary>
/// <param name="bareme"></param>
/// <returns></returns>
public static bool CreateBareme(BO.Baremes bareme)
{
try
{
if (Exist(bareme.CodeGroupement, bareme.DateVigueur))
{
return(DAL.Baremes.Update(bareme));
}
else
{
SqlConnection cnx = DAL.SqlConnexion.OpenConnexion();
int output = cnx.Execute("ajout_bareme", new
{
codegroupement = bareme.CodeGroupement,
datevigueur = bareme.DateVigueur,
typeacte = bareme.TypeActe,
libelle = bareme.Libelle,
tfixe = bareme.TarifFixe,
tmini = bareme.TarifMini,
tmaxi = bareme.TarifMaxi,
nomvaccin = (bareme.Vaccin == null) ? "" : bareme.Vaccin.NomVaccin
},
commandType: CommandType.StoredProcedure);
SqlConnexion.CloseConnexion(cnx);
return(output > 0);
}
}
catch (Exception e)
{
throw e;
}
}
private void buttonModify_Click(object sender, EventArgs e)
{
if (dataGridViewListPrice.CurrentCell != null)
{
BO.Baremes bareme = new BO.Baremes();
bareme.CodeGroupement = dataGridViewListPrice.CurrentCell.OwningRow.Cells[0].FormattedValue.ToString();
bareme.DateVigueur = dataGridViewListPrice.CurrentCell.OwningRow.Cells[1].FormattedValue.ToString();
BLL.BaremesMgr.CreateBareme(bareme, this.textBoxTarifFixe.Text, this.textBoxTarifMini.Text, this.textBoxTarifMaxi.Text);
this.Update_Data();
}
}
/// <summary>
/// Archive ou desarchive un bareme
/// </summary>
/// <param name="bareme"></param>
/// <param name="archiveParam"></param>
/// <returns></returns>
public static bool Archive(BO.Baremes bareme, bool archiveParam)
{
try
{
SqlConnection cnx = DAL.SqlConnexion.OpenConnexion();
var query = @"UPDATE Baremes SET Archive=@archive WHERE CodeGroupement = @code AND DateVigueur like('%' + @date + '%')";
int rowNb = cnx.Execute(query, new { archive = (archiveParam) ? 1 : 0, code = bareme.CodeGroupement, date = bareme.DateVigueur });
SqlConnexion.CloseConnexion(cnx);
return(rowNb > 0);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Importe le xml dans barème
/// </summary>
/// <param name="path"></param>
public static void ImportXml(string path)
{
XDocument doc = XDocument.Load(path);
List <XNode> nodes = (from n in doc.Descendants()
where n.Name == "Baremes"
select n).ToList <XNode>();
DAL.Baremes.Flush();
foreach (XElement node in nodes)
{
BO.Baremes bar = new BO.Baremes();
foreach (XElement son in node.Nodes())
{
bar.Attribute(son.Name.ToString(), son.Value);
}
DAL.Baremes.CreateBareme(bar);
}
}
/// <summary>
/// Création d'un barème
/// </summary>
/// <param name="code"></param>
/// <param name="date"></param>
/// <param name="newTarif"></param>
public static void CreateBareme(BO.Baremes baremeParam, String newTarifFixe, String newTarifMini, String newTarifMaxi)
{
if (Decimal.Parse(newTarifMini) <= Decimal.Parse(newTarifMaxi))
{
BO.Baremes bareme = DAL.Baremes.GetBareme(baremeParam.CodeGroupement, baremeParam.DateVigueur);
if (DAL.Baremes.Archive(bareme, true))
{
bareme.DateVigueur = DateTime.Now.ToString("dd/MM/yy");
bareme.TarifFixe = Decimal.Parse(newTarifFixe);
bareme.TarifMaxi = Decimal.Parse(newTarifMaxi);
bareme.TarifMini = Decimal.Parse(newTarifMini);
if (!DAL.Baremes.CreateBareme(bareme))
{
DAL.Baremes.Archive(bareme, false);
}
}
}
else
{
throw new Exception(BLL.Lang.BAREMES_PROBLEME_TARIF);
}
}
/// <summary>
/// Met à jour le barème passé en params
/// </summary>
/// <param name="bareme"></param>
/// <returns></returns>
public static bool Update(BO.Baremes bareme)
{
try
{
SqlConnection cnx = DAL.SqlConnexion.OpenConnexion();
var query = @"UPDATE Baremes
SET
TypeActe = @typeacte,
Libelle = @libelle,
TarifFixe = @tfixe,
TarifMini = @tmini,
TarifMaxi = @tmaxi,
CodeVaccin = @codevaccin,
Archive = @archive
WHERE CodeGroupement = @codegroupement
AND DateVigueur = @datevigueur";
int rowNb = cnx.Execute(query, new{
codegroupement = bareme.CodeGroupement,
datevigueur = bareme.DateVigueur,
typeacte = bareme.TypeActe,
libelle = bareme.Libelle,
tfixe = bareme.TarifFixe,
tmini = bareme.TarifMini,
tmaxi = bareme.TarifMaxi,
codevaccin = (bareme.Vaccin == null) ? null : bareme.Vaccin.CodeVaccin,
archive = bareme.Archive
});
SqlConnexion.CloseConnexion(cnx);
return(rowNb > 0);
}
catch (Exception e)
{
throw e;
}
}
private void comboBoxActeLibelle_SelectedIndexChanged(object sender, EventArgs e)
{
selectedBarems = (BO.Baremes) this.comboBoxActeLibelle.SelectedItem;
RefreshTarif();
}
