public bool Delete(T entity)
{
try
{
using (VSOFTDBEntities ctx = new VSOFTDBEntities())
{
ctx.Set <T>().Remove(entity);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(true);
}
public async Task <IList <T> > GetAll()
{
try
{
using (VSOFTDBEntities ctx = new VSOFTDBEntities())
{
List <T> result = ctx.Set <T>().ToList();
return(result);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(null);
}
public async Task <T> Update(T entity)
{
try
{
using (VSOFTDBEntities context = new VSOFTDBEntities())
{
context.Entry(entity).State = EntityState.Modified;
context.ChangeTracker.DetectChanges();
var tt = context.ChangeTracker.HasChanges();
context.SaveChanges();
return(entity);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public T GetById(object Id)
{
try
{
if (Id != null && null != string.Empty)
{
using (VSOFTDBEntities ctx = new VSOFTDBEntities())
{
T result = ctx.Set <T>().Find(Id);
return(result);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(null);
}
public async Task <T> Create(T entity)
{
try
{
if (entity != null)
{
using (VSOFTDBEntities ctx = new VSOFTDBEntities())
{
ctx.Set <T>().Add(entity);
await ctx.SaveChangesAsync();
return(entity);
}
}
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
return(null);
}
