public void LoadListsOrganization(string strPrtId, string strCsoId, RadComboBox cbPartner, RadComboBox cbCSO, string strLngId, DBConnection dbCon) { #region Variables utilLanguageTranslation utilLT = null; utilListTable uLT = null; DataTable dt = null; string strEmptySingleSelect = string.Empty; #endregion Variables utilLT = new utilLanguageTranslation(); utilLT.Language = strLngId; strEmptySingleSelect = utilLT.GetMessageTranslation(cMIDEmptyListSingleSelect, dbCon.dbCon); #region Get Parent Values if (strCsoId.Length != 0 && !strCsoId.Equals(cEmptyListValue)) { dt = GetCSOParent(strCsoId, dbCon); if (utilCollections.HasRows(dt)) { strPrtId = dt.Rows[0]["prt_id"].ToString(); } else { strCsoId = string.Empty; strPrtId = string.Empty; } } else if (strPrtId.Length != 0 && !strPrtId.Equals(cEmptyListValue)) { strCsoId = string.Empty; } #endregion Get Parent Values #region Load Lists uLT = new utilListTable(); dt = uLT.GetData("lst_partner", true, strPrtId, dbCon.dbCon); dt = utilCollections.AddEmptyItemFront(dt, "lt_id", "lt_name", cEmptyListValue, strEmptySingleSelect); utilControls.RadComboBoxFill(cbPartner, dt, "lt_id", "lt_name"); dt = GetCSOByParents(strPrtId, dbCon); dt = utilCollections.AddEmptyItemFront(dt, "lt_id", "lt_name", cEmptyListValue, strEmptySingleSelect); utilControls.RadComboBoxFill(cbCSO, dt, "lt_id", "lt_name"); #endregion Load Lists #region Set List Selection if (strPrtId.Length != 0) { cbPartner.SelectedValue = strPrtId; } else { cbPartner.SelectedIndex = 0; } if (strCsoId.Length != 0) { cbCSO.SelectedValue = strCsoId; } else { cbCSO.SelectedIndex = 0; } #endregion Set List Selection }
/// <summary> /// Validates specified email and password against the values in the database /// </summary> /// <param name="strUserEmail">Email of User to be logged in</param> /// <param name="strPassword">Password of User to be logged in</param> /// <param name="strLngID">Language Message must be returned in</param> /// <param name="dbCon">Database connection that must be used</param> /// <returns>Returns string array, value key pair, based on log in result</returns> public string[] LogIn(string strUserEmail, string strPassword, DBConnection dbCon) { #region Variables utilLanguageTranslation utilLT = new utilLanguageTranslation(); DataTable dt = null; int intPasswordFormat = -1; string[] arrResult = new string[2]; string strPasswordCheck = string.Empty; string strSalt = string.Empty; string strSQL = string.Empty; string strUserID = string.Empty; #endregion Variables #region LogIn strSQL = "SELECT usr_id, usr_password, usr_password_format, usr_password_salt, usr_active FROM um_user WHERE LOWER(usr_email) = '{0}' "; strSQL = string.Format(strSQL, strUserEmail.ToLower()); dt = dbCon.ExecuteQueryDataTable(strSQL); if (utilCollections.HasRows(dt)) { if (Convert.ToBoolean(dt.Rows[0]["usr_active"])) { strUserID = dt.Rows[0]["usr_id"].ToString(); if (utilFormatting.IsInt(dt.Rows[0]["usr_password_format"].ToString())) { intPasswordFormat = Convert.ToInt32(dt.Rows[0]["usr_password_format"]); switch (intPasswordFormat) { case 0: strPasswordCheck = dt.Rows[0]["usr_password"].ToString(); break; case 1: strPasswordCheck = dt.Rows[0]["usr_password"].ToString(); strSalt = dt.Rows[0]["usr_password_salt"].ToString(); strPassword = utilEncryption.HashText(strPassword, strSalt); break; default: arrResult[0] = "2"; arrResult[1] = utilLT.GetMessageTranslation(utilSOCYWeb.cMIDPasswordFormatInvalid, dbCon.dbCon); break; } if (strPasswordCheck != string.Empty) { if (strPassword.Equals(strPasswordCheck)) { arrResult[0] = "0"; arrResult[1] = strUserID; } else { arrResult[0] = "3"; arrResult[1] = utilLT.GetMessageTranslation(utilSOCYWeb.cMIDPasswordIncorrect, dbCon.dbCon); } } } else { arrResult[0] = "2"; arrResult[1] = utilLT.GetMessageTranslation(utilSOCYWeb.cMIDPasswordFormatInvalid, dbCon.dbCon); } } else { arrResult[0] = "4"; arrResult[1] = utilLT.GetMessageTranslation(utilSOCYWeb.cMIDAccountInactive, dbCon.dbCon); } } else { arrResult[0] = "1"; arrResult[1] = utilLT.GetMessageTranslation(utilSOCYWeb.cMIDEmailAddressInvalid, dbCon.dbCon); } #endregion LogIn return(arrResult); }
public void LoadListsArea(string strRgnId, string strDstId, string strSctId, string strWrdId, RadComboBox cbRegion, RadComboBox cbDistrict, RadComboBox cbSubCounty, RadComboBox cbWard, string strLngId, DBConnection dbCon) { #region Variables utilLanguageTranslation utilLT = null; utilListTable uLT = null; DataTable dt = null; string strEmptySingleSelect = string.Empty; #endregion Variables utilLT = new utilLanguageTranslation(); utilLT.Language = strLngId; strEmptySingleSelect = utilLT.GetMessageTranslation(cMIDEmptyListSingleSelect, dbCon.dbCon); #region Get Parent Values if (strWrdId.Length != 0 && !strWrdId.Equals(cEmptyListValue)) { dt = GetWardParents(strWrdId, dbCon); if (utilCollections.HasRows(dt)) { strSctId = dt.Rows[0]["sct_id"].ToString(); strDstId = dt.Rows[0]["dst_id"].ToString(); if (cbRegion != null) { strRgnId = dt.Rows[0]["rgn_id"].ToString(); } } else { strWrdId = string.Empty; strSctId = string.Empty; strDstId = string.Empty; strRgnId = string.Empty; } } else if (strSctId.Length != 0 && !strSctId.Equals(cEmptyListValue)) { dt = GetSubCountyParents(strSctId, dbCon); if (utilCollections.HasRows(dt)) { strDstId = dt.Rows[0]["dst_id"].ToString(); if (cbRegion != null) { strRgnId = dt.Rows[0]["rgn_id"].ToString(); } } else { strSctId = string.Empty; strDstId = string.Empty; strRgnId = string.Empty; } strWrdId = string.Empty; } else if (strDstId.Length != 0 && !strDstId.Equals(cEmptyListValue)) { dt = GetDistrictParents(strDstId, dbCon); if (utilCollections.HasRows(dt)) { if (cbRegion != null) { strRgnId = dt.Rows[0]["rgn_id"].ToString(); } } else { strDstId = string.Empty; strRgnId = string.Empty; } strWrdId = string.Empty; strSctId = string.Empty; } else if (strRgnId.Length != 0 && !strRgnId.Equals(cEmptyListValue)) { strWrdId = string.Empty; strSctId = string.Empty; strDstId = string.Empty; } else { strWrdId = string.Empty; strSctId = string.Empty; strDstId = string.Empty; strRgnId = string.Empty; } #endregion Get Parent Values #region Load Lists uLT = new utilListTable(); if (cbRegion != null) { dt = uLT.GetData("lst_region", true, strRgnId, false, strLngId, dbCon.dbCon); dt = utilCollections.AddEmptyItemFront(dt, "lt_id", "lt_name", cEmptyListValue, strEmptySingleSelect); utilControls.RadComboBoxFill(cbRegion, dt, "lt_id", "lt_name"); if (strRgnId.Length != 0) { cbRegion.SelectedValue = strRgnId; } else { cbRegion.SelectedIndex = 0; } } if (cbDistrict != null) { dt = GetDistrictByParents(strRgnId, strLngId, dbCon); dt = utilCollections.AddEmptyItemFront(dt, "lt_id", "lt_name", cEmptyListValue, strEmptySingleSelect); utilControls.RadComboBoxFill(cbDistrict, dt, "lt_id", "lt_name"); if (strDstId.Length != 0) { cbDistrict.SelectedValue = strDstId; } else { cbDistrict.SelectedIndex = 0; } } if (cbSubCounty != null) { dt = GetSubCountyByParents(strRgnId, strDstId, strLngId, dbCon); dt = utilCollections.AddEmptyItemFront(dt, "lt_id", "lt_name", cEmptyListValue, strEmptySingleSelect); utilControls.RadComboBoxFill(cbSubCounty, dt, "lt_id", "lt_name"); if (strSctId.Length != 0) { cbSubCounty.SelectedValue = strSctId; } else { cbSubCounty.SelectedIndex = 0; } } if (cbWard != null) { dt = GetWardByParents(strRgnId, strDstId, strSctId, strLngId, dbCon); dt = utilCollections.AddEmptyItemFront(dt, "lt_id", "lt_name", cEmptyListValue, strEmptySingleSelect); utilControls.RadComboBoxFill(cbWard, dt, "lt_id", "lt_name"); if (strWrdId.Length != 0) { cbWard.SelectedValue = strWrdId; } else { cbWard.SelectedIndex = 0; } } #endregion Load Lists }
/// <summary> /// Runs validation again user input /// </summary> /// <returns>Returns a blank string if the user input validated, else returns the validation error messages</returns> private string ValidatePage() { #region Variables DBConnection dbCon = null; utilLanguageTranslation utilLT = null; bool blnValid = true; string[] arrMessage = null; string strEmail = txtEmail.Text.Trim(); string strMessage = string.Empty; #endregion Variables #region Required Fields if (strEmail.Length == 0) { blnValid = false; } else if (txtpassword.Text.Trim().Length == 0) { blnValid = false; } if (!blnValid) { if (strMessage.Trim().Length == 0) { strMessage = utilSOCYWeb.cMIDRequiredFields; } else { strMessage = strMessage + "," + utilSOCYWeb.cMIDRequiredFields; } } #endregion Required Fields #region Get Messages if (strMessage.Length != 0) { dbCon = new DBConnection(utilSOCYWeb.cWCKConnection); try { utilLT = new utilLanguageTranslation(); utilLT.Language = Session[utilSOCYWeb.cSVLanguage].ToString(); arrMessage = utilLT.GetMessagesTranslation(strMessage.Split(','), dbCon.dbCon); if (arrMessage.Length != 0) { strMessage = arrMessage[0]; for (int intCount = 1; intCount < arrMessage.Length; intCount++) { strMessage = strMessage + "<br/>" + arrMessage[intCount]; } } } finally { dbCon.Dispose(); } } #endregion Get Messages return(strMessage); }