public int Insert(Data.Model.Category category)
{
db = new BespokeDbEntities();
db.Entry(category).State = System.Data.Entity.EntityState.Added;
return(db.SaveChanges());
}
public int Update(Data.Model.User user)
{
db = new BespokeDbEntities();
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
public int Insert(Data.Model.Branch branch)
{
db = new BespokeDbEntities();
db.Entry(branch).State = System.Data.Entity.EntityState.Added;
return(db.SaveChanges());
}
public List <Data.Model.User> Gets()
{
db = new BespokeDbEntities();
var result = default(List <Database.User>);
result = db.Users.ToList();
return(result);
}
public Data.Model.User GetLogin(string username, string password)
{
var user = new Data.Model.User();
db = new BespokeDbEntities();
user = db.Users.Where(x => x.Username == username && x.Password == password).FirstOrDefault();
return(user);
}
public int Delete(int id)
{
db = new BespokeDbEntities();
var data = db.Users.FirstOrDefault(x => x.Id == id);
db.Entry(data).State = System.Data.Entity.EntityState.Deleted;
return(db.SaveChanges());
}
public List <Data.Model.Category> Gets()
{
db = new BespokeDbEntities();
var result = default(List <Database.Category>);
result = db.Categories.ToList();
return(result);
}
public List <Data.Model.Branch> Gets()
{
db = new BespokeDbEntities();
var result = default(List <Database.Branch>);
result = db.Branches.ToList();
return(result);
}
public Data.Model.User Get(int id)
{
db = new BespokeDbEntities();
return(db.Users.FirstOrDefault(x => x.Id == id));
}
public Data.Model.Category Get(int id)
{
db = new BespokeDbEntities();
return(db.Categories.FirstOrDefault(x => x.Id == id));
}
