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