private void BtnRemove_Click(object sender, RoutedEventArgs e)
{
var item = (sender as FrameworkElement).DataContext;
int index = ListPayments.Items.IndexOf(item);
DataRowView row = ListPayments.Items.GetItemAt(index) as DataRowView;
ConfirmForm c = new ConfirmForm("Cette Dépense Sera Définitivement Supprimée, Voulez Vous Vraiment Continuer?");
c.Owner = this;
this.Opacity = 0.5;
this.Effect = new BlurEffect();
if ((bool)c.ShowDialog())
{
cn.Open();
cmd.Connection = cn;
cmd.CommandText = "delete from Payments where IdPayment = '" + row.Row[0].ToString() + "'";
cmd.ExecuteNonQuery();
cn.Close();
messageContent.Text = "Paiement Bien Supprimée";
animateBorder(borderMessage);
ajouter.Content = "Ajouter";
NomTextBox.Text = null;
PrixTextBox.Text = null;
ListPayments.UnselectAll();
loaded();
}
coutItems();
this.Opacity = 1;
this.Effect = null;
}
public async Task <IActionResult> ListAsync(DateTime?start = null, DateTime?end = null, int startIndex = 0, int pageSize = 30)
{
if (start == null)
{
start = DateHelpers.MonthStart();
}
if (end == null)
{
end = DateHelpers.MonthEnd();
}
startIndex = Math.Max(startIndex, 0);
pageSize = Math.Min(pageSize, 100);
var query = new ListPayments(start.Value, end.Value, new Paging(startIndex, pageSize));
var result = await queries.RunAsync(query);
return(Ok(result));
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (ajouter.Content.ToString() == "Nouveau")
{
ajouter.Content = "Ajouter";
NomTextBox.Text = null;
PrixTextBox.Text = null;
ListPayments.UnselectAll();
}
else if (ajouter.Content.ToString() == "Ajouter")
{
if (PrixTextBox.Text == "" || NomTextBox.Text == "")
{
messageContent.Text = "Merci De Remplir tous Les Champs";
animateBorder(borderMessage);
}
else
{
try
{
if (ListPayments.SelectedIndex != -1)
{
DataRowView row1 = ListPayments.Items.GetItemAt(0) as DataRowView;
date = DateTime.Parse(row1.Row[4].ToString(), new System.Globalization.CultureInfo("fr"));
}
cn.Open();
cmd.Connection = cn;
cmd.Parameters.Clear();
cmd.CommandText = "insert into Payments values (@a,'" + id.ToString() + "','" + ConnectedSalle.ToString() + "','" + ConnectedSport.ToString() + "','" + double.Parse(PrixTextBox.Text) + "')";
cmd.Parameters.AddWithValue("@a", DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")));
cmd.ExecuteNonQuery();
messageContent.Text = "Paiement Bien Ajoutée";
animateBorder(borderMessage);
if (DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")) > date)
{
cmd.Parameters.Clear();
cmd.CommandText = "update Clients set LastPay = @b where IdClient = '" + id.ToString() + "'";
cmd.Parameters.AddWithValue("@b", DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")));
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
string msg = ex.Message;
MessageForm m = new MessageForm(msg);
m.ShowDialog();
}
finally
{
cn.Close();
loaded();
NomTextBox.Text = null;
PrixTextBox.Text = null;
}
}
}
}
private void Modifier_Click(object sender, RoutedEventArgs e)
{
if (ListPayments.SelectedIndex == -1)
{
messageContent.Text = "Veuillez Sélectionner Une Ligne";
animateBorder(borderMessage);
}
else
{
if (PrixTextBox.Text == "" || NomTextBox.Text == "")
{
messageContent.Text = "Merci De Remplir tous Les Champs";
animateBorder(borderMessage);
}
else
{
try
{
DataRowView row1 = ListPayments.Items.GetItemAt(0) as DataRowView;
DateTime date = DateTime.Parse(row1.Row[4].ToString(), new System.Globalization.CultureInfo("fr"));
int index = ListPayments.SelectedIndex;
DataRowView row = ListPayments.Items.GetItemAt(index) as DataRowView;
int idpay = int.Parse(row.Row[0].ToString());
cn.Open();
cmd.Connection = cn;
cmd.Parameters.Clear();
cmd.CommandText = "update Payments set date_Payment =@a, Prix ='" + double.Parse(PrixTextBox.Text) + "' where IdPayment ='" + idpay + "'";
cmd.Parameters.AddWithValue("@a", DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")));
cmd.ExecuteNonQuery();
messageContent.Text = "Paiement Bien Modifiée";
animateBorder(borderMessage);
if (count == 1)
{
cmd.Parameters.Clear();
cmd.CommandText = "update Clients set LastPay = @b where IdClient = '" + id.ToString() + "'";
cmd.Parameters.AddWithValue("@b", DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")));
cmd.ExecuteNonQuery();
}
else if (DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")) > date)
{
cmd.Parameters.Clear();
cmd.CommandText = "update Clients set LastPay = @c where IdClient = '" + id.ToString() + "'";
cmd.Parameters.AddWithValue("@c", DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")));
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
string msg = ex.Message;
MessageForm m = new MessageForm(msg);
m.ShowDialog();
}
finally
{
cn.Close();
ajouter.Content = "Ajouter";
NomTextBox.Text = null;
PrixTextBox.Text = null;
ListPayments.UnselectAll();
loaded();
}
}
}
coutItems();
}
public void addPaymentToList(Payment p)
{
PaymentViewModel payment = new PaymentViewModel(p);
ListPayments.Add(payment);
}
