Пример #1
0
 public static StrategyModel ToModel(this StrategyEntity SE)
 {
     if (SE != null)
     {
         BossesPerZoneRepository           repoBZ = new BossesPerZoneRepository();
         CharactersConfigurationRepository repoCC = new CharactersConfigurationRepository();
         UserRepository repoU = new UserRepository();
         StrategyModel  SM    = new StrategyModel();
         SM.User = repoU.GetOne(SE.UserId).MapTo <UserModel>();
         SM.CharactersConfiguration = repoCC.GetOne(SE.CharactersConfigurationId).ToModel();
         SM.BossZone    = repoBZ.GetOne(SE.BossZoneId).ToModel();
         SM.ImagePath1  = SE.ImagePath1;
         SM.ImagePath2  = SE.ImagePath2;
         SM.ImagePath3  = SE.ImagePath3;
         SM.ImagePath4  = SE.ImagePath4;
         SM.Description = SE.Description;
         SM.Note        = SE.Note;
         SM.Id          = SE.Id;
         SM.Active      = SE.Active;
         return(SM);
     }
     else
     {
         return(null);
     }
 }
 public void Update(int Id, StrategyEntity T)
 {
     using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString))
     {
         using (SqlCommand cmd = c.CreateCommand())
         {
             if (T != null && T.ImagePath1 != null && T.ImagePath2 != null && T.ImagePath3 != null && T.ImagePath4 != null && T.CharactersConfigurationId != 0 && T.BossZoneId != 0 && T.UserId != 0 && Id != 0)
             {
                 cmd.CommandText = "SP_UpdateStrategy";
                 cmd.CommandType = CommandType.StoredProcedure;
                 SqlParameter BossZoneId = new SqlParameter("BossZoneId", T.BossZoneId);
                 SqlParameter CharactersConfigurationId = new SqlParameter("CharactersConfigurationId", T.CharactersConfigurationId);
                 SqlParameter ImagePath1 = new SqlParameter("ImagePath1", T.ImagePath1);
                 SqlParameter ImagePath2 = new SqlParameter("ImagePath2", T.ImagePath2);
                 SqlParameter ImagePath3 = new SqlParameter("ImagePath3", T.ImagePath3);
                 SqlParameter ImagePath4 = new SqlParameter("ImagePath4", T.ImagePath4);
                 SqlParameter Note       = new SqlParameter("Note", T.Note);
                 SqlParameter UserId     = new SqlParameter("UserId", T.UserId);
                 SqlParameter PId        = new SqlParameter("Id", Id);
                 cmd.Parameters.Add(BossZoneId);
                 cmd.Parameters.Add(CharactersConfigurationId);
                 cmd.Parameters.Add(ImagePath1);
                 cmd.Parameters.Add(ImagePath2);
                 cmd.Parameters.Add(ImagePath3);
                 cmd.Parameters.Add(ImagePath4);
                 cmd.Parameters.Add(Note);
                 cmd.Parameters.Add(UserId);
                 cmd.Parameters.Add(PId);
                 c.Open();
                 cmd.ExecuteNonQuery();
             }
         }
     }
 }
Пример #3
0
        public void DependOnStrategy()
        {
            StrategyEntity strategy = Factory.GetStrategyEntity();

            bool result = TestObject.AddDependency(strategy);

            Assert.IsFalse(result, "Should not be able to depend on other Strategy entities.");
        }
 public static StrategyEntity ToEntity(this StrategyModel SM)
 {
     if (SM != null)
     {
         StrategyEntity SE = new StrategyEntity();
         SE.UserId = SM.User.Id;
         SE.CharactersConfigurationId = SM.CharactersConfiguration.Id;
         SE.BossZoneId = SM.BossZone.Id;
         SE.ImagePath1 = SM.ImagePath1;
         SE.ImagePath2 = SM.ImagePath2;
         SE.ImagePath3 = SM.ImagePath3;
         SE.ImagePath4 = SM.ImagePath4;
         SE.Note       = SM.Note;
         SE.Id         = SM.Id;
         SE.Active     = SM.Active;
         return(SE);
     }
     else
     {
         return(null);
     }
 }
 public StrategyEntity GetOne(int id)
 {
     using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString))
     {
         using (SqlCommand cmd = c.CreateCommand())
         {
             cmd.CommandText = "SELECT * FROM Strategies WHERE Id = @Id AND Active = 1";
             cmd.Parameters.AddWithValue("Id", id);
             c.Open();
             using (SqlDataReader Tab = cmd.ExecuteReader())
             {
                 if (Tab.Read())
                 {
                     StrategyEntity S = new StrategyEntity()
                     {
                         Id         = (int)Tab["Id"],
                         BossZoneId = (int)Tab["BossZoneId"],
                         CharactersConfigurationId = (int)Tab["CharactersConfigurationId"],
                         ImagePath1 = Tab["ImagePath1"].ToString(),
                         ImagePath2 = Tab["ImagePath2"].ToString(),
                         ImagePath3 = Tab["ImagePath3"].ToString(),
                         ImagePath4 = Tab["ImagePath4"].ToString(),
                         UserId     = (int)Tab["UserId"],
                         Note       = (int)Tab["Note"],
                         Active     = (int)Tab["Active"]
                     };
                     return(S);
                 }
                 else
                 {
                     return(null);
                 }
             }
         }
     }
 }
Пример #6
0
 public void Update(StrategyEntity item)
 {
     _strategies.RemoveAll(dto => dto.Id == item.Id);
     _strategies.Add(item);
 }
Пример #7
0
 public void Create(StrategyEntity item)
 {
     _strategies.Add(item);
 }
Пример #8
0
 public void Initialise()
 {
     TestObject = Factory.GetStrategyEntity();
     Assert.IsNotNull(TestObject, "Failed to instantiate TestObject.");
 }