//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);
}
}
}
//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);;
}
}
}
//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; ;
}
}
}
