private void cmbCR_SelectedIndexChanged(object sender, EventArgs e)
{
using (TibcoGPEntities model = new TibcoGPEntities())
{
model.Database.CommandTimeout = 200;
var xml = model.Compte_rendu.Where(x => x.cr_id == ((V_Compte_Rendu)cmbCR.SelectedValue).cr_id).Select(x => x.cr_rapport).FirstOrDefault();
if (!string.IsNullOrEmpty(xml))
{
System.Xml.Linq.XDocument xDocument = System.Xml.Linq.XDocument.Parse(xml);
txtXML.Text = xDocument.ToString();
System.Xml.Linq.XDocument xXslt = System.Xml.Linq.XDocument.Parse(Properties.Resources.Defaultss);
System.Xml.Xsl.XslCompiledTransform xTrans = new System.Xml.Xsl.XslCompiledTransform();
xTrans.Load(xXslt.CreateReader());
ms = new System.IO.MemoryStream();
xTrans.Transform(xDocument.CreateReader(), null, ms);
ms.Position = 0;
webBrowserXML.DocumentStream = ms;
}
else
{
txtXML.Clear();
txtXML.Text = "VIDE";
webBrowserXML.DocumentText = string.Empty;
}
}
}
public FrmCompterenduVisualisation()
{
InitializeComponent();
this.Size = Screen.PrimaryScreen.WorkingArea.Size;
using (TibcoGPEntities model = new TibcoGPEntities())
{
crList = new List <V_Compte_Rendu>();
crList.AddRange(from c in model.V_Compte_Rendu orderby c.cr_id select c);
lblCnx.Text = model.Database.Connection.ConnectionString;
}
this.cmbCR.DisplayMember = "cr_id";
this.cmbCR.DataSource = crList;
splitContainerSearch.SplitterDistance = this.Width;
}
private void btnSauvegarde_Click(object sender, EventArgs e)
{
try
{
using (TibcoGPEntities model = new TibcoGPEntities())
{
if (MessageBox.Show(string.Format("êtes vous sur de vouloir modifier {0} ?", model.Database.Connection.DataSource), "Sauvegarde en BDD ", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
var cr = model.Compte_rendu.Where(x => x.cr_id == ((V_Compte_Rendu)cmbCR.SelectedValue).cr_id).Select(x => x).FirstOrDefault();
if (cr != null)
{
cr.cr_rapport = txtXML.Text;
}
model.SaveChanges();
MessageBox.Show("Sauvegarde réussi", "Sauvegarde", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Echec de la sauvegarde:" + ex.Message, "Sauvegarde", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
