public static List<myUser> GetAllUser()
{
myUserData tempADO = new myUserData();
List<myUser> list = new List<myUser>();
DataSet tempDS = tempADO.GetAllUser();
if (tempADO.HasData)
{
foreach (DataRow row in tempDS.Tables[0].Rows)
list.Add(new myUser(row));
return list;
}
return new List<myUser>();
}
public void UpdateGameRoom(int val)
{
myUserData tempADO = new myUserData();
tempADO.UpdateUserByGameRoomID(val, UserID);
}
public bool UpdateData()
{
myUser n = new myUser();
n.GetUserBySessionID(mySessionID);
if (n.UserID != 0 && n.UserID != myUserID) { return false; }
n = new myUser();
n.GetUserByUserName(myUserName);
if (n.UserID != 0 && n.UserID != myUserID) { return false; }
myUserData data = new myUserData();
List<SqlParameter> tempAL = new List<SqlParameter>();
SqlParameter tempP;
tempP = new SqlParameter();
tempP.ParameterName = "@UserID";
tempP.Size = 4;
tempP.SqlDbType = SqlDbType.Int;
tempP.Value = myUserID;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@SessionID";
tempP.Size = 200;
tempP.SqlDbType = SqlDbType.VarChar;
tempP.Value = mySessionID;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@UserName";
tempP.Size = 200;
tempP.SqlDbType = SqlDbType.VarChar;
tempP.Value = myUserName;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@Password";
tempP.Size = 200;
tempP.SqlDbType = SqlDbType.VarChar;
tempP.Value = myPassword;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
data.RunProcedure("csp_UpdateUser", tempAL);
return true;
}
public bool InsertData()
{
myUser n = new myUser();
n.GetUserBySessionID(mySessionID);
if (n.UserID != 0) return false;
n = new myUser();
n.GetUserByUserName(myUserName);
if (n.UserID != 0) return false;
myUserData data = new myUserData();
List<SqlParameter> tempAL = new List<SqlParameter>();
SqlParameter tempP; DataSet tempDS;
tempP = new SqlParameter();
tempP.ParameterName = "@SessionID";
tempP.Size = 200;
tempP.SqlDbType = SqlDbType.VarChar;
tempP.Value = mySessionID;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@UserName";
tempP.Size = 200;
tempP.SqlDbType = SqlDbType.VarChar;
tempP.Value = myUserName;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@Password";
tempP.Size = 200;
tempP.SqlDbType = SqlDbType.VarChar;
tempP.Value = myPassword;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempDS = data.RunProcedure("csp_InsertUser", tempAL);
myUserID = int.Parse(tempDS.Tables[0].Rows[0][0].ToString());
tempDS.Dispose(); return true;
}
public bool GetUserByUserName(string val)
{
myUserData tempADO = new myUserData();
DataSet tempDS = tempADO.GetUserByUserName(val);
if (tempADO.HasData)
{
UpdateUser(tempDS.Tables[0].Rows[0]);
return true;
} return false;
}
public static List<myUser> GetUserByGameRoom(myGameRoom val)
{
myUserData tempADO = new myUserData();
List<myUser> list = new List<myUser>();
DataSet tempDS = tempADO.GetUserByGameRoomID(val.GameRoomID);
if (tempADO.HasData)
{
foreach (DataRow row in tempDS.Tables[0].Rows)
list.Add(new myUser(row));
return list;
}
return new List<myUser>();
}
