public bool UpdateStudenti(int id_c, string name, string prenume, string email, string tel, string grad, int camera, string functie, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { using (var transaction = context.Database.BeginTransaction()) { try { var serv = new Studenti { ID_C = id_c, Nume = name, Prenume = prenume, Email = email, Nr_tel = tel, Grad_militar = grad, Camera = camera, Functie = functie }; context.Studentis.Add(serv); context.Entry(serv).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); transaction.Commit(); return true; } catch (Exception ex) { transaction.Rollback(); return false; } } } }
public bool UpdateInvoireApel(int id_s, DateTime data, TimeSpan ora_plecare, TimeSpan ora_sosire, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { using (var transaction = context.Database.BeginTransaction()) { try { var serv = new Invoire_apel { ID_S = id_s, Data = data, Ora_plecare = ora_plecare, Ora_sosire = ora_sosire }; context.Invoire_apel.Add(serv); context.Entry(serv).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); transaction.Commit(); return true; } catch (Exception ex) { transaction.Rollback(); return false; } } } }
public bool UpdateListaServicii(string nume, int nr, string an, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { using (var transaction = context.Database.BeginTransaction()) { try { var serv = new Lista_servicii { Nume_serviciu = nume, Nr_componenta = nr, An_studiu = an, }; context.Lista_servicii.Add(serv); context.Entry(serv).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); transaction.Commit(); return true; } catch (Exception ex) { transaction.Rollback(); return false; } } } }
public void DeleteComandanti(string nume, string prenume) { using (var context = new ServiciiATMContext()) { var cdt = context.Comandantis.Where(n => n.Nume == nume && n.Prenume == prenume).ToList<Comandanti>().FirstOrDefault(); if (cdt != null) { context.Comandantis.Attach(cdt); context.Comandantis.Remove(cdt); context.Entry(cdt).State = System.Data.Entity.EntityState.Deleted; context.SaveChangesAsync(); } } }
public void DeleteInvApel(DateTime dt) { using (var context = new ServiciiATMContext()) { var std = context.Apel_seara.Where(n => n.Data == dt).ToList<Apel_seara>().FirstOrDefault(); if (std != null) { context.Apel_seara.Attach(std); context.Apel_seara.Remove(std); context.Entry(std).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } } }
public bool InsertListaServicii(string nume, int nr_comp, string an, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { var lista = new Lista_servicii { Nume_serviciu = nume, Nr_componenta = nr_comp, An_studiu = an, }; context.Lista_servicii.Add(lista); context.Entry(lista).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); return true; } }
//Merge public void DeleteServicii(DateTime time) { using (var context = new ServiciiATMContext()) { var serv = context.Serviciis.Where(n => n.Data == time && n.Data < DateTime.Now).ToList<Servicii>().FirstOrDefault(); if (serv != null) { context.Serviciis.Attach(serv); context.Serviciis.Remove(serv); context.Entry(serv).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } } }
public void DeleteListaServicii(string name) { using (var context = new ServiciiATMContext()) { var std = context.Lista_servicii.Where(n => n.Nume_serviciu == name).ToList<Lista_servicii>().FirstOrDefault(); if (std != null) { context.Lista_servicii.Attach(std); context.Lista_servicii.Remove(std); context.Entry(std).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } } }
public void DeleteCompanii(string an) { using (var context = new ServiciiATMContext()) { var std = context.Companiis.Where(n => n.An_studii == an).ToList<Companii>().FirstOrDefault(); if (std != null) { context.Companiis.Attach(std); context.Companiis.Remove(std); context.Entry(std).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } } }
public bool InsertComandanti(string name, string lastname, string tel, string mail, string adr, string gm, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { var com = new Comandanti { Nume = name, Prenume = lastname, Nr_tel = tel, Email = mail, Adresa = adr, Grad_militar = gm }; context.Comandantis.Add(com); context.Entry(com).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); return true; } }
public bool InsertCompanii(int id_com, string an_studiu, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { var com = new Companii { ID_com = id_com, An_studii = an_studiu, }; context.Companiis.Add(com); context.Entry(com).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); return true; } }
public bool InsertApelSeara(int id_c, int efc, int efp, int efa, DateTime data, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { var apel = new Apel_seara { ID_C = id_c, Efectiv_control = efc, Efectiv_prezenti = efp, Efectiv_absenti = efa, Data = data, }; context.Apel_seara.Add(apel); context.Entry(apel).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); return true; } }
public bool InsertServicii(int id_l, int id_s, DateTime data, bool check, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { var serv = new Servicii { ID_ls = id_l, ID_S = id_s, Data = data, Check = check }; context.Serviciis.Add(serv); context.Entry(serv).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); return true; } }
public bool InsertStudenti(int id_c, string nume, string prenume, string mail, string tel, string grad, int camera, string functie, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { var student = new Studenti { ID_C = id_c, Nume = nume, Prenume = prenume, Email = mail, Nr_tel = tel, Grad_militar = grad, Camera = camera, Functie = functie, }; context.Studentis.Add(student); context.Entry(student).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); return true; } }
public bool UpdateApelSeara(int id_c, int efc, int efp, int efa, DateTime data, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { using (var transaction = context.Database.BeginTransaction()) { try { var apel = new Apel_seara { ID_C = id_c }; context.Apel_seara.Attach(apel); context.Entry(apel).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); transaction.Commit(); return true; } catch (Exception ex) { transaction.Rollback(); return false; } } } }
public void DeleteStudent(string name, string lastname) { using (var context = new ServiciiATMContext()) { var std = context.Studentis.Where(n => n.Nume == name && n.Prenume == lastname).ToList<Studenti>().FirstOrDefault(); if (std != null) { context.Studentis.Attach(std); context.Studentis.Remove(std); context.Entry(std).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } } }
public bool UpdServicii(int id_l, int id_s, DateTime data, bool check, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { using (var transaction = context.Database.BeginTransaction()) { try { var serv = new Servicii { ID_ls = id_l, ID_S = id_s, }; context.Serviciis.Add(serv); context.Entry(serv).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); transaction.Commit(); return true; } catch (Exception ex) { transaction.Rollback(); return false; } } } }
public bool InsertInvoireSeara(int id_s, DateTime data, TimeSpan ora_plecare, TimeSpan ora_sosire, int code) { if (code == 0) return false; using (var context = new ServiciiATMContext()) { var invoire = new Invoire_apel { ID_S = id_s, Ora_plecare = ora_plecare, Ora_sosire = ora_sosire, Data = data, }; context.Invoire_apel.Add(invoire); context.Entry(invoire).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); return true; } }