public CharactersConfigurationEntity GetOne(int id) { using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString)) { using (SqlCommand cmd = c.CreateCommand()) { cmd.CommandText = "SELECT * FROM CharactersConfigurations WHERE Id = @Id AND Active = 1"; cmd.Parameters.AddWithValue("Id", id); c.Open(); using (SqlDataReader Tab = cmd.ExecuteReader()) { if (Tab.Read()) { CharactersConfigurationEntity S = new CharactersConfigurationEntity() { Id = (int)Tab["Id"], ClasseId1 = (int)Tab["ClasseId1"], ClasseId2 = (int)Tab["ClasseId2"], ClasseId3 = (int)Tab["ClasseId3"], ClasseId4 = (int)Tab["ClasseId4"], Active = (int)Tab["Active"] }; return(S); } else { return(null); } } } } }
public void Update(int Id, CharactersConfigurationEntity T) { using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString)) { using (SqlCommand cmd = c.CreateCommand()) { if (T.ClasseId1 != 0 && T.ClasseId2 != 0 && T.ClasseId3 != 0 && T.ClasseId4 != 0 && Id != 0) { cmd.CommandText = "SP_UpdateCharactersConfiguration"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter PId = new SqlParameter("Id", T.Id); SqlParameter ClasseId1 = new SqlParameter("ClasseId1", T.ClasseId1); SqlParameter ClasseId2 = new SqlParameter("ClasseId2", T.ClasseId2); SqlParameter ClasseId3 = new SqlParameter("ClasseId3", T.ClasseId3); SqlParameter ClasseId4 = new SqlParameter("ClasseId4", T.ClasseId4); cmd.Parameters.Add(ClasseId1); cmd.Parameters.Add(ClasseId2); cmd.Parameters.Add(ClasseId3); cmd.Parameters.Add(ClasseId4); cmd.Parameters.Add(PId); c.Open(); cmd.ExecuteNonQuery(); } } } }
public CharactersConfigurationEntity GetCharactersConfigurationByClasses(int C1, int C2, int C3, int C4) { using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString)) { using (SqlCommand cmd = c.CreateCommand()) { //Rework will be needed as it not really fit the need (can be sometimes bad result) string sC1 = ""; string sC2 = ""; string sC3 = ""; string sC4 = ""; if (C1 != 0) { sC1 = $" AND (ClasseId1 = {C1} OR ClasseId2 = {C1} OR ClasseId3 = {C1} OR ClasseId4 = {C1})"; } if (C2 != 0) { sC2 = $" AND (ClasseId1 = {C2} OR ClasseId2 = {C2} OR ClasseId3 = {C2} OR ClasseId4 = {C2})"; } if (C3 != 0) { sC3 = $" AND (ClasseId1 = {C3} OR ClasseId2 = {C3} OR ClasseId3 = {C3} OR ClasseId4 = {C3})"; } if (C4 != 0) { sC4 = $" AND (ClasseId1 = {C4} OR ClasseId2 = {C4} OR ClasseId3 = {C4} OR ClasseId4 = {C4})"; } cmd.CommandText = "SELECT * FROM CharactersConfigurations WHERE Active = 1" + sC1 + sC2 + sC3 + sC4; c.Open(); using (SqlDataReader Tab = cmd.ExecuteReader()) { if (Tab.Read()) { CharactersConfigurationEntity S = new CharactersConfigurationEntity() { Id = (int)Tab["Id"], ClasseId1 = (int)Tab["ClasseId1"], ClasseId2 = (int)Tab["ClasseId2"], ClasseId3 = (int)Tab["ClasseId3"], ClasseId4 = (int)Tab["ClasseId4"], Active = (int)Tab["Active"] }; return(S); } else { return(null); } } } } }
public static CharactersConfigurationEntity ToEntity(this CharactersConfigurationModel CCM) { if (CCM != null) { CharactersConfigurationEntity CCE = new CharactersConfigurationEntity(); CCE.Id = CCM.Id; CCE.ClasseId1 = CCM.Classe1.Id; CCE.ClasseId2 = CCM.Classe2.Id; CCE.ClasseId3 = CCM.Classe3.Id; CCE.ClasseId4 = CCM.Classe4.Id; CCE.Active = CCM.Active; return(CCE); } else { return(null); } }
public static CharactersConfigurationModel ToModel(this CharactersConfigurationEntity CCE) { if (CCE != null) { ClasseRepository repoCl = new ClasseRepository(); CharactersConfigurationModel CCM = new CharactersConfigurationModel(); CCM.Id = CCE.Id; CCM.Classe1 = repoCl.GetOne(CCE.ClasseId1).MapTo <ClasseModel>(); CCM.Classe2 = repoCl.GetOne(CCE.ClasseId2).MapTo <ClasseModel>(); CCM.Classe3 = repoCl.GetOne(CCE.ClasseId3).MapTo <ClasseModel>(); CCM.Classe4 = repoCl.GetOne(CCE.ClasseId4).MapTo <ClasseModel>(); CCM.Active = CCE.Active; return(CCM); } else { return(null); } }