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