private void data(PlaineModel plaineModel)
{
plaineModel.DateDebut = DTP_Start.Value.ToShortDateString().Trim();
plaineModel.DateFin = DTP_Stop.Value.ToShortDateString().Trim();
plaineModel.Nom = TB_NomPlaine.Text.Trim();
this.plaines = plaineModel;
}
public static void NewWeek(PlaineModel plaineModel)
{
using (SQLiteConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
string Query = @"Insert into Plaine (Nom,DateDebut,DateFin) values (@NOM,@DATEDEBUT,@DATEFIN)";
cnn.Execute(Query, plaineModel);
}
}
public static void UpdatePlaine(PlaineModel plaineModel)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
string Query = @"UPDATE Plaine SET Nom = @NOM, DateDebut=@DATEDEBUT, DateFin=@DATEFIN" +
" Where Id = @ID;";
cnn.Execute(Query, plaineModel);
}
}
internal static void DeletePlaine(PlaineModel plaine)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
string Query1 = $"DELETE from Enfant where PlaineID = {plaine.Id}";
string Query2 = $"DELETE from Plaine where ID = {plaine.Id}";
cnn.Execute(Query1);
cnn.Execute(Query2);
}
}
public static void SavePlaine(PlaineModel plaineModel)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
string Query = @"INSERT INTO Plaine (Nom,DateDebut,DateFin)" +
"values (@NOM,@DATEDEBUT,@DATEFIN)";
cnn.Execute(Query, plaineModel);
}
}
public Newweek(PlaineModel plaine)
{
this.modif = true;
InitializeComponent();
this.plaines = plaine;
DTP_Start.Value = Convert.ToDateTime(plaines.DateDebut);
DTP_Stop.Value = Convert.ToDateTime(plaines.DateFin);
TB_NomPlaine.Text = plaines.Nom;
}
private void savePlaine()
{
try
{
if (modif)
{
data(plaines);
SQLclass.SqlManager.UpdatePlaine(this.getplaine());
}
else
{
PlaineModel chillModel = new PlaineModel();
data(chillModel);
SQLclass.SqlManager.SavePlaine(this.getplaine());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
