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 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 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 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 JsonResult GetAllUsers() { AttendanceManagment attendanceManagment = new AttendanceManagment(); var userList = new { data = attendanceManagment.vUserDetails.ToList() }; return(Json(userList, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllEmployee() { using (var context = new AttendanceManagment()) { var emp = new { data = context.vUserDetails.Where(t => t.UserTypeName == "Employee").ToList <vUserDetail>() }; return(Json(emp, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetUserDetail(int UserId) { AttendanceManagment attendanceManagment = new AttendanceManagment(); var userDetail = attendanceManagment.vUserFullDetails.Where(t => t.UserId == UserId).ToList(); var jsonResult = Json(userDetail, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = Int32.MaxValue; return(jsonResult); }
public ActionResult SignIn(vUser user) { if (user.UserName != null && user.Password != null) { string input = user.Password; string key = "sblw-3hn8-sqoy19"; byte[] EncStr = UTF8Encoding.UTF8.GetBytes(input); TripleDESCryptoServiceProvider tripleDES = new TripleDESCryptoServiceProvider(); tripleDES.Key = UTF8Encoding.UTF8.GetBytes(key); tripleDES.Mode = CipherMode.ECB; tripleDES.Padding = PaddingMode.PKCS7; ICryptoTransform cryptoTransform = tripleDES.CreateEncryptor(); byte[] result = cryptoTransform.TransformFinalBlock(EncStr, 0, EncStr.Length); using (var context = new AttendanceManagment()) { var isUserValid = context.Users.Where(t => t.UserName == user.UserName && t.Password == result).FirstOrDefault <User>(); if (isUserValid != null) { var userDetial = context.UserDetails.Where(t => t.UserId == isUserValid.UserId).FirstOrDefault <UserDetail>(); Session["UserId"] = isUserValid.UserId; //Session["UserName"] = isUserValid.UserName; //Session["ProfilePhoto"] = userDetial.ProfilePhoto; if (isUserValid.UserTypeId == 1) { FormsAuthentication.SetAuthCookie(isUserValid.UserName, false); return(RedirectToAction("Home", "Home", new { area = "Admin" })); } else if (isUserValid.UserTypeId == 2) { FormsAuthentication.SetAuthCookie(isUserValid.UserName, false); return(RedirectToAction("Home", "Home", new { area = "HR" })); } else if (isUserValid.UserTypeId == 3) { FormsAuthentication.SetAuthCookie(isUserValid.UserName, false); return(RedirectToAction("Home", "Home", new { area = "Employee" })); } else { return(View()); } } else { return(View()); } // return Content("<b>" + isUserValid.UserName); } } else { return(View()); } }
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 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 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 JsonResult GetUserDetail() { int UserId = (int)Session["UserId"]; AttendanceManagment attendanceManagment = new AttendanceManagment(); var userDetail = attendanceManagment.vUserFullDetails.Where(t => t.UserId == UserId).FirstOrDefault <vUserFullDetail>(); List <ViewModels.vUserFullDetails> list = new List <ViewModels.vUserFullDetails>(); list.Add(new ViewModels.vUserFullDetails() { ProfilePhoto = Convert.ToBase64String(userDetail.ProfilePhoto), UserName = userDetail.UserName, Email = userDetail.Email, Address = userDetail.Address }); var jsonResult = Json(list, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = Int32.MaxValue; return(jsonResult); }
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" })); }