//Update Driver Status
public List <DriverStatus> UpdateDriverStatus(string driid, string status, string Latitude, string Longitud)
{
var driverstatus = new List <DriverStatus>();
try
{
using (rideshareEntities entities = new rideshareEntities())
{
int driverid = Convert.ToInt32(driid);
tbl_driver driver = entities.tbl_driver.SingleOrDefault(dri => dri.dri_id == driverid);
tbl_vehicle vehicle = entities.tbl_vehicle.SingleOrDefault(dri => dri.veh_driverid == driverid);
driver.dri_status = status;
vehicle.veh_Latitude = Latitude;
vehicle.veh_Longitude = Longitud;
entities.SaveChanges();
driverstatus.Add(new DriverStatus
{
updatestatus = "1"
});
}
}
catch (Exception)
{
driverstatus.Add(new DriverStatus
{
updatestatus = "0"
});
//throw;
}
return(driverstatus);;
}
//Add New vehicle
public string AddTaxi( string regno , string type, string description, string driver)
{
using (rideshareEntities entities = new rideshareEntities())
{
var a = entities.tbl_vehicle.SingleOrDefault(vehicle => vehicle.veh_regno == regno);
if (a != null)
{
return string.Format("Vehicle Already Exist");
}
else
{
tbl_vehicle vehicle = new tbl_vehicle { veh_regno = regno, veh_type = type, veh_description = description , veh_driverid = int.Parse(driver), active = "T"};
entities.tbl_vehicle.Add(vehicle);
entities.SaveChanges();
return null;
}
}
}
//Add New vehicle
public string AddTaxi(string regno, string type, string description, string driver)
{
using (rideshareEntities entities = new rideshareEntities())
{
var a = entities.tbl_vehicle.SingleOrDefault(vehicle => vehicle.veh_regno == regno);
if (a != null)
{
return(string.Format("Vehicle Already Exist"));
}
else
{
tbl_vehicle vehicle = new tbl_vehicle {
veh_regno = regno, veh_type = type, veh_description = description, veh_driverid = int.Parse(driver), active = "T"
};
entities.tbl_vehicle.Add(vehicle);
entities.SaveChanges();
return(null);
}
}
}
//Update Vehicle Details
public string UpdateTaxi(string vehid, string regno, string type, string description, string driver, string active)
{
try
{
using (rideshareEntities entities = new rideshareEntities())
{
tbl_vehicle vehicle = entities.tbl_vehicle.SingleOrDefault(veh => veh.veh_id == int.Parse(vehid));
if (regno != "")
{
vehicle.veh_regno = regno;
}
if (type != "")
{
vehicle.veh_type = type;
}
if (description != "")
{
vehicle.veh_description = description;
}
if (driver != "")
{
vehicle.veh_driverid = int.Parse(driver);
}
if (active != "")
{
vehicle.active = active;
}
entities.SaveChanges();
return("Sucess");
}
}
catch (Exception)
{
throw new Exception("Oops something wrong try again");
}
}
