public ActionResult Login(Employee emp)
{
EntityFrameworkEntities context = new EntityFrameworkEntities();
Employee e = context.Employees.Where(x => x.Email == emp.Email && x.Password == emp.Password).FirstOrDefault();
if (e == null)
{
ViewBag.Error = "Wrong Passsword";
return(View());
}
else
{
Session["IsLogin"] = true;
Session["Email"] = e.Email;
Session["IsAdmin"] = e.IsAdmin;
if ((bool)Session["IsAdmin"])
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Myprofile"));
}
}
}
/// <summary>
/// Añado los detalles de un usuario por ID
/// </summary>
/// <param name="userID"></param>
/// <param name="userName"></param>
/// <param name="userLastName"></param>
/// <param name="userBitrh"></param>
/// <param name="userEmail"></param>
/// <returns></returns>
public bool AddUserDetails(int userID, string userName, string userLastName, string userBitrh, string userEmail)
{
bool status = false;
users user = GetUserById(userID);
if(user != null)
{
user_details userDetails = new user_details
{
user_id = userID,
name = userName,
last_name = userLastName,
date_of_birth = DateTime.Parse(userBitrh),
email = userEmail
};
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
context.user_details.Add(userDetails);
status = SaveChanges(context);
}
}
return status;
}
public ActionResult Myprofile()
{
string e = Convert.ToString(Session["Email"]);
EntityFrameworkEntities context = new EntityFrameworkEntities();
Employee emp = context.Employees.Where(x => x.Email == e).FirstOrDefault();
return(View(emp));
}
public ActionResult Create(Employee emp)
{
EntityFrameworkEntities context = new EntityFrameworkEntities();
context.Employees.Add(emp);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public void deleteStudent(int studentID)
{
using (var db = new EntityFrameworkEntities())
{
var delete = (from d in db.Students where d.StudentID == studentID select d).Single();
db.Students.Remove(delete);
db.SaveChanges();
}
}
public ActionResult Aproveacept(int id)
{
EntityFrameworkEntities context = new EntityFrameworkEntities();
Leave l = context.Leaves.Find(id);
l.Aproved = "1";
context.SaveChanges();
return(RedirectToAction("Aproved"));
}
public void updateStudent(Student student)
{
using (var db = new EntityFrameworkEntities())
{
var update = (from u in db.Students where u.StudentID == student.StudentID select u).Single();
update.StudentGender = student.StudentGender;
update.StudentName = student.StudentName;
update.PhoneNumber = student.PhoneNumber;
update.Email = student.Email;
db.SaveChanges();
}
}
public ActionResult Edit(Employee emp)
{
EntityFrameworkEntities context = new EntityFrameworkEntities();
Employee e = context.Employees.Find(emp.Id);
e.Name = emp.Name;
e.Salary = emp.Salary;
e.Email = emp.Email;
e.Password = emp.Password;
e.IsAdmin = emp.IsAdmin;
context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
bool IsLogin = Convert.ToBoolean(Session["IsLogin"]);
if (IsLogin)
{
EntityFrameworkEntities context = new EntityFrameworkEntities();
Employee emp = context.Employees.Find(id);
return(View(emp));
}
else
{
return(RedirectToAction("Login"));
}
}
public List <Student> getAllStudent()
{
List <Student> students = new List <Student>();
//Console.OutputEncoding = Encoding.UTF8;
using (var db = new EntityFrameworkEntities())
{
var select = from s in db.Students select s;
foreach (var data in select)
{
students.Add(data);
}
}
return(students);
}
public ActionResult Apply(Leave l)
{
string e = Convert.ToString(Session["Email"]);
EntityFrameworkEntities context = new EntityFrameworkEntities();
Employee emp = context.Employees.Where(x => x.Email == e).FirstOrDefault();
l.EmployeeId = emp.Id;
l.CreateOn = DateTime.Now;
l.CreatedBy = emp.Id;
l.ModifiedOn = DateTime.Now;
context.Leaves.Add(l);
context.SaveChanges();
return(View());
}
public ActionResult Delete(int id)
{
bool IsLogin = Convert.ToBoolean(Session["IsLogin"]);
if (IsLogin)
{
EntityFrameworkEntities context = new EntityFrameworkEntities();
Employee emp = context.Employees.Find(id);
context.Employees.Remove(emp);
context.SaveChanges();
return(Json("You have successfully deleted One record", JsonRequestBehavior.AllowGet));
}
else
{
return(RedirectToAction("Login"));
}
}
public void addStudent(Student student)
{
// Thông tin của sinh viên được thêm mới
/*var student = new Student();
* student.StudentID = 3;
* student.StudentName = "Lê Thị Hồng";
* student.StudentGender = "Nam";
* student.Address = "Bình Dương";
* student.Email = "*****@*****.**";
* student.PhoneNumber = "113";*/
// Thêm vào database
using (var db = new EntityFrameworkEntities())
{
db.Students.Add(student);
db.SaveChanges();
}
}
public ActionResult PostIn()
{
Attendance a = new Attendance();
string e = Convert.ToString(Session["Email"]);
EntityFrameworkEntities context = new EntityFrameworkEntities();
Employee emp = context.Employees.Where(x => x.Email == e).FirstOrDefault();
a.Date = DateTime.Now;
a.EmplyeeId = emp.Id;
a.PunchIn = DateTime.Now;
context.Attendances.Add(a);
context.SaveChanges();
// ViewBag.PunchInMessage = "You have punch in successfully"
return(Json("You have punch in successfully"));
}
/// <summary>
/// Añado un usuario en la base de datos
/// </summary>
/// <param name="name"></param>
/// <param name="password"></param>
/// <returns>True = Se ha insertado el usuario, de lo contrario False</returns>
public bool AddUser(string name, string password)
{
bool status = false;
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
users user = new users
{
user = name,
password = password
};
context.users.Add(user);
status = SaveChanges(context);
}
return status;
}
public bool UpdateUserDetails(int userID, string userName, string userLastName, string userBitrh, string userEmail)
{
bool status = false;
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
user_details userDetails = context.user_details.SingleOrDefault(x => x.user_id == userID);
if (userDetails !=null)
{
userDetails.name = userName;
userDetails.last_name = userLastName;
userDetails.date_of_birth = DateTime.Parse(userBitrh);
userDetails.email = userEmail;
status = SaveChanges(context);
}
}
return status;
}
public ActionResult Aproved()
{
bool IsLogin = Convert.ToBoolean(Session["IsLogin"]);
bool IsAdmin = Convert.ToBoolean(Session["IsAdmin"]);
if (IsLogin)
{
if (IsAdmin)
{
EntityFrameworkEntities context = new EntityFrameworkEntities();
List <Leave> l = context.Leaves.ToList();
return(View(l));
}
else
{
return(View());
}
}
else
{
return(RedirectToAction("Login"));
}
}
public ActionResult Index()
{
bool IsLogin = Convert.ToBoolean(Session["IsLogin"]);
bool IsAdmin = Convert.ToBoolean(Session["IsAdmin"]);
if (IsLogin)
{
if (IsAdmin)
{
EntityFrameworkEntities context = new EntityFrameworkEntities();
List <Employee> emp = context.Employees.ToList();
return(View(emp));
}
else
{
return(RedirectToAction("Myprofile"));
}
}
else
{
return(RedirectToAction("Login"));
}
}
public ActionResult PostOut()
{
Attendance a = new Attendance();
string e = Convert.ToString(Session["Email"]);
EntityFrameworkEntities context = new EntityFrameworkEntities();
Employee emp = context.Employees.Where(x => x.Email == e).FirstOrDefault();
List <Attendance> dbs = context.Attendances.Where(x => x.EmplyeeId == emp.Id).OrderBy(x => x.Date).ToList();
Attendance db = dbs.Where(x => x.Date.ToString("MM/dd/yyyy") == DateTime.Now.ToString("MM/dd/yyyy")).LastOrDefault();
if (db != null)
{
db.PunchOut = DateTime.Now;
context.SaveChanges();
// ViewBag.PunchInMessage = "You have punch out successfully";
return(Json("You have punch out successfully"));
}
else
{
// ViewBag.PunchInMessage = "No record for today punch in";
return(Json("No record for taday punch in"));
}
}
/// <summary>
/// Guarda los cambios en la base de datos
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private bool SaveChanges(EntityFrameworkEntities context)
{
try
{
context.SaveChanges();
return true;
}
catch (DbEntityValidationException ex)
{
MessageBox.Show("Error de validación en la base de datos.\n\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (DbUpdateException ex)
{
MessageBox.Show("Error actualizando la base de datos.\n\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return false;
}
/// <summary>
/// Obtengo todos los usuarios que contengan "userName" en el campo "Users"
/// </summary>
/// <returns></returns>
public IEnumerable<users> GetUsersByUserName(string userName)
{
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
return context.users.Where(x=> x.user.Contains(userName)).ToList();
}
}
/// <summary>
/// Devuelve un listado de todos los usuarios qye hay en la tabla
/// </summary>
/// <returns></returns>
public IEnumerable<users> GetUsers()
{
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
return context.users.ToList();
}
}
/// <summary>
/// Devuelve un objeto de tipo UserDetails con los datos del usuario encontrado con el ID pasado
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public UserDetails GetUserAndDetailsById(int ID)
{
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
//JOIN: El usuario tiene que existir y tener datos en la tabla dedetalles, si no devuelve null.
//var query = (from user in context.users
// join user_detail in context.user_details on user.id equals user_detail.user_id
// where user.id == ID
// select new UserDetails
// {
// UserName = user.user,
// Password = user.password,
// Name = user_detail.name,
// LastName = user_detail.last_name,
// DateOfBirth = user_detail.date_of_birth,
// Email = user_detail.email
// }).FirstOrDefault();
//LEFT JOIN: Si el usuario existe y no tiene detalles, devolvera los datos de usuario.
var query = (from user in context.users
join user_detail in context.user_details on user.id equals user_detail.user_id into temp
from table in temp.DefaultIfEmpty()
where user.id == ID
select new UserDetails
{
UserName = user.user,
Password = user.password,
Name = table.name,
LastName = table.last_name,
DateOfBirth = table.date_of_birth,
Email = table.email
}).FirstOrDefault();
return (UserDetails)query;
}
}
/// <summary>
/// Busco un usuario por su ID
/// </summary>
/// <returns>Objeto del usuario</returns>
public users GetUserById(int ID)
{
users user = null;
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
user = context.users.Where(x => x.id == ID).FirstOrDefault();
}
return user;
}
/// <summary>
/// Obtengo el primer usuario de la base de datos
/// </summary>
/// <returns>Objeto del usuario</returns>
public users GetFirstUser()
{
users user = null;
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
user = context.users.FirstOrDefault();
}
return user;
}
/// <summary>
/// Borro un usuario por ID
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public bool DeleteUserById(int userID)
{
bool status = false;
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
users user = context.users.Where(x => x.id == userID).FirstOrDefault();
if (user != null)
{
context.users.Remove(user);
status = SaveChanges(context);
}
}
return status;
}
