public void CreateWLC(WLCDAO _WLCCreate)
{
WLCDAO _CreateUser = new WLCDAO();
try
{
using (SqlConnection _connection = new SqlConnection(connectionstring))
{
using (SqlCommand _command = new SqlCommand("sp_CreateWLC", _connection))
{
_command.CommandType = CommandType.StoredProcedure;
_command.Parameters.AddWithValue("@Gender", _WLCCreate.Gender);
_command.Parameters.AddWithValue("@Age", _WLCCreate.Age);
_command.Parameters.AddWithValue("@Height", _WLCCreate.Height);
_command.Parameters.AddWithValue("@Weight", _WLCCreate.Weight);
_command.Parameters.AddWithValue("@Goal", _WLCCreate.Goal);
_command.Parameters.AddWithValue("@GoalTime", _WLCCreate.GoalTime);
_command.Parameters.AddWithValue("@User_ID", _WLCCreate.User_ID);
_command.Parameters.AddWithValue("@Result", _WLCCreate.Result);
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
_connection.Dispose();
}
}
}
catch (Exception error)
{
Error_Logger log = new Error_Logger();
log.LogError(error);
}
}
public WLCDAO GetWLCByUser_ID(int User_ID)
{
WLCDAO _WLCToGet = new WLCDAO();
try
{ //esablishing the connection for the database
using (SqlConnection _connection = new SqlConnection(connectionstring))
{ //establishing the command to pass to the database and defining the command
using (SqlCommand _command = new SqlCommand("sp_GetWLCByUser_ID", _connection))
{
//this specifies what type of command is being used
_command.CommandType = CommandType.StoredProcedure;
//here is where values are going to be passed to the command
_command.Parameters.AddWithValue("@User_ID", User_ID);
//here is where the connection is open
_connection.Open();
//this executes the command
_command.ExecuteNonQuery();
using (SqlDataReader _reader = _command.ExecuteReader())
{
//loop through the dataset or command and write each element to the _playerToList using the player object class
while (_reader.Read())
{
_WLCToGet.Gender = _reader.GetString(0);
_WLCToGet.Age = _reader.GetInt32(1);
_WLCToGet.Height = _reader.GetDecimal(2);
_WLCToGet.Weight = _reader.GetDecimal(3);
_WLCToGet.Goal = _reader.GetDecimal(4);
_WLCToGet.GoalTime = _reader.GetDecimal(5);
_WLCToGet.User_ID = _reader.GetInt32(6);
_WLCToGet.ID = _reader.GetInt32(7);
}
}
}
}
}
catch (Exception error)
{
Error_Logger log = new Error_Logger();
log.LogError(error);
}
return(_WLCToGet);
}
public WLC Map(WLCDAO _CreateListToMap)
{
WLC _WLCToCreate = new WLC()
{
Gender = _CreateListToMap.Gender,
Age = _CreateListToMap.Age,
Height = _CreateListToMap.Height,
Weight = _CreateListToMap.Weight,
Goal = _CreateListToMap.Goal,
GoalTime = _CreateListToMap.GoalTime,
User_ID = _CreateListToMap.User_ID,
ID = _CreateListToMap.ID,
Result = _CreateListToMap.Result,
};
return(_WLCToCreate);
}
public List <WLCDAO> ViewWLC()
{
List <WLCDAO> _WLCList = new List <WLCDAO>();
try
{ //esablishing the connection for the database
using (SqlConnection _connection = new SqlConnection(connectionstring))
{ //establishing the command to pass to the database and defining the command
using (SqlCommand _command = new SqlCommand("sp_ViewWLC", _connection))
{
_command.CommandType = CommandType.StoredProcedure;
//connect to the database
_connection.Open();
//open the SQL data reader
using (SqlDataReader _reader = _command.ExecuteReader())
{
//loop through the dataset or command and write each element to the _playerToList using the player object class
while (_reader.Read())
{
WLCDAO _userToList = new WLCDAO()
{
Gender = _reader.GetString(0),
Age = _reader.GetInt32(1),
Height = _reader.GetDecimal(2),
Weight = _reader.GetDecimal(3),
Goal = _reader.GetDecimal(4),
GoalTime = _reader.GetDecimal(5),
User_ID = _reader.GetInt32(6),
ID = _reader.GetInt32(7),
Result = _reader.GetDecimal(8),
};
_WLCList.Add(_userToList);
}
}
}
}
}
catch (Exception error)
{
Error_Logger log = new Error_Logger();
log.LogError(error);
}
return(_WLCList);
}
public bool UpdateWLC(WLCDAO WLCToUpdate)
{
bool success = false;
try
{
using (SqlConnection _connection = new SqlConnection(connectionstring))
{
using (SqlCommand _command = new SqlCommand("sp_UpdateWLC", _connection))
{
//this specifies what type of command is being used
_command.CommandType = CommandType.StoredProcedure;
//here is where values are going to be passed to the command
_command.Parameters.AddWithValue("@Gender", WLCToUpdate.Gender);
_command.Parameters.AddWithValue("@Age", WLCToUpdate.Age);
_command.Parameters.AddWithValue("@Height", WLCToUpdate.Height);
_command.Parameters.AddWithValue("@Weight", WLCToUpdate.Weight);
_command.Parameters.AddWithValue("@Goal", WLCToUpdate.Goal);
_command.Parameters.AddWithValue("GoalTime", WLCToUpdate.GoalTime);
_command.Parameters.AddWithValue("@Result", WLCToUpdate.Result);
//here is where the connection is open
_connection.Open();
//this executes the command
_command.ExecuteNonQuery();
success = true;
_connection.Close();
}
}
}
catch (Exception error)
{
Error_Logger log = new Error_Logger();
log.LogError(error);
}
return(success);
}
public List <WLCDAO> Map(List <WLC> _WLCListToMap)
{
List <WLCDAO> _WLCListToReturn = new List <WLCDAO>();
foreach (WLC _WLCToMap in _WLCListToMap)
{
WLCDAO _WLCToView = new WLCDAO()
{
Gender = _WLCToMap.Gender,
Age = _WLCToMap.Age,
Height = _WLCToMap.Height,
Weight = _WLCToMap.Weight,
Goal = _WLCToMap.Goal,
GoalTime = _WLCToMap.GoalTime,
User_ID = _WLCToMap.User_ID,
ID = _WLCToMap.ID,
Result = _WLCToMap.Result,
};
_WLCListToReturn.Add(_WLCToView);
}
return(_WLCListToReturn);
}
