//Login Driver
public List <LoginDriver> DriverLogin(string phoneno, string password)
{
using (rideshareEntities entities = new rideshareEntities())
{
var driverlogin = new List <LoginDriver>();
var a = (from c in entities.tbl_driver where (c.dri_phoneno == phoneno && c.dri_password == password) select c.dri_id).ToList();
// var isprecent = from d in entities.tbl_driver where d.dri_phoneno == phoneno && d.dri_password == password select 1;
var firstOrDefault = a.FirstOrDefault();
if (a.Count == 1)
{
foreach (var k in a)
{
driverlogin.Add(new LoginDriver()
{
loginstatus = firstOrDefault.ToString()
});
}
}
else
{
driverlogin.Add(new LoginDriver()
{
loginstatus = "0"
});
}
return(driverlogin);;
}
}
//Get Vehicle List
public List <VehicleInfo> GetTaxiList()
{
using (rideshareEntities entities = new rideshareEntities())
{
var vehicleInfo = new List <VehicleInfo>();
var a = (from v in entities.tbl_vehicle
join d in entities.tbl_driver on v.veh_driverid equals d.dri_id
select new { v.veh_regno, v.veh_type, v.veh_location, v.veh_description, d.dri_lname, d.dri_phoneno, v.veh_Latitude, v.veh_Longitude });
foreach (var k in a)
{
vehicleInfo.Add(new VehicleInfo()
{
veh_regno = k.veh_regno,
veh_type = k.veh_type,
veh_location = k.veh_location,
veh_description = k.veh_description,
dri_lname = k.dri_lname,
dri_phoneno = k.dri_phoneno,
veh_Latitude = k.veh_Latitude,
veh_Longitude = k.veh_Longitude
});
}
return(vehicleInfo);;
}
}
//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);;
}
//Login Driver
public List<LoginDriver> DriverLogin(string phoneno, string password)
{
using (rideshareEntities entities = new rideshareEntities())
{
var driverlogin = new List<LoginDriver>();
var a = (from c in entities.tbl_driver where (c.dri_phoneno == phoneno && c.dri_password == password) select c.dri_id).ToList();
// var isprecent = from d in entities.tbl_driver where d.dri_phoneno == phoneno && d.dri_password == password select 1;
var firstOrDefault = a.FirstOrDefault();
if (a.Count == 1)
{
foreach (var k in a)
{
driverlogin.Add(new LoginDriver()
{
loginstatus = firstOrDefault.ToString()
});
}
}
else
{
driverlogin.Add(new LoginDriver()
{
loginstatus = "0"
});
}
return driverlogin; ;
}
}
//Login Customer
//
public List <UserLogin> Login(string username, string password)
{
using (rideshareEntities entities = new rideshareEntities())
{
var userlogin = new List <UserLogin>();
// var a = (from c in entities.tbl_customer where v.cus_email == username && v.cus_password = password select 1);
var isprecent = (from c in entities.tbl_customer where (c.cus_email == username && c.cus_password == password)select 1).ToList();
if (isprecent.Capacity < 1)
{
userlogin.Add(new UserLogin()
{
Loginstatus = "0"
});
}
foreach (var k in isprecent)
{
userlogin.Add(new UserLogin()
{
Loginstatus = "1"
});
}
return(userlogin);;
}
}
//Login Driver
public int LoginDriver(string phoneno, string password)
{
using (rideshareEntities entities = new rideshareEntities())
{
var isprecent = from d in entities.tbl_driver where d.dri_phoneno == phoneno && d.dri_password == password select 1;
if (isprecent == null)
{
return(0);
}
else
{
return(1);
}
}
}
//Login Customer
public int Login(string phoneno)
{
using (rideshareEntities entities = new rideshareEntities())
{
var isprecent = entities.tbl_customer.SingleOrDefault(customer => customer.cus_phoneno == phoneno);
if (isprecent != null)
{
return(1);
}
else
{
return(0);
}
}
}
//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;
}
}
}
//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");
}
}
//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");
}
}
//Login Customer
//
public List<UserLogin> Login(string username, string password)
{
using (rideshareEntities entities = new rideshareEntities())
{
var userlogin = new List<UserLogin>();
// var a = (from c in entities.tbl_customer where v.cus_email == username && v.cus_password = password select 1);
var isprecent = (from c in entities.tbl_customer where (c.cus_email == username && c.cus_password == password) select 1).ToList();
if (isprecent.Capacity <1)
{
userlogin.Add(new UserLogin()
{
Loginstatus = "0"
});
}
foreach (var k in isprecent)
{
userlogin.Add(new UserLogin()
{
Loginstatus = "1"
});
}
return userlogin; ;
}
}
//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 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; ;
}
//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");
}
}
//Get Vehicle List
public List<VehicleInfo> GetTaxiList()
{
using (rideshareEntities entities = new rideshareEntities())
{
var vehicleInfo = new List<VehicleInfo>();
var a = (from v in entities.tbl_vehicle
join d in entities.tbl_driver on v.veh_driverid equals d.dri_id
select new { v.veh_regno, v.veh_type, v.veh_location, v.veh_description, d.dri_lname, d.dri_phoneno, v.veh_Latitude, v.veh_Longitude });
foreach (var k in a)
{
vehicleInfo.Add(new VehicleInfo()
{
veh_regno = k.veh_regno,
veh_type = k.veh_type,
veh_location = k.veh_location,
veh_description = k.veh_description,
dri_lname = k.dri_lname,
dri_phoneno = k.dri_phoneno,
veh_Latitude= k.veh_Latitude,
veh_Longitude = k.veh_Longitude
});
}
return vehicleInfo; ;
}
}
//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");
}
}
