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