public List <ElectricityConsumer> FindBatchRuns(string strFind, IDBContextElectricityConsumer db) { var batchRuns = from b in db.ElectricityConsumers where (b.User.Contains(strFind) || b.Address.ToString().Contains(strFind)) select b; return(batchRuns.Cast <ElectricityConsumer>().ToList()); }
public List <ElectricityConsumer> GetBatchRuns(IDBContextElectricityConsumer db) { try { return(db.ElectricityConsumers.OrderByDescending(p => p.Id).ToList <ElectricityConsumer>()); } catch (Exception e) { Console.WriteLine(e.Message); return(null); } }
public ElectricityConsumer GetBatchRunsById(int id, IDBContextElectricityConsumer db) { return(db.ElectricityConsumers.FirstOrDefault(s => s.Id == id)); }
public string Delete(ElectricityConsumer obj, IDBContextElectricityConsumer db) { db.ElectricityConsumers.Remove(obj); db.SaveChanges(); return("Deleted successfully"); }
public string Save(ElectricityConsumer obj, IDBContextElectricityConsumer db) { db.ElectricityConsumers.Add(obj); db.SaveChanges(); return("Saved successfully"); }