public ActionResult Edit(int id)
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
return(View(objDentistDBEntities.Users.Where(s => s.Id == id).FirstOrDefault()));
}
}
public ActionResult Create(UserModel objUserModel)
{
if (ModelState.IsValid)
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
var objUser = new DBModel.Users();
if (objDentistDBEntities.Users.Any(x => x.Email == objUserModel.Email))
{
ViewBag.ErrorEmailMessage = "Email już istnieje!";
return(View());
}
objUser.CreatedOn = DateTime.Now;
objUser.FirstName = objUserModel.FirstName;
objUser.LastName = objUserModel.LastName;
objUser.Email = objUserModel.Email;
objUser.Password = Hash.HashPassword(objUserModel.Password);
objUser.Role = 3;
objDentistDBEntities.Users.Add(objUser);
objDentistDBEntities.SaveChanges();
return(RedirectToAction("Index", "Employee"));
}
}
return(View());
}
public ActionResult AppointmentsDelete(int id)
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
return(View(objDentistDBEntities.Visit.Where(x => x.Id == id).FirstOrDefault()));
}
}
public ActionResult Visit(string UserId, string EmployeeId, string time, DateTime startDate)
{
var dateInt = startDate.AddHours(Convert.ToInt32(time)).ToString();
var idUser = Convert.ToInt32(UserId);
var idEmployee = Convert.ToInt32(EmployeeId);
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
var employee = objDentistDBEntities.Users.Where(x => x.Id == idEmployee).FirstOrDefault();
if (objDentistDBEntities.Visit.Any(x => x.employeeId == idEmployee && x.timedate == dateInt))
{
ViewBag.EmployeeId = employee.Id;
ViewBag.EmployeeFirstName = employee.FirstName;
ViewBag.EmployeeLastName = employee.LastName;
ViewBag.UserId = idUser;
ViewBag.ErrorEmailMessage = "Termin już jest zajęty!";
return(View());
}
var objvisit = new DBModel.Visit();
objvisit.timedate = dateInt;
objvisit.userId = idUser;
objvisit.employeeId = idEmployee;
objvisit.timeOrderBy = startDate.AddHours(Convert.ToInt32(time));
objvisit.employeeName = employee.FirstName + " " + employee.LastName;
objDentistDBEntities.Visit.Add(objvisit);
objDentistDBEntities.SaveChanges();
}
ViewBag.ErrorEmailMessage = startDate.AddHours(Convert.ToInt32(time)).Ticks;
return(RedirectToAction("Index", "Employee"));
}
public ActionResult Index()
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
var user = objDentistDBEntities.Users.Where(a => a.Email == User.Identity.Name).FirstOrDefault();
ViewBag.RoleId = user.Role;
return(View(objDentistDBEntities.Users.Where(x => x.Role == 3).ToList()));
}
}
public ActionResult Delete(int id, FormCollection collection)
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
var user = objDentistDBEntities.Users.Where(x => x.Id == id).FirstOrDefault();
objDentistDBEntities.Users.Remove(user);
objDentistDBEntities.SaveChanges();
return(RedirectToAction("Index", "Employee"));
}
}
public ActionResult AppointmentsDelete(int id, FormCollection collection)
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
var appointment = objDentistDBEntities.Visit.Where(x => x.Id == id).FirstOrDefault();
objDentistDBEntities.Visit.Remove(appointment);
objDentistDBEntities.SaveChanges();
return(RedirectToAction("Appointments", "Employee"));
}
}
public ActionResult Appointments()
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
var user = objDentistDBEntities.Users.Where(a => a.Email == User.Identity.Name).FirstOrDefault();
ViewBag.RoleId = user.Role;
if (user.Role == 3)
{
return(View(objDentistDBEntities.Visit.Where(x => x.employeeId == user.Id).OrderBy(s => s.timeOrderBy).ToList()));
}
return(View(objDentistDBEntities.Visit.Where(x => x.userId == user.Id).OrderBy(s => s.timeOrderBy).ToList()));
}
}
public ActionResult Index()
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
var user = objDentistDBEntities.Users.Where(a => a.Email == User.Identity.Name).FirstOrDefault();
ViewBag.Identificacion = user.Id;
ViewBag.FirstName = user.FirstName;
ViewBag.LastName = user.LastName;
ViewBag.Email = user.Email;
ViewBag.CreatedOn = user.CreatedOn;
return(View(user));
}
}
public ActionResult Edit(int id, Users user)
{
try
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
objDentistDBEntities.Entry(user).State = EntityState.Modified;
objDentistDBEntities.SaveChanges();
return(RedirectToAction("Index", "User"));
}
} catch
{
return(View());
}
}
public ActionResult Visit(int id)
{
using (DentistDBEntities3 objDentistDBEntities = new DentistDBEntities3())
{
var employee = objDentistDBEntities.Users.Where(x => x.Id == id).FirstOrDefault();
var user = objDentistDBEntities.Users.Where(a => a.Email == User.Identity.Name).FirstOrDefault();
ViewBag.EmployeeId = employee.Id;
ViewBag.EmployeeFirstName = employee.FirstName;
ViewBag.EmployeeLastName = employee.LastName;
ViewBag.UserId = user.Id;
return(View());
}
}