Esempio n. 1
0
 public Affectation Store(Affectation affectation)
 {
     affectation.Datetime = DateTime.Now;
     _afdtechContext.Affectations.Add(affectation);
     _afdtechContext.SaveChanges();
     return(affectation);
 }
        public ActionResult addLot(Lot lot, int agent)
        {
            using (WakilRecouvContext WakilContext = new WakilRecouvContext())
            {
                using (UnitOfWork UOW = new UnitOfWork(WakilContext))
                {
                    Debug.WriteLine(lot);

                    LotService         LotService         = new LotService(UOW);
                    AffectationService AffectationService = new AffectationService(UOW);

                    LotService.Add(lot);
                    LotService.Commit();

                    Affectation affectation = new Affectation
                    {
                        DateAffectation = DateTime.Now,
                        LotId           = lot.LotId,
                        EmployeId       = agent
                    };

                    AffectationService.Add(affectation);
                    AffectationService.Commit();

                    return(RedirectToAction("ConsulterClients", new { numLot = 0, sortOrder = 0 }));
                }
            }
        }
        public async Task <ActionResult <Affectation> > PostAffectation(Affectation affectation)
        {
            _context.Affectations.Add(affectation);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetAffectation", new { id = affectation.AffectationId }, affectation));
        }
        public async Task <IActionResult> PutAffectation(int id, int id2, Affectation affectation)
        {
            if (id != affectation.IdFiliere && id2 != affectation.IdMatiere)
            {
                return(BadRequest());
            }

            _context.Entry(affectation).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!AffectationExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
Esempio n. 5
0
        private void modifierToolStripMenuItem_Click(object sender, EventArgs e)
        {
            FRM_Produit_Commande frm = new FRM_Produit_Commande(this);
            Produit     PR           = new Produit();
            Affectation QteAff       = new Affectation();

            if (dvgDetailCommande.CurrentRow != null)
            {
                frm.lblTitre.Text          = "Modifier Produit";
                frm.txtIdClientAffect.Text = IDCLIENT.ToString();
                frm.txtIdExpediteur.Text   = IDEXPEDITEUR.ToString();
                frm.txtIdProduit.Text      = dvgDetailCommande.CurrentRow.Cells[0].Value.ToString();
                frm.lblnom.Text            = dvgDetailCommande.CurrentRow.Cells[1].Value.ToString();
                ////Importer le stock de produit depuis le datagrid produit//////
                int IDEX   = IDEXPEDITEUR;
                int IDPROD = int.Parse(dvgDetailCommande.CurrentRow.Cells[0].Value.ToString());
                QteAff            = db.Affectations.Single(s => s.ID_Client == IDEX && s.ID_Produit == IDPROD);
                frm.lblstock.Text = QteAff.Quantite_affectee.ToString();
                ////Importer inventaire de produit depuis le datagrid produit//////
                int IDP = int.Parse(dvgDetailCommande.CurrentRow.Cells[0].Value.ToString());
                PR = db.Produits.Single(s => s.ID_Produit == IDP);
                frm.lblInv.Text      = PR.NumInventaire.ToString();;
                frm.lblprix.Text     = dvgDetailCommande.CurrentRow.Cells[3].Value.ToString();
                frm.txtquantite.Text = dvgDetailCommande.CurrentRow.Cells[2].Value.ToString();
                frm.txtremise.Text   = dvgDetailCommande.CurrentRow.Cells[4].Value.ToString();
                frm.txttotal.Text    = dvgDetailCommande.CurrentRow.Cells[5].Value.ToString();
                frm.ShowDialog();
            }
        }
Esempio n. 6
0
        public ActionResult DeleteConfirmed(int id)
        {
            Affectation affectation = db.affectations.Find(id);

            db.affectations.Remove(affectation);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Esempio n. 7
0
        public JsonResult Delete(int ID)
        {
            Affectation a = db.affectations.Find(ID);

            db.affectations.Remove(a);
            db.SaveChanges();
            return(Json(0, JsonRequestBehavior.AllowGet));
        }
        public ActionResult updateLot(ClientAffecteViewModel cavm)
        {
            using (WakilRecouvContext WakilContext = new WakilRecouvContext())
            {
                using (UnitOfWork UOW = new UnitOfWork(WakilContext))
                {
                    LotService         LotService         = new LotService(UOW);
                    AffectationService AffectationService = new AffectationService(UOW);

                    Lot newlot = LotService.GetById(cavm.Lot.LotId);
                    newlot.Adresse       = cavm.Lot.Adresse;
                    newlot.Compte        = cavm.Lot.Compte;
                    newlot.DescIndustry  = cavm.Lot.DescIndustry;
                    newlot.Emploi        = cavm.Lot.Emploi;
                    newlot.IDClient      = cavm.Lot.IDClient;
                    newlot.NomClient     = cavm.Lot.NomClient;
                    newlot.NumLot        = cavm.Lot.NumLot;
                    newlot.PostCode      = cavm.Lot.PostCode;
                    newlot.SoldeDebiteur = cavm.Lot.SoldeDebiteur;
                    newlot.TelFixe       = cavm.Lot.TelFixe;
                    newlot.TelPortable   = cavm.Lot.TelPortable;
                    newlot.Type          = cavm.Lot.Type;
                    newlot.Emploi        = cavm.Lot.Emploi;
                    LotService.Update(newlot);
                    LotService.Commit();


                    Affectation affectation = AffectationService.GetById(cavm.Affectation.AffectationId);
                    Debug.WriteLine(cavm.Affectation.EmployeId);

                    if (affectation == null)
                    {
                        Affectation aff = new Affectation
                        {
                            EmployeId       = cavm.Affectation.EmployeId,
                            LotId           = cavm.Lot.LotId,
                            DateAffectation = DateTime.Now
                        };

                        AffectationService.Add(aff);
                        AffectationService.Commit();
                    }
                    else
                    {
                        affectation.EmployeId       = cavm.Affectation.EmployeId;
                        affectation.LotId           = cavm.Lot.LotId;
                        affectation.DateAffectation = DateTime.Now;
                        AffectationService.Update(affectation);
                        AffectationService.Commit();
                    }


                    return(RedirectToAction("ConsulterClients", new { numLot = 0, sortOrder = 0 }));
                }
            }
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        int.TryParse("" + Request.QueryString["UserId"], out UserIdQuery);



        if (UserIdQuery > 0)
        {
            if (DataMapping.Sub_Active(UserIdQuery, "PagePro") == true) //La page est accessible par superuser, par le membre propriétaire même si l'abonnement est inactif
            {
                member = DataMapping.GetMemberByUserID(UserIdQuery);

                if (member != null && member.id != null && member.id > 0 && member.nim > 0)
                {
                    affectation = DataMapping.GetAffectation(member.nim, DateTime.Now.Year);
                    content     = DataMapping.GetContentPagePro(UserIdQuery);

                    Binding_Panel2();
                }
                else
                {
                    //if (PortalSettings.HomeTabId > 0)
                    //{
                    //    Response.Redirect(Globals.NavigateURL(PortalSettings.HomeTabId), true);
                    //}
                    //else
                    //{
                    //    Response.Redirect(Globals.GetPortalDomainName(PortalSettings.PortalAlias.HTTPAlias, Request, true), true);
                    //}
                }
            }
            else
            {
                //if (PortalSettings.HomeTabId > 0)
                //{
                //    Response.Redirect(Globals.NavigateURL(PortalSettings.HomeTabId), true);
                //}
                //else
                //{
                //    Response.Redirect(Globals.GetPortalDomainName(PortalSettings.PortalAlias.HTTPAlias, Request, true), true);
                //}
            }
        }
        else
        {
            //if (PortalSettings.HomeTabId > 0)
            //{
            //    Response.Redirect(Globals.NavigateURL(PortalSettings.HomeTabId), true);
            //}
            //else
            //{
            //    Response.Redirect(Globals.GetPortalDomainName(PortalSettings.PortalAlias.HTTPAlias, Request, true), true);
            //}
        }
    }
Esempio n. 10
0
    public string GetListeMembres(int cric, string critere, string top, string tri, int index, int max, bool onlyvisible, string username, string password, string device, string version, string fonction)
    {
        DateTime dt      = DateTime.Now;
        string   comment = "";
        string   code    = "ok";
        //envoyerTest(fonction);
        List <Member> lm = new List <Member>();
        List <Membre> ln = new List <Membre>();

        try
        {
            string token = ConnectFromAndroid(username, password, device, version, fonction);

            bool court = true;
            if (token == "1")
            {
                court = false;
            }

            lm = DataMapping.ListMembers(cric, critere, top, tri, index, max, onlyvisible, court);

            //DateTime now = DateTime.Now;
            //int year = 0;
            //int.TryParse(now.ToString("yyyy"), out year);

            foreach (Member m in lm)
            {
                m.photo = HttpContext.Current.Server.MapPath(m.GetPhoto());

                //if (year > 0)
                //{
                //Affectation aff = DataMapping.GetAffectation(m.nim, year);
                Affectation aff = DataMapping.GetAffectation(m.nim, Functions.GetRotaryYear());
                if (aff != null && !string.IsNullOrEmpty(aff.function))
                {
                    m.fonction_rotarienne = aff.function;
                }
                //}

                ln.Add(memberToMembre(m));
            }
        }
        catch (Exception ee)
        {
            code    = "erreur";
            comment = ee.ToString();

            Functions.Error(ee);
        }

        string output = JsonConvert.SerializeObject(ln, Formatting.Indented);

        DataMapping.InsertLogWS(os, device, version, getIP(), dt, getDuree(dt), fonction, code, comment, username);
        return(output);
    }
        public ActionResult Create(AffectationViewModel avm)
        {
            Affectation f = new Affectation()
            {
                DateEnvoi = DateTime.Now,
                Etat      = Etat.envoyée,
                Mannequin = servicem.GetById(avm.CIN),
            };

            serviAff.Add(f);
            serviAff.Commit();
            return(RedirectToAction("Index"));
        }
Esempio n. 12
0
 public ActionResult Edit([Bind(Include = "Id,DateAffectation,DureeCours,ClasseId,ProfesseurId,MatiereId,QuantumHoraire")] Affectation affectation)
 {
     if (ModelState.IsValid)
     {
         db.Entry(affectation).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.ClasseId     = new SelectList(db.classes, "Id", "Libelle", affectation.ClasseId);
     ViewBag.MatiereId    = new SelectList(db.matieres, "Id", "Libelle", affectation.MatiereId);
     ViewBag.ProfesseurId = new SelectList(db.professeurs, "Id", "Prenom", affectation.ProfesseurId);
     return(View(affectation));
 }
Esempio n. 13
0
        private AbstractExpression getExpression()
        {
            Affectation exp = null;

            if (Program.mainMontage.mapOfCalculExpressions.TryGetValue(this.name, out exp))
            {
                return(exp.expression);
            }
            else
            {
                return(null);
            }
        }
Esempio n. 14
0
        public JsonResult Update(Affectation affectation)
        {
            Affectation aff = db.affectations.Find(affectation.Id);

            aff.DateAffectation = affectation.DateAffectation;
            aff.DureeCours      = affectation.DureeCours;
            aff.ClasseId        = affectation.ClasseId;
            aff.ProfesseurId    = affectation.ProfesseurId;
            aff.MatiereId       = affectation.MatiereId;
            aff.QuantumHoraire  = affectation.QuantumHoraire;
            db.SaveChanges();
            return(Json(1, JsonRequestBehavior.AllowGet));
        }
 public void Ajouter_Expedition(int client, int produit, int quantite)
 {
     clsE            = new Affectation();
     clsE.ID_Client  = client;
     clsE.ID_Produit = produit;
     clsE            = db.Affectations.SingleOrDefault(s => s.ID_Client == client && s.ID_Produit == produit);
     if (clsE != null)
     //if (db.Affectations.SingleOrDefault(s => s.ID_Client == client && s.ID_Produit == produit) != null)// si existe pas
     {
         clsE.Quantite_affectee = clsE.Quantite_affectee - quantite;
         db.SaveChanges();
     }
 }
Esempio n. 16
0
        // GET: Affectations/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Affectation affectation = db.affectations.Find(id);

            if (affectation == null)
            {
                return(HttpNotFound());
            }
            return(View(affectation));
        }
        public ActionResult <Affectation> Put(int id, Affectation affectation)
        {
            var a = _affectationDao.GetById(id);

            if (a == null)
            {
                return(NotFound());
            }

            a.ConsultantId       = affectation.ConsultantId;
            a.ProjectId          = affectation.ProjectId;
            affectation.Datetime = DateTime.Now;
            return(_affectationDao.Update(a));
        }
Esempio n. 18
0
        private void DataShow_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
        {
            DataBases bd = new DataBases();

            Debug.WriteLine("------" + DataShow.Columns[e.ColumnIndex].Name);
            if (DataShow.Columns[e.ColumnIndex].Name == "Supprimer")
            {
                if (DataShow.Rows[e.RowIndex].Cells[2].Value.ToString() == "non-affecter")
                {
                    MessageBox.Show("pas d'affectation");
                }
                else
                if (MessageBox.Show("Voulez-vous vraiment le supprimer\n" + DataShow.Rows[e.RowIndex].Cells[1].Value + "?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                {
                    if (bd.DeleteAffercation(DataShow.Rows[e.RowIndex].Cells[1].Value.ToString()))
                    {
                        MessageBox.Show("bien supprimer");
                    }
                    else
                    {
                        MessageBox.Show("error");
                    }
                }
            }
            if (DataShow.Columns[e.ColumnIndex].Name == "Affecter_modifier")
            {
                String      name     = DataShow.Rows[e.RowIndex].Cells[0].Value.ToString();
                String      username = DataShow.Rows[e.RowIndex].Cells[1].Value.ToString();
                Affectation l        = new Affectation(this);
                l.chercheur.Text = name + " ," + username;
                IGetEquipes.IGetEquipes getEquipes = (IGetEquipes.IGetEquipes)Activator.GetObject(typeof(IGetEquipes.IGetEquipes), "tcp://localhost:8086/getEquipes");
                try
                {
                    List <Equipe> equipes = getEquipes.GetEquipes();
                    foreach (Equipe equipe in equipes)
                    {
                        l.equipes.Items.Add(equipe);
                    }
                    l.Show();
                }
                catch
                {
                    MessageBox.Show("verfier la cnx ");
                }
            }
            ClearData();
            DataInTable();
        }
Esempio n. 19
0
    protected void dataList_Members_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        Affectation affectation = (Affectation)e.Item.DataItem;
        Member      member      = DataMapping.GetMemberByNim(affectation.nim);
        Image       Image1      = (Image)e.Item.FindControl("Image1");

        if (member != null)
        {
            Image1.ImageUrl = member.GetPhoto();
        }
        else
        {
            Image1.ImageUrl = Const.MEMBERS_NOPHOTO_H;
        }

        Label LBL_Club = (Label)e.Item.FindControl("LBL_Club");

        LBL_Club.Text = DataMapping.GetClub(affectation.cric).name;

        Label LBL_Nom = (Label)e.Item.FindControl("LBL_Nom");

        LBL_Nom.Text = affectation.name;

        HyperLink HL_Contact = (HyperLink)e.Item.FindControl("HL_Contact");

        if (member != null)
        {
            PortalSettings ps = PortalController.GetCurrentPortalSettings();
            if (ps.UserInfo.Roles != null && ps.UserInfo.Roles.Count() > 0)
            {
                HL_Contact.NavigateUrl = "javascript:dnnModal.show('/AIS/contact.aspx?id=" + member.id + "&popUp=true',false,350,850,false);";
            }
            else
            {
                HL_Contact.NavigateUrl = "javascript:dnnModal.show('/AIS/contact.aspx?id=" + member.id + "&popUp=true',false,350,500,false);";
            }

            if (member.IsWoman() == true)
            {
                HL_Contact.Text = "La contacter";
            }
        }
        else
        {
            HL_Contact.Visible = false;
        }
    }
Esempio n. 20
0
        // GET: Affectations/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Affectation affectation = db.affectations.Find(id);

            if (affectation == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ClasseId     = new SelectList(db.classes, "Id", "Libelle", affectation.ClasseId);
            ViewBag.MatiereId    = new SelectList(db.matieres, "Id", "Libelle", affectation.MatiereId);
            ViewBag.ProfesseurId = new SelectList(db.professeurs, "Id", "Prenom", affectation.ProfesseurId);
            return(View(affectation));
        }
Esempio n. 21
0
    /// <summary>
    /// Permet de valider les modifications des AAR
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void BT_Valider_Click(object sender, EventArgs e)
    {
        if (!(UserInfo.IsSuperUser || UserInfo.IsInRole(Const.ADMIN_ROLE) || UserInfo.IsInRole(Const.ROLE_ADMIN_CLUB) || UserInfo.IsInRole(Const.ROLE_ADMIN_DISTRICT) || DataMapping.isADG(Functions.GetCurrentMember().id)))
        {
            return;
        }

        int cric = Functions.CurrentCric;
        List <Affectation> affectations = new List <Affectation>();

        foreach (Control row in Panel1.Controls)
        {
            if (row is DropDownList)
            {
                DropDownList dl  = row as DropDownList;
                string[]     ids = dl.ID.Split(new char[] { '_' }, StringSplitOptions.RemoveEmptyEntries);

                Affectation affectation = new Affectation();
                affectation.cric     = cric;
                affectation.function = ids[ids.Length - 1];

                int nim = 0;
                int.TryParse("" + dl.SelectedValue, out nim);
                affectation.nim  = nim;
                affectation.name = dl.SelectedIndex > 0 ? dl.Items[dl.SelectedIndex].Text : "";
                if (affectation.name != "")
                {
                    affectations.Add(affectation);
                }
            }
        }
        if (DataMapping.UpdateAffectationRY(cric, int.Parse(RB_AR.SelectedValue), affectations))
        {
            Club c = AIS.DataMapping.GetClub(cric);

            string subject = "[Rotary 1730] Information";
            string body    = "Le bureau du club " + c.name + " vient d'être modifié pour l'année " + RB_AR.SelectedValue + ".";


            AIS.Functions.SendMail("*****@*****.**", subject, body);
            AIS.Functions.SendMail("*****@*****.**", subject, body);
        }
    }
        public void Ajouter_Affectation(int client, int produit, int quantite)
        {
            clsA            = new Affectation();
            clsA.ID_Client  = client;
            clsA.ID_Produit = produit;

            if (db.Affectations.SingleOrDefault(s => s.ID_Client == client && s.ID_Produit == produit) == null)// si existe pas
            {
                clsA.Quantite_affectee = quantite;
                db.Affectations.Add(clsA);
                db.SaveChanges();
            }
            else
            {
                clsA = db.Affectations.SingleOrDefault(s => s.ID_Client == client && s.ID_Produit == produit);
                clsA.Quantite_affectee = clsA.Quantite_affectee + quantite;
                db.SaveChanges();
            }
        }
Esempio n. 23
0
        private void modifierToolStripMenuItem_Click(object sender, EventArgs e)
        {
            FRM_Produit_Livraison frm = new FRM_Produit_Livraison(this);
            Produit     PR            = new Produit();
            Affectation QteAff        = new Affectation();

            if (dvgDetailLivraison.CurrentRow != null)
            {
                frm.lblTitre.Text          = "Modifier Livraison";
                frm.txtIdClientAffect.Text = IDDEST.ToString();
                frm.txtIdProduit.Text      = dvgDetailLivraison.CurrentRow.Cells[0].Value.ToString();
                frm.lblnom.Text            = dvgDetailLivraison.CurrentRow.Cells[1].Value.ToString();
                ////Importer inventaire de produit depuis le datagrid produit//////
                int IDP = int.Parse(dvgDetailLivraison.CurrentRow.Cells[0].Value.ToString());
                PR = db.Produits.Single(s => s.ID_Produit == IDP);
                frm.lblInv.Text      = PR.NumInventaire.ToString();;
                frm.txtquantite.Text = dvgDetailLivraison.CurrentRow.Cells[2].Value.ToString();
                frm.ShowDialog();
            }
        }
        public async Task <ActionResult <Affectation> > PostAffectation(Affectation affectation)
        {
            _context.Affectation.Add(affectation);
            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateException)
            {
                if (AffectationExists(affectation.IdFiliere))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            return(CreatedAtAction("GetAffectation", new { id = affectation.IdFiliere }, affectation));
        }
Esempio n. 25
0
        private static void ImportTache(IXLWorksheet sheet, ref int line, Tache t, JourEvenement jour, Planning p, FestivArtsContext ctx)
        {
            IXLRow timeRow = sheet.Row(line);

            line++;
            int   maxB     = t.GetMaxBenevoleByDay(jour.Id);
            Regex regex    = new Regex("^([0-9]+)");
            var   aAjouter = new Dictionary <int, HashSet <int> >();


            for (int l = 0; l < maxB; l++)
            {
                IXLRow r = sheet.Row(line);
                int    i = ExcelUtils.FIRST_PLAN_COLUMN;
                foreach (CreneauDef d in jour.CreneauDefs.OrderBy(s => s.NoCreneau))
                {
                    var    cell   = r.Cell(i);
                    string benStr = cell.Value.ToString();

                    if (!string.IsNullOrWhiteSpace(benStr))
                    {
                        var m = regex.Match(benStr.Trim());
                        if (m.Success)
                        {
                            int id = int.Parse(m.Groups[0].Captures[0].Value);
                            var b  = ctx.Benevoles.FirstOrDefault(s => s.Id == id);
                            if (b == null)
                            {
                                throw new ImportException(string.Format("Cell ({0}) Tache {1} : n° de bénévole introuvable : {2}'", cell.Address.ToStringRelative(true), t.Nom, benStr));
                            }
                            var c = t.Creneaux.FirstOrDefault(s => s.CreneauDefId == d.Id);
                            if (c == null)
                            {
                                throw new ImportException(string.Format("Cell ({0}) Tache {1} : creneau introuvable. Creneau def {2}'", cell.Address.ToStringRelative(true), t.Nom, d.Id));
                            }

                            if (!aAjouter.ContainsKey(b.Id))
                            {
                                aAjouter.Add(b.Id, new HashSet <int>());
                            }
                            if (!aAjouter[b.Id].Contains(c.Id))
                            {
                                aAjouter[b.Id].Add(c.Id);
                            }
                        }
                        else
                        {
                            throw new ImportException(string.Format("Cell ({0}) ne correspond pas a un n° de bénévole : {1}'", cell.Address.ToStringRelative(true), benStr));
                        }
                    }
                    i++;
                }
                line++;
            }
            if (aAjouter.Count > 0)
            {
                var anciensA = ctx.Affectations.Where(s => s.Creneau.CreneauDef.JourId == jour.Id &&
                                                      s.PlanningId == p.Id && s.Creneau.TacheId == t.Id).ToList();
                foreach (Affectation a in anciensA)
                {
                    if (aAjouter.ContainsKey(a.BenevoleId) && aAjouter[a.BenevoleId].Contains(a.CreneauId))
                    {
                        //L'affectation existait déjà, on ne fait rien
                        aAjouter[a.BenevoleId].Remove(a.CreneauId);
                    }
                    else
                    {
                        //N'existe plus, on la supprime;
                        ctx.Affectations.Remove(a);
                    }
                }

                foreach (var kv in aAjouter.Where(s => s.Value.Count > 0).ToList())
                {
                    foreach (var v in kv.Value)
                    {
                        Affectation a = new Affectation()
                        {
                            BenevoleId = kv.Key,
                            CreneauId  = v,
                            PlanningId = p.Id
                        };
                        ctx.Affectations.Add(a);
                    }
                }
                ctx.SaveChanges();
            }
        }
        static void Main(string[] args)
        {
            GestionProjet gs = new GestionProjet();

            Ingenieur j1 = new Ingenieur()
            {
                Id     = 1,
                Nom    = "Dhia",
                Prenom = "Saadlaui",
                Email  = "*****@*****.**", Specialite = Specialite.GL
            };
            Ingenieur j2 = new Ingenieur()
            {
                Id         = 1,
                Nom        = "Amal",
                Prenom     = "aaaaaaaaaaaa",
                Email      = "aaaaaaaaaaaa",
                Specialite = Specialite.GL
            };

            Ingenieur j3 = new Ingenieur()
            {
                Id         = 1,
                Nom        = "Dhia",
                Prenom     = "Saadlaui",
                Email      = "*****@*****.**",
                Specialite = Specialite.GL
            };

            Ingenieur j4 = new Ingenieur()
            {
                Id         = 1,
                Nom        = "Dhia",
                Prenom     = "Saadlaui",
                Email      = "*****@*****.**",
                Specialite = Specialite.GL
            };
            ChefProjet cf1 = new ChefProjet()
            {
                // here to fill object props
            };
            ChefProjet cf2 = new ChefProjet()
            {
                // here to fill object props
            };
            Affectation af1 = new Affectation()
            {
                // here to fill object props
            };
            Affectation af2 = new Affectation()
            {
                // here to fill object props
            };

            //TO TEST Extension Method
            //  gs.AjoutProjet(new Projet(){Nom = "projet1"});

            // METHOD 1

            var Query =
                from AFF in gs.Affectations
                join chef in gs.ChefProjets on AFF.Projet.chef equals chef
                group AFF by AFF.Projet into g
                where g.Key.chef.Experiance > 7
                select g;


            foreach (var aff in Query)
            {
                Console.WriteLine(aff.GetEnumerator());
            }
            // METHOD 2
            var innerJoinQuery =
                from chef in gs.ChefProjets
                where chef.Experiance > 7
                select chef;


            foreach (var chef in innerJoinQuery)
            {
                foreach (var projet in chef.Projets)
                {
                    Console.WriteLine(gs.Affectations.FindAll(affectation => affectation.Projet == projet));
                }
            }

            Console.ReadKey();
        }
Esempio n. 27
0
        public void ActualiserdvgAlerte()
        {
            dgvDate.Columns[5].DefaultCellStyle.Format = "dd/MM/yyyy";
            db = new dbStockContext();
            dgvDate.Rows.Clear();
            var listerecherche = db.Produits.ToList();

            if (combocategorieCtrl.SelectedItem != null && comboTypeCtrl.SelectedItem != null)
            {
                string CategRech = combocategorieCtrl.SelectedValue.ToString();
                int    IdCat;
                bool   testCat  = Int32.TryParse(CategRech, out IdCat);
                string TypeRech = comboTypeCtrl.SelectedValue.ToString();
                int    IdTyp;
                bool   testTyp = Int32.TryParse(TypeRech, out IdTyp);
                string IdRech  = txtrechercheInvProdCtrl.Text;
                int    IdProd;
                bool   testProd = Int32.TryParse(IdRech, out IdProd);
                listerecherche = listerecherche.Where(s => s.NumInventaire.IndexOf(txtrechercheInvProdCtrl.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && s.Nom_Produit.IndexOf(txtrechercheNomCtrl.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && IdTyp == s.ID_Type && IdCat == s.ID_Categorie).ToList();
            }
            if (combocategorieCtrl.SelectedItem != null)
            {
                string CategRecherche = combocategorieCtrl.SelectedValue.ToString();
                int    IdCateg;
                bool   testCateg = Int32.TryParse(CategRecherche, out IdCateg);
                listerecherche = listerecherche.Where(s => s.NumInventaire.IndexOf(txtrechercheInvProdCtrl.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && s.Nom_Produit.IndexOf(txtrechercheNomCtrl.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && IdCateg == s.ID_Categorie).ToList();
            }
            if (comboTypeCtrl.SelectedItem != null)
            {
                string TypeRecherche = comboTypeCtrl.SelectedValue.ToString();
                int    IdType;
                bool   testType = Int32.TryParse(TypeRecherche, out IdType);
                listerecherche = listerecherche.Where(s => s.NumInventaire.IndexOf(txtrechercheInvProdCtrl.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && s.Nom_Produit.IndexOf(txtrechercheNomCtrl.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && IdType == s.ID_Type).ToList();
            }
            if (combocategorieCtrl.SelectedItem == null && comboTypeCtrl.SelectedItem == null)
            {
                listerecherche = listerecherche.Where(s => s.NumInventaire.IndexOf(txtrechercheInvProdCtrl.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && s.Nom_Produit.IndexOf(txtrechercheNomCtrl.Text, StringComparison.CurrentCultureIgnoreCase) != -1).ToList();
            }

            Categorie   Cat       = new Categorie();
            Type        Typ       = new Type();//ajout pout type
            Affectation IDAffect  = new Affectation();
            Client      NomClient = new Client();

            foreach (var Lis in listerecherche)
            {
                Cat = db.Categories.SingleOrDefault(s => s.ID_Categorie == Lis.ID_Categorie);
                Typ = db.Types.SingleOrDefault(s => s.ID_Type == Lis.ID_Type);//ajout type

                if (Lis.Date_Controle != "")
                {
                    DateTime date       = Convert.ToDateTime(Lis.Date_Controle.ToString());
                    DateTime dateDuJour = DateTime.Now;
                    int      nbJours    = (date - dateDuJour).Days;
                    if (Cat != null & Typ != null & nbJours <= 30)//si existe
                    {
                        if (db.Affectations.SingleOrDefault(s => s.ID_Produit == Lis.ID_Produit) != null)
                        {
                            IDAffect  = db.Affectations.SingleOrDefault(s => s.ID_Produit == Lis.ID_Produit);
                            NomClient = db.Clients.SingleOrDefault(s => s.ID_Client == IDAffect.ID_Client);
                            dgvDate.Rows.Add(Lis.ID_Produit, Cat.Nom_Categorie, Typ.Nom_Type, Lis.NumInventaire, Lis.Nom_Produit, Lis.Date_Controle, nbJours, NomClient.Nom_Client + " " + NomClient.Prenom_Client);//cat.Nom pour afficher nom de cagorie depuis table categorie
                        }
                        else
                        {
                            NomClient = null;
                            dgvDate.Rows.Add(Lis.ID_Produit, Cat.Nom_Categorie, Typ.Nom_Type, Lis.NumInventaire, Lis.Nom_Produit, Lis.Date_Controle, nbJours, NomClient);//cat.Nom pour afficher nom de cagorie depuis table categorie
                        }
                    }
                }
            }
            PL.USER_Dashboard.Instance.txtNbreDateCtrlAlerte.Text = (dgvDate.Rows.Count.ToString());

            for (int i = 0; i < dgvDate.Rows.Count; i++)
            {
                if ((int)dgvDate.Rows[i].Cells[6].Value <= 0)
                {
                    dgvDate.Rows[i].Cells[6].Style.BackColor = Color.DimGray;
                }
                else
                {
                    dgvDate.Rows[i].Cells[6].Style.BackColor = Color.DarkGray;
                }
                dgvDate.ClearSelection();
            }
        }
Esempio n. 28
0
        public void ActualiserdvgStock()
        {
            db = new dbStockContext();
            dgvStock.Rows.Clear();
            var listerecherche = db.Produits.ToList();

            if (combocategorieStock.SelectedItem != null && combotypeStock.SelectedItem != null)
            {
                string CategRech = combocategorieStock.SelectedValue.ToString();
                int    IdCat;
                bool   testCat  = Int32.TryParse(CategRech, out IdCat);
                string TypeRech = combotypeStock.SelectedValue.ToString();
                int    IdTyp;
                bool   testTyp = Int32.TryParse(TypeRech, out IdTyp);
                string IdRech  = txtrechercheInvProdStock.Text;
                int    IdProd;
                bool   testProd = Int32.TryParse(IdRech, out IdProd);
                listerecherche = listerecherche.Where(s => s.NumInventaire.IndexOf(txtrechercheInvProdStock.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && s.Nom_Produit.IndexOf(txtrechercheNomStock.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && IdTyp == s.ID_Type && IdCat == s.ID_Categorie).ToList();
            }
            if (combocategorieStock.SelectedItem != null)
            {
                string CategRecherche = combocategorieStock.SelectedValue.ToString();
                int    IdCateg;
                bool   testCateg = Int32.TryParse(CategRecherche, out IdCateg);
                listerecherche = listerecherche.Where(s => s.NumInventaire.IndexOf(txtrechercheInvProdStock.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && s.Nom_Produit.IndexOf(txtrechercheNomStock.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && IdCateg == s.ID_Categorie).ToList();
            }
            if (combotypeStock.SelectedItem != null)
            {
                string TypeRecherche = combotypeStock.SelectedValue.ToString();
                int    IdType;
                bool   testType = Int32.TryParse(TypeRecherche, out IdType);
                listerecherche = listerecherche.Where(s => s.NumInventaire.IndexOf(txtrechercheInvProdStock.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && s.Nom_Produit.IndexOf(txtrechercheNomStock.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && IdType == s.ID_Type).ToList();
            }
            if (combocategorieStock.SelectedItem == null && combotypeStock.SelectedItem == null)
            {
                listerecherche = listerecherche.Where(s => s.NumInventaire.IndexOf(txtrechercheInvProdStock.Text, StringComparison.CurrentCultureIgnoreCase) != -1 && s.Nom_Produit.IndexOf(txtrechercheNomStock.Text, StringComparison.CurrentCultureIgnoreCase) != -1).ToList();
            }

            Categorie   Cat      = new Categorie();
            Type        Typ      = new Type();
            Affectation IDAffect = new Affectation();

            //foreach (var Lis in db.Produits)
            foreach (var Lis in listerecherche)
            {
                Cat = db.Categories.SingleOrDefault(s => s.ID_Categorie == Lis.ID_Categorie);
                Typ = db.Types.SingleOrDefault(s => s.ID_Type == Lis.ID_Type);
                int Depot = 14;
                if (db.Affectations.SingleOrDefault(s => s.ID_Produit == Lis.ID_Produit && s.ID_Client == Depot) != null) // si produit affecte sur depot central ID = 10
                {
                    if ((Lis.Stock_Alerte) != "")                                                                         // si un stock d'alerte est renseigne
                    {
                        if (Lis.ID_Type != 3)                                                                             //si le produit n'est pas un unitaire
                        {
                            IDAffect = (db.Affectations.SingleOrDefault(s => s.ID_Produit == Lis.ID_Produit && s.ID_Client == Depot));
                            if (IDAffect.Quantite_affectee <= int.Parse(Lis.Stock_Alerte)) //si stock en alerte
                            {
                                dgvStock.Rows.Add(Lis.ID_Produit, Cat.Nom_Categorie, Typ.Nom_Type, Lis.NumInventaire, Lis.Nom_Produit, IDAffect.Quantite_affectee, Lis.Stock_Alerte);
                            }
                        }
                    }
                }
            }
            PL.USER_Dashboard.Instance.txtNbreStockAlerte.Text = (dgvStock.Rows.Count.ToString());

            for (int i = 0; i < dgvStock.Rows.Count; i++)
            {
                if ((int)dgvStock.Rows[i].Cells[5].Value == 0)
                {
                    dgvStock.Rows[i].Cells[5].Style.BackColor = Color.DimGray;
                }
                else
                {
                    dgvStock.Rows[i].Cells[5].Style.BackColor = Color.DarkGray;
                }
                dgvStock.ClearSelection();
            }
        }
Esempio n. 29
0
 public bool Delete(Affectation affectation)
 {
     _afdtechContext.Affectations.Remove(affectation);
     _afdtechContext.SaveChanges();
     return(true);
 }
Esempio n. 30
0
 public Affectation Update(Affectation affectation)
 {
     _afdtechContext.Affectations.Update(affectation);
     _afdtechContext.SaveChanges();
     return(affectation);
 }