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