public List <T> GetList <T>() where T : class
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Set <T>().ToList());
}
}
public List <Geolocation> GetGeolocationList()
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Geolocations.Include("City").OrderBy(d => d.Address).ToList());
}
}
public List <SensorDevice> GetSensorDeviceList()
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.SensorDevices.Include("Supplier").OrderBy(d => d.SerialNumber).ToList());
}
}
public List <District> GetDistrictList()
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Districts.Include("Province").OrderBy(d => d.Name).ToList());
}
}
public List <City> GetCityList()
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Cities.Include("District").OrderBy(d => d.Name).ToList());
}
}
public List <Vehicle> GetVehicleList()
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Vehicles.Include("GPSDevice").OrderBy(d => d.VehicleNo).ToList());
}
}
public List <Tank> GetTankList()
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Tanks.Include("FuelType").OrderBy(d => d.Code).ToList());
}
}
public string GetFuelLevels(int cityId)
{
string levels = "";
using (FLMSEntities entities = new FLMSEntities())
{
var lastBatchId = entities.TankFuelLevelInputBatches.OrderByDescending(b => b.Id).Take(1).SingleOrDefault().Id;
var depotTankLevels = entities.TankFuelLevels
.Include("DepotTank").Where(l => l.TankFuelLevelInputBatchId == lastBatchId)
.ToList();
if (cityId != 0)
{
depotTankLevels = depotTankLevels.Where(d => d.DepotTank.Depot.Geolocation.City.Id == cityId).ToList();
}
List <TamkFuelLveleModel> levelModels = new List <TamkFuelLveleModel>();
foreach (var depotTankLevel in depotTankLevels)
{
levelModels.Add(new TamkFuelLveleModel()
{
TankCode = depotTankLevel.DepotTank.Tank.Code,
Level = ((depotTankLevel.CurrentVolume / depotTankLevel.DepotTank.Tank.Volume) * 100).Value.ToString("#.00"),
Location = depotTankLevel.DepotTank.Depot.Geolocation.City.Name,
Volume = depotTankLevel.CurrentVolume.ToString()
});
}
levels = JsonConvert.SerializeObject(levelModels);
return(levels);
}
}
public Geolocation GetGeolocationById(int?id)
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Geolocations
.Include("City")
.Where(s => s.Id == id).SingleOrDefault());
}
}
public Vehicle GetVehicleById(int?id)
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Vehicles
.Include("GPSDevice")
.Where(s => s.Id == id).SingleOrDefault());
}
}
public Tank GetTankById(int?id)
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Tanks
.Include("FuelType")
.Where(s => s.Id == id).SingleOrDefault());
}
}
public SensorDevice GetSensorDeviceById(int?id)
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.SensorDevices
.Include("Supplier")
.Where(s => s.Id == id).SingleOrDefault());
}
}
public City GetCityById(int?id)
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Cities
.Include("District")
.Where(s => s.Id == id).SingleOrDefault());
}
}
public District GetDistrictById(int?id)
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Districts
.Include("Province")
.Where(s => s.Id == id).SingleOrDefault());
}
}
public List <Depot> GetDepotList()
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Depots
.Include("Geolocation")
.Include("DepotType")
.OrderBy(d => d.Code).ToList());
}
}
public Depot GetDepotById(int?id)
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.Depots
.Include("Geolocation")
.Include("DepotType")
.Where(s => s.Id == id).SingleOrDefault());
}
}
public List <DepotTank> GetDepotTankList()
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.DepotTanks
.Include("Tank")
.Include("Depot")
.Include("SensorDevice")
.ToList());
}
}
public DepotTank GetDepotTankById(int?id)
{
using (FLMSEntities entities = new FLMSEntities())
{
return(entities.DepotTanks
.Include("Tank")
.Include("Depot")
.Include("SensorDevice")
.Where(s => s.Id == id).SingleOrDefault());
}
}
public void SaveOrUpdate(City city)
{
using (FLMSEntities entities = new FLMSEntities())
{
if (city.Id == 0)
{
entities.Cities.Add(city);
entities.SaveChanges();
}
else
{
entities.Entry(city).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
}
}
}
public void SaveOrUpdate(SensorDevice district)
{
using (FLMSEntities entities = new FLMSEntities())
{
if (district.Id == 0)
{
entities.SensorDevices.Add(district);
entities.SaveChanges();
}
else
{
entities.Entry(district).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
}
}
}
public void SaveOrUpdate(Depot depots)
{
using (FLMSEntities entities = new FLMSEntities())
{
if (depots.Id == 0)
{
entities.Depots.Add(depots);
entities.SaveChanges();
}
else
{
entities.Entry(depots).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
}
}
}
public void SaveOrUpdate(Geolocation geolocation)
{
using (FLMSEntities entities = new FLMSEntities())
{
if (geolocation.Id == 0)
{
entities.Geolocations.Add(geolocation);
entities.SaveChanges();
}
else
{
entities.Entry(geolocation).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
}
}
}
public void SaveOrUpdate <T>(T t, int id) where T : class
{
using (FLMSEntities entities = new FLMSEntities())
{
if (id == 0)
{
entities.Set <T>().Add(t);
entities.SaveChanges();
}
else
{
entities.Entry(t).State = EntityState.Modified;
entities.SaveChanges();
}
}
}
public void SaveOrUpdate(Tank tank)
{
using (FLMSEntities entities = new FLMSEntities())
{
if (tank.Id == 0)
{
entities.Tanks.Add(tank);
entities.SaveChanges();
}
else
{
entities.Entry(tank).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
}
}
}
