protected void BtnEnvoyer_Click(object sender, EventArgs e) { try { MsgCodeF.Text = ""; MsgObser.Text = ""; MsgPrix.Text = ""; MsgProduit.Text = ""; MsgQte.Text = ""; lblMsgSuccee.Text = ""; AstreeDonnees a = new AstreeDonnees(); UtilisateurDB User = a.GetUser(Convert.ToInt16(Session["code_utilisateur"].ToString())); serviceDB S = new serviceDB(); S.libelleService = "Commande"; S.etat = "A"; if (Txtcode.Text == "") { MsgCodeF.Visible = true; MsgCodeF.Text = "Vous devez selectionner un fournisseur!"; } else { S.dateDemande = DateTime.Now; S.codeDest = Convert.ToInt16(Txtcode.Text); S.codeUtilisateur =Convert.ToInt16(Session["code_utilisateur"].ToString()); a.Insertservice(S); List<serviceDB> lstService = a.GetServices(); serviceDB serv = lstService.Where(w => w.codeUtilisateur == User.code_utilisateur).LastOrDefault(); notificationDB notif = new notificationDB(); notif.codeService = serv.code_service; notif.contenuNotification = serv.reponse; notif.etatNotif = "N";// NON LU notif.dateNotification = serv.dateReponse; a.InsertNotification(notif); DetailCommandeDB Detail = new DetailCommandeDB(); if (gv_listeCommande.Rows.Count > 0) { try { foreach (GridViewRow row in gv_listeCommande.Rows) { Detail.code_service = serv.code_service; Detail.Id_produit = Convert.ToInt16(row.Cells[0].Text); Detail.Qte = Convert.ToInt16(row.Cells[2].Text); Detail.PU = Convert.ToInt16(row.Cells[3].Text); if (TxtBesoin.Text == "" || TxtBesoin.Text == null) { MsgObser.Visible = true; MsgObser.Text = "Vous devez saisir une observation!"; } else { Detail.Observation = TxtBesoin.Text; a.Inserer_Commande(Detail); } } if (TxtBesoin.Text == "" || TxtBesoin.Text == null) { MsgObser.Visible = true; MsgObser.Text = "Vous devez saisir une observation!"; } else { lblMsgSuccee.Visible = true; lblMsgSuccee.Text = "Commande envoyé avec succés!"; Txtcode.Text = ""; txtPrix.Text = ""; txtQte.Text = ""; TxtBesoin.Text = ""; // lblMsgSuccee.Text = ""; } Session["lstCommande"] = null; } catch (Exception ex) { Response.Redirect("PageErreur.aspx"); } } else { MsgCodeF.Text = ""; txterror.Visible = true; txterror.Text = "aucun article dans le panier!"; } } } catch (Exception ex) { Response.Redirect("PageErreur.aspx"); } }
protected void Btnreponse_Click(object sender, EventArgs e) { AstreeDonnees a = new AstreeDonnees(); MsgTaxe.Text = ""; MsgPH.Text = ""; MsgCP.Text = ""; lblSuccee.Text = ""; lblerreur.Text = ""; MsgEtat.Text = ""; if (txtproduit.Text != "") { List <serviceDB> lstService = a.GetServices(); serviceDB ser = new serviceDB(); ser = lstService.Where(w => w.code_service == Convert.ToInt16(txtID.Text)).FirstOrDefault(); if (ser != null) { if (Txtetat.Text != "VALIDEE") { MsgProduit.Visible = false; MsgEtat.Visible = true; MsgEtat.Text = "Vous devez valider le devis selectionné!"; } else { if (String.IsNullOrEmpty(TxtPHT.Text) || Convert.ToDecimal(TxtPHT.Text) == 0) { MsgPT.Visible = false; MsgTaxe.Visible = false; MsgCP.Visible = false; MsgPH.Visible = true; MsgPH.Text = "veuillez remplir le prime HT "; } else if (String.IsNullOrEmpty(txtTaxe.Text) || Convert.ToDecimal(txtTaxe.Text) == 0) { MsgCP.Visible = false; MsgPH.Visible = false; MsgPT.Visible = false; MsgTaxe.Visible = true; MsgTaxe.Text = "veuillez remplir le taxe "; } else if (String.IsNullOrEmpty(txtCP.Text) || Convert.ToDecimal(txtCP.Text) == 0) { MsgPH.Visible = false; MsgPT.Visible = false; MsgTaxe.Visible = false; MsgCP.Visible = true; MsgCP.Text = "veuillez remplir le coût police"; } else if (MsgPH.Text != "" && MsgCP.Text != "" && MsgTaxe.Text != "") { lblerreur.Text = "Vous devez remplir tout les champs!"; } else { try { ser.etat = "V"; ser.dateReponse = DateTime.Now; ser.primeHtax = Convert.ToDecimal(TxtPHT.Text); ser.primeTotal = Convert.ToDecimal(txtPT.Text); ser.coutPolice = Convert.ToDecimal(txtCP.Text); ser.taxe = Convert.ToDecimal(txtTaxe.Text); a.maj_devis(ser); BindGrid(); lblSuccee.Visible = true; lblerreur.Visible = false; lblSuccee.Text = "La réponse envoyée avec succés! "; } catch { lblerreur.Visible = true; lblSuccee.Visible = false; lblerreur.Text = " Les champs doivent être des entiers!"; } } } Label x = (Label)Master.FindControl("lblDevis") as Label; Label y = (Label)Master.FindControl("nbNotification") as Label; List <serviceDB> lsNotification = a.GetServices().Where(w => (w.libelleService != null) && (w.etat.Trim() == "A")).ToList(); x.Text = lsNotification.Where(w => w.libelleService.Trim() == "Devis").Count().ToString(); y.Text = (Convert.ToInt16(y.Text.ToString()) - 1).ToString(); if (ser.etatNotif == "") { notificationDB notif = new notificationDB(); notif.codeService = ser.code_service; notif.contenuNotification = ser.reponse; notif.etatNotif = "N";// NON LU notif.dateNotification = ser.dateReponse; a.InsertNotification(notif); //lsNotification = a.GetServices().Where(w => (w.libelleService != null) && (w.etat.Trim() == "A")).ToList(); //x.Text = lsNotification.Where(w => w.libelleService.Trim() == "Devis" ).Count().ToString(); //y.Text = (Convert.ToInt16(y.Text.ToString()) - 1).ToString(); BindGrid(); } } } else { MsgEtat.Visible = false; MsgProduit.Visible = true; MsgProduit.Text = "Vous devez selectionner un devis!"; } }
protected void Btnreponse_Click(object sender, EventArgs e) { AstreeDonnees a = new AstreeDonnees(); if (txtproduit.Text != "") { List <serviceDB> lstService = a.GetServices(); serviceDB ser = new serviceDB(); ser = lstService.Where(w => w.code_service == Convert.ToInt16(txtId.Text)).FirstOrDefault(); if (ser != null) { if (Txtetat.Text != "VALIDEE") { lblMsgSucces.Visible = false; MsgProduit.Visible = false; MsgEtat.Visible = true; MsgEtat.Text = "Vous devez valider le devis selectionné!"; } else { if (String.IsNullOrEmpty(txtreponse.Text)) { lblMsgSucces.Visible = false; MsgEtat.Visible = false; Msgreponse.Visible = true; Msgreponse.Text = "veuillez remplir la réponse "; } else { ser.etat = "V"; ser.dateReponse = DateTime.Now; ser.reponse = txtreponse.Text; a.maj_derogation(ser); BindGrid(); MsgEtat.Visible = false; Msgreponse.Visible = false; lblMsgSucces.Visible = true; lblMsgSucces.Text = "Reponse envoyée avec succès "; if (ser.etatNotif == "") { notificationDB notif = new notificationDB(); notif.codeService = ser.code_service; notif.contenuNotification = ser.reponse; notif.etatNotif = "N";// NON LU notif.dateNotification = ser.dateReponse; a.InsertNotification(notif); Label b = (Label)Master.FindControl("nbNotification") as Label; Label x = (Label)Master.FindControl("lblNotifRemise") as Label; List <serviceDB> lsNotification = a.GetServices().Where(w => (w.libelleService != null) && (w.etat.Trim() == "A")).ToList(); x.Text = lsNotification.Where(w => w.libelleService.Trim() == "Derogation" && w.idType == 1).Count().ToString(); //b.Text = x.Text; Label y = (Label)Master.FindControl("lblNotifProrogation") as Label; y.Text = lsNotification.Where(w => w.libelleService.Trim() == "Derogation" && w.idType == 2).Count().ToString(); //b.Text = y.Text; Label z = (Label)Master.FindControl("lblNotifSouscription") as Label; z.Text = lsNotification.Where(w => w.libelleService.Trim() == "Derogation" && w.idType == 3).Count().ToString(); //b.Text = z.Text; b.Text = (Convert.ToInt16(b.Text.ToString()) - 1).ToString(); } } } } else { MsgEtat.Visible = false; MsgProduit.Visible = true; MsgProduit.Text = "Vous devez selectionner un devis!"; } } }
protected void Btnreponse_Click(object sender, EventArgs e) { MsgNum.Text = ""; AstreeDonnees a = new AstreeDonnees(); //if (txtetat.Text == "VALIDEE") //{ AstreeDonnees ad = new AstreeDonnees(); if (txtNum.Text != "") { serviceDB ser = a.GetServices().Where(w => w.code_service == Convert.ToInt16(txtNum.Text)).FirstOrDefault(); DetailCommandeDB detailComm = a.GetDetailCommande().Where(w => w.LibelleService.Trim() == "Commande" && w.code_dest == 404 && w.code_service == Convert.ToInt16(txtNum.Text) && w.LibelleProduit.Trim() == txtProduit.Text.Trim()).FirstOrDefault(); if (txtQteLivree.Text == "") { txtQteLivree.Text = "Vous devez remplir la quantité à livrée"; } if (detailComm != null) { detailComm.reponse = txtReponse.Text; detailComm.QteLivree = Convert.ToInt16(txtQteLivree.Text); ad.maj_DetailCommande(detailComm); } List <DetailCommandeDB> lstDetailComm = a.GetDetailCommande().Where(w => w.LibelleService.Trim() == "Commande" && w.code_dest == 404 && w.code_service == Convert.ToInt16(txtNum.Text) && w.QteLivree == 0).ToList(); if (ser != null && lstDetailComm.Count == 0) { ser.etat = "V"; ser.dateReponse = DateTime.Now; ser.reponse = txtReponse.Text; ser.code_service = Convert.ToInt16(txtNum.Text); ser.QteLivree = Convert.ToInt16(txtQteLivree.Text); a.maj_Commande(ser); gv_Detail.Visible = false; Label x = (Label)Master.FindControl("lblNotifCommande") as Label; Label y = (Label)Master.FindControl("lblNotifCommandeInterFourn") as Label; Label z = (Label)Master.FindControl("nbNotification") as Label; List <serviceDB> lsNotification = a.GetServices().Where(w => (w.libelleService != null) && (w.etat.Trim() == "A") && w.codeDest == 404).ToList(); x.Text = lsNotification.Where(w => w.libelleService.Trim() == "Commande" && w.etat.Trim() == "A" && w.codeDest == 404).Count().ToString(); List <serviceDB> lsNotificationFourn = a.GetServices().Where(w => (w.libelleService != null) && (w.etat.Trim() == "V") && w.codeDest != 404 && w.codeUtilisateur == Convert.ToInt16(Session["code_utilisateur"])).ToList(); y.Text = lsNotificationFourn.Count().ToString(); z.Text = (Convert.ToInt16(z.Text.ToString()) - 1).ToString(); notificationDB notif = new notificationDB(); notif.codeService = ser.code_service; notif.contenuNotification = ser.reponse; notif.etatNotif = "N";// NON LU notif.dateNotification = ser.dateReponse; a.InsertNotification(notif); // Label x = (Label)Master.FindControl("lblNotifCommande") as Label; // Label y = (Label)Master.FindControl("lblNotifCommandeInterFourn") as Label; //Label z = (Label)Master.FindControl("nbNotification") as Label; //List<serviceDB> lsNotification = a.GetServices().Where(w => (w.libelleService != null) && (w.etat.Trim() == "A") && w.codeDest == 404).ToList(); // x.Text = lsNotification.Where(w => w.libelleService.Trim() == "Commande" && w.etat.Trim() == "A" && w.codeDest == 404).Count().ToString(); //List<serviceDB> lsNotificationFourn = a.GetServices().Where(w => (w.libelleService != null) && (w.etat.Trim() == "V") && w.codeDest != 404 && w.codeUtilisateur == Convert.ToInt16(Session["code_utilisateur"])).ToList(); //y.Text = lsNotificationFourn.Count().ToString(); //z.Text = (Convert.ToInt16(x.Text) + Convert.ToInt16(y.Text)).ToString(); BindGrid(); } } else { MsgNum.Text = "Vous devez séléctionner une commande!"; } // } }
protected void BtnRepondre_Click(object sender, EventArgs e) { try { AstreeDonnees a = new AstreeDonnees(); serviceDB reclam = a.GetServices().Where(w => w.libelleService.Trim() == "Reclamation" && w.etat.Trim() == "A" && w.code_service == Convert.ToInt16(myCode.Text)).FirstOrDefault(); DataAccesDataContext dbcontext = new DataAccesDataContext(); if (reclam != null) { if (String.IsNullOrEmpty(message.Text)) { msgerror.Visible = true; msgerror.Text = "veuillez remplir la réponse "; lundi(sender, e); } else { reclam.dateReponse = DateTime.Now; reclam.etat = "V"; reclam.reponse = message.Text; a.maj_reclamation(reclam); message.Text = "écrivez votre réponse ici..."; lundi(sender, e); if (reclam.etatNotif == "") { notificationDB notif = new notificationDB(); notif.codeService = reclam.code_service; notif.contenuNotification = reclam.reponse; notif.etatNotif = "N";// NON LU notif.dateNotification = reclam.dateReponse; a.InsertNotification(notif); } UtilisateurDB user = a.GetUser(Convert.ToInt16(Session["code_utilisateur"].ToString())); List <destinationDB> lstDestination = a.GetDestination(); List <serviceDB> lstReclamation = a.GetServices().Where(w => w.libelleService.Trim() == "Reclamation" && w.etat.Trim() == "A").ToList(); List <serviceDB> lstReclamationFin = new List <serviceDB>(); foreach (serviceDB recl in lstReclamation) { if (lstDestination.Where(w => w.codeDest == recl.codeDest && w.codeProfil == user.code_profil).Count() > 0) { lstReclamationFin.Add(recl); } } lstReclamation = lstReclamationFin; Label y = (Label)Master.FindControl("nbNotification") as Label; Label x = (Label)Master.FindControl("lblNotifReclamation") as Label; x.Text = lstReclamation.Count().ToString(); y.Text = (Convert.ToInt16(y.Text.ToString()) - 1).ToString(); } } } catch (Exception ex) { lundi(sender, e); msgerror.Visible = true; msgerror.Text = "Il n'existe aucunne réclamation selectionner"; } }