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