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