private void BindUser()
{
if (clsSecurity.LoginChecker())
{
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region DataBuilder
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("PName,FName,LName,HN,Mobile,Phone,Email ");
strSQL.Append("FROM ");
strSQL.Append("[User] ");
strSQL.Append("WHERE ");
strSQL.Append("[UID]=" + parameterChar + "UID");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), new string[, ] {
{ parameterChar + "UID", clsSecurity.LoginUID }
}, dbType, cs);
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0]["PName"] != DBNull.Value && dt.Rows[0]["PName"].ToString() != "")
{
ddlPName.SelectedValue = dt.Rows[0]["PName"].ToString();
}
if (dt.Rows[0]["FName"] != DBNull.Value && dt.Rows[0]["FName"].ToString() != "")
{
txtFName.Text = dt.Rows[0]["FName"].ToString();
}
if (dt.Rows[0]["LName"] != DBNull.Value && dt.Rows[0]["LName"].ToString() != "")
{
txtLName.Text = dt.Rows[0]["LName"].ToString();
}
if (dt.Rows[0]["Email"] != DBNull.Value && dt.Rows[0]["Email"].ToString() != "")
{
txtEmail.Text = dt.Rows[0]["Email"].ToString();
}
if (dt.Rows[0]["Phone"] != DBNull.Value && dt.Rows[0]["Phone"].ToString() != "")
{
txtPhone.Text += dt.Rows[0]["Phone"].ToString() + ",";
}
if (dt.Rows[0]["Mobile"] != DBNull.Value && dt.Rows[0]["Mobile"].ToString() != "")
{
txtPhone.Text += dt.Rows[0]["Mobile"].ToString() + ",";
}
txtPhone.Text = clsDefault.LastStringRemover(txtPhone.Text, ",");
}
#endregion
}
}
