public void send(contact c)
{
Database1Entities4 f = new Database1Entities4();
f.contacts.AddObject(c);
f.SaveChanges();
}
public List <caterer> find(caterer u)
{
Database1Entities4 d = new Database1Entities4();
List <caterer> list = d.caterers.Where(x => (x.name == u.name) || (x.city == u.city)).ToList();
return(list);
}
public void add(user u)
{
Database1Entities4 f = new Database1Entities4();
f.users.AddObject(u);
f.SaveChanges();
}
public List <user> signIn(string u, string p)
{
using (Database1Entities4 f = new Database1Entities4())
{
List <user> list = f.users.Where(x => (x.username == u && x.password == p)).ToList();
return(list);
}
}
public void remove(int id)
{
using (Database1Entities4 f = new Database1Entities4())
{
caterer obj = f.caterers.First(x => x.Id == id);
f.caterers.DeleteObject(obj);
f.SaveChanges();
}
}
//
// GET: /MyCaterer/
public user getUserById(int?id)
{
user u = null;
using (Database1Entities4 f = new Database1Entities4())
{
u = f.users.First(x => x.Id == id);
}
return(u);
}
public void add(caterer u, int i)
{
user usr = null;
using (Database1Entities4 f = new Database1Entities4())
{
usr = f.users.First(x => x.Id == i);
u.user = usr;
usr.caterers.Add(u);
f.caterers.AddObject(u);
f.SaveChanges();
}
}
//
// GET: /MyHome/
public Boolean checkNIC(String n)
{
user a = null;
using (Database1Entities4 c = new Database1Entities4())
{
a = c.users.FirstOrDefault(x => x.username == n);
}
if (a != null)
{
return(true);
}
return(false);
}
public caterer detail(int id)
{
Database1Entities4 d = new Database1Entities4();
return(d.caterers.First(x => x.Id == id));
}
public List <caterer> view()
{
Database1Entities4 d = new Database1Entities4();
return(d.caterers.ToList());
}