public static void insert_ArticoleDrepturi(int id_stud, int id_admin, DateTime data, int savoniera,
int sapun, int spuma, int aparat, int caiete, int rigla,
int guma, int crema, int maieu, int agrafe, int capse)
{
var bd = new DataLayer.Models.ProiectBDContext();
ArticoleDrepturi art = new ArticoleDrepturi
{
ID_Student = id_stud,
ID_Administrator = id_admin,
Data_Alocarii = data,
Savoniera = savoniera,
Sapun = sapun,
Spuma_ras = spuma,
Aparat_ras = aparat,
Caiete = caiete,
Rigla = rigla,
Guma = guma,
Crema = crema,
Maieu = maieu,
Agrafe = agrafe,
Capse = capse
};
bd.ArticoleDrepturis.Add(art);
bd.Entry(art).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static IQueryable<Models.newArticoleVest> get_ArticoleVest()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.ArticoleVests
join s in bd.Students on b.ID_Student equals s.ID_Student
join a in bd.Administratoris on b.ID_Administrator equals a.ID_Admistrator
select new newArticoleVest
{
ID_Student = b.ID_Student,
Nume_Student = s.Nume+" "+s.Prenume,
ID_Administrator = b.ID_Administrator,
Nume_Administrator = a.Nume+" "+a.Prenume,
Data_Alocarii = b.Data_Alocarii,
Bocanci = b.Bocanci,
Capela = b.Capela,
Cascheta = b.Cascheta,
Costum_Camuflaj = b.Costum_Camuflaj,
Costum_Tercot = b.Costum_Tercot,
Costum_Camgarn = b.Costum_Camgarn,
Camasa_Alba = b.Camasa_Alba,
Camasa_Arma = b.Camasa_Arma,
Camasa_Camuflaj = b.Camasa_Camuflaj,
Boneta = b.Boneta,
Fular = b.Fular,
Pantofi =b.Pantofi,
Ghete = b.Ghete,
Ecuson_Nominal= b.Ecuson_Nominal,
Ecuson_Romania = b.Ecuson_Romania,
Cuc = b.Cuc,
Cravata = b.Cravata,
Scurta_Oras =b.Scurta_Oras,
Scurta_Camuflat = b.Scurta_Camuflat
};
return query;
}
public static IQueryable<string> get_nume_Companie()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Companies
select b.Nume;
return query;
}
public static IQueryable<Models.Grade> get_Grade()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Grades
select b;
return query;
}
public static void insert_ArticoleDrepturi(int id_stud, int id_admin, DateTime data, int savoniera,
int sapun, int spuma, int aparat, int caiete, int rigla,
int guma, int crema, int maieu, int agrafe, int capse)
{
var bd = new DataLayer.Models.ProiectBDContext();
ArticoleDrepturi art = new ArticoleDrepturi
{
ID_Student = id_stud,
ID_Administrator = id_admin,
Data_Alocarii = data,
Savoniera = savoniera,
Sapun = sapun,
Spuma_ras = spuma,
Aparat_ras = aparat,
Caiete = caiete,
Rigla = rigla,
Guma = guma,
Crema = crema,
Maieu = maieu,
Agrafe = agrafe,
Capse = capse
};
bd.ArticoleDrepturis.Add(art);
bd.Entry(art).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static IQueryable <Models.newArticoleDrepturi> get_ArticoleDrepturi()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.ArticoleDrepturis
join s in bd.Students on b.ID_Student equals s.ID_Student
join a in bd.Administratoris on b.ID_Administrator equals a.ID_Admistrator
select new newArticoleDrepturi
{
ID_Student = b.ID_Student,
Nume_Student = s.Nume + " " + s.Prenume,
ID_Administrator = b.ID_Administrator,
Nume_Administrator = a.Nume + " " + a.Prenume,
Data_Alocarii = b.Data_Alocarii,
Savoniera = b.Savoniera,
Sapun = b.Sapun,
Spuma_ras = b.Spuma_ras,
Aparat_ras = b.Aparat_ras,
Caiete = b.Caiete,
Rigla = b.Rigla,
Guma = b.Guma,
Crema = b.Crema,
Maieu = b.Maieu,
Agrafe = b.Agrafe,
Capse = b.Capse
};
return(query);
}
public static IQueryable<Models.newArticoleDrepturi> get_ArticoleDrepturi()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.ArticoleDrepturis
join s in bd.Students on b.ID_Student equals s.ID_Student
join a in bd.Administratoris on b.ID_Administrator equals a.ID_Admistrator
select new newArticoleDrepturi
{
ID_Student = b.ID_Student,
Nume_Student = s.Nume + " " + s.Prenume,
ID_Administrator = b.ID_Administrator,
Nume_Administrator = a.Nume + " " + a.Prenume,
Data_Alocarii = b.Data_Alocarii,
Savoniera = b.Savoniera,
Sapun = b.Sapun,
Spuma_ras = b.Spuma_ras,
Aparat_ras = b.Aparat_ras,
Caiete = b.Caiete,
Rigla = b.Rigla,
Guma = b.Guma,
Crema = b.Crema,
Maieu = b.Maieu,
Agrafe = b.Agrafe,
Capse = b.Capse
};
return query;
}
public static IQueryable <SumarCompanie> get_sumar_comp_by_name(string name)
{
var bd = new DataLayer.Models.ProiectBDContext();
int query1 = (from b in bd.Administratoris
join c in bd.Companies on b.ID_Admistrator equals c.ID_Administrator
join d in bd.CDT_Comp on c.ID_Comandant equals d.ID_Comandant
join e in bd.Students on c.ID_Companie equals e.ID_Companie
where d.Nume == name
select e.ID_Student).Count();
var query = from b in bd.Administratoris
join c in bd.Companies on b.ID_Admistrator equals c.ID_Administrator
join d in bd.CDT_Comp on c.ID_Comandant equals d.ID_Comandant
join e in bd.Students on c.ID_Companie equals e.ID_Companie
where d.Nume == name
select new SumarCompanie
{
nume_comp = d.Nume,
nume_adm = b.Nume + " " + b.Prenume,
nume_cdt = d.Nume + " " + d.Prenume,
numar_stud = query1
};
return(query);
}
public static IQueryable <Models.Grade> get_Grade()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Grades
select b;
return(query);
}
public static IQueryable <string> get_nume_Companie()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Companies
select b.Nume;
return(query);
}
public static void insert_Grade(string grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
Grade gr = new Grade { Nume = grad };
bd.Grades.Add(gr);
bd.Entry(gr).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static IQueryable<Models.Preturi> get_Preturi()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Preturis
select b;
var x = query.ToList();
return query;
}
public static IQueryable <Models.Preturi> get_Preturi()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Preturis
select b;
var x = query.ToList();
return(query);
}
public static void delete_Administratori(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = (from b in bd.Administratoris
where b.ID_Admistrator == id
select b).First();
bd.Administratoris.Remove(query);
bd.Entry(query).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_Student(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var st = (from b in bd.Students
where b.ID_Student == id
select b).First();
bd.Students.Remove(st);
bd.Entry(st).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_Grade(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var gr = (from g in bd.Grades
where g.ID_Grad == id
select g).First();
bd.Grades.Remove(gr);
bd.Entry(gr).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_Companie(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var comp = (from b in bd.Companies
where b.ID_Companie == id
select b).First();
bd.Companies.Remove(comp);
bd.Entry(comp).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_CDT_Comp(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var cdt = (from b in bd.CDT_Comp
where b.ID_Comandant == id
select b).First();
bd.CDT_Comp.Remove(cdt);
bd.Entry(cdt).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_Companie(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var comp = (from b in bd.Companies
where b.ID_Companie == id
select b).First();
bd.Companies.Remove(comp);
bd.Entry(comp).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_Grade(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var gr = (from g in bd.Grades
where g.ID_Grad == id
select g).First();
bd.Grades.Remove(gr);
bd.Entry(gr).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_Preturi(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var pr = (from b in bd.Preturis
where b.ID_Pret == id
select b).First();
bd.Preturis.Remove(pr);
bd.Entry(pr).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void insert_Grade(string grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
Grade gr = new Grade {
Nume = grad
};
bd.Grades.Add(gr);
bd.Entry(gr).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void delete_CDT_Comp(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var cdt = (from b in bd.CDT_Comp
where b.ID_Comandant == id
select b).First();
bd.CDT_Comp.Remove(cdt);
bd.Entry(cdt).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_Preturi(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var pr = (from b in bd.Preturis
where b.ID_Pret == id
select b).First();
bd.Preturis.Remove(pr);
bd.Entry(pr).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_Administratori(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = (from b in bd.Administratoris
where b.ID_Admistrator == id
select b).First();
bd.Administratoris.Remove(query);
bd.Entry(query).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void update_Grade(int id, string nume)
{
var bd = new DataLayer.Models.ProiectBDContext();
var gr = (from g in bd.Grades
where g.ID_Grad == id
select g).First();
gr.Nume = nume;
bd.Entry(gr).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static IQueryable<Models.newCompanie> get_IDCompanie(string nume)
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Companies
where b.Nume == nume
select new newCompanie
{
ID_Companie = b.ID_Companie
};
return query;
}
public static void delete_AlocareHrana(int student, int pret)
{
var bd = new DataLayer.Models.ProiectBDContext();
var aloc = (from b in bd.AlocareHranas
where b.ID_Student == student &&
b.ID_Pret == pret
select b).First();
bd.AlocareHranas.Remove(aloc);
bd.Entry(aloc).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static void delete_AlocareHrana(int student, int pret)
{
var bd = new DataLayer.Models.ProiectBDContext();
var aloc = (from b in bd.AlocareHranas
where b.ID_Student == student &&
b.ID_Pret == pret
select b).First();
bd.AlocareHranas.Remove(aloc);
bd.Entry(aloc).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
}
public static IQueryable <Models.newCompanie> get_IDCompanie(string nume)
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Companies
where b.Nume == nume
select new newCompanie
{
ID_Companie = b.ID_Companie
};
return(query);
}
public static void update_Grade(int id, string nume)
{
var bd = new DataLayer.Models.ProiectBDContext();
var gr = (from g in bd.Grades
where g.ID_Grad == id
select g).First();
gr.Nume = nume;
bd.Entry(gr).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static bool Exists(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var st = from g in bd.Grades
where g.ID_Grad == id
select g;
var list = st.ToList();
if (list.Count != 0)
return true;
else
return false;
}
public static bool Exists(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var st = from b in bd.Preturis
where b.ID_Pret == id
select b;
var list = st.ToList();
if (list.Count != 0)
return true;
else
return false;
}
public static void increment_AlocareHrana(int student, int pret, int counter)
{
var bd = new DataLayer.Models.ProiectBDContext();
var aloc = (from b in bd.AlocareHranas
where b.ID_Student == student &&
b.ID_Pret == pret
select b).First();
aloc.Counter = aloc.Counter + counter;
bd.Entry(aloc).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static void insert_Companie(string nume, int com, int admin)
{
var bd = new DataLayer.Models.ProiectBDContext();
Companie comp = new Companie
{
Nume = nume,
ID_Comandant = com,
ID_Administrator = admin
};
bd.Companies.Add(comp);
bd.Entry(comp).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void insert_CDT_Comp(string nume, string prenume, int grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
CDT_Comp cdt = new CDT_Comp
{
Nume = nume,
Prenume = prenume,
ID_Grad = grad
};
bd.CDT_Comp.Add(cdt);
bd.Entry(cdt).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void update_Preturi(int id, string nume, double pret, DateTime data)
{
var bd = new DataLayer.Models.ProiectBDContext();
var pr = (from b in bd.Preturis
where b.ID_Pret == id
select b).First();
pr.Nume = nume;
pr.Pret = pret;
pr.Data = data;
bd.Entry(pr).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static void update_CDT_Comp(int id, string nume, string prenume, int grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
var cdt = (from b in bd.CDT_Comp
where b.ID_Comandant == id
select b).First();
cdt.Nume = nume;
cdt.Prenume = prenume;
cdt.ID_Grad = grad;
bd.Entry(cdt).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static void update_Companie(int id, string nume, int com, int admin)
{
var bd = new DataLayer.Models.ProiectBDContext();
var comp = (from b in bd.Companies
where b.ID_Companie == id
select b).First();
comp.Nume = nume;
comp.ID_Comandant = com;
comp.ID_Administrator = admin;
bd.Entry(comp).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static void update_Preturi(int id, string nume, double pret, DateTime data)
{
var bd = new DataLayer.Models.ProiectBDContext();
var pr = (from b in bd.Preturis
where b.ID_Pret == id
select b).First();
pr.Nume = nume;
pr.Pret = pret;
pr.Data = data;
bd.Entry(pr).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static void insert_Companie(string nume, int com, int admin)
{
var bd = new DataLayer.Models.ProiectBDContext();
Companie comp = new Companie
{
Nume = nume,
ID_Comandant = com,
ID_Administrator = admin
};
bd.Companies.Add(comp);
bd.Entry(comp).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void insert_Administratori(string nume, string prenume, int grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
Administratori admin = new Administratori
{
Nume = nume,
Prenume = prenume,
ID_Grad = grad
};
bd.Administratoris.Add(admin);
bd.Entry(admin).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void update_CDT_Comp(int id, string nume, string prenume, int grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
var cdt = (from b in bd.CDT_Comp
where b.ID_Comandant == id
select b).First();
cdt.Nume = nume;
cdt.Prenume = prenume;
cdt.ID_Grad = grad;
bd.Entry(cdt).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static void insert_CDT_Comp(string nume, string prenume, int grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
CDT_Comp cdt = new CDT_Comp
{
Nume = nume,
Prenume = prenume,
ID_Grad = grad
};
bd.CDT_Comp.Add(cdt);
bd.Entry(cdt).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void update_Administratori(int id, string nume, string prenume, int grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = (from b in bd.Administratoris
where b.ID_Admistrator == id
select b).First();
query.Nume = nume;
query.Prenume = prenume;
query.ID_Grad = grad;
bd.Entry(query).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static void update_AlocareHrana(int student, int pret, int admin, int counter)
{
var bd = new DataLayer.Models.ProiectBDContext();
var aloc = (from b in bd.AlocareHranas
where b.ID_Student == student &&
b.ID_Pret == pret
select b).First();
aloc.ID_Administrator = admin;
aloc.Counter = counter;
bd.Entry(aloc).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static void update_Administratori(int id, string nume, string prenume, int grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = (from b in bd.Administratoris
where b.ID_Admistrator == id
select b).First();
query.Nume = nume;
query.Prenume = prenume;
query.ID_Grad = grad;
bd.Entry(query).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static void insert_Administratori(string nume, string prenume, int grad)
{
var bd = new DataLayer.Models.ProiectBDContext();
Administratori admin = new Administratori
{
Nume = nume,
Prenume = prenume,
ID_Grad = grad
};
bd.Administratoris.Add(admin);
bd.Entry(admin).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static IQueryable<Models.newAdministratori> get_Administratori()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Administratoris
join c in bd.Grades
on b.ID_Grad equals c.ID_Grad
select new newAdministratori {
ID_Administrator = b.ID_Admistrator,
Nume = b.Nume,
Prenume = b.Prenume,
ID_Grad = b.ID_Grad,
Grad = c.Nume
};
return query;
}
public static void insert_Preturi(string nume, double pret, DateTime data)
{
var bd = new DataLayer.Models.ProiectBDContext();
Preturi pr = new Preturi
{
Nume = nume,
Pret = pret,
Data = data
};
bd.Preturis.Add(pr);
bd.Entry(pr).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void insert_AlocareHrana(int student, int pret, int admin, int counter)
{
var bd = new DataLayer.Models.ProiectBDContext();
AlocareHrana aloc = new AlocareHrana
{
ID_Student = student,
ID_Pret = pret,
ID_Administrator = admin,
Counter = counter
};
bd.AlocareHranas.Add(aloc);
bd.Entry(aloc).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void insert_Preturi(string nume, double pret, DateTime data)
{
var bd = new DataLayer.Models.ProiectBDContext();
Preturi pr = new Preturi
{
Nume = nume,
Pret = pret,
Data = data
};
bd.Preturis.Add(pr);
bd.Entry(pr).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static IQueryable<Models.newCDT_Comp> get_CDT_comp()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.CDT_Comp
join g in bd.Grades on b.ID_Grad equals g.ID_Grad
select new newCDT_Comp
{
ID_Comandant = b.ID_Comandant,
Nume = b.Nume,
Prenume = b.Prenume,
ID_Grad = b.ID_Grad,
Grad = g.Nume
};
return query;
}
public static void insert_AlocareHrana(int student, int pret, int admin, int counter)
{
var bd = new DataLayer.Models.ProiectBDContext();
AlocareHrana aloc = new AlocareHrana
{
ID_Student = student,
ID_Pret = pret,
ID_Administrator = admin,
Counter = counter
};
bd.AlocareHranas.Add(aloc);
bd.Entry(aloc).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static IQueryable <Models.newCDT_Comp> get_CDT_comp()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.CDT_Comp
join g in bd.Grades on b.ID_Grad equals g.ID_Grad
select new newCDT_Comp
{
ID_Comandant = b.ID_Comandant,
Nume = b.Nume,
Prenume = b.Prenume,
ID_Grad = b.ID_Grad,
Grad = g.Nume
};
return(query);
}
public static IQueryable <Models.newAdministratori> get_Administratori()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Administratoris
join c in bd.Grades
on b.ID_Grad equals c.ID_Grad
select new newAdministratori {
ID_Administrator = b.ID_Admistrator,
Nume = b.Nume,
Prenume = b.Prenume,
ID_Grad = b.ID_Grad,
Grad = c.Nume
};
return(query);
}
public static IQueryable<Models.newCompanie> get_Companie()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from b in bd.Companies
join c in bd.CDT_Comp on b.ID_Comandant equals c.ID_Comandant
join a in bd.Administratoris on b.ID_Administrator equals a.ID_Admistrator
select new newCompanie
{
ID_Companie = b.ID_Companie,
Nume = b.Nume,
ID_Comandant = b.ID_Comandant,
Nume_Comandant = c.Nume+" "+c.Prenume,
ID_Administrator = b.ID_Administrator,
Nume_Administrator = a.Nume+" "+a.Prenume
};
return query;
}
public static bool Exists(int id)
{
var bd = new DataLayer.Models.ProiectBDContext();
var st = from b in bd.Students
where b.ID_Student == id
select b;
var list = st.ToList();
if (list.Count != 0)
{
return(true);
}
else
{
return(false);
}
}
public static void update_Student(int id, string nume, string prenume, int grad, string cnp, string adresa, int comp)
{
var bd = new DataLayer.Models.ProiectBDContext();
var st = (from b in bd.Students
where b.ID_Student == id
select b).First();
st.Nume = nume;
st.Prenume = prenume;
st.ID_Grad = grad;
st.CNP = cnp;
st.Adresa = adresa;
st.ID_Companie = comp;
bd.Entry(st).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
public static IQueryable<Models.newAlocareHrana> get_AlocareHrana()
{
var bd = new DataLayer.Models.ProiectBDContext();
var query = from a in bd.AlocareHranas
join s in bd.Students on a.ID_Student equals s.ID_Student
join p in bd.Preturis on a.ID_Pret equals p.ID_Pret
join adm in bd.Administratoris on a.ID_Administrator equals adm.ID_Admistrator
select new newAlocareHrana
{
ID_Student = s.ID_Student,
Nume_Student = s.Nume + " " + s.Prenume,
ID_Pret = p.ID_Pret,
Nume_Produs = p.Nume,
Pret = p.Pret,
ID_Administrator = adm.ID_Admistrator,
Nume_Administrator = adm.Nume + " " + adm.Prenume,
Counter = a.Counter
};
return query;
}
