// Database1Entities db = new Database1Entities();
public void save(login l)
{
using (Database1Entities1 db = new Database1Entities1()) {
db.logins.Add(l);
db.SaveChanges();
}
}
public void submitpost(product p)
{
using (Database1Entities1 db = new Database1Entities1())
{
//if()
db.products.Add(p);
db.SaveChanges();
}
}
public int search(login l)
{
using (Database1Entities1 db = new Database1Entities1())
{
var y = db.logins.FirstOrDefault(x => x.username.Equals(l.username) && x.password.Equals(l.password));
//var q = from y in db.logins select y;
if (y != null)
{
return(1);
}
}
return(0);
}
//public product checkSearch(string search)
//{
// Database1Entities1 db = new Database1Entities1();
// return db.products.FirstOrDefault(x => x.option.Equals(search));
// //if (u != null)
// //{
// // result = "User Name is already exist";
// //}
// //else
// //{
// // result = "User Name is Available";
// //}
// //return result;
//}
public string checkUser(string name)
{
Database1Entities1 db = new Database1Entities1();
string result;
var u = db.logins.FirstOrDefault(x => x.username.Equals(name));
if (u != null)
{
result = "User Name is already exist";
}
else
{
result = "User Name is Available";
}
return(result);
}
