public List <EmpMasterModel> GetLastThreeStarOftheMonthEmpDetails()
{
string currentYear = DateTime.Now.ToString("yyyy");
List <EmpMasterModel> lstEmpModel = new List <EmpMasterModel>();
using (objSOMEntities = new SOMEntities())
using (objIPEntities = new IntranetPortalEntities())
{
var somData = objSOMEntities.StarOfTheMonths.Where(r => r.Year == currentYear).OrderByDescending(r => r.TransID).ToList();
foreach (var item in somData)
{
var emp = objIPEntities.EmpMasters.Where(r => r.EmployeeNumber == item.EmpId.ToString()).FirstOrDefault();
if (emp != null)
{
EmpMasterModel model = new EmpMasterModel();
model.EmpID = emp.EmpID;
model.EmployeeName = emp.EmployeeName;
model.EmployeeNumber = emp.EmployeeNumber;
model.ImagePath = emp.ImagePath;
model.EMPMonth = item.Month;
model.EMPYear = item.Year;
lstEmpModel.Add(model);
}
}
}
return(lstEmpModel);
}
public RepositoryResponse GetUserDetailsByUserID(string userID)
{
RepositoryResponse baseModel = new RepositoryResponse();
using (objSOMEntities = new SOMEntities())
using (objIPEntities = new IntranetPortalEntities())
{
var userDet = objIPEntities.EmpMasters.Where(r => r.EmployeeNumber == userID && r.IsActive == true).FirstOrDefault();
if (userDet != null)
{
EmpMasterModel model = new EmpMasterModel();
model.UserName = userDet.UserName;
model.UserRole = userDet.UserRole;
model.EmployeeNumber = userDet.EmployeeNumber;
model.Department = userDet.Department;
model.Grade = userDet.Grade;
model.EmployeeName = userDet.EmployeeName;
//model.EmployeeSOMRole = GetEmployeeRole(userID, userDet.Grade);
int value = GetSOMEmployeeRoleByUser(userDet);
model.EmployeeSOMRole = value;
model.EmployeeSOMRoleAsString = EnumHelper.GetDescription((SOMEmpRole)value);
baseModel = new RepositoryResponse {
success = true, message = "user Details retrieved Successfully", Data = model
};
}
else
{
baseModel = new RepositoryResponse {
success = false, message = "user Details not available"
};
}
}
return(baseModel);
}
public RepositoryResponse GetLoginUserDetails(string userName)
{
RepositoryResponse baseModel = new RepositoryResponse();
using (objSOMEntities = new SOMEntities())
using (objIPEntities = new IntranetPortalEntities())
{
var userDet = objIPEntities.EmpMasters.Where(r => r.UserName == userName && r.IsActive == true).FirstOrDefault();
if (userDet != null)
{
EmpMasterModel model = new EmpMasterModel();
model.UserName = userDet.UserName;
model.EmployeeName = userDet.EmployeeName;
model.UserRole = userDet.UserRole;
model.EmployeeNumber = userDet.EmployeeNumber;
model.Department = userDet.Department;
model.Grade = userDet.Grade;
baseModel = new RepositoryResponse {
success = true, message = "user Details retrieved Successfully", Data = model
};
}
else
{
baseModel = new RepositoryResponse {
success = false, message = "user Details not available"
};
}
}
return(baseModel);
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (HttpContext.Current.Session["UserName"] == null)
{
var loggedInuser = "";
var prinicpal = (System.Security.Claims.ClaimsPrincipal)System.Threading.Thread.CurrentPrincipal;
if (prinicpal != null && prinicpal.Claims != null)
{
if (prinicpal.Claims.Where(c => c.Type == System.Security.Claims.ClaimTypes.Name).Any())
{
loggedInuser = prinicpal.Claims.Where(c => c.Type == System.Security.Claims.ClaimTypes.Name).Select(c => c.Value).FirstOrDefault();
}
}
HttpContext.Current.Session.Add("loggedInuser", loggedInuser);
loggedInuser = loggedInuser.Replace("\\", "|");
if (loggedInuser.Contains("|"))
{
loggedInuser = loggedInuser.Split('|')[1];
}
loggedInuser = "******"; //Nomination User -- DH --RThangaraj
//loggedInuser = "******"; //Nomination User DH -- RThangaraj
//loggedInuser = "******";//Nomination User
//loggedInuser = "******"; //DH user
//loggedInuser = "******"; //DH user
//loggedInuser = "******"; // Evaluation user
//loggedInuser = "******"; // Evaluation user
//loggedInuser = "******"; //TQC Head
//loggedInuser = "******"; //Admin
//loggedInuser = "******";
//loggedInuser = "******";
ILoginRepo loginRepo = new LoginRepo();
RepositoryResponse model = loginRepo.GetLoginUserDetails(loggedInuser);
if (model.success)
{
EmpMasterModel _orGModel = model.Data;
if (_orGModel != null)
{
//RepositoryResponse _model = loginRepo.GetPageAccessListByUserGrade(_orGModel.Grade, loggedInuser);
//if (_model != null)
//{
// HttpContext.Current.Session.Add("pageAccessList", _model.Data);
// //claims.Add(new Claim(ClaimTypes.Actor, _model.Data));
//}
}
if (string.IsNullOrEmpty(_orGModel.ImagePath))
{
HttpContext.Current.Session.Add("UserImage", "/Images/UserImages/user-1.jpg");
}
else
{
HttpContext.Current.Session.Add("UserImage", _orGModel.ImagePath);
}
//HttpContext.Current.Session.Add("UserImage", _orGModel.ImagePath);
//HttpContext.Current.Session.Add("UserImage", "/Images/UserImages/user-1.jpg");
HttpContext.Current.Session.Add("UserName", _orGModel.UserName);
HttpContext.Current.Session.Add("UserFullName", _orGModel.EmployeeName);
HttpContext.Current.Session.Add("UserID", _orGModel.EmployeeNumber);
HttpContext.Current.Session.Add("UserDepartment", _orGModel.Department);
HttpContext.Current.Session.Add("UserGrade", _orGModel.Grade.ToString());
//claims.Add(new Claim(ClaimTypes.GivenName, _orGModel.UserName));
//claims.Add(new Claim(ClaimTypes.SerialNumber, _orGModel.EmployeeNumber));
//claims.Add(new Claim(ClaimTypes.Role, _orGModel.Department));
//claims.Add(new Claim(ClaimTypes.Surname, _orGModel.Grade));
//if (_orGModel.Grade == "A1")
//{
// HttpContext.Current.Session.Add("UserGrade", _orGModel.Grade.ToString());
// HttpContext.Current.Session.Add("UserRole", "Nomination");
//}
//else if (_orGModel.Grade == "DH")
//{
// HttpContext.Current.Session.Add("UserGrade", _orGModel.Grade.ToString());
// HttpContext.Current.Session.Add("UserRole", "DepartmentHead");
//}
//else if (_orGModel.Grade == "C1")
//{
// HttpContext.Current.Session.Add("UserGrade", _orGModel.Grade.ToString());
// HttpContext.Current.Session.Add("UserRole", "Evaluation");
//}
int empRole = 0;
RepositoryResponse _model1 = loginRepo.GetUserDetailsByUserID(_orGModel.EmployeeNumber);
if (_model1 != null && _model1.Data != null)
{
EmpMasterModel data = _model1.Data;
empRole = data.EmployeeSOMRole;
HttpContext.Current.Session.Add("EmpSOMRole", empRole.ToString());
HttpContext.Current.Session.Add("EmpSOMRoleText", data.EmployeeSOMRoleAsString);
string menuNames = loginRepo.getMenuForUser(_orGModel.EmployeeNumber, empRole);
HttpContext.Current.Session.Add("pageAccessList", menuNames);
//claims.Add(new Claim(ClaimTypes.StreetAddress, empRole.ToString()));
}
//Get Notification count
int count = loginRepo.getActionCounts(_orGModel.EmployeeNumber, empRole);
HttpContext.Current.Session.Add("NotifyCount", count);
//claims.Add(new Claim(ClaimTypes.HomePhone, count.ToString()));
//if (empRole == (int)EmployeeRole.Nomination)
//{
// filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { action = "Index", controller = "Nomination" }));
//}
//else
//{
// filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { action = "Index", controller = "Dashboard" }));
//}
//Get Star of the month details
IStarOfMonthRepo starOfTheMonth = new StarOfMonthRepo();
List <EmpMasterModel> _data = starOfTheMonth.GetLastThreeStarOftheMonthEmpDetails();
if (_data == null)
{
HttpContext.Current.Session.Add("SOM_Month_Count", "0");
}
else
{
HttpContext.Current.Session.Add("SOM_Month_Count", _data.Count);
}
for (int i = 0; i < _data.Count; i++)
{
HttpContext.Current.Session.Add("SOM_Month_" + i, _data[i].EMPMonth);
HttpContext.Current.Session.Add("SOM_Image_" + i, _data[i].ImagePath);
}
}
else
{
filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { action = "Index", controller = "NoAccess" }));
}
}
base.OnActionExecuting(filterContext);
}
public ActionResult Access(string returnUrl = "")
{
if (Request.IsAuthenticated)
{
var loggedInuser = "";
var prinicpal = (System.Security.Claims.ClaimsPrincipal)System.Threading.Thread.CurrentPrincipal;
if (prinicpal != null && prinicpal.Claims != null)
{
if (prinicpal.Claims.Where(c => c.Type == System.Security.Claims.ClaimTypes.Name).Any())
{
loggedInuser = prinicpal.Claims.Where(c => c.Type == System.Security.Claims.ClaimTypes.Name).Select(c => c.Value).FirstOrDefault();
}
}
Session["User"] = loggedInuser;
loggedInuser = loggedInuser.Replace("\\", "|");
if (loggedInuser.Contains("|"))
{
loggedInuser = loggedInuser.Split('|')[1];
}
loggedInuser = "******"; //Nomination User -- DH --RThangaraj
//loggedInuser = "******"; //Nomination User DH -- RThangaraj
//loggedInuser = "******";//Nomination User
//loggedInuser = "******"; //DH user
//loggedInuser = "******"; //DH user
//loggedInuser = "******"; // Evaluation user
//loggedInuser = "******"; // Evaluation user
//loggedInuser = "******"; //TQC Head
//loggedInuser = "******"; //Admin
//loggedInuser = "******";//Nomination User
//loggedInuser = "******";//DH
//loggedInuser = "******";
// loggedInuser = "******";
ILoginRepo loginRepo = new LoginRepo();
RepositoryResponse model = loginRepo.GetLoginUserDetails(loggedInuser);
if (model.success)
{
EmpMasterModel _orGModel = model.Data;
if (_orGModel != null)
{
//RepositoryResponse _model = loginRepo.GetPageAccessListByUserGrade(_orGModel.Grade, loggedInuser);
//if (_model != null)
//{
// Session.Add("pageAccessList", _model.Data);
//}
if (string.IsNullOrEmpty(_orGModel.ImagePath))
{
Session.Add("UserImage", "/Images/UserImages/user-1.jpg");
}
else
{
Session.Add("UserImage", _orGModel.ImagePath);
}
//Session.Add("UserImage", "/Images/UserImages/user-1.jpg");
Session.Add("UserName", _orGModel.UserName);
Session.Add("UserFullName", _orGModel.EmployeeName);
Session.Add("UserID", _orGModel.EmployeeNumber);
Session.Add("UserDepartment", _orGModel.Department);
Session.Add("UserGrade", _orGModel.Grade.ToString());
}
int empRole = 0;
RepositoryResponse _model1 = loginRepo.GetUserDetailsByUserID(_orGModel.EmployeeNumber);
if (_model1 != null && _model1.Data != null)
{
EmpMasterModel data = _model1.Data;
empRole = data.EmployeeSOMRole;
Session.Add("EmpSOMRole", empRole.ToString());
Session.Add("EmpSOMRoleText", data.EmployeeSOMRoleAsString);
string menuNames = loginRepo.getMenuForUser(_orGModel.EmployeeNumber, empRole);
Session.Add("pageAccessList", menuNames);
}
//Get Notification count
int count = loginRepo.getActionCounts(_orGModel.EmployeeNumber, empRole);
Session.Add("NotifyCount", count);
//Get Star of the month details
IStarOfMonthRepo starOfTheMonth = new StarOfMonthRepo();
List <EmpMasterModel> _data = starOfTheMonth.GetLastThreeStarOftheMonthEmpDetails();
if (_data == null)
{
Session.Add("SOM_Month_Count", "0");
}
else
{
Session.Add("SOM_Month_Count", _data.Count);
}
for (int i = 0; i < _data.Count; i++)
{
Session.Add("SOM_Month_" + i, _data[i].EMPMonth);
Session.Add("SOM_Image_" + i, _data[i].ImagePath);
}
if (empRole == (int)SOMEmpRole.Nomination)
{
return(RedirectToAction("Index", "Nomination"));
}
else
{
return(RedirectToAction("Index", "Dashboard"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
return(RedirectToAction("Index", "Home"));
}
