public SetUp GetSetUp()
{
using (MPRContext2 entityContext = new MPRContext2())
{
SetUp query = (from a in entityContext.SetUpSet
select a).FirstOrDefault();
return(query);
}
}
public OnBoardingUsers GetOnBoardingUsers()
{
using (MPRContext2 entityContext = new MPRContext2())
{
OnBoardingUsers query = (from a in entityContext.OnBoardingUsersSet
select a).FirstOrDefault();
return(query);
}
}
//////public bool userSetUpValidation(string username)
//////{
////// using (MPRContext3 mx3 = new MPRContext3())
////// {
////// //var user = db.Applicants.Where(a => a.UserEmailAddress.Equals(username) && a.password.Equals(password)).SingleOrDefault();
////// var user = mx3.CorUserSetUpSet.Where(a => a.LoginID.Equals(username)).FirstOrDefault();
////// if (user != null)
////// {
////// System.Web.HttpContext.Current.Session["userfullname"] = user.Name;
////// System.Web.HttpContext.Current.Session["userstaffid"] = user.StaffID;
////// System.Web.HttpContext.Current.Session["photourlpath"] = user.PhotoUrl;
////// return true;
////// }
////// }
////// return false;
//////}
public bool userMISValidation(string username)
{
using (MPRContext2 mx2 = new MPRContext2())
{
string clientcode = Convert.ToString(ConfigurationManager.AppSettings["ClientCode"]).Trim().ToUpper();
////var user = db.Applicants.Where(a => a.UserEmailAddress.Equals(username) && a.password.Equals(password)).SingleOrDefault();
////var user = mx2.UserMISSet.Where(a => a.LoginID.Equals(username)).FirstOrDefault();
//var userMISObj = mx2.UserMISSet.Where(x => x.LoginID.Trim().ToUpper() == username.ToUpper()).FirstOrDefault();
UserMIS userMISObj = null;
if (clientcode == "ABP")
{
using (MPRContextSecondFintrakDB dbObj = new MPRContextSecondFintrakDB())
{
userMISObj = dbObj.UserMISSet.Where(x => x.LoginID.Trim().ToUpper() == username.ToUpper()).FirstOrDefault();
}
}
else
{
userMISObj = mx2.UserMISSet.Where(x => x.LoginID.Trim().ToUpper() == username.ToUpper()).FirstOrDefault();
}
appLog.InfoFormat("{0}{1}", "userMISObj gotten from the 'userMISValidation(string username) method' using loginId: ", username);
if (userMISObj != null)
{
System.Web.HttpContext.Current.Session["ProfitCenterDefinitionCode"] = userMISObj.ProfitCenterDefinitionCode;
System.Web.HttpContext.Current.Session["ProfitCenterMisCode"] = userMISObj.ProfitCenterMisCode;
System.Web.HttpContext.Current.Session["UserMisId"] = userMISObj.UserMisId;
return(true);
}
}
return(false);
}
