public ActionResult Store(Models.Driver dr)
{
ViewBag.delete = "";
try
{
var data = (from Driver in careemEntities.Drivers select Driver).ToList();
if (ModelState.IsValid)
{
var id = dr.licenseNo;
var count = careemEntities.Drivers.Where(s => s.licenseNo.Equals(id)).Count();
if (count > 0)
{
ViewBag.message = "License Number already exists";
ViewBag.drivers = data;
return(View("Driver", dr));
}
careemEntities.Drivers.Add(dr);
careemEntities.SaveChanges();
data = (from Driver in careemEntities.Drivers select Driver).ToList();
ViewBag.drivers = data;
ViewBag.message = "";
return(View("Driver", dr));
//return Json(_post);
}
ViewBag.drivers = data;
ViewBag.message = "Insert failed!";
return(View("Driver"));
}
catch (Exception ex)
{
ViewBag.message = ex.ToString();
return(View("Driver"));
}
}
public ActionResult Index()
{
string queryString = "Select * From Driver";
List <Models.Driver> Driver = new List <Models.Driver>();
using (SqlConnection connection = new SqlConnection(_connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Models.Driver driver = new Models.Driver();
driver.ID = Convert.ToInt32(reader["Id"]);
driver.firstName = reader["FirstName"].ToString();
driver.LastName = reader["LastName"].ToString();
driver.EmailAddress = reader["EmailAddress"].ToString();
driver.Birthday = Convert.ToDateTime(reader["Birthday"].ToString());
driver.CarYear = Convert.ToInt32(reader["CarYear"]);
driver.CarMake = reader["CarMake"].ToString();
driver.CarModel = reader["CarModel"].ToString();
driver.DUII = reader["DUII"].ToString();
driver.SpeedingTickets = Convert.ToInt32(reader["SpeedingTickets"]);
driver.InsuranceType = reader["InsuranceType"].ToString();
driver.Add(driver);
}
connection.Close();
}
return(View());
}
private void GetDrivers()
{
_dbConnection.Open();
using (DbCommand command = _dbConnection.CreateCommand())
{
command.CommandText = "SELECT * FROM Drivers"; // TODO add season ID
var reader = command.ExecuteReader();
Drivers.Clear();
while (reader.Read())
{
Models.Driver driver = new Models.Driver();
driver.FirstName = (string)reader["FirstName"];
driver.LastName = (string)reader["LastName"];
driver.IsLadies = (bool)reader["IsLadies"];
driver.IsNovice = (bool)reader["IsNovice"];
driver.Id = (int)reader["Id"];
driver.SeasonId = (int)reader["SeasonId"];
driver.DriverExists = true;
Drivers.Add(driver);
}
}
_dbConnection.Close();
}
public JsonResult ProvinceCodeRemoteValidator(string provinceCode)
{
Driver driver = new Models.Driver(_context);
if (driver.ProvinceCodeExists(provinceCode))
{
return(Json(true));
}
return(Json("Province code is invalid, ensure it is at least two letter"));
}
private DbCommand CreateDriverInsertCommand(Models.Driver driverInfo)
{
DbCommand driverInsertQuery = _dbConnection.CreateCommand();
driverInsertQuery.CommandText = "INSERT INTO Drivers (SeasonId, FirstName, LastName, IsLadies, IsNovice) VALUES (@SeasonId, @FirstName, @LastName, @IsLadies, @IsNovice)";;
Utilities.Extensions.AddParamWithValue(ref driverInsertQuery, "SeasonId", driverInfo.SeasonId);
Utilities.Extensions.AddParamWithValue(ref driverInsertQuery, "FirstName", driverInfo.FirstName);
Utilities.Extensions.AddParamWithValue(ref driverInsertQuery, "LastName", driverInfo.LastName);
Utilities.Extensions.AddParamWithValue(ref driverInsertQuery, "IsLadies", driverInfo.IsLadies);
Utilities.Extensions.AddParamWithValue(ref driverInsertQuery, "IsNovice", driverInfo.IsNovice);
return(driverInsertQuery);
}
public Task <Models.Driver> AddDriverAsync(string firstName, string lastName, string phone, string email = null)
{
this._readerWriterLockSlim.EnterWriteLock();
try
{
var driver = new Models.Driver(this.CalculateId(), firstName, lastName, phone, email);
this._drivers.Add(driver);
return(Task.FromResult(driver));
}
finally
{
this._readerWriterLockSlim.ExitWriteLock();
}
}
private void InsertDriver(Models.Driver driver)
{
// Insert driver if they do not exist
if (!driver.DriverExists)
{
using (DbCommand driverInsertCommand = CreateDriverInsertCommand(driver))
{
int result = driverInsertCommand.ExecuteNonQuery();
if (result < 0)
{
Console.WriteLine("Error inserting run data into Database!");
// TODO handle error
}
}
}
}
//Updates the existing Driver Details
public async Task <IActionResult> OnPutUpdateDriver([FromBody] Models.Driver obj)
{
if (obj != null && (HttpContext.User.IsInRole("Admin") || HttpContext.User.IsInRole("Fleet")))
{
try
{
_context.Attach(obj).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(new JsonResult(obj));
}
catch (DbUpdateException d)
{
return(new JsonResult("Driver Changes not saved." + d.InnerException.Message));
}
}
return(new JsonResult("Drivers Changes not saved. You do not have access rights to save these changes"));
}
private Entities.Driver MapJsonDriver(int?jsonDriverId, Models.InputJson.Json inputJson)
{
if (jsonDriverId == null)
{
return(null);
}
Models.Driver jsonDriver = inputJson.Drivers.First(x => x.Id == jsonDriverId);
Entities.Driver entityDriver = new Entities.Driver
{
Id = jsonDriverId.Value,
LicenseNumber = jsonDriver.LicenseNumber,
PersonId = jsonDriver.Person,
Person = MapJsonPerson(jsonDriver.Person, inputJson)
};
return(entityDriver);
}
public ActionResult EditDriver([Bind(Include = "id,name,status,licenseNo,vichleNo,city,email")] Models.Driver _driver)
{
if (ModelState.IsValid)
{
var data = careemEntities.Drivers.Find(_driver.id);
data.name = _driver.name;
data.status = _driver.status;
data.licenseNo = _driver.licenseNo;
data.vichleNo = _driver.vichleNo;
data.city = _driver.city;
data.email = _driver.email;
careemEntities.Entry(data).State = EntityState.Modified;
careemEntities.SaveChanges();
// return Json(_post);
return(RedirectToAction("Driver"));
}
var dataEdit = careemEntities.Drivers.Where(s => s.licenseNo == _driver.licenseNo).FirstOrDefault();
return(View(dataEdit));
}
//Inserts a new Employee with details
public async Task <IActionResult> OnPostInsertDriver([FromBody] Models.Driver obj)
{
if (obj != null && (HttpContext.User.IsInRole("Admin") || HttpContext.User.IsInRole("Fleet")))
{
try
{
_context.Add(obj);
await _context.SaveChangesAsync();
int id = obj.DriverID; // Yes it's here
return(new JsonResult(obj));
}
catch (DbUpdateException d)
{
return(new JsonResult("Driver Not Added." + d.InnerException.Message));
}
}
else
{
return(new JsonResult("Driver Not Inserted"));
}
}
private void GetEventData(int eventId)
{
_dbConnection.Open();
using (DbCommand command = _dbConnection.CreateCommand())
{
command.CommandText = "SELECT * FROM Results WHERE ";
var reader = command.ExecuteReader();
while (reader.Read())
{
Models.Driver driver = new Models.Driver();
driver.FirstName = (string)reader["FirstName"];
driver.LastName = (string)reader["LastName"];
driver.IsLadies = (bool)reader["IsLadies"];
driver.IsNovice = (bool)reader["IsNovice"];
driver.Id = (int)reader["Id"];
driver.DriverExists = true;
}
}
_dbConnection.Close();
}
public static DM.Driver DriverToModel(RideShare.DAL.Driver entity)
{
DM.Driver result = new Models.Driver(entity.DriverId, entity.LicensePlateNo, entity.Name, entity.Rating, entity.XCoordinate, entity.YCoordinate);
return(result);
}
public bool UpdateDriver(Models.Driver driver)
{
return(driverService.UpdateDriver(driver));
}
public long InsertDriver(Models.Driver driver)
{
return(driverService.AddDriver(driver));
}
