protected void BindDefault()
{
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region Bind UserGroup
ddlUserGroup.DataSource = clsSQL.Bind("SELECT UID,Name FROM UserGroup WHERE Active='1' ORDER BY Sort", dbType, cs);
ddlUserGroup.DataTextField = "Name";
ddlUserGroup.DataValueField = "UID";
ddlUserGroup.DataBind();
#endregion
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("[User].UserGroupUID,");
strSQL.Append("UserGroup.Name AS UserGroupName,");
strSQL.Append("[User].UID,");
strSQL.Append("[User].Username,");
strSQL.Append("[User].Password,");
strSQL.Append("[User].HN,");
strSQL.Append("[User].Photo,");
strSQL.Append("[User].PName,");
strSQL.Append("[User].FName,");
strSQL.Append("[User].LName,");
strSQL.Append("[User].BirthDate,");
strSQL.Append("[User].Gender,");
strSQL.Append("[User].Phone,");
strSQL.Append("[User].Mobile,");
strSQL.Append("[User].Email,");
strSQL.Append("[User].Address,");
strSQL.Append("[User].AddressDistrict,");
strSQL.Append("[User].AddressPrefecture,");
strSQL.Append("[User].AddressProvince,");
strSQL.Append("[User].AddressPostal,");
strSQL.Append("[User].Profile,");
strSQL.Append("[User].Signature,");
strSQL.Append("[User].Sort,");
strSQL.Append("[User].Active ");
strSQL.Append("FROM ");
strSQL.Append("[User] ");
strSQL.Append("INNER JOIN UserGroup ");
strSQL.Append("ON [User].UserGroupUID=UserGroup.UID AND UserGroup.Active='1' ");
strSQL.Append("WHERE ");
strSQL.Append("[User].UID=" + parameterChar + "UID ");
strSQL.Append("AND (");
strSQL.Append("UserGroup.Name='admin' OR (UserGroup.Name <> 'admin' AND [User].Active='1')");
strSQL.Append(");");
#endregion
#region Bind Data
dt = clsSQL.Bind(strSQL.ToString(), new string[, ] {
{ "" + parameterChar + "UID", clsSecurity.LoginUID }
}, dbType, cs);
if (dt != null && dt.Rows.Count > 0)
{
txtUsername.Text = dt.Rows[0]["Username"].ToString();
ddlUserGroup.SelectedValue = dt.Rows[0]["UserGroupUID"].ToString();
txtEMail.Text = dt.Rows[0]["Email"].ToString();
#region Photo
if (dt.Rows[0]["Photo"] != DBNull.Value)
{
lblPhoto.Text = "<div><img src='" + dt.Rows[0]["Photo"].ToString() + "'/></div>";
}
#endregion
#region HN
if (dt.Rows[0]["HN"] != DBNull.Value)
{
txtHN.Text = dt.Rows[0]["HN"].ToString();
}
#endregion
#region Name
if (dt.Rows[0]["PName"] != DBNull.Value)
{
ddlPName.SelectedValue = dt.Rows[0]["PName"].ToString();
}
txtFName.Text = dt.Rows[0]["FName"].ToString();
txtLName.Text = dt.Rows[0]["LName"].ToString();
#endregion
#region BirthDate
DateTime dttm = (dt.Rows[0]["BirthDate"] != DBNull.Value ? DateTime.Parse(dt.Rows[0]["BirthDate"].ToString()) : DateTime.MinValue);
if (dttm != DateTime.MinValue)
{
ucDateTimeFlat1.DateTime = dttm;
}
#endregion
#region Gender
if (dt.Rows[0]["Gender"] != DBNull.Value)
{
rbGender.SelectedValue = dt.Rows[0]["Gender"].ToString();
}
#endregion
#region Phone Mobile
if (dt.Rows[0]["Phone"] != DBNull.Value)
{
txtPhone.Text = dt.Rows[0]["Phone"].ToString();
}
if (dt.Rows[0]["Mobile"] != DBNull.Value)
{
txtMobile.Text = dt.Rows[0]["Mobile"].ToString();
}
#endregion
#region Address
if (dt.Rows[0]["Address"] != DBNull.Value)
{
txtAddress.Text = dt.Rows[0]["Address"].ToString();
}
if (dt.Rows[0]["AddressDistrict"] != DBNull.Value)
{
txtAddressDistrict.Text = dt.Rows[0]["AddressDistrict"].ToString();
}
if (dt.Rows[0]["AddressPrefecture"] != DBNull.Value)
{
txtAddressPrefecture.Text = dt.Rows[0]["AddressPrefecture"].ToString();
}
if (dt.Rows[0]["AddressProvince"] != DBNull.Value)
{
txtAddressProvince.Text = dt.Rows[0]["AddressProvince"].ToString();
}
if (dt.Rows[0]["AddressPostal"] != DBNull.Value)
{
txtAddressPostal.Text = dt.Rows[0]["AddressPostal"].ToString();
}
#endregion
#region Profile & Signature
if (dt.Rows[0]["Profile"] != DBNull.Value)
{
ucProfile.Text = dt.Rows[0]["Profile"].ToString();
}
if (dt.Rows[0]["Signature"] != DBNull.Value)
{
ucSignature.Text = dt.Rows[0]["Signature"].ToString();
}
#endregion
}
else
{
clsSecurity.LoginDelete();
//clsDefault.Redirect("/", "ไม่พบข้อมูลของคุณ");
ucColorBox1.Redirect("/", "ไม่พบข้อมูลของคุณ");
}
#endregion
}
protected void btLogout_Click(object sender, EventArgs e)
{
clsSecurity.LoginDelete();
//LoginChecker();
Response.Redirect(Request.RawUrl);
}
