public IEnumerable <T> Insert(IEnumerable <T> list)
{
using (var db = new VRContext())
{
using (var trans = db.Database.BeginTransaction())
{
IEnumerable <T> tList = null;
try
{
tList = db.Set <T>().AddRange(list);
db.SaveChanges();
trans.Commit(); //Data Saved Successfully. Transaction Commited
//tList = list;
}
catch (DbException ex)
{
Logger.Error(ex.Message, ex);
}
catch (Exception ex)
{
trans.Rollback();//Error Occured during data saved. Transaction Rolled Back
Logger.Error(ex.Message, ex);
}
return(tList);
}
}
}
public IEnumerable <T> GetRange(int pageIndex, int pageSize)
{
IEnumerable <T> result = null;
try
{
using (var db = new VRContext())
{
result = db.Set <T>().Where(i => !i.IsDeleted).OrderBy(i => i.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Logger.Error(string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage));
}
}
}
catch (DbException ex)
{
Logger.Error(ex.Message, ex);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result ?? Enumerable.Empty <T>());
}
public IEnumerable <T> GetRange(Expression <Func <T, bool> > predicate, int pageIndex, int pageSize, out int count)
{
count = 0;
IEnumerable <T> result = null;
try
{
using (var db = new VRContext())
{
var list = db.Set <T>().Where(i => !i.IsDeleted).Where(predicate).ToList();
count = list.Count();
result = list.Skip((pageIndex - 1) * pageSize).Take(pageSize);
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Logger.Error(string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage));
}
}
}
catch (DbException ex)
{
Logger.Error(ex.Message, ex);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result ?? Enumerable.Empty <T>());
}
public T SingleBy(Expression <Func <T, bool> > predicate)
{
T entity = null;
try
{
using (var db = new VRContext())
{
entity = db.Set <T>().Where(i => !i.IsDeleted).FirstOrDefault(predicate);
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Logger.Error(string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage));
}
}
}
catch (DbException ex)
{
Logger.Error(ex.Message, ex);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(entity);
}
public IEnumerable <T> FindBy(Expression <Func <T, bool> > predicate)
{
IEnumerable <T> result = null;
try
{
using (var db = new VRContext())
{
result = db.Set <T>().Where(x => !x.IsDeleted).Where(predicate).ToList();
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Logger.Error(string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage));
}
}
}
catch (DbException ex)
{
Logger.Error(ex.Message, ex);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result ?? Enumerable.Empty <T>());
}
public bool Update(List <T> dtoList)
{
using (var db = new VRContext())
{
using (var trans = db.Database.BeginTransaction())
{
T entity = null;
try
{
var dbSet = db.Set <T>();
dtoList.ForEach(x =>
{
entity = dbSet.Find(x.Id);
if (entity != null)
{
db.Entry(entity).CurrentValues.SetValues(x);
}
});
db.SaveChanges();
trans.Commit();//Data Saved Successfully. Transaction Commited
return(true);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Logger.Error(string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage));
}
}
return(false);
}
catch (DbException ex)
{
Logger.Error(ex.Message, ex);
return(false);
}
catch (Exception ex)
{
trans.Rollback();//Error Occured during data saved. Transaction Rolled Back
Logger.Error(ex.Message, ex);
return(false);
}
}
}
}
public T Update(T dto)
{
T entity = null;
try
{
using (var db = new VRContext())
{
entity = db.Set <T>().Find(dto.Id);
if (entity != null)
{
db.Entry(entity).CurrentValues.SetValues(dto);
db.SaveChanges();
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Logger.Error(string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage));
}
}
entity = null;
}
catch (DbException ex)
{
Logger.Error(ex.Message, ex);
entity = null;
}
catch (Exception ex)
{
entity = null;
Logger.Error(ex.Message, ex);
}
return(entity);
}
public T GetById(int id)
{
T entity = null;
try
{
using (var db = new VRContext())
{
entity = db.Set <T>().Find(id);
}
}
catch (DbException ex)
{
Logger.Error(ex.Message, ex);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(entity);
}
public Repository()
{
DbSet = context.Set <T>();
}