1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| namespace Top_Galop_WebService
{
public class DBLibraryUpdateCommand
{
public DBLibraryUpdateCommand()
{
}
private MySqlCommand m_MySqlCommand = new MySqlCommand("", DBLibraryConnexion.myConnection);
public MySqlCommand UptodateBaseCheval(BaseCheval _m_OBaseCheval, BaseCheval _m_NBaseCheval)
{
[...]
}
public MySqlCommand UptodateCourse(Course _m_OldCourse,Course _m_NewCourse)
{
[...]
}
public MySqlCommand UptodatePerformances(int idCheval,int idCourse, Performance _m_NewPerf)
{
[...]
}
public MySqlCommand UptodateBaseChevalEJP(Performance _m_Performance)
{
m_MySqlCommand.CommandText = string.Format(" UPDATE chevallist Set Entraineur=" + "'" + _m_Performance.Entraineur + "'," + " Jockey=" + "'" + _m_Performance.Jockey + "'," +
" Proprietaire=" + "'" + _m_Performance.Proprietaire + "'" + " WHERE NomCheval=" + "'" +
_m_Performance.Cheval + "'" + "AND IdCheval=" + "'" + _m_Performance.IdCheval + "'");
return m_MySqlCommand;
}
} |
Partager