/// <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(); }