public DailyTankerReading GetDailyTankerReadingByTankerID(int tankerID)
{
DailyTankerReading dailyDailyTankerReading = new DailyTankerReading();
using (var dbContext = new ppmsEntities())
{
dailyDailyTankerReading = (from a in dbContext.DailyTankerReadings
where a.IsActive == true && a.TankerId == tankerID
select a).FirstOrDefault();
}
return(dailyDailyTankerReading);
}
public long CreateTanker(TankerData tankerData, UserOpMap userOpMap)
{
DAL_Tanker dAL_Tanker = new DAL_Tanker();
Tanker tanker = new Tanker();
DailyTankerReading dailyTankerReading = new DailyTankerReading();
tanker.Name = tankerData.Name;
tanker.Size = tankerData.Size;
tanker.Description = tankerData.Description;
tanker.FuelTypeId = tankerData.FuelTypeID;
dailyTankerReading.DailyStartReading = tankerData.DayStartReading;
dailyTankerReading.DailyEndReading = tankerData.DayEndReading;
return(dAL_Tanker.CreateTanker(tanker, dailyTankerReading, userOpMap));
}
public long UpdateTanker(Tanker tanker, DailyTankerReading dailyTankerReading, UserOpMap userOpMap)
{
using (var dbContext = new ppmsEntities())
{
Tanker tankerData = new Tanker();
tankerData = (from a in dbContext.Tankers
where a.IsActive == true && a.Id == tanker.Id
select a).FirstOrDefault();
tankerData.Description = tanker.Description;
tankerData.Size = tanker.Size;
tankerData.FuelTypeId = tanker.FuelTypeId;
tankerData.UpdatedOn = DateTime.Now;
tankerData.Updatedby = Convert.ToInt64(userOpMap.UserID);
dbContext.SaveChanges();
DateTime today = DateTime.Now;
DailyTankerReading dailyTankerReadingData = new DailyTankerReading();
dailyTankerReadingData = (from a in dbContext.DailyTankerReadings
where a.UpdatedOn.Value.Day == today.Day &&
a.UpdatedOn.Value.Month == today.Month &&
a.UpdatedOn.Value.Year == today.Year && a.TankerId == tanker.Id && a.IsActive == true
select a).FirstOrDefault();
if (dailyTankerReadingData == null)
{
dailyTankerReading.TankerId = tanker.Id;
dailyTankerReading.DailyStartReading = dailyTankerReading.DailyStartReading;
dailyTankerReading.DailyEndReading = dailyTankerReading.DailyEndReading;
dailyTankerReading.CreatedBy = Convert.ToInt64(userOpMap.UserID);
dailyTankerReading.Updatedby = Convert.ToInt64(userOpMap.UserID);
dailyTankerReading.UpdatedOn = DateTime.Now;
dailyTankerReading.CreatedOn = DateTime.Now;
dailyTankerReading.IsActive = true;
dbContext.DailyTankerReadings.Add(dailyTankerReading);
dbContext.SaveChanges();//this generates the Id for DailyTankerReadings
}
else
{
dailyTankerReadingData.DailyStartReading = dailyTankerReading.DailyStartReading;
dailyTankerReadingData.DailyEndReading = dailyTankerReading.DailyEndReading;
dailyTankerReadingData.Updatedby = Convert.ToInt64(userOpMap.UserID);
dailyTankerReadingData.UpdatedOn = DateTime.Now;
dbContext.SaveChanges();//this generates the Id for DailyTankerReadings
}
return(dailyTankerReading.Id);
}
}
public long CreateTanker(Tanker tanker, DailyTankerReading dailyTankerReading, UserOpMap userOpMap)
{
using (var dbContext = new ppmsEntities())
{
Tanker tankerData = new Tanker();
tankerData = (from a in dbContext.Tankers
where a.IsActive == true && a.Name == tanker.Name
select a).FirstOrDefault();
if (tankerData == null)
{
//Create Tanker
tanker.IsActive = true;
tanker.CreatedBy = Convert.ToInt64(userOpMap.UserID);
tanker.Updatedby = Convert.ToInt64(userOpMap.UserID);
tanker.CreatedOn = DateTime.Now;
tanker.UpdatedOn = DateTime.Now;
dbContext.Tankers.Add(tanker);
dbContext.SaveChanges();
int tankerID = tanker.Id;
dailyTankerReading.CreatedBy = Convert.ToInt64(userOpMap.UserID);
dailyTankerReading.Updatedby = Convert.ToInt64(userOpMap.UserID);
dailyTankerReading.UpdatedOn = DateTime.Now;
dailyTankerReading.CreatedOn = DateTime.Now;
dailyTankerReading.IsActive = true;
dailyTankerReading.TankerId = tankerID;
dbContext.DailyTankerReadings.Add(dailyTankerReading);
dbContext.SaveChanges();
return(dailyTankerReading.Id);
}
else
{
throw new Exception("Tanker already exist !");
}
}
}
