protected void Page_Load(object sender, EventArgs e)
{
if (Session["CompanyDBID"] == null)
{
FileType.Items.FindByValue("D").Enabled = false;
FileType.Items.FindByValue("E").Enabled = true;
FileTypeRow.Visible = false;
}
else
{
if (Application["MasterDBConfig"] != null && Session["CompanyDBID"] != null)
{
int CurID = (int)Session["CompanyDBID"];
HROne.DataAccess.DatabaseConnection masterDBConn = ((DatabaseConfig)Application["MasterDBConfig"]).CreateDatabaseConnectionObject();
string CommandLineFolder = HROne.SaaS.Entities.ESystemParameter.getParameter(masterDBConn, HROne.SaaS.Entities.ESystemParameter.PARAM_CODE_HSBC_MRI_DIRECTORY);
if (string.IsNullOrEmpty(CommandLineFolder))
{
FileType.Items.FindByValue("D").Enabled = false;
}
HROne.HSBC.Utility.HSBCMRICommandLineDirectory = CommandLineFolder;
}
}
//HROne.ProductLicense productLicense = WebUtils.productLicense(Session);
//if (productLicense.ProductType != HROne.ProductLicense.ProductLicenseType.HROneSaaS)
//{
//}
}
protected void FileType_SelectedIndexChanged(object sender, EventArgs e)
{
if (FileType.SelectedValue.Equals("D"))
{
RemoteProfileID.Visible = true;
PaymentMethodRow.Visible = false;
if (Application["MasterDBConfig"] != null && Session["CompanyDBID"] != null)
{
int CurID = (int)Session["CompanyDBID"];
HROne.DataAccess.DatabaseConnection masterDBConn = ((DatabaseConfig)Application["MasterDBConfig"]).CreateDatabaseConnectionObject();
DBFilter filter = new DBFilter();
filter.add(new Match("CompanyDBID", (int)Session["CompanyDBID"]));
filter.add(new Match("HSBCExchangeProfileIsLocked", false));
ArrayList exchangeProfileList = HROne.SaaS.Entities.EHSBCExchangeProfile.db.select(masterDBConn, filter);
if (exchangeProfileList.Count > 0)
{
foreach (HROne.SaaS.Entities.EHSBCExchangeProfile exchangeProfile in exchangeProfileList)
{
if (exchangeProfile.HSBCExchangeProfileBankCode.Equals(BankCode, StringComparison.CurrentCultureIgnoreCase))
{
txtRemoteProfileID.Text = exchangeProfile.HSBCExchangeProfileRemoteProfileID;
RemoteProfileID.Visible = false;
}
}
if (RemoteProfileID.Visible)
{
txtRemoteProfileID.Text = ((HROne.SaaS.Entities.EHSBCExchangeProfile)exchangeProfileList[0]).HSBCExchangeProfileRemoteProfileID;
RemoteProfileID.Visible = false;
}
}
HROne.HSBC.Utility.HSBCMRICommandLineDirectory = HROne.SaaS.Entities.ESystemParameter.getParameter(masterDBConn, HROne.SaaS.Entities.ESystemParameter.PARAM_CODE_HSBC_MRI_DIRECTORY);
//HROne.SaaS.Entities.ECompanyDatabase companyDB = new HROne.SaaS.Entities.ECompanyDatabase();
//companyDB.CompanyDBID = CurID;
//if (HROne.SaaS.Entities.ECompanyDatabase.db.select(masterDBConn, companyDB))
//{
// txtRemoteProfileID.Text = companyDB.CompanyDBClientCode;
// HROne.HSBC.Utility.HSBCMRICommandLineDirectory = HROne.SaaS.Entities.ESystemParameter.getParameter(masterDBConn, HROne.SaaS.Entities.ESystemParameter.PARAM_CODE_HSBC_MRI_DIRECTORY);
// RemoteProfileID.Visible = false;
//}
}
}
else
{
RemoteProfileID.Visible = false;
if (FileType.SelectedValue.Equals("AMCND"))
{
PaymentMethodRow.Visible = true;
}
else
{
PaymentMethodRow.Visible = false;
}
}
}
protected void Login_Click(object sender, EventArgs e)
{
EESSUser user = null;
Session.Clear();
HROne.DataAccess.DatabaseConnection mainDBConn = null;
HROne.SaaS.Entities.ECompanyDatabase companyDB = null;
bool hasError = false;
string message = string.Empty;
// always check whether companyDB exists after click
if (Application["MasterDBConfig"] != null)
{
DatabaseConfig masterDBConfig = (DatabaseConfig)Application["MasterDBConfig"];
HROne.DataAccess.DatabaseConnection masterDBConn = masterDBConfig.CreateDatabaseConnectionObject();
DBFilter companyDatabaseFilter = new DBFilter();
companyDatabaseFilter.add(new Match("CompanyDBClientCode", txtCustomerID.Text));
ArrayList companyDatabaseList = HROne.SaaS.Entities.ECompanyDatabase.db.select(masterDBConn, companyDatabaseFilter);
if (companyDatabaseList.Count > 0)
{
companyDB = (HROne.SaaS.Entities.ECompanyDatabase)companyDatabaseList[0];
DatabaseConfig tempDBConfig = new DatabaseConfig();
tempDBConfig.ConnectionString = companyDB.getConnectionString(masterDBConn);
tempDBConfig.DBType = WebUtils.DBTypeEmun.MSSQL;
if (tempDBConfig.TestConnection())
{
mainDBConn = tempDBConfig.CreateDatabaseConnectionObject();
HROne.Lib.Entities.ESystemParameter.setParameter(mainDBConn, HROne.Lib.Entities.ESystemParameter.PARAM_CODE_PRODUCTKEY, companyDB.CompanyDBProductKey);
HROne.Lib.Entities.ESystemParameter.setParameter(mainDBConn, HROne.Lib.Entities.ESystemParameter.PARAM_CODE_PRODUCTFEATURECODE, companyDB.getProductFeatureCode(masterDBConn));
string[] smtpParameterList = new string[]
{
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_SERVER_NAME,
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_PORT,
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_USERNAME,
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_ENABLE_SSL,
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_SMTP_OUTGOING_EMAIL_ADDRESS
};
foreach (string smptParameter in smtpParameterList)
{
HROne.Lib.Entities.ESystemParameter.setParameter(mainDBConn, smptParameter, ESystemParameter.getParameter(masterDBConn, smptParameter));
}
HROne.Lib.Entities.ESystemParameter.setParameterWithEncryption(mainDBConn, HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_PASSWORD
, HROne.SaaS.Entities.ESystemParameter.getParameterWithEncryption(masterDBConn, HROne.SaaS.Entities.ESystemParameter.PARAM_CODE_SMTP_PASSWORD));
}
else
{
if (HROne.DataAccess.DBAESEncryptStringFieldAttribute.InvalidRSAKey)
{
HttpRuntime.UnloadAppDomain();
}
}
}
}
else
{
mainDBConn = WebUtils.GetDatabaseConnection();
if (mainDBConn == null)
{
if (multiDBRow.Visible)
{
int idx;
if (int.TryParse(cboDatabase.SelectedValue, out idx))
{
HROneConfig config = HROneConfig.GetCurrentHROneConfig();
DatabaseConfig dbconfig = config.DatabaseConfigList[idx];
if (dbconfig.TestConnection())
{
mainDBConn = dbconfig.CreateDatabaseConnectionObject();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "errorMessage", "alert(\"Fail to connect database\");", true);
return;
}
}
}
}
}
if (mainDBConn != null)
{
WebUtils.SetSessionDatabaseConnection(Session, mainDBConn);
}
HROne.ProductLicense productLicense = WebUtils.productLicense(Session);
if (productLicense != null)
{
if (companyDB == null && productLicense.ProductType == HROne.ProductLicense.ProductLicenseType.HROneSaaS)
{
productLicense.LoadProductKey(string.Empty);
}
}
if (mainDBConn == null && companyDB != null)
{
hasError = true;
message = "Fail to connect to database. Please contact to customer service.";
}
if (!hasError)
{
bool ChangePassword = false;
try
{
WebUtils.ValidateUser(mainDBConn, Username.Text, HROne.CommonLib.Hash.PasswordHash(Password.Text), true, out ChangePassword, out user);
}
catch (Exception ex)
{
hasError = true;
message = ex.Message;
}
// copy from GAP customization, checking Active Directory ID
if (user != null)
{
DBFilter ADIDFilter = new DBFilter();
ADIDFilter.add(new Match("EmpExtraFieldName", "AD ID"));
DBFilter ADIDValueFilter = new DBFilter();
ADIDValueFilter.add(new IN("EmpExtraFieldID", "Select EmpExtraFieldID from " + EEmpExtraField.db.dbclass.tableName, ADIDFilter));
ADIDValueFilter.add(new Match("EmpID", user.EmpID));
ArrayList ADIDList = EEmpExtraFieldValue.db.select(dbConn, ADIDValueFilter);
if (ADIDList.Count > 0)
{
string remoteUser = Request.ServerVariables["REMOTE_USER"].Trim();
string ADID = ((EEmpExtraFieldValue)ADIDList[0]).EmpExtraFieldValue.Trim();
if (!remoteUser.Equals(ADID, StringComparison.CurrentCultureIgnoreCase) && !remoteUser.EndsWith("\\" + ADID, StringComparison.CurrentCultureIgnoreCase) && !remoteUser.EndsWith("/" + ADID, StringComparison.CurrentCultureIgnoreCase))
{
hasError = true;
message = "This PC is not logged with your network ID!";
}
}
}
if (companyDB != null && !hasError)
{
if (!companyDB.CompanyDBIsActive)
{
hasError = true;
message = "Subscribed service has been expired; please contact customer service hotline for assistant.";
}
if (!productLicense.IsESS)
{
hasError = true;
message = "You are NOT subscribed the service.";
}
}
if (!hasError)
{
HROne.Lib.Entities.EESSLoginAudit.CreateLoginAudit(mainDBConn, user.EmpID, Username.Text, Request, AppUtils.ServerDateTime(), false, string.Empty);
// ADD the Session "User" Value is user
Session["User"] = user;
if (ChangePassword)
{
Session.Add("ForceChangePassword", true);
}
WebUtils.SetSessionLanguage(Session, user);
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/Default.aspx?LastURL=" + DecryptedRequest["LastURL"]);
}
}
// Remove all item for release session
Session.Clear();
Request.Cookies.Remove(HROne.Common.WebUtility.getDefaultSessionCookieName());
//if (companyDB != null)
//{
// Session.Remove("DatabaseConnection");
//}
{
if (user != null)
{
HROne.Lib.Entities.EESSLoginAudit.CreateLoginAudit(mainDBConn, user.EmpID, Username.Text, Request, AppUtils.ServerDateTime(), true, message);
}
else
{
HROne.Lib.Entities.EESSLoginAudit.CreateLoginAudit(mainDBConn, 0, Username.Text, Request, AppUtils.ServerDateTime(), true, message);
}
//message = message.Replace("\\", "\\\\").Replace("\r", "\\r").Replace("\n", "\\n").Replace("\"", "\\\"");
//message = message.Replace(HROne.Common.WebUtility.GetLocalizedString("validate.prompt"), "");
//ScriptManager.RegisterStartupScript(this, this.GetType(), "errorMessage", "alert(\"" + message + "\");", true);
Prompt.Text = message;
System.Threading.Thread.Sleep(1000);
}
}
public int buildSQL(DatabaseConnection dbConn, int index, StringBuilder b)
{
b.Append(fieldName1).Append(op).Append(fieldName2);
return(index);
}
//public bool ValidateUser(string username, string encryptedPassword)
//{
// string message = string.Empty;
// DBFilter filter = new DBFilter();
// filter.add(new Match("LoginID", username));
// filter.add(new Match("UserAccountStatus", "<>", "D"));
// ArrayList list = EUser.db.select(dbConn, filter);
// if (list.Count == 0)
// {
// message = "Invalid User Name or Password";
// throw new Exception(message);
// return;
// }
// EUser user = (EUser)list[0];
// if (user.UserPassword == null)
// user.UserPassword = "";
// if (!(user.UserAccountStatus == "A"))
// {
// message = "Account is Inactive/Locked";
// throw new Exception(message);
// return;
// }
// if (!user.UserPassword.Equals(encryptedPassword))
// {
// message = "Invalid User Name or Password";
// user.FailCount++;
// string maxFailCountParameterString = ESystemParameter.getParameter(ESystemParameter.PARAM_CODE_LOGIN_MAX_FAIL_COUNT);
// if (!maxFailCountParameterString.Equals(string.Empty))
// {
// int MaxFailCount = 0;
// if (int.TryParse(maxFailCountParameterString, out MaxFailCount))
// if (MaxFailCount > 0)
// if (user.FailCount >= MaxFailCount)
// {
// user.UserAccountStatus = "I";
// user.FailCount = 0;
// }
// else if (user.FailCount - MaxFailCount == 1)
// {
// message += "\r\n" + "The account will be locked if you fail to login 1 more time";
// }
// }
// EUser.db.update(dbConn, user);
// throw new Exception(message);
// return;
// }
// Session["User"] = user;
// WebUtils.SetSessionLanguage(Session, user);
// user.FailCount = 0;
// EUser.db.update(dbConn, user);
// //WebUtils.RefreshPermission(Session);
// bool isForceChangePassword = false;
// if (user.UserChangePasswordUnit == "D")
// {
// if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddDays(user.UserChangePasswordPeriod))
// isForceChangePassword = false;
// else
// isForceChangePassword = true;
// }
// else if (user.UserChangePasswordUnit == "M")
// {
// if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddMonths(user.UserChangePasswordPeriod))
// isForceChangePassword = false;
// else
// isForceChangePassword = true;
// }
// else if (user.UserChangePasswordUnit == "Y")
// {
// if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddYears(user.UserChangePasswordPeriod))
// isForceChangePassword = false;
// else
// isForceChangePassword = true;
// }
// else
// isForceChangePassword = false;
// if (user.UserChangePassword)
// isForceChangePassword = true;
// //EInbox.GenerateInboxMessage(user.UserID);
// if (isForceChangePassword)
// Session["ForceChangePassword"] = true;
// if (Session["LastURL"] != null)
// Response.Redirect(Session["LastURL"].ToString());
// else
// HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Emp_List.aspx");
//}
protected void Login_Click(object sender, EventArgs e)
{
HROne.Lib.Entities.EUser user = null;
Session.Clear();
HROne.DataAccess.DatabaseConnection mainDBConn = null;
HROne.SaaS.Entities.ECompanyDatabase companyDB = null;
bool hasError = false;
string message = string.Empty;
// always check whether companyDB exists after click
if (Application["MasterDBConfig"] != null)
{
DatabaseConfig masterDBConfig = (DatabaseConfig)Application["MasterDBConfig"];
HROne.DataAccess.DatabaseConnection masterDBConn = masterDBConfig.CreateDatabaseConnectionObject();
DBFilter companyDatabaseFilter = new DBFilter();
companyDatabaseFilter.add(new Match("CompanyDBClientCode", txtCustomerID.Text));
ArrayList companyDatabaseList = HROne.SaaS.Entities.ECompanyDatabase.db.select(masterDBConn, companyDatabaseFilter);
if (companyDatabaseList.Count > 0)
{
companyDB = (HROne.SaaS.Entities.ECompanyDatabase)companyDatabaseList[0];
DatabaseConfig tempDBConfig = new DatabaseConfig();
tempDBConfig.ConnectionString = companyDB.getConnectionString(masterDBConn);
tempDBConfig.DBType = WebUtils.DBTypeEmun.MSSQL;
if (tempDBConfig.TestConnection())
{
mainDBConn = tempDBConfig.CreateDatabaseConnectionObject();
HROne.Lib.Entities.ESystemParameter.setParameter(mainDBConn, HROne.Lib.Entities.ESystemParameter.PARAM_CODE_PRODUCTKEY, companyDB.CompanyDBProductKey);
HROne.Lib.Entities.ESystemParameter.setParameter(mainDBConn, HROne.Lib.Entities.ESystemParameter.PARAM_CODE_PRODUCTFEATURECODE, companyDB.getProductFeatureCode(masterDBConn));
string[] smtpParameterList = new string[]
{
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_SERVER_NAME,
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_PORT,
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_USERNAME,
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_ENABLE_SSL,
HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_SMTP_OUTGOING_EMAIL_ADDRESS
};
foreach (string smptParameter in smtpParameterList)
{
HROne.Lib.Entities.ESystemParameter.setParameter(mainDBConn, smptParameter, HROne.SaaS.Entities.ESystemParameter.getParameter(masterDBConn, smptParameter));
}
HROne.Lib.Entities.ESystemParameter.setParameterWithEncryption(mainDBConn, HROne.Lib.Entities.ESystemParameter.PARAM_CODE_SMTP_PASSWORD
, HROne.SaaS.Entities.ESystemParameter.getParameterWithEncryption(masterDBConn, HROne.SaaS.Entities.ESystemParameter.PARAM_CODE_SMTP_PASSWORD));
}
else
{
if (HROne.DataAccess.DBAESEncryptStringFieldAttribute.InvalidRSAKey)
{
HttpRuntime.UnloadAppDomain();
}
}
}
}
else
{
mainDBConn = WebUtils.GetDatabaseConnection();
if (mainDBConn == null)
{
if (multiDBRow.Visible)
{
int idx;
if (int.TryParse(cboDatabase.SelectedValue, out idx))
{
HROneConfig config = HROneConfig.GetCurrentHROneConfig();
DatabaseConfig dbconfig = config.DatabaseConfigList[idx];
if (dbconfig.TestConnection())
{
mainDBConn = dbconfig.CreateDatabaseConnectionObject();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "errorMessage", "alert(\"Fail to connect database\");", true);
return;
}
}
}
}
}
if (mainDBConn != null)
{
WebUtils.SetSessionDatabaseConnection(Session, mainDBConn);
}
HROne.ProductLicense productLicense = WebUtils.productLicense(Session);
if (productLicense != null)
{
if (companyDB == null && productLicense.ProductType == HROne.ProductLicense.ProductLicenseType.HROneSaaS)
{
productLicense.LoadProductKey(string.Empty);
}
}
if (mainDBConn == null && companyDB != null)
{
hasError = true;
message = "Fail to connect to database. Please contact to customer service.";
}
if (!hasError)
{
try
{
WebUtils.ValidateUser(mainDBConn, Username.Text, HROne.CommonLib.Hash.PasswordHash(Password.Text), true, true, out user);
}
catch (Exception ex)
{
hasError = true;
message = ex.Message;
}
// Check the database status after login is verified
if (companyDB != null && !hasError)
{
if (!companyDB.CompanyDBIsActive)
{
hasError = true;
message = "Subscribed service has been expired; please contact customer service hotline for assistant.";
}
}
if (!hasError)
{
// Create Login Audit for successfully login
HROne.Lib.Entities.ELoginAudit.CreateLoginAudit(mainDBConn, user.UserID, Username.Text, Request, AppUtils.ServerDateTime(), false, string.Empty);
Session["LoginID"] = user.LoginID;
Session["PasswordEncrypted"] = user.UserPassword;
if (companyDB != null)
{
Session["CompanyDBID"] = companyDB.CompanyDBID;
}
if (mainDBConn is HROne.DataAccess.DatabaseConnectionWithAudit)
{
((HROne.DataAccess.DatabaseConnectionWithAudit)mainDBConn).UserID = user.UserID;
}
WebUtils.SetSessionLanguage(Session, user);
//WebUtils.RefreshPermission(Session);
bool isForceChangePassword = false;
if (user.UserChangePasswordUnit == "D")
{
if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddDays(user.UserChangePasswordPeriod))
{
isForceChangePassword = false;
}
else
{
isForceChangePassword = true;
}
}
else if (user.UserChangePasswordUnit == "M")
{
if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddMonths(user.UserChangePasswordPeriod))
{
isForceChangePassword = false;
}
else
{
isForceChangePassword = true;
}
}
else if (user.UserChangePasswordUnit == "Y")
{
if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddYears(user.UserChangePasswordPeriod))
{
isForceChangePassword = false;
}
else
{
isForceChangePassword = true;
}
}
else
{
isForceChangePassword = false;
}
if (user.UserChangePassword)
{
isForceChangePassword = true;
}
//EInbox.GenerateInboxMessage(user.UserID);
if (isForceChangePassword)
{
Session["ForceChangePassword"] = true;
}
WebUtils.SetSessionLanguage(Session, WebUtils.GetCurUser(Session));
//RegenerateSessionId();
HROne.Lib.Entities.EInbox.DeleteAllDeletedUserID(mainDBConn);
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/Default.aspx?LastURL=" + DecryptedRequest["LastURL"]);
}
}
// Remove all item for release session
Session.Clear();
Request.Cookies.Remove(HROne.Common.WebUtility.getDefaultSessionCookieName());
//if (companyDB != null)
//{
// Session.Remove("DatabaseConnection");
//}
{
// Create Login Audit for fail login
if (user != null)
{
HROne.Lib.Entities.ELoginAudit.CreateLoginAudit(mainDBConn, user.UserID, Username.Text, Request, AppUtils.ServerDateTime(), true, message);
}
else
{
HROne.Lib.Entities.ELoginAudit.CreateLoginAudit(mainDBConn, 0, Username.Text, Request, AppUtils.ServerDateTime(), true, message);
}
message = message.Replace("\\", "\\\\").Replace("\r", "\\r").Replace("\n", "\\n").Replace("\"", "\\\"");
message = message.Replace(HROne.Common.WebUtility.GetLocalizedString("validate.prompt"), "");
ScriptManager.RegisterStartupScript(this, this.GetType(), "errorMessage", "alert(\"" + message + "\");", true);
System.Threading.Thread.Sleep(1000);
}
}
public SearchBinding(DatabaseConnection DBConn, DBManager db)
{
this.DBConn = DBConn;
this.db = db;
}
//public bool ValidateUser(string username, string encryptedPassword)
//{
// string message = string.Empty;
// DBFilter filter = new DBFilter();
// filter.add(new Match("LoginID", username));
// filter.add(new Match("UserAccountStatus", "<>", "D"));
// ArrayList list = EUser.db.select(dbConn, filter);
// if (list.Count == 0)
// {
// message = "Invalid User Name or Password";
// throw new Exception(message);
// return;
// }
// EUser user = (EUser)list[0];
// if (user.UserPassword == null)
// user.UserPassword = "";
// if (!(user.UserAccountStatus == "A"))
// {
// message = "Account is Inactive/Locked";
// throw new Exception(message);
// return;
// }
// if (!user.UserPassword.Equals(encryptedPassword))
// {
// message = "Invalid User Name or Password";
// user.FailCount++;
// string maxFailCountParameterString = ESystemParameter.getParameter(ESystemParameter.PARAM_CODE_LOGIN_MAX_FAIL_COUNT);
// if (!maxFailCountParameterString.Equals(string.Empty))
// {
// int MaxFailCount = 0;
// if (int.TryParse(maxFailCountParameterString, out MaxFailCount))
// if (MaxFailCount > 0)
// if (user.FailCount >= MaxFailCount)
// {
// user.UserAccountStatus = "I";
// user.FailCount = 0;
// }
// else if (user.FailCount - MaxFailCount == 1)
// {
// message += "\r\n" + "The account will be locked if you fail to login 1 more time";
// }
// }
// EUser.db.update(dbConn, user);
// throw new Exception(message);
// return;
// }
// Session["User"] = user;
// WebUtils.SetSessionLanguage(Session, user);
// user.FailCount = 0;
// EUser.db.update(dbConn, user);
// //WebUtils.RefreshPermission(Session);
// bool isForceChangePassword = false;
// if (user.UserChangePasswordUnit == "D")
// {
// if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddDays(user.UserChangePasswordPeriod))
// isForceChangePassword = false;
// else
// isForceChangePassword = true;
// }
// else if (user.UserChangePasswordUnit == "M")
// {
// if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddMonths(user.UserChangePasswordPeriod))
// isForceChangePassword = false;
// else
// isForceChangePassword = true;
// }
// else if (user.UserChangePasswordUnit == "Y")
// {
// if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddYears(user.UserChangePasswordPeriod))
// isForceChangePassword = false;
// else
// isForceChangePassword = true;
// }
// else
// isForceChangePassword = false;
// if (user.UserChangePassword)
// isForceChangePassword = true;
// //EInbox.GenerateInboxMessage(user.UserID);
// if (isForceChangePassword)
// Session["ForceChangePassword"] = true;
// if (Session["LastURL"] != null)
// Response.Redirect(Session["LastURL"].ToString());
// else
// Response.Redirect("Emp_List.aspx");
//}
protected void Login_Click(object sender, EventArgs e)
{
Session.Clear();
// re-assign the connection
HROne.DataAccess.DatabaseConnection mainDBConn = WebUtils.GetDatabaseConnection();
if (mainDBConn != null)
{
WebUtils.SetSessionDatabaseConnection(Session, mainDBConn);
}
HROne.SaaS.Entities.EUser user = null;
string message = string.Empty;
bool hasError = false;
try
{
WebUtils.ValidateUser(mainDBConn, Username.Text, HROne.CommonLib.Hash.PasswordHash(Password.Text), true, true, out user);
}
catch (Exception ex)
{
hasError = true;
message = ex.Message;
}
if (!hasError)
{
Session["LoginID"] = user.LoginID;
Session["PasswordEncrypted"] = user.UserPassword;
if (mainDBConn is HROne.DataAccess.DatabaseConnectionWithAudit)
{
((HROne.DataAccess.DatabaseConnectionWithAudit)mainDBConn).UserID = user.UserID;
}
//WebUtils.RefreshPermission(Session);
bool isForceChangePassword = false;
if (user.UserChangePasswordUnit == "D")
{
if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddDays(user.UserChangePasswordPeriod))
{
isForceChangePassword = false;
}
else
{
isForceChangePassword = true;
}
}
else if (user.UserChangePasswordUnit == "M")
{
if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddMonths(user.UserChangePasswordPeriod))
{
isForceChangePassword = false;
}
else
{
isForceChangePassword = true;
}
}
else if (user.UserChangePasswordUnit == "Y")
{
if (AppUtils.ServerDateTime() < user.UserChangePasswordDate.AddYears(user.UserChangePasswordPeriod))
{
isForceChangePassword = false;
}
else
{
isForceChangePassword = true;
}
}
else
{
isForceChangePassword = false;
}
if (user.UserChangePassword)
{
isForceChangePassword = true;
}
//EInbox.GenerateInboxMessage(user.UserID);
if (isForceChangePassword)
{
Session["ForceChangePassword"] = true;
}
Response.Redirect("~/Default.aspx");
}
// Remove all item for release session
Session.Clear();
Request.Cookies.Remove(HROne.Common.WebUtility.getDefaultSessionCookieName());
{
message = message.Replace("\\", "\\\\").Replace("\r", "\\r").Replace("\n", "\\n").Replace("\"", "\\\"");
message = message.Replace(HROne.Common.WebUtility.GetLocalizedString("validate.prompt"), "");
ScriptManager.RegisterStartupScript(this, this.GetType(), "errorMessage", "alert(\"" + message + "\");", true);
System.Threading.Thread.Sleep(1000);
}
}
public void loadData(DatabaseConnection DBConn, DataSet ds, string tableName, ListInfo info, string select, string from, string distinct)
{
StringBuilder s = new StringBuilder();
s.Append("SELECT ");
if (!string.IsNullOrEmpty(distinct))
{
s.Append("DISTINCT ");
}
s.Append(select).Append(" ");
s.Append(from).Append(" ");
//s.Append(getWhereClause());
//s.Append(getGroupCluase());
//s.Append(getOrderClause(info));
DbCommand command = DBConn.CreateSelectCommand(s.ToString(), this, info);
DbDataAdapter adapter = DBConn.CreateAdapter();
adapter.SelectCommand = command;
try
{
//conn.Open();
if (info != null)
{
StringBuilder cs = new StringBuilder();
cs.Append("SELECT ");
if (!string.IsNullOrEmpty(distinct))
{
cs.Append("COUNT(DISTINCT ").Append(distinct).Append(") ");
}
else
{
cs.Append("COUNT(*) ");
}
cs.Append(from);
cs.Append(getWhereClause(DBConn));
//cs.Append(getGroupCluase());
DbCommand ccommand = DBConn.CreateCommand();
ccommand.CommandText = cs.ToString();
setParams(ccommand);
info.numRecord = Convert.ToInt32(DBConn.ExecuteScalar(ccommand));
if (info.recordPerPage > 0)
{
info.numPage = (int)Math.Ceiling((double)info.numRecord / info.recordPerPage);
if (info.page >= info.numPage)
{
info.page = info.numPage - 1;
}
if (info.page < 0)
{
info.page = 0;
}
int rowIndex = info.page * info.recordPerPage;
adapter.Fill(ds, rowIndex, info.recordPerPage, "table");
}
else
{
info.numPage = 1;
info.page = 0;
adapter.Fill(ds, tableName);
}
}
else
{
adapter.Fill(ds, tableName);
}
//DataTable table=ds.Tables["table"];
//ds.Tables.Clear();
//return table;
}
catch (Exception ex)
{
throw new Exception(ex.ToString() + "\r\n" + select + from);
}
finally
{
adapter.Dispose();
//conn.Close();
//conn.Dispose();
}
}
public DataTable loadData(DatabaseConnection DBConn, string SelectQuery)
{
DataSet ds = new DataSet();
return(DBConn.ExecuteToDataTable(DBConn.CreateSelectCommand(SelectQuery, this)));
}
public DataTable loadData(DatabaseConnection DBConn, ListInfo info, string select, string from)
{
return(loadData(DBConn, info, select, from, null));
}
public string getWhereClause(DatabaseConnection dbConn, bool first)
{
int out_index;
return(getWhereClause(dbConn, first, 0, out out_index));
}
public string getWhereClause(DatabaseConnection dbConn)
{
return(getWhereClause(dbConn, false));
}
