public FavoriteStrategyEntity GetOne(int id)
{
using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString))
{
using (SqlCommand cmd = c.CreateCommand())
{
cmd.CommandText = "SELECT * FROM FavoriteStrategies WHERE Id = @Id AND Active = 1";
cmd.Parameters.AddWithValue("Id", id);
c.Open();
using (SqlDataReader Tab = cmd.ExecuteReader())
{
if (Tab.Read())
{
FavoriteStrategyEntity S = new FavoriteStrategyEntity()
{
Id = (int)Tab["Id"],
UserId = (int)Tab["UserId"],
StrategyId = (int)Tab["StrategyId"],
Active = (int)Tab["Active"]
};
return(S);
}
else
{
return(null);
}
}
}
}
}
public static FavoriteStrategyEntity ToEntity(this FavoriteStrategyModel FM)
{
if (FM != null)
{
FavoriteStrategyEntity FE = new FavoriteStrategyEntity();
FE.StrategyId = FM.Strategy.Id;
FE.UserId = FM.User.Id;
FE.Id = FM.Id;
FE.Active = FM.Active;
return(FE);
}
else
{
return(null);
}
}
public static FavoriteStrategyModel ToModel(this FavoriteStrategyEntity FE)
{
if (FE != null)
{
StrategyRepository repoEnre = new StrategyRepository();
UserRepository repoUtil = new UserRepository();
FavoriteStrategyModel FM = new FavoriteStrategyModel();
FM.Strategy = repoEnre.GetOne(FE.StrategyId).ToModel();
FM.User = repoUtil.GetOne(FE.UserId).MapTo <UserModel>();
FM.Id = FE.Id;
FM.Active = FE.Active;
return(FM);
}
else
{
return(null);
}
}
public void Create(FavoriteStrategyEntity T)
{
using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString))
{
using (SqlCommand cmd = c.CreateCommand())
{
if (T != null && T.StrategyId != 0 && T.UserId != 0)
{
cmd.CommandText = "SP_AddFavoriteStrategy";
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter StrategyId = new SqlParameter("StrategyId", T.StrategyId);
SqlParameter UserId = new SqlParameter("UserId", T.UserId);
cmd.Parameters.Add(StrategyId);
cmd.Parameters.Add(UserId);
c.Open();
cmd.ExecuteNonQuery();
}
}
}
}
