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