public TransactionV SelectTransactionV(string rd) { TransactionV t = null; TransactionV.Select((_t) => { t = _t; }, "RegistrationDate = @rd", 1, ("@rd", rd)); return(t); }
public TransactionControl() { InitializeComponent(); HTransactionV = new TransactionV(Financeiro.Handler); var dt = DateTime.Now.AddMonths(-1); DateIntervalDI.BeginMTB.Text = $"{dt:dd/MM/yy}"; var dt2 = DateTime.Now.AddDays(1); DateIntervalDI.EndMTB.Text = $"{dt2:dd/MM/yy}"; PesquisarB_Click(null, null); }
//public string InsertTransaction(Historico_Consultas consulta) { // Transaction.Title = $"Consulta - {consulta.Paciente}"; // Transaction.Description = $"Funcionário: {consulta.Funcionario}\nEspecilização: {consulta.Especializacao}\nProfissão: {consulta.Profissao}\nRetorno: {consulta.Retorno}"; // Transaction.Amount = consulta.Pago; // Transaction.Date = DateTimeHelper.ToUnixTimestamp(consulta.RealizadoEm); // Transaction.Source = (long)Sources.MySql; // Transaction.Origin = (long)Entities.Paciente; // Transaction.Destination = (long)Entities.Clinica; // var payments = consulta.GetPayment(consulta.ID); // var money = payments.FirstOrDefault(x => x.Item1 == PaymentMethods.Dinheiro); // var debit = payments.FirstOrDefault(x => x.Item1 == PaymentMethods.Debito); // var credit = payments.FirstOrDefault(x => x.Item1 == PaymentMethods.Credito); // return Transaction.Insert(money.Item2, debit.Item2, credit.Item2, 1); //} public string InsertTransaction(TransactionV tranV) { Transaction.Title = tranV.Title; Transaction.Description = tranV.Description; Transaction.Date = tranV.Date; Transaction.Origin = tranV.Origin; Transaction.Destination = tranV.Destination; Transaction.Amount = tranV.Amount; Transaction.Category = tranV.Category; var pm = SelectTransactionPayment(tranV.RegistrationDate); var money = pm.FirstOrDefault(x => x.Item1 == PaymentMethods.Dinheiro); var debit = pm.FirstOrDefault(x => x.Item1 == PaymentMethods.Debito); var credit = pm.FirstOrDefault(x => x.Item1 == PaymentMethods.Credito); return(Transaction.Insert(money.Item2, debit.Item2, credit.Item2, 1)); }
public SqliteFinanceiro(string db_path = "db.db") { if (!db_path.Contains(@"\")) { db_path = AppDomain.CurrentDomain.BaseDirectory + @"\" + db_path; } Handler = new SqliteHandler(db_path); if (!File.Exists(db_path)) { Handler.NonQuery(Properties.Resources.DatabaseCreation); Handler.NonQuery(Properties.Resources.InitialData); } Transaction = new Transaction(Handler); TransactionPayment = new TransactionPayment(Handler); SimpleTableManager = new SimpleTableManager(Handler); ToUpload = new ToUpload(Handler); TransactionV = new TransactionV(Handler); }
public InsertTransaction(TransactionV selection = null) { InitializeComponent(); var dt_tb = new CustomDateTimeTB(); dt_tb.ApplyMask(DateMTB); ProvedorCE.RegistrationDate = 1; if (selection != null) { TransactionV = selection; TitleTB.Text = selection.Title; //DateMTB.Mask = "################"; DateMTB.Text = selection.DateStr; //DateMTB.Mask = "00/00/00 00:00"; var payments = Financeiro.SelectTransactionPayment(selection.RegistrationDate); foreach (var(payment, amount) in payments) { switch (payment) { case PaymentMethods.Dinheiro: DinheiroTB.Text = amount + ""; break; case PaymentMethods.Debito: DebitoTB.Text = amount + ""; break; case PaymentMethods.Credito: CreditoTB.Text = amount + ""; break; } } ParcelasTB.Text = "1"; ProvedorCE.RegistrationDate = selection.Origin; DestinatarioCE.RegistrationDate = selection.Destination; DescriptionTB.Text = selection.Description; InserirB.Content = "Editar"; } }