public static IEnumerable <T> Get(Expression <Func <T, bool> > expression = null /*IQueryable<T> query=null*/)
{
try
{
var time1 = DateTime.Now;
if (expression == null)
{
var result = new DBcon <T>().Table.Where(c => c.Deleted == false).ToList();
var time2 = DateTime.Now;
var totaltime = time2 - time1;
return(result);
}
else
{
var resultquery = new DBcon <T>().Table.Where(expression).ToList().Where(c => c.Deleted == false);
var time2 = DateTime.Now;
var totaltime = time2 - time1;
return(resultquery);
}
}
catch (Exception ex)
{
ExceptionHandler.GetLog(ex, "e916a894-e3d1-4484-99de-4c92096b08e8", LoggerModels.ExcptionType.UnknownError);
return(null);
}
}
public static object Anonymous()
{
var db = new DBcon <T>();
var db1 = new DBcon <T>();
var result = from tt in db.Table join ff in db1.Table on tt.ID equals ff.ID select new { tt.ID, tt.Deleted, ff.CreateDate };
return(result);
}
public static int Delete(params object[] id)
{
var db = new DBcon <T>();
var Table = db.Table.Find(id);
Table.UpdateDate = DateTime.Now;
Table.Deleted = true;
return(db.SaveChanges());
}
public static int UpdateRange(IEnumerable <T> tables)
{
var db = new DBcon <T>();
foreach (var table in tables)
{
db.Entry(table).State = EntityState.Modified;
}
return(db.SaveChanges());
}
public static int DeleteRange(IEnumerable <T> ids)
{
var db = new DBcon <T>();
foreach (var id in ids)
{
var Table = db.Table.Find(id);
Table.Deleted = true;
}
return(db.SaveChanges());
}
public static T Find(params object[] id)
{
var value = new DBcon <T>().Table.Find(id);
if (value.Deleted == false)
{
return(value);
}
else
{
return(null);
}
}
public static int AddRange(List <T> tables)
{
var db = new DBcon <T>();
foreach (var table in tables)
{
if (string.IsNullOrEmpty(table.UserID))
{
throw new Exception("UserID empty you must enter valid UserID");
}
table.CreateDate = DateTime.Now;
table.UpdateDate = DateTime.Now;
table.Deleted = false;
}
db.Table.AddRange(tables);
return(db.SaveChanges());
}
public static int Update(T model)
{
var db = new DBcon <T>();
var db2 = new DBcon <T>();
var data = db2.Table.Find(model.ID);
if (data != null && data.Deleted != true)
{
model.UpdateDate = DateTime.Now;
model.CreateDate = data.CreateDate;
model.UserID = data.UserID;
db.Entry(model).State = EntityState.Modified;
return(db.SaveChanges());
}
else
{
throw new DataStoreException("We can't find the selected data to update");
}
}
public static int Add(T model)
{
if (string.IsNullOrEmpty(model.UserID) && typeof(T).Name != "Logger")
{
throw new DataStoreException("UserID Null");
}
var db = new DBcon <T>();
model.CreateDate = DateTime.Now;
model.UpdateDate = DateTime.Now;
model.Deleted = false;
db.Table.Add(model);
try
{
return(db.SaveChanges());
}
catch (Exception ex)
{
ExceptionHandler.GetLog(ex, model.UserID, LoggerModels.ExcptionType.UnknownError);
throw new DataStoreException("UnKnown exception please look at the InnerException", ex);
}
}