/// <summary>
/// Method Delete dalPhoto.
/// </summary>
/// <param name="dalCategory">Entity that need delete.</param>
public void Delete(DalCategoryPhoto dalCategory)
{
var categoryPhoto = new CategoryPhoto()
{
Name = dalCategory.Name
};
context.Set <CategoryPhoto>().Remove(categoryPhoto);
}
/// <summary>
/// Method Create create category entity.
/// </summary>
/// <param name="dalCategory">New category entity for create.</param>
public void Create(DalCategoryPhoto dalCategory)
{
var categoryPhoto = new CategoryPhoto()
{
Name = dalCategory.Name
};
context.Set <CategoryPhoto>().Add(categoryPhoto);
}
/// <summary>
/// Method GetByPredicate return DalCategoryPhoto by predicate.
/// </summary>
/// <param name="f">Predicate.</param>
/// <returns>Return DalCategoryPhoto by predicate f.</returns>
public DalCategoryPhoto GetByPredicate(Expression <Func <DalCategoryPhoto, bool> > f)
{
var convert = ExpressionConverter.Convert <DalCategoryPhoto, CategoryPhoto>(f);
CategoryPhoto item = context.Set <CategoryPhoto>().SingleOrDefault(convert);
return(new DalCategoryPhoto {
Name = item.Name, Id = item.Id
});
}
public int InsertImageOfCategory(CategoryPhoto photo)
{
using (var dataContext = new DataContext(_connectionString))
{
dataContext.GetTable <CategoryPhoto>().InsertOnSubmit(photo);
dataContext.SubmitChanges();
}
return(photo.Id);
}
public void UpdateImageOfCategory(CategoryPhoto photo)
{
using (var dataContext = new DataContext(_connectionString))
{
CategoryPhoto dbPhoto = dataContext.GetTable <CategoryPhoto>().Single(p => p.CategoryId == photo.CategoryId);
dbPhoto.Picture = photo.Picture;
dataContext.SubmitChanges();
}
}
/// <summary>
/// Method Update update exists category.
/// </summary>
/// <param name="dalCategory">DalCategoryPhoto that need update.</param>
public void Update(DalCategoryPhoto dalCategory)
{
var actualCategory = GetById(dalCategory.Id);
CategoryPhoto updatedCategory = new CategoryPhoto()
{
Id = actualCategory.Id,
Name = actualCategory.Name
};
context.Set <CategoryPhoto>().Attach(updatedCategory);
var category = context.Entry(updatedCategory);
category.Property(ctg => ctg.Name).IsModified = true;
context.SaveChanges();
}
