public IEnumerable <Additional> GetAddiotionals()
{
using (OfficeDbEntities entity = new OfficeDbEntities())
{
return(entity.Additionals.ToList());
}
}
public Additional GetAdditionalById(int id)
{
using (OfficeDbEntities entity = new OfficeDbEntities())
{
return(entity.Additionals.FirstOrDefault(e => e.Id == id));
}
}
public IEnumerable <Clark> GetClarks()
{
using (OfficeDbEntities entity = new OfficeDbEntities())
{
return(entity.Clarks.ToList());
}
}
public Clark GetClarkById(int id)
{
using (OfficeDbEntities entity = new OfficeDbEntities())
{
return(entity.Clarks.FirstOrDefault(e => e.Id == id));
}
}
public IEnumerable <Employee> GetEmployees()
{
using (OfficeDbEntities entity = new OfficeDbEntities())
{
return(entity.Employees.ToList());
}
}
public Employee GetEmployeeById(int id)
{
using (OfficeDbEntities entity = new OfficeDbEntities())
{
return(entity.Employees.FirstOrDefault(e => e.Id == id));
}
}
public Management GetManagementById(int id)
{
using (OfficeDbEntities entity = new OfficeDbEntities())
{
return(entity.Managements.FirstOrDefault(e => e.Id == id));
}
}
public IEnumerable <Management> GetManagements()
{
using (OfficeDbEntities entity = new OfficeDbEntities())
{
return(entity.Managements.ToList());
}
}
public IEnumerable <Bill> GetBills()
{
using (OfficeDbEntities entity = new OfficeDbEntities())
{
return(entity.Bills.ToList());
}
}
public ActionResult SignUp(User model)
{
using (var context = new OfficeDbEntities())
{
context.User.Add(model);
context.SaveChanges();
}
return(RedirectToAction("LogIn"));
}
public ActionResult LogIn(Models.Membership model)
{
using (var context = new OfficeDbEntities())
{
bool isValid = context.User.Any(x => x.UserName == model.UserName && x.Password == model.Password);
if (isValid)
{
FormsAuthentication.SetAuthCookie(model.UserName, false);
return(RedirectToAction("Index", "Employees"));
}
ModelState.AddModelError("", "Invalid username and password");
return(View());
}
}
