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);
}
