/// <summary> /// Adds a new object of type <see cref="DetaliuComanda"/> /// </summary> /// <param name="orderId"></param> /// <param name="materialId"></param> /// <param name="operatieId"></param> /// <param name="mecanicId"></param> /// <param name="imagineId"></param> public static void Add(int orderId, int materialId, int operatieId, int mecanicId, int?imagineId = null) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); try { DetaliuComanda detaliuComanda = new DetaliuComanda() { ComandaId = orderId, MaterialId = materialId, OperatieId = operatieId, MecanicId = mecanicId }; } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { throw; } } } } }
/// <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> /// Return an object of type <see cref="DetaliuComanda"/> or <code>null</code> if the object is not found /// </summary> /// <param name="id"></param> /// <returns></returns> public static DetaliuComanda GetById(int id) { using (ModelCarServiceContainer context = new ModelCarServiceContainer()) { context.Database.Connection.Open(); var _detaliuCmd = context.MecanicSet.SingleOrDefault(m => m.Id == id); if (_detaliuCmd != null) { DetaliuComanda detaliuComanda = new DetaliuComanda() { Id = id }; context.DetaliuComandaSet.Attach(detaliuComanda); return(detaliuComanda); } } return(null); }