internal void Update(int id, User model) { using (var Entities = new CCLMEntities()) { var userEntity = Entities.users.FirstOrDefault(x => x.id == id); if (userEntity == null) { throw new Exception("Usuario no encontrado"); } var ids = userEntity.distribution_centers.Select(x => x.id).ToList(); var oldDsEntities = Entities.distribution_centers.Where(x => ids.Contains(x.id)); foreach (var ds in oldDsEntities) { userEntity.distribution_centers.Remove(ds); } var newDsEntities = Entities.distribution_centers.Where(x => model.DistributionCentersSelected.Contains(x.id)); foreach (var ds in newDsEntities) { userEntity.distribution_centers.Add(ds); } Entities.SaveChanges(); } }
internal void Create(User model) { using (var Entities = new CCLMEntities()) { Entities.users.Add(new users { nickname = model.NickName, full_name = model.FullName, email = model.Email, is_full = model.IsFull, distribution_centers = GenerateDS(Entities, model.DistributionCentersSelected) }); Entities.SaveChanges(); } }
internal void Create(DistributionCenter model) { using (var Entities = new CCLMEntities()) { Entities.distribution_centers.Add(new distribution_centers { code = model.Code, name = model.Name, process_start_time = model.ProcessStartTime, process_end_time = model.ProcessEndTime, binnacle_days = model.BinnacleDays, mail_success = false }); Entities.SaveChanges(); } }
internal void Update(int Id, DistributionCenter model) { using (var Entities = new CCLMEntities()) { var dsEntity = Entities.distribution_centers.FirstOrDefault(x => x.id == Id); if (dsEntity == null) { throw new Exception("Sitio no encontrado"); } dsEntity.name = model.Name; dsEntity.process_start_time = model.ProcessStartTime; dsEntity.process_end_time = model.ProcessEndTime; dsEntity.binnacle_days = model.BinnacleDays; Entities.SaveChanges(); } }