//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);;
}
//Update Driver Details
public string UpdateDriver(string driid, string fname, string lname, string address, string nic, string licenceno)
{
try
{
using (rideshareEntities entitis = new rideshareEntities())
{
tbl_driver driver = entitis.tbl_driver.SingleOrDefault(dri => dri.dri_id == int.Parse(driid));
if (lname != "")
{
driver.dri_lname = lname;
}
if (address != "")
{
driver.dri_address = address;
}
if (nic != "")
{
driver.dri_nic = nic;
}
entitis.SaveChanges();
return("Sucess");
}
}
catch (Exception)
{
throw;
}
}
//UpdateCustomerDetails
public string Updateuser(string address, string nic, string phoneno, string fname, string lname, string vehicleno, string licenceno)
{
try
{
using (rideshareEntities entities = new rideshareEntities())
{
tbl_driver driver = entities.tbl_driver.SingleOrDefault(dri => dri.dri_nic == nic);
if (nic != "")
{
driver.dri_nic = nic;
}
if (fname != "")
{
driver.dri_fname = fname;
}
if (lname != "")
{
driver.dri_lname = lname;
}
if (licenceno != "")
{
driver.dri_licence = licenceno;
}
if (phoneno != "")
{
driver.dri_phoneno = phoneno;
}
if (address != "")
{
driver.dri_address = address;
}
entities.SaveChanges();
return("Sucess");
}
}
catch (Exception)
{
throw new Exception("Oops something wrong try again");
}
}
//Add New Driver
public string AddDriver(string fname, string lname, string address, string nic)
{
using (rideshareEntities entities = new rideshareEntities())
{
var a = entities.tbl_driver.SingleOrDefault(driver => driver.dri_nic == nic);
if (a != null)
{
return(string.Format("Vehicle Already Exist"));
}
else
{
tbl_driver driver = new tbl_driver {
dri_nic = nic, dri_address = address, dri_fname = fname, dri_lname = lname, active = "T"
};
entities.tbl_driver.Add(driver);
entities.SaveChanges();
return(null);
}
}
}
//Add New Driver
public string AddDriver(string fname, string lname, string address, string nic)
{
using (rideshareEntities entities = new rideshareEntities())
{
var a = entities.tbl_driver.SingleOrDefault(driver => driver.dri_nic == nic );
if (a != null)
{
return string.Format("Vehicle Already Exist");
}
else
{
tbl_driver driver = new tbl_driver { dri_nic = nic, dri_address = address, dri_fname = fname, dri_lname = lname , active = "T" };
entities.tbl_driver.Add(driver);
entities.SaveChanges();
return null;
}
}
}
