//protected void DownloadFileIndexe(object sender, EventArgs e) //{ // int id = int.Parse((sender as LinkButton).CommandArgument); // byte[] bytes; // AstreeDonnees a = new AstreeDonnees(); // fichierIndexeDB F = new fichierIndexeDB(); // F = a.GetFichierIndexe().Where(w => w.code_service == id).FirstOrDefault(); // bytes = (byte[])F.DataR; // Response.Clear(); // Response.Buffer = true; // Response.Charset = ""; // Response.Clear(); // Response.Cache.SetCacheability(HttpCacheability.NoCache); // Response.AppendHeader("ContentType", "application/pdf"); // Response.AppendHeader("Content-Description", "F DOWNOALD"); // Response.AppendHeader("Content-Transfer-Encoding", "binary\n"); // Response.AppendHeader("Content-Disposition", "attachment; filename=aaa.pdf"); // //Response.TransmitFile(Server.MapPath("~/Files/Serverside.pdf")); // Response.BinaryWrite(bytes); // Response.Flush(); // Response.End(); //} protected void gv_Commande_RowDataBound(object sender, GridViewRowEventArgs e) { try { AstreeDonnees a = new AstreeDonnees(); foreach (GridViewRow row in gv_Commande.Rows) { if (row.RowType == DataControlRowType.DataRow) { serviceDB serv = a.GetServices().Where(w => (w.libelleService != null) && (w.libelleService.Trim() == "Commande") && w.codeDest == Convert.ToInt16(Session["code_utilisateur"].ToString()) && (w.code_service == Convert.ToInt32(row.Cells[1].Text))).FirstOrDefault(); if (serv != null) { if (serv.etat.Trim() == "V") { //e.Row.BackColor = System.Drawing.Color.Red; row.ForeColor = System.Drawing.Color.Green; } if (serv.etat.Trim() == "A") { row.ForeColor = System.Drawing.Color.Red; } } } } } catch (Exception ex) { } }
private void BindGrid() { AstreeDonnees a = new AstreeDonnees(); gv_Historique.DataSource = a.GetServices().Where(w => w.libelleService == "Commande".Trim() && w.codeDest == 404).OrderByDescending(w => w.dateReponse); gv_Historique.DataBind(); }
protected void Btnreponse_Click(object sender, EventArgs e) { MsgCode.Text = ""; MsgEtat.Text = ""; MsgReponse.Text = ""; try { AstreeDonnees a = new AstreeDonnees(); serviceDB lstService = a.GetServices().Where(w => w.libelleService.Trim() == "Commande" && w.code_service == Convert.ToInt16(txtcodeService.Text)).FirstOrDefault(); if (txtCode.Text == "") { MsgCode.Visible = true; MsgCode.Text = "Vous devez selectionner une commande !"; } //else if (txtEtat.Text == "") //{ // MsgEtat.Visible = true; // MsgEtat.Text = "Vous devez valider la commande !"; //} else if (txtReponse.Text == "") { MsgReponse.Visible = true; MsgReponse.Text = "Vous devez sasir votre réponse !"; } else { DetailCommandeDB detailComm = a.GetDetailCommande().Where(w => w.LibelleService.Trim() == "Commande" && w.code_service == lstService.code_service && w.LibelleProduit.Trim() == txtProduit.Text.Trim()).FirstOrDefault(); if (detailComm != null) { detailComm.reponse = txtReponse.Text; detailComm.QteLivree = detailComm.Qte; a.maj_DetailCommande(detailComm); } List <DetailCommandeDB> lstDetailComm = a.GetDetailCommande().Where(w => w.LibelleService.Trim() == "Commande" && w.code_dest == Convert.ToInt16(Session["code_utilisateur"].ToString()) && w.code_service == lstService.code_service && w.QteLivree == 0).ToList(); if (lstService != null && lstDetailComm.Count == 0) { lstService.etat = "V"; lstService.dateReponse = DateTime.Now; lstService.reponse = txtReponse.Text; a.maj_Commande(lstService); Label x = (Label)Master.FindControl("lblNotifCommandeFourn") as Label; Label y = (Label)Master.FindControl("nbNotification") as Label; List <serviceDB> lsNotification = a.GetServices().Where(w => (w.libelleService != null) && (w.etat.Trim() == "A") && (w.codeDest == Convert.ToInt16(Session["code_utilisateur"]))).ToList(); x.Text = lsNotification.Where(w => w.libelleService.Trim() == "Commande").Count().ToString(); y.Text = x.Text; BindGrid(); } lblMsgSucces.Visible = true; lblMsgSucces.Text = "Reponse envoyé avec succés!"; txtCode.Text = ""; txtcodeService.Text = ""; //txtEtat.Text = ""; txtReponse.Text = ""; List <DetailCommandeDB> ls = a.GetDetailCommande().Where(w => w.LibelleService.Trim() == "Commande" && w.code_dest == Convert.ToInt16(Session["code_utilisateur"].ToString())).ToList(); gv_Commande.DataSource = ls; gv_Commande.DataBind(); } } catch (Exception ex) { MsgCode.Visible = true; MsgCode.Text = "Vous devez selectionner une commande !"; } }