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