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