/// <summary> /// Add a new object of type <see cref="Auto"/> in the database /// </summary> /// <param name="nrAuto"></param> /// <param name="serieSasiu"></param> /// <param name="codSasiu"></param> /// <param name="denumireSasiu"></param> /// <param name="clientId"></param> public static void Add(string nrAuto, string serieSasiu, string codSasiu, string denumireSasiu, int clientId) { int sasiuID = 0; using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); //Verifica daca exista deja acest sasiu //var codSasiuExistent = context.SasiuSet.SingleOrDefault(s => s.CodSasiu == codSasiu); var denumireSasiuExistenta = context.SasiuSet.SingleOrDefault(s => s.Denumire == denumireSasiu); if (denumireSasiuExistenta != null) { sasiuID = denumireSasiuExistenta.Id; } else { Sasiu sasiu = new Sasiu() { CodSasiu = codSasiu, Denumire = denumireSasiu }; context.SasiuSet.Add(sasiu); context.SaveChanges(); sasiuID = sasiu.Id; } try { Auto auto = new Auto() { NumarAuto = nrAuto, SerieSasiu = serieSasiu, SasiuId = sasiuID, ClientId = clientId }; context.AutoSet.Add(auto); context.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { throw; } } } } }
/// <summary> /// Add method, adds a new operation to the Operatie entity /// </summary> /// <param name="denumire"></param> /// <param name="timpExec"></param> public static void Add(string denumire, Decimal timpExec) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); try { Operatie operatie = new Operatie() { Denumire = denumire, TimpExecutie = timpExec }; context.OperatieSet.Add(operatie); context.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { throw; } } } } }
/// <summary> /// Add method, adds a new mecanic /// </summary> /// <param name="nume"></param> /// <param name="prenume"></param> public static void Add(string nume, string prenume) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); try { Mecanic mecanic = new Mecanic() { Nume = nume, Prenume = prenume }; context.MecanicSet.Add(mecanic); context.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { throw; } } } } }
/// <summary> /// Adds a new object of type <see cref="Material"/> /// </summary> /// <param name="denumire"></param> /// <param name="cantitate"></param> /// <param name="pret"></param> /// <param name="dataAprovizionare"></param> public static void Add(string denumire, Decimal cantitate, Decimal pret, DateTime dataAprovizionare) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); try { Material material = new Material() { Denumire = denumire, Cantitate = cantitate, Pret = pret, DataAprovizionare = dataAprovizionare }; context.MaterialSet.Add(material); context.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { throw; } } } } }
/// <summary> /// Deletes an object from the DB. It requires the id of the object /// </summary> /// <param name="id"></param> public static void Delete(int id) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); Operatie operatie = new Operatie() { Id = id }; context.OperatieSet.Attach(operatie); context.OperatieSet.Remove(operatie); context.SaveChanges(); } }
/// <summary> /// Delete method, deletes an object from the DB. It requires the id of the object /// </summary> /// <param name="id"></param> public static void Delete(int id) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); Auto auto = new Auto() { Id = id }; context.AutoSet.Attach(auto); context.AutoSet.Remove(auto); context.SaveChanges(); } }
/// <summary> /// Deletes an object of type <see cref="Imagine"/> /// </summary> /// <param name="id"></param> public static void Delete(int id) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); Imagine imagine = new Imagine() { Id = id }; context.ImagineSet.Attach(imagine); context.ImagineSet.Remove(imagine); context.SaveChanges(); } }
/// <summary> /// Delete method, deletes an object from the DB. It requires the id of the object /// </summary> /// <param name="id"></param> public static void Delete(int id) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); Mecanic mecanic = new Mecanic() { Id = id }; context.MecanicSet.Attach(mecanic); context.MecanicSet.Remove(mecanic); context.SaveChanges(); } }
/// <summary> /// Deletes an object of type <see cref="Material"/> /// </summary> /// <param name="id"></param> public static void Delete(int id) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); Material material = new Material() { Id = id }; context.MaterialSet.Attach(material); context.MaterialSet.Remove(material); context.SaveChanges(); } }
/// <summary> /// Deletes an object of type <see cref="DetaliuComanda"/> /// </summary> /// <param name="id"></param> public static void Delete(int id) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); DetaliuComanda detaliu = new DetaliuComanda() { Id = id }; context.DetaliuComandaSet.Attach(detaliu); context.DetaliuComandaSet.Remove(detaliu); context.SaveChanges(); } }
/// <summary> /// Delete method, deletes an object from the DB. It requires the id of the object /// </summary> /// <param name="id"></param> public static void Delete(int?id) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); if (id != null) { Client client = new Client() { Id = id.GetValueOrDefault() }; context.ClientSet.Attach(client); context.ClientSet.Remove(client); context.SaveChanges(); } } }
/// <summary> /// Update method, changes the values of an object of type <see cref="Auto"/> /// </summary> /// <param name="id"></param> /// <param name="nrAuto"></param> /// <param name="serieSasiu"></param> /// <param name="codSasiu"></param> /// <param name="denumireSasiu"></param> /// <param name="clientId"></param> public static void Update(int id, string nrAuto, string serieSasiu, string codSasiu, string denumireSasiu, int clientId) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); var autoId = context.AutoSet.SingleOrDefault(i => i.Id == id); var sasiu = context.SasiuSet.SingleOrDefault(s => s.Id == autoId.SasiuId); if (autoId != null) { autoId.NumarAuto = nrAuto; autoId.SerieSasiu = serieSasiu; sasiu.CodSasiu = codSasiu; sasiu.Denumire = denumireSasiu; autoId.ClientId = clientId; context.SaveChanges(); } } }
/// <summary> /// Update method. Requires <paramref name="id"/> of the entity Mecanic and /// the new values for <paramref name="nume"/> and <paramref name="prenume"/> to be changed /// </summary> /// <param name="id"></param> /// <param name="nume"></param> /// <param name="prenume"></param> public static void Update(int id, string nume, string prenume) { Mecanic mecanic = new Mecanic() { Id = id, Nume = nume, Prenume = prenume }; using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); var result = context.MecanicSet.SingleOrDefault(m => m.Id == id); if (result != null) { result.Nume = nume; result.Prenume = prenume; context.SaveChanges(); } } }
public static void AddClient(Client client) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { try { context.Database.Connection.Open(); context.ClientSet.Add(client); context.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { throw; } } } } }
/// <summary> /// Add method, adds a new client /// </summary> /// <param name="fName"></param> /// <param name="lName"></param> /// <param name="addrs"></param> /// <param name="localitate"></param> /// <param name="judet"></param> /// <param name="tel"></param> /// <param name="email"></param> public static void Add(string fName, string lName, string addrs, string localitate, string judet, string tel, string email) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); try { Client client = new Client() { Nume = fName, Prenume = lName, Adresa = addrs, Localitate = localitate, Judet = judet, Telefon = tel, Email = email }; context.ClientSet.Add(client); context.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { //Console.WriteLine("Error: {0}", error.ErrorMessage); //return error.ErrorMessage; throw; } } } } }
/// <summary> /// Adds a new object of type <see cref="Comanda"/> /// </summary> /// <param name="autoId"></param> /// <param name="clientId"></param> /// <param name="stare"></param> /// <param name="dataProgramare"></param> /// <param name="dataFinalizare"></param> /// <param name="kmBord"></param> /// <param name="descriere"></param> public static void Add(int autoId, int clientId, string stare, DateTime dataProgramare, DateTime dataFinalizare, int kmBord, string descriere) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); try { Comanda comanda = new Comanda() { AutoId = autoId, ClientId = clientId, StareComanda = stare, DataSystem = DateTime.Now, DataProgramare = dataProgramare, DataFinalizare = dataFinalizare, KmBord = kmBord, Descriere = descriere, ValoarePiese = 0 }; context.ComandaSet.Add(comanda); context.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { throw; } } } } }