public ActionResult AddHr(vUser vUser, HttpPostedFileBase img1) { if (ModelState.IsValid) { byte[] encPassword = EncPassword(vUser.Password); using (var context = new AttendanceManagment()) { var user = new User() { UserName = vUser.UserName, Email = vUser.Email, Password = encPassword, UserTypeId = 2 }; context.Users.Add(user); context.SaveChanges(); var userDetail = new UserDetail() { UserId = user.UserId, Address = vUser.Address }; userDetail.ProfilePhoto = new byte[img1.ContentLength]; img1.InputStream.Read(userDetail.ProfilePhoto, 0, img1.ContentLength); context.UserDetails.Add(userDetail); context.SaveChanges(); } } return(View()); }
public ActionResult AddTodayAttendance(string mDate, string mFromTime, string mToTime) { DateTime date = Convert.ToDateTime(mDate); TimeSpan fromTime = TimeSpan.Parse(mFromTime); TimeSpan toTime = TimeSpan.Parse(mToTime); using (var context = new AttendanceManagment()) { var holidayAvail = context.vHolidayDetails.Where(t => t.date == date).FirstOrDefault <vHolidayDetail>(); if (holidayAvail != null) { return(RedirectToAction("Home", "Home", new { Area = "HR" })); } else { var attendance = new Attendance() { UserId = (int)Session["UserId"], Date = date, FromTime = fromTime, ToTime = toTime }; context.Attendances.Add(attendance); context.SaveChanges(); return(RedirectToAction("Home", "Home", new { Area = "HR" })); } } }
public ActionResult UpdateProfile(string uAddress, string uPassword, string uEmail) { int UserId = (int)Session["UserId"]; byte[] encPassword = EncPassword(uPassword); using (var context = new AttendanceManagment()) { try { var isUserAvail = context.Users.Where(t => t.UserId == UserId).FirstOrDefault <AttendanceMgmt.Models.User>(); if (isUserAvail != null) { isUserAvail.Email = uEmail; isUserAvail.Password = encPassword; } var userDetail = context.UserDetails.Where(t => t.UserId == UserId).FirstOrDefault <UserDetail>(); userDetail.Address = uAddress; context.SaveChanges(); } catch (Exception e) { } } return(RedirectToAction("Home", "Home", new { Area = "HR" })); }
public ActionResult UpdateUser(int uUserId, string uUserName, string uEmail, string uUserType) { int userTypeId; if (uUserType == "Admin") { userTypeId = 1; } else if (uUserType == "HR") { userTypeId = 2; } else { userTypeId = 3; } using (var context = new AttendanceManagment()) { try { var isUserAvail = context.Users.Where(t => t.UserId == uUserId).FirstOrDefault <AttendanceMgmt.Models.User>(); if (isUserAvail != null) { isUserAvail.UserName = uUserName; isUserAvail.Email = uEmail; isUserAvail.UserTypeId = userTypeId; } context.SaveChanges(); } catch (Exception e) { } } return(RedirectToAction("Home", "Home", new { Area = "Admin" })); }
public ActionResult DeleteLeave(int LeaveId) { int UserId = (int)Session["EmpIdForLeave"]; using (var context = new AttendanceManagment()) { context.Leaves.Remove(context.Leaves.Single(a => a.LeaveId == LeaveId)); context.SaveChanges(); } return(RedirectToAction("EmployeeLeaves", "Employee", new { Area = "HR", EmpId = UserId })); }
public ActionResult Delete(int AttendanceId) { int UserId = (int)Session["UserIdForAttendance"]; using (var context = new AttendanceManagment()) { context.Attendances.Remove(context.Attendances.Single(a => a.AttendanceId == AttendanceId)); context.SaveChanges(); } return(RedirectToAction("UserAttendance", "UserAttendance", new { Area = "Admin", UserId = UserId })); }
public ActionResult Delete(int UserId) { using (var context = new AttendanceManagment()) { context.UserDetails.Remove(context.UserDetails.Single(a => a.UserId == UserId)); context.Users.Remove(context.Users.Single(a => a.UserId == UserId)); context.SaveChanges(); } return(RedirectToAction("Home", "Home", new { Area = "Admin" })); }
public ActionResult RejectLeave(int LeaveId, int EmpId) { using (var context = new AttendanceManagment()) { var approve = context.Leaves.Where(t => t.LeaveId == LeaveId).FirstOrDefault <Leaf>(); if (approve != null) { approve.IsApproved = false; approve.ApprovedBy = (string)Session["UserName"]; } context.SaveChanges(); return(RedirectToAction("EmployeeLeaves", "Employee", new { Area = "HR", EmpId = EmpId })); } }
public ActionResult ApproveAttendance(int AttendanceId, int EmpId) { using (var context = new AttendanceManagment()) { var approve = context.Attendances.Where(t => t.AttendanceId == AttendanceId).FirstOrDefault <Attendance>(); if (approve != null) { approve.IsApproved = true; approve.ApprovedById = (int)Session["UserId"]; approve.ApprovedByName = (string)Session["UserName"]; } context.SaveChanges(); return(RedirectToAction("EmployeeAttendance", "Employee", new { Area = "HR", EmpId = EmpId })); } }
public ActionResult AddHoliday(string uName, string uDate, string uDesc) { DateTime date = Convert.ToDateTime(uDate); using (var context = new AttendanceManagment()) { var holiday = new Holiday() { HolidayName = uName, date = date, Description = uDesc }; context.Holidays.Add(holiday); context.SaveChanges(); } return(RedirectToAction("Home", "Home", new { Area = "Admin" })); }
public ActionResult UpdateEmployee(int uUserId, string uUserName, string uEmail, string uPassword) { using (var context = new AttendanceManagment()) { byte[] encPassword = EncPassword(uPassword); var isUserAvail = context.Users.Where(t => t.UserId == uUserId).FirstOrDefault <AttendanceMgmt.Models.User>(); if (isUserAvail != null) { isUserAvail.UserName = uUserName; isUserAvail.Email = uEmail; isUserAvail.Password = encPassword; } context.SaveChanges(); } return(RedirectToAction("Employee", "Employee", new { Area = "HR" })); }
public ActionResult AddLeave(string mReason, string mFromDate, string mToDate) { DateTime Fromdate = Convert.ToDateTime(mFromDate); DateTime Todate = Convert.ToDateTime(mToDate); int UserId = (int)Session["UserId"]; using (var context = new AttendanceManagment()) { var leave = new Leaf() { UserId = UserId, FromDate = Fromdate, ToDate = Todate, Reason = mReason }; context.Leaves.Add(leave); context.SaveChanges(); } return(RedirectToAction("Home", "Home", new { Area = "HR" })); }