public override int GetHashCode()
{
int hash = 1;
if (Playerid != 0)
{
hash ^= Playerid.GetHashCode();
}
if (Name.Length != 0)
{
hash ^= Name.GetHashCode();
}
if (Roleid != 0)
{
hash ^= Roleid.GetHashCode();
}
if (Seat != 0)
{
hash ^= Seat.GetHashCode();
}
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public override int GetHashCode()
{
const int prime = 31;
int result = 1;
result = prime * result + ((string.ReferenceEquals(Roleid, null)) ? 0 : Roleid.GetHashCode());
result = prime * result + ((string.ReferenceEquals(Permissionid, null)) ? 0 : Permissionid.GetHashCode());
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
string sid;
id.Text = Session["StaffID"].ToString();
string prevaddr = "";
sid = Session["StaffID"].ToString();
int.TryParse(sid, out res);
string connectionString = WebConfigurationManager.ConnectionStrings["ims"].ConnectionString;
string selectall = "Select Username,Roleid,Fname,Lname,DOB,Password from StaffData where StaffID='" + res + "'";
string selectSQL2 = "Select Address,AddressDetail from StaffAddr where StaffID='" + res + "'";
string selectSQL = "Select Contact,ContactNo from StaffContact where StaffID='" + res + "'";
string Username, Roleid, Fname, Lname, DOB, Password;
SqlConnection con = new SqlConnection(connectionString);
SqlCommand basic = new SqlCommand(selectall, con);
SqlCommand cmd2 = new SqlCommand(selectSQL2, con);
SqlCommand cmd = new SqlCommand(selectSQL, con);
SqlDataReader readerall;
SqlDataReader reader2;
SqlDataReader reader1;
int added = 0;
string addr = "";
//try
//{
con.Open();
readerall = basic.ExecuteReader();
while (readerall.Read())
{
Username = readerall["Username"].ToString();
Password = readerall["Password"].ToString();
Fname = readerall["Fname"].ToString();
Lname = readerall["Lname"].ToString();
DOB = readerall["DOB"].ToString();
Roleid = readerall["Roleid"].ToString();
if (una.Text == "")
{
una.Text = Username.ToString();
}
if (password.Text == "")
{
password.Text = Password.ToString();
}
if (fname.Text == "")
{
fname.Text = Fname.ToString();
}
if (lname.Text == "")
{
lname.Text = Lname.ToString();
}
if (dob.Text == "")
{
dob.Text = DOB.ToString();
}
if (role.Text == "")
{
role.Text = Roleid.ToString();
}
}
readerall.Close();
reader2 = cmd2.ExecuteReader();
while (reader2.Read())
{
prevaddr = reader2["Address"].ToString();
addr = reader2["AddressDetail"].ToString();
if (prevaddr == '1'.ToString() && adres1.Text == "")
{
adres1.Text = addr.ToString();
}
else if (prevaddr == '2'.ToString() && adres2.Text == "")
{
adres2.Text = addr.ToString();
}
else if (prevaddr == '3'.ToString() && adres3.Text == "")
{
adres3.Text = addr.ToString();
}
}
reader2.Close();
reader1 = cmd.ExecuteReader();
while (reader1.Read())
{
prevaddr = reader1["Contact"].ToString();
addr = reader1["ContactNo"].ToString();
if (prevaddr == '1'.ToString() && c1.Text == "")
{
c1.Text = addr.ToString();
}
else if (prevaddr == '2'.ToString() && c2.Text == "")
{
c2.Text = addr.ToString();
}
else if (prevaddr == '3'.ToString() && c3.Text == "")
{
c3.Text = addr.ToString();
}
}
reader1.Close();
}
