public List <ShoesStyle> Get()
{
try
{
using (var context = new ShoesEntities())
{
var result = context.ShoesStyles.Where(x => !x.isDeleted);
return(result.ToList());
}
}
catch (Exception ex)
{
return(null);
}
}
public List <Shoes> Get(ShoesFilter filter)
{
try
{
using (ShoesEntities context = new ShoesEntities())
{
var result = context.Shoes.Include(s => s.ShoesStyles).Include(s => s.Brand).Where(x => !x.isDeleted);
if (filter != null)
{
if (filter.Id != Guid.Empty)
{
result = result.Where(x => x.Id == filter.Id);
}
if (filter.Name != string.Empty)
{
result = result.Where(x => x.Name.Contains(filter.Name));
}
if (filter.Brand_Ids != null)
{
result = result.Where(x => filter.Brand_Ids.Contains(x.Brand.Id));
}
if (filter.Style_Ids != null)
{
result = result.Where(x => x.ShoesStyles.Any(style => filter.Style_Ids.Contains(style.Id)));
}
}
return(result.ToList());
}
}
catch (Exception ex)
{
return(null);
}
}
public Shoes InsertOrUpdate(Shoes shoes)
{
try
{
using (var context = new ShoesEntities())
{
var result = context.Shoes.FirstOrDefault(x => x.Id == shoes.Id);
if (result == null)
{
shoes.Id = Guid.NewGuid();
shoes.ShoesStyles = shoes.ShoesStyles.Select(x => context.ShoesStyles.Find(x.Id)).ToList();
shoes.Brand = context.Brands.Find(shoes.Brand.Id);
shoes.CreatedDate = DateTime.Now;
result = context.Shoes.Add(shoes);
}
else
{
result.ShoesStyles.Clear();
var styles = shoes.ShoesStyles.Select(x => context.ShoesStyles.Find(x.Id)).ToList();
foreach (var style in styles)
{
result.ShoesStyles.Add(style);
}
result.Name = shoes.Name;
result.ModifiedBy = shoes.ModifiedBy;
result.Brand = context.Brands.Find(shoes.Brand.Id);
result.ModifiedDate = DateTime.Now;
}
context.SaveChanges();
return(result);
}
}
catch (Exception ex)
{
return(null);
}
}
public int Delete(Guid id)
{
try
{
using (ShoesEntities context = new ShoesEntities())
{
var entity = context.Shoes.FirstOrDefault(x => x.Id == id);
if (entity == null)
{
throw new Exception();
}
else
{
entity.isDeleted = true;
context.SaveChanges();
return(1);
}
}
}
catch (Exception ex)
{
return(-1);
}
}
