//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;
}
}
//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);;
}
//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 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;
}
}
}
//Register Customer
public string RegisterCustomer(string phoneno, string email, string fname, string lname, string password)
{
using (rideshareEntities entities = new rideshareEntities())
{
var a = entities.tbl_customer.SingleOrDefault(customer => customer.cus_phoneno == phoneno);
if (a != null)
{
return(string.Format("Email Already Exist"));
}
else
{
tbl_customer customer = new tbl_customer {
cus_phoneno = phoneno, cus_password = password, cus_fname = fname, cus_lname = lname, cus_email = email
};
entities.tbl_customer.Add(customer);
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);
}
}
}
//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 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;
}
}
}
//public int Login(string username, string password)
//{
// using (rideshareEntities entities = new rideshareEntities())
// {
// var isprecent = entities.tbl_customer.SingleOrDefault(customer => customer.cus_email == username && customer.cus_password == password);
// //var query = entities.tbl_customer.Where(p => p.cus_email == 'a' && p.product_price > 500 && p.product_price < 10000)
// // var queary = entities.tbl_customer.SingleOrDefault(customer => customer.cus_email == username && customer.cus_password == password);
// if (isprecent != null)
// {
// return 1;
// }
// else
// {
// return 0;
// }
// }
//}
//Register Customer
public List <RegisterStatus> RegisterCustomer(string phoneno, string email, string fname, string lname, string password)
{
var registerstatus = new List <RegisterStatus>();
using (rideshareEntities entities = new rideshareEntities())
{
var a = (from c in entities.tbl_customer where (c.cus_email == email || c.cus_phoneno == phoneno)select 1);
//var a = entities.tbl_customer.SingleOrDefault(customer => customer.cus_phoneno == phoneno);
var firstOrDefault = a.FirstOrDefault();
if (firstOrDefault == 1)
{
if (a != null)
{
registerstatus.Add(new RegisterStatus()
{
registration = "0"
});
return(registerstatus);;
}
return(registerstatus);;
}
else
{
tbl_customer customer = new tbl_customer {
cus_phoneno = phoneno, cus_password = password, cus_fname = fname, cus_lname = lname, cus_email = email
};
entities.tbl_customer.Add(customer);
entities.SaveChanges();
registerstatus.Add(new RegisterStatus()
{
registration = "1"
});
return(registerstatus);;
}
}
}
//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");
}
}
//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");
}
}
//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");
}
}
//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;
}
}
//public int Login(string username, string password)
//{
// using (rideshareEntities entities = new rideshareEntities())
// {
// var isprecent = entities.tbl_customer.SingleOrDefault(customer => customer.cus_email == username && customer.cus_password == password);
// //var query = entities.tbl_customer.Where(p => p.cus_email == 'a' && p.product_price > 500 && p.product_price < 10000)
// // var queary = entities.tbl_customer.SingleOrDefault(customer => customer.cus_email == username && customer.cus_password == password);
// if (isprecent != null)
// {
// return 1;
// }
// else
// {
// return 0;
// }
// }
//}
//Register Customer
public List<RegisterStatus> RegisterCustomer(string phoneno, string email, string fname, string lname, string password)
{
var registerstatus = new List<RegisterStatus>();
using (rideshareEntities entities = new rideshareEntities())
{
var a = (from c in entities.tbl_customer where (c.cus_email == email || c.cus_phoneno== phoneno) select 1);
//var a = entities.tbl_customer.SingleOrDefault(customer => customer.cus_phoneno == phoneno);
var firstOrDefault = a.FirstOrDefault();
if (firstOrDefault == 1 )
{
if (a != null)
{
registerstatus.Add(new RegisterStatus()
{
registration = "0"
});
return registerstatus; ;
}
return registerstatus; ;
}
else
{
tbl_customer customer = new tbl_customer { cus_phoneno = phoneno, cus_password = password, cus_fname = fname, cus_lname = lname, cus_email = email };
entities.tbl_customer.Add(customer);
entities.SaveChanges();
registerstatus.Add(new RegisterStatus()
{
registration = "1"
});
return registerstatus; ;
}
}
}