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 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_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_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 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_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 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_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_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_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 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 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 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 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 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 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 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 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_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 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_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_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 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 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 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_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 void insert_Student(string nume, string prenume, int grad, string cnp, string adresa, int comp)
{
var bd = new DataLayer.Models.ProiectBDContext();
Student st = new Student
{
Nume = nume,
Prenume = prenume,
ID_Grad = grad,
CNP = cnp,
Adresa = adresa,
ID_Companie = comp
};
bd.Students.Add(st);
bd.Entry(st).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void insert_ArticoleVest(int id_stud, int id_admin, DateTime data, int bocanci,
int capela, int cascheta, int costCamuflaj, int costTercot,
int costCamgarn, int camasaAlba, int camasaArma, int camasaCamo,
int boneta, int fular, int pantofi, int ghete, int nominal, int romania,
int cuc, int cravata, int scurtaO, int scurtaC)
{
var bd = new DataLayer.Models.ProiectBDContext();
ArticoleVest art = new ArticoleVest
{
ID_Student = id_stud,
ID_Administrator = id_admin,
Data_Alocarii = data,
Bocanci = bocanci,
Capela = capela,
Cascheta = cascheta,
Costum_Camuflaj = costCamuflaj,
Costum_Tercot = costTercot,
Costum_Camgarn = costCamgarn,
Camasa_Alba = camasaAlba,
Camasa_Camuflaj = camasaCamo,
Camasa_Arma = camasaArma,
Boneta = boneta,
Fular = fular,
Pantofi = pantofi,
Ghete = ghete,
Ecuson_Nominal = nominal,
Ecuson_Romania = romania,
Cuc = cuc,
Cravata = cravata,
Scurta_Oras = scurtaO,
Scurta_Camuflat = scurtaC
};
bd.ArticoleVests.Add(art);
bd.Entry(art).State = System.Data.Entity.EntityState.Added;
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_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 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 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 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 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 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_ArticoleVest(int id_stud, int id_admin, DateTime data, int bocanci,
int capela, int cascheta, int costCamuflaj, int costTercot,
int costCamgarn, int camasaAlba, int camasaArma, int camasaCamo,
int boneta, int fular, int pantofi, int ghete, int nominal, int romania,
int cuc, int cravata, int scurtaO, int scurtaC)
{
var bd = new DataLayer.Models.ProiectBDContext();
ArticoleVest art = new ArticoleVest
{
ID_Student = id_stud,
ID_Administrator = id_admin,
Data_Alocarii = data,
Bocanci =bocanci,
Capela = capela,
Cascheta = cascheta,
Costum_Camuflaj = costCamuflaj,
Costum_Tercot = costTercot,
Costum_Camgarn = costCamgarn,
Camasa_Alba = camasaAlba,
Camasa_Camuflaj = camasaCamo,
Camasa_Arma =camasaArma,
Boneta = boneta,
Fular = fular,
Pantofi = pantofi,
Ghete = ghete,
Ecuson_Nominal = nominal,
Ecuson_Romania = romania,
Cuc = cuc,
Cravata = cravata,
Scurta_Oras = scurtaO,
Scurta_Camuflat = scurtaC
};
bd.ArticoleVests.Add(art);
bd.Entry(art).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
public static void insert_Student(string nume, string prenume, int grad, string cnp, string adresa, int comp)
{
var bd = new DataLayer.Models.ProiectBDContext();
Student st = new Student
{
Nume = nume,
Prenume = prenume,
ID_Grad = grad,
CNP = cnp,
Adresa = adresa,
ID_Companie = comp
};
bd.Students.Add(st);
bd.Entry(st).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
}
