public User Get(int id)
{
using (var ctx = new FPContext())
{
return(ctx.Users.FirstOrDefault(x => x.Id == id));
}
}
public List <User> ReadAll()
{
using (var ctx = new FPContext())
{
return(ctx.Users.ToList());
}
}
public ActionResult Index(int?CountValue)
{
var model = new Models.CountModel()
{
CountValue = CountValue.Value
};
using (var db = new FPContext())
{
var firstRecord = db.Counts.FirstOrDefault();
if (firstRecord != null)
{
firstRecord.CountValue = CountValue.Value;
}
else
{
firstRecord = db.Counts.Add(new Count {
CountValue = CountValue.Value
});
}
db.SaveChanges();
}
return(View(model));
}
public void Post([FromBody] Dati dati)
{
FPContext db = new FPContext();
db.Datis.Add(dati);
db.SaveChanges();
}
public bool Delete(User t)
{
using (var ctx = new FPContext())
{
ctx.Entry(ctx.Users.FirstOrDefault(x => x.Id == t.Id)).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
return(ctx.Users.FirstOrDefault(x => x.Id == t.Id) == null);
}
}
public User Create(User t)
{
using (var ctx = new FPContext())
{
ctx.Users.Add(t);
ctx.SaveChanges();
return(t);
}
}
public User Update(User t)
{
using (var ctx = new FPContext())
{
var userToUpdate = ctx.Users.FirstOrDefault(x => x.Id == t.Id);
if (userToUpdate != null)
{
userToUpdate.FirstName = t.FirstName;
userToUpdate.LastName = t.LastName;
userToUpdate.Email = t.Email;
userToUpdate.Company = t.Company;
userToUpdate.Type = t.Type;
userToUpdate.Password = t.Password;
}
ctx.SaveChanges();
return(t);
}
}
public ActionResult Index()
{
var model = new Models.CountModel()
{
CountValue = 0
};
using (var db = new FPContext())
{
db.Database.CreateIfNotExists();
model = db.Counts.Select(x => new Models.CountModel
{
CountValue = x.CountValue
}).FirstOrDefault();
}
return(View(model));
}
public PizzeriaRepository(FPContext databaseContext)
{
_databaseContext = databaseContext;
}
public PizzaSizeRepository(FPContext databaseContext)
{
_databaseContext = databaseContext;
}
public IEnumerable <Dati> Get()
{
FPContext db = new FPContext();
return(db.Datis.AsEnumerable());
}
