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; }