public List <StoreBami> getListStore()
{
BamiBreadDataContext context = new BamiBreadDataContext();
List <StoreBami> list = context.StoreBamis.ToList();
return(list);
}
public List <TokenDevice> getTokenDevices()
{
BamiBreadDataContext context = new BamiBreadDataContext();
List <TokenDevice> listToken = context.TokenDevices.ToList();
return(listToken);
}
public User getUser(int id)
{
BamiBreadDataContext context = new BamiBreadDataContext();
User user = context.Users.FirstOrDefault(x => x.ID == id);
return(user);
}
public List <User> GetAllUser()
{
BamiBreadDataContext context = new BamiBreadDataContext();
List <User> listUser = context.Users.ToList();
return(listUser);
}
public FastFood GetFastFood(int id)
{
BamiBreadDataContext context = new BamiBreadDataContext();
FastFood ff = context.FastFoods.FirstOrDefault(x => x.ID == id);
if (ff != null)
{
ff.Category = null;
}
return(ff);
}
public List <FastFood> getAllFastFood()
{
BamiBreadDataContext context = new BamiBreadDataContext();
List <FastFood> listFastFood = context.FastFoods.ToList();
foreach (FastFood ff in listFastFood)
{
ff.Category = null;
}
return(listFastFood);
}
public List <Introduce> getListIntroduce()
{
try
{
BamiBreadDataContext context = new BamiBreadDataContext();
List <Introduce> list = context.Introduces.ToList();
return(list);
}
catch { }
return(null);
}
public bool getUserName(String username)
{
BamiBreadDataContext context = new BamiBreadDataContext();
User user = context.Users.FirstOrDefault(x => x.Username == username);
if (user != null)
{
return(true);
}
return(false);
}
public Category GetCategory(int id)
{
BamiBreadDataContext context = new BamiBreadDataContext();
Category c = context.Categories.FirstOrDefault(x => x.ID == id);
if (c != null)
{
c.FastFoods.Clear();
}
return(c);
}
public List <FastFood> getListFF(int maDM)
{
BamiBreadDataContext context = new BamiBreadDataContext();
List <FastFood> listFastFood = context.FastFoods.Where(x => x.IDCategory == maDM).ToList();
foreach (FastFood ff in listFastFood)
{
ff.Category = null;
}
return(listFastFood);
}
public List <FastFood> getListFF(int a, int b)
{
BamiBreadDataContext context = new BamiBreadDataContext();
List <FastFood> listFastFood = context.FastFoods.Where(x => x.Price >= a && x.Price <= b).ToList();
foreach (FastFood ff in listFastFood)
{
ff.Category = null;
}
return(listFastFood);
}
public bool checkUserNamePassword(String username, String password)
{
try
{
BamiBreadDataContext context = new BamiBreadDataContext();
User user = context.Users.FirstOrDefault(x => x.Username == username && x.Password == password);
if (user != null)
{
return(true);
}
}
catch { }
return(false);
}
public bool delete(String username, String password)
{
try
{
BamiBreadDataContext context = new BamiBreadDataContext();
User user = context.Users.FirstOrDefault(x => x.Username == username && x.Password == password);
if (user != null)
{
context.Users.DeleteOnSubmit(user);
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool saveUser(String username, String password, String name)
{
try
{
BamiBreadDataContext context = new BamiBreadDataContext();
User user = new User();
user.Username = username;
user.Password = password;
user.NameUser = name;
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
return(true);
}
catch { }
return(false);
}
public bool updateUser(String username, String password, String name)
{
try
{
BamiBreadDataContext context = new BamiBreadDataContext();
User user = context.Users.FirstOrDefault(x => x.Username == username);
if (user != null)
{
user.Password = password;
user.NameUser = name;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool saveToken(String token)
{
try
{
BamiBreadDataContext context = new BamiBreadDataContext();
TokenDevice tokenD = context.TokenDevices.FirstOrDefault(x => x.Token == token);
if (tokenD != null)
{
return(false);
}
TokenDevice mToken = new TokenDevice();
mToken.Token = token;
context.TokenDevices.InsertOnSubmit(mToken);
context.SubmitChanges();
return(true);
}
catch { }
return(false);
}
public bool delete(int maDM)
{
try
{
BamiBreadDataContext context = new BamiBreadDataContext();
Category c = context.Categories.FirstOrDefault(x => x.ID == maDM);
if (c != null)
{
if (c.FastFoods.Count() > 0)
{
return(false);
}
context.Categories.DeleteOnSubmit(c);
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
