public IHttpActionResult DriverRatingDetails(DriverRating driverRating)
{
var DriverRating = new DriverBO().SaveDriverRating(driverRating);
if (DriverRating)
{
return(Ok(DriverRating));
}
else
{
return(NotFound());
}
}
public IHttpActionResult DriverRatingDetails(DriverRating driverRating)
{
var DriverRating = new DriverBO().SaveDriverRating(driverRating);
if (DriverRating)
{
return(Ok(new { DriverRating }));
}
else
{
return(Ok(new { Status = UTILITY.FAILURESTATUS }));
}
}
public IContract GetDriverRating <T>(IContract lookupItem) where T : IContract
{
var item = ((DriverRating)lookupItem);
DriverRating driverItem = db.ExecuteSprocAccessor(DBRoutine.SELECTDRIVERAVERAGERATING,
MapBuilder <DriverRating>
.MapAllProperties().Build(), item.DriverID).FirstOrDefault();
if (driverItem == null)
{
return(null);
}
return(driverItem);
}
public bool SaveDriverRating <T>(T item) where T : IContract
{
var result = 0;
DriverRating driverRating = (DriverRating)(object)item;
if (currentTransaction == null)
{
connection = db.CreateConnection();
connection.Open();
}
var transaction = (currentTransaction == null ? connection.BeginTransaction() : currentTransaction);
try
{
var savecommand = db.GetStoredProcCommand(DBRoutine.SAVEDRIVERRATING);
db.AddInParameter(savecommand, "BookingNo", System.Data.DbType.String, driverRating.BookingNo);
db.AddInParameter(savecommand, "DriverID", System.Data.DbType.String, driverRating.DriverID);
db.AddInParameter(savecommand, "Rating", System.Data.DbType.String, driverRating.Rating);
db.AddInParameter(savecommand, "Remarks", System.Data.DbType.String, driverRating.Remarks);
result = db.ExecuteNonQuery(savecommand, transaction);
if (currentTransaction == null)
{
transaction.Commit();
}
}
catch (Exception ex)
{
if (currentTransaction == null)
{
transaction.Rollback();
}
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
}
return(result > 0 ? true : false);
}
public bool CreateDriverRating(DriverRatingCreate model)
{
using (var ctx = new ApplicationDbContext())
{
var entity =
new DriverRating()
{
ApplicationUser = _userId,
DriverId = model.DriverId,
DriverFunScore = model.DriverFunScore,
DriverSafetyScore = model.DriverSafetyScore,
DriverCleanlinessScore = model.DriverCleanlinessScore,
UserCreatedDriverRating = ctx.Users.Single(dr => dr.Id == _userId.ToString()).UserName,
};
ctx.DriverRatings.Add(entity);
return(ctx.SaveChanges() == 1);
}
}
public async Task <int> SeedDriversRatings(ApplicationDbContext context)
{
var driversRatings = new DriverRating[]
{
new DriverRating()
{
ClientId = "dta", TransferId = 1, DriverId = "abc"
},
new DriverRating()
{
ClientId = "dta", TransferId = 2, DriverId = "abc"
},
new DriverRating()
{
ClientId = "dta", TransferId = 3, DriverId = "abc"
},
new DriverRating()
{
ClientId = "dta", TransferId = 4, DriverId = "bcd"
},
new DriverRating()
{
ClientId = "dta", TransferId = 5, DriverId = "bcd"
},
new DriverRating()
{
ClientId = "dta", TransferId = 6, DriverId = "cde"
},
};
foreach (var driverRating in driversRatings)
{
await context.DriversRatings.AddAsync(driverRating);
}
await context.SaveChangesAsync();
return(driversRatings.Length);
}
public bool SaveDriverRating(DriverRating driverRating)
{
return(driverDAL.SaveDriverRating(driverRating));
}
public DriverRating GetDriverRating(DriverRating item)
{
return((DriverRating)driverDAL.GetDriverRating <DriverRating>(item));
}
