public ModeleDeGamme GetOne(int id) { ModeleDeGamme dto = new ModeleDeGamme(); using (var db = new maderaEntities()) { var query = from a in db.MODELE_DE_GAMME where a.MODELE_GAMME_ID.Equals(id) select a; dto.Id = query.First().MODELE_GAMME_ID; dto.Nom = query.First().MODELE_GAMME_NOM; dto.Description = query.First().MODELE_GAMME_DESCRIPTION; dto.EstParDefaut = query.First().EST_PAR_DEFAUT; dto.NbPieces = query.First().MODELE_GAMME_NB_PIECES; dto.Surface = query.First().MODELE_GAMME_SURFACE; dto.TypeModeleGamme = typeModeleGammeRepository.GetOne(query.First().TYPE_MODELE_GAMME_ID); dto.Gamme = gammeRepository.GetOne(query.First().GAMME_ID); var image = from a in db.MODELE_GAMME_IMAGE where a.MODELE_GAMME_ID.Equals(dto.Id) select a; if (image.Count() != 0) { dto.Image = fichierRepository.GetOne(image.First().FICHIER_ID); } var queryFinitions = from a in db.LIER_FINITION where a.MODELE_GAMME_ID.Equals(id) select a; List <Finition> finitions = new List <Finition>(); foreach (var item in queryFinitions) { finitions.Add(finitionRepository.getOne(item.FINITION_ID)); } dto.Finitions = finitions; dto.Modules = moduleRepository.GetCompositionByIdModeleGamme(id); } return(dto); }
public List <Finition> getByModeleDeGamme(ModeleDeGamme modele) { List <Finition> dtos = new List <Finition>(); using (var db = new maderaEntities()) { var lierFinition = from a in db.LIER_FINITION where a.MODELE_GAMME_ID.Equals(modele.Id) select a; foreach (var item in lierFinition) { var query = from a in db.FINITION where a.FINITION_ID.Equals(item.FINITION_ID) select a; Finition finition = new Finition(); finition.Id = query.First().FINITION_ID; finition.Nom = query.First().FINITION_NOM; finition.Description = query.First().FINITION_DESCRIPTION; finition.TypeFinition = typeFinitionRepository.GetOne(query.First().TYPE_FINITION_ID); var fichier = from a in db.FINITION_IMAGE where a.FINITION_ID.Equals(finition.Id) select a; if (fichier.Count() > 0) { finition.Image = fichierRepository.GetOne(fichier.First().FICHIER_ID); } dtos.Add(finition); } } return(dtos); }
protected void BtnSelectionModeleGamme_Click(object sender, EventArgs e) { Button BtnSelectionModeleGamme = (Button)sender; ModeleDeGamme foundModeleGamme = modelGammeRepository.GetOne(int.Parse(BtnSelectionModeleGamme.ID)); Session["selectedModeleGamme"] = foundModeleGamme; Session["downPanelId"] = "panelFinition"; refreshFinitionPanel(foundModeleGamme); }
public int Add(ModeleDeGamme dto) { MODELE_DE_GAMME entity = new MODELE_DE_GAMME(); entity.GAMME_ID = dto.Gamme.Id; entity.EST_PAR_DEFAUT = dto.EstParDefaut; entity.MODELE_GAMME_DESCRIPTION = dto.Description; entity.MODELE_GAMME_NB_PIECES = dto.NbPieces; entity.MODELE_GAMME_SURFACE = dto.Surface; entity.MODELE_GAMME_NOM = dto.Nom; entity.TYPE_MODELE_GAMME_ID = dto.TypeModeleGamme.Id; entity.GAMME_ID = dto.Gamme.Id; using (var db = new maderaEntities()) { db.MODELE_DE_GAMME.Add(entity); db.SaveChanges(); var queryModele = (from a in db.MODELE_DE_GAMME orderby a.MODELE_GAMME_ID descending select a); foreach (var item in dto.Finitions) { LIER_FINITION entityFin = new LIER_FINITION(); entityFin.FINITION_ID = item.Id; entityFin.MODELE_GAMME_ID = queryModele.First().MODELE_GAMME_ID; db.LIER_FINITION.Add(entityFin); db.SaveChanges(); } //var query = from a in db.MODELE_DE_GAMME; foreach (var mod in dto.Modules) { LIER_MODULE entityFin2 = new LIER_MODULE(); entityFin2.HAUTEUR = mod.Hauteur; entityFin2.IDENTIFICATION = mod.Identification; entityFin2.LONGUEUR = mod.Longueur; entityFin2.MODELE_GAMME_ID = queryModele.First().MODELE_GAMME_ID; entityFin2.SECTION = mod.Section; entityFin2.MODULE_ID = mod.Module.Id; db.LIER_MODULE.Add(entityFin2); db.SaveChanges(); } } return(entity.MODELE_GAMME_ID); }
public List <ModuleCompose> GetCompositionByModeleGamme(ModeleDeGamme modeleGamme) { List <ModuleCompose> dtos = new List <ModuleCompose>(); using (var db = new maderaEntities()) { var queryLierModule = from a in db.LIER_MODULE where a.MODELE_GAMME_ID.Equals(modeleGamme.Id) select a; foreach (var item in queryLierModule) { ModuleCompose dto = new ModuleCompose(); dto.Section = item.SECTION; dto.Module = GetOne(item.MODULE_ID); dto.Hauteur = item.HAUTEUR; dto.Longueur = item.LONGUEUR; dto.Identification = item.IDENTIFICATION; dtos.Add(dto); } } return(dtos); }
public List <ModeleDeGamme> GetByGamme(Gamme gamme) { List <ModeleDeGamme> dtos = new List <ModeleDeGamme>(); using (var db = new maderaEntities()) { var query = from a in db.MODELE_DE_GAMME where a.GAMME_ID.Equals(gamme.Id) select a; foreach (var item in query) { ModeleDeGamme dto = new ModeleDeGamme(); dto.Id = (int)item.MODELE_GAMME_ID; dto.Nom = item.MODELE_GAMME_NOM; dto.Description = item.MODELE_GAMME_DESCRIPTION; dto.EstParDefaut = item.EST_PAR_DEFAUT; dto.NbPieces = item.MODELE_GAMME_NB_PIECES; dto.Surface = item.MODELE_GAMME_SURFACE; dto.TypeModeleGamme = typeModeleGammeRepository.GetOne(item.TYPE_MODELE_GAMME_ID); dto.Gamme = gammeRepository.GetOne(item.GAMME_ID); var image = from a in db.MODELE_GAMME_IMAGE where a.MODELE_GAMME_ID.Equals(dto.Id) select a; if (image.Count() != 0) { //TODO : Plante quand il n'y a pas d'image dto.Image = fichierRepository.GetOne(image.First().FICHIER_ID); } var queryFinitions = from a in db.LIER_FINITION where a.MODELE_GAMME_ID.Equals(dto.Id) select a; List <Finition> finitions = new List <Finition>(); foreach (var itemFin in queryFinitions) { finitions.Add(finitionRepository.getOne(itemFin.FINITION_ID)); } dto.Finitions = finitions; dtos.Add(dto); } } return(dtos); }
private void refreshFinitionPanel(ModeleDeGamme selectedModeleDeGamme) { downPanel.Controls.Clear(); //TODO : get finition by gamme //Couverture Label labelToit = new Label(); labelToit.Text = "Couverture"; labelToit.CssClass = "control-label col-sm-4"; DropDownList selectToit = new DropDownList(); selectToit.DataSource = finitionRepository.getByGamme(selectedModeleDeGamme.Gamme).FindAll(i => i.TypeFinition.Nom == "Couverture"); //selectToit.DataSource = finitionRepository.getByModeleDeGamme(selectedModeleDeGamme).FindAll(i => i.TypeFinition.Nom == "Couverture"); selectToit.DataTextField = "Nom"; selectToit.DataValueField = "Id"; selectToit.DataBind(); selectToit.ID = "selectToit"; selectToit.CssClass = "form-control"; Panel pan = new Panel(); pan.CssClass = "form-group"; pan.Controls.Add(labelToit); pan.Controls.Add(selectToit); downPanel.Controls.Add(pan); //Finition intérieure Label labelFinitionInterieure = new Label(); labelFinitionInterieure.Text = "Finition Intérieure"; labelFinitionInterieure.CssClass = "control-label col-sm-4"; DropDownList selectFinitionInterieure = new DropDownList(); selectFinitionInterieure.DataSource = finitionRepository.getByGamme(selectedModeleDeGamme.Gamme).FindAll(i => i.TypeFinition.Nom == "Finition intérieure"); selectFinitionInterieure.DataTextField = "Nom"; selectFinitionInterieure.DataValueField = "Id"; selectFinitionInterieure.DataBind(); selectFinitionInterieure.ID = "selectFinitionInterieure"; selectFinitionInterieure.CssClass = "form-control"; pan = new Panel(); pan.CssClass = "form-group"; pan.Controls.Add(labelFinitionInterieure); pan.Controls.Add(selectFinitionInterieure); downPanel.Controls.Add(pan); //Finition extérieure Label labelFinitionExterieure = new Label(); labelFinitionExterieure.Text = "Finition extérieure"; labelFinitionExterieure.CssClass = "control-label col-sm-4"; DropDownList selectFinitionExterieure = new DropDownList(); selectFinitionExterieure.DataSource = finitionRepository.getByGamme(selectedModeleDeGamme.Gamme).FindAll(i => i.TypeFinition.Nom == "Finition extérieure"); selectFinitionExterieure.DataTextField = "Nom"; selectFinitionExterieure.DataValueField = "Id"; selectFinitionExterieure.DataBind(); selectFinitionExterieure.ID = "selectFinitionExterieure"; selectFinitionExterieure.CssClass = "form-control"; pan = new Panel(); pan.CssClass = "form-group"; pan.Controls.Add(labelFinitionExterieure); pan.Controls.Add(selectFinitionExterieure); downPanel.Controls.Add(pan); //Isolation Label labelIsolation = new Label(); labelIsolation.Text = "Isolation"; labelIsolation.CssClass = "control-label col-sm-4"; DropDownList selectIsolation = new DropDownList(); selectIsolation.DataSource = finitionRepository.getByGamme(selectedModeleDeGamme.Gamme).FindAll(i => i.TypeFinition.Nom == "Isolation"); selectIsolation.DataTextField = "Nom"; selectIsolation.DataValueField = "Id"; selectIsolation.DataBind(); selectIsolation.ID = "selectIsolation"; selectIsolation.CssClass = "form-control"; pan = new Panel(); pan.CssClass = "form-group"; pan.Controls.Add(labelIsolation); pan.Controls.Add(selectIsolation); downPanel.Controls.Add(pan); //Plancher Label labelPlancher = new Label(); labelPlancher.Text = "Plancher"; labelPlancher.CssClass = "control-label col-sm-4"; DropDownList selectPlancher = new DropDownList(); selectPlancher.DataSource = finitionRepository.getByGamme(selectedModeleDeGamme.Gamme).FindAll(i => i.TypeFinition.Nom == "Plancher"); selectPlancher.DataTextField = "Nom"; selectPlancher.DataValueField = "Id"; selectPlancher.DataBind(); selectPlancher.ID = "selectPlancher"; selectPlancher.CssClass = "form-control"; pan = new Panel(); pan.CssClass = "form-group"; pan.Controls.Add(labelPlancher); pan.Controls.Add(selectPlancher); downPanel.Controls.Add(pan); //Qualité des huisseries Label labelHuisseries = new Label(); labelHuisseries.Text = "Huisseries"; labelHuisseries.CssClass = "control-label col-sm-4"; DropDownList selectHuisseries = new DropDownList(); selectHuisseries.DataSource = finitionRepository.getByGamme(selectedModeleDeGamme.Gamme).FindAll(i => i.TypeFinition.Nom == "Qualité des huisseries"); selectHuisseries.DataTextField = "Nom"; selectHuisseries.DataValueField = "Id"; selectHuisseries.DataBind(); selectHuisseries.ID = "selectHuisseries"; selectHuisseries.CssClass = "form-control"; pan = new Panel(); pan.CssClass = "form-group"; pan.Controls.Add(labelHuisseries); pan.Controls.Add(selectHuisseries); downPanel.Controls.Add(pan); Button validationFinitionButton = new Button(); validationFinitionButton.Text = "Valider"; validationFinitionButton.ID = "validationButtonId"; validationFinitionButton.CssClass = "btn btn-success"; validationFinitionButton.Click += new EventHandler(this.BtnConfigurerProduit_Click); downPanel.Controls.Add(validationFinitionButton); }