private void Updates()
{
AddTransaction atd = new AddTransaction();
Tran tran = new Tran();
if (AmmountTextBox.Text.ToString() == "")
{
MessageBox.Show("Enter Ammount");
}
else if (dateTextBox.Text.ToString() == "")
{
MessageBox.Show("Enter Date");
}
else
{
tran.Id = Convert.ToInt32(deleteCompanygridview.CurrentRow.Cells[4].Value.ToString());
tran.Ammount = AmmountTextBox.Text.ToString();
tran.AgentName = AgentNameComboBox.Text.ToString();
tran.Date = dateTextBox.Text.ToString();
tran.BankName = DetailsTextBox1.Text.ToString();
TransactionsServices transervices = new TransactionsServices();
if (transervices.Update(tran) == 1)
{
MessageBox.Show("Successfull Updated");
}
}
}
private void Add()
{
id = id + 1;
Tran tran = new Tran();
if (AmmountTextBox.Text.ToString() == "")
{
MessageBox.Show("Enter Ammount");
}
else if (dateTextBox.Text.ToString() == "")
{
MessageBox.Show("Enter Date");
}
else
{
tran.Id = id;
tran.Ammount = AmmountTextBox.Text.ToString();
tran.AgentName = AgentNameComboBox.Text.ToString();
tran.Date = dateTextBox.Text.ToString();
tran.BankName = DetailsTextBox1.Text.ToString();
TransactionsServices transervices = new TransactionsServices();
if (transervices.Add(tran) == 1)
{
MessageBox.Show("Insert Successfull");
}
}
}
private void deleteCompanygridview_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
Tran trans = new Tran();
TransactionsServices transervices = new TransactionsServices();
String companyId = deleteCompanygridview.CurrentRow.Cells[4].Value.ToString();
int c_id = Convert.ToInt32(companyId);
trans.Id = c_id;
if (transervices.Remove(trans) == 1)
{
MessageBox.Show("Successfully Deleted");
}
}
void showAllByAgentName()
{
Tran trans = new Tran();
List <Tran> transactionlist;
TransactionsServices transactionsServices = new TransactionsServices();
String agentname = viewtransactiongridview.CurrentRow.Cells[1].Value.ToString();
trans.AgentName = agentname;
transactionlist = transactionsServices.GetListByAgent(trans);
viewByAgentGridView.DataSource = transactionlist;
//viewByAgentGridView.Columns[1].Width = 200;
//viewByAgentGridView.Columns[1].HeaderText = "Ammount";
//viewByAgentGridView.Columns[2].Width = 200;
//viewByAgentGridView.Columns[2].HeaderText = "Date";
//viewByAgentGridView.Columns[0].Visible = false;
// viewByAgentGridView.Columns[3].Visible = false;
//viewByAgentGridView.Columns[4].Visible = false;
}
public BalanceListingModel GetBalances()
{
BalanceListingModel model = new BalanceListingModel();
DebtCardsListingModel debtsCardModel = new DebtCardsListingModel();
DebtCardServices debtCardServices = new DebtCardServices();
TransactionsServices transactionsServices = new TransactionsServices();
float countRemaningLimit = 0;
var context = new HBMContext();
float incomes = 0, expenses = 0;
int valueCompare = 0;
debtsCardModel.DebtCards = debtCardServices.GetAllDebtCards();
debtsCardModel.Transactions = transactionsServices.GetAllTransactions();
DateTime now = DateTime.Today;
DateTime searchTermStart = new DateTime(now.Year, now.Month, 1);
foreach (var transactions in context.Transactions)
{
valueCompare = DateTime.Compare(transactions.Date, (DateTime)now);
if (valueCompare <= 0)
{
valueCompare = DateTime.Compare((DateTime)searchTermStart, transactions.Date);
{
if (valueCompare <= 0) //daty zgodne
{
if (transactions.Budgets.KBudgetID == 1)
{
incomes += transactions.Price;
}
else
{
expenses += transactions.Price;
}
}
}
}
}
foreach (var debts in debtsCardModel.DebtCards)
{
float remaning = debts.Limit;
foreach (var transactionsDebts in debtsCardModel.Transactions)
{
valueCompare = DateTime.Compare(transactionsDebts.Date, (DateTime)now);
if (valueCompare <= 0)
{
valueCompare = DateTime.Compare((DateTime)searchTermStart, transactionsDebts.Date);
{
if (valueCompare <= 0) //daty zgodne
{
if (transactionsDebts.BudgetsName == debts.Name)
{
remaning -= transactionsDebts.Price;
debts.Price = remaning;
}
}
}
}
}
model.DebtCardRemaning = debts.Limit - remaning;
countRemaningLimit += model.DebtCardRemaning;
}
model.Incomes = incomes;
model.Expenses = expenses;
model.DebtCardRemaning = countRemaningLimit;
return(model);
}
