public static TeamsDM ReadTeamById(string teamId)
{
TeamsDM _team = new TeamsDM();
try
{
using (SqlCommand cmd = new SqlCommand("READ_TEAM_BY_ID", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlConnect.Connection.Open();
cmd.Parameters.AddWithValue("@Team_ID", teamId);
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
_team.TeamName = (string)reader["Team_Name"];
_team.TeamId = (Int64)reader["Team_ID"];
_team.ClientId = (Int64)reader["Client_ID"];
}
}
}
SqlConnect.Connection.Close();
}
return(_team);
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
throw ex;
}
}
public static List <TeamsDM> ReadTeams()
{
List <TeamsDM> teamList = new List <TeamsDM>();
try
{
using (SqlCommand cmd = new SqlCommand("READ_TEAMS", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlConnect.Connection.Open();
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var _team = new TeamsDM();
_team.TeamName = (string)reader["Team_Name"];
_team.TeamId = (Int64)reader["Team_ID"];
_team.ClientId = (Int64)reader["Client_ID"];
teamList.Add(_team);
}
}
}
SqlConnect.Connection.Close();
}
return(teamList);
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
throw ex;
}
}
public static void DeleteTeam(TeamsDM _team)
{
try
{
using (SqlCommand cmd = new SqlCommand("DELETE_TEAM", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Team_ID", _team.TeamId);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
//Write to error log
throw ex;
}
}
/// <summary>
/// Basic CRUD methods for Team information. TeamDM is the model being used here.
/// </summary>
#region Team DAL METHODS
public static void CreateTeam(TeamsDM _team)
{
try
{
//Creating a way of adding new user information to my database
using (SqlCommand cmd = new SqlCommand("CREATE_TEAM", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Team_Name", _team.TeamName);
cmd.Parameters.AddWithValue("@Client_ID", _team.ClientId);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception e)
{
SqlConnect.Connection.Close();
throw (e);
}
}
public static void UpdateTeam(TeamsDM _team)
{
try
{
using (SqlCommand cmd = new SqlCommand("UPDATE_TEAM", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Team_Name", _team.TeamName);
cmd.Parameters.AddWithValue("@Team_ID", _team.TeamId);
cmd.Parameters.AddWithValue("@Client_ID", _team.ClientId);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception e)
{
SqlConnect.Connection.Close();
throw (e);
}
}
public ActionResult ReadTeamByID(TeamsDM team)
{
return(View(Mapper.Map <TeamsVM>(TeamsDAL.ReadTeamById(team.TeamId.ToString()))));
}
