private void OverviewShowContent()
{
this.tabControl1.SelectedTab = this.OverviewTab;
this.FilterAllBtn.Checked = true;
this.FilterYearlyBtn.Checked = false;
this.FilterMonthlyBtn.Checked = false;
this.FilterDailyBtn.Checked = false;
//INCOME_EXPENSE
IncomeChartAllLoading();
//CATEGOGY
CategoryAllLoading();
//TODAY TRANSACTION
Connection.Connect();
try
{
DateTime today = DateTime.Now;
SqlDataReader reader = Connection.Select($"SELECT * FROM transactions JOIN categogies ON transactions.categogyName = categogies.categogyName WHERE username = '******' AND transactionTime = '{today.ToString("yyyy-MM-dd")}'");
if (reader.HasRows)
{
this.TodayTransactionPanel.Controls.Clear();
}
while (reader.Read())
{
TransactionModel transactionModel = new TransactionModel();
transactionModel.Username = (string)reader["username"];
transactionModel.WalletName = (string)reader["walletName"];
transactionModel.Type = (string)reader["transactionType"];
transactionModel.Value = (double)reader["transactionValue"];
transactionModel.Note = (string)reader["transactionNote"];
OverviewWallet transaction = new OverviewWallet(transactionModel.Type, this.user);
transaction.Value.Text = String.Format("{0:n0}", transactionModel.Value);
transaction.Wallet.Text = transactionModel.WalletName;
transaction.Categogy.Image = ImageProccess.ByteToImage((byte[])reader["categogyImage"]);
transaction.MouseClick += TransactionMenu_Click;
this.TodayTransactionPanel.Controls.Add(transaction);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Connection.Close();
}
private void TransactionShowContent()
{
this.TransactionContainer.Controls.Clear();
TransactionContainer.AutoScroll = false;
TransactionContainer.HorizontalScroll.Enabled = false;
TransactionContainer.HorizontalScroll.Visible = false;
TransactionContainer.HorizontalScroll.Maximum = 0;
TransactionContainer.AutoScroll = true;
Connection.Connect();
SqlDataReader reader = Connection.Select($"SELECT * FROM transactions JOIN categogies ON transactions.categogyName = categogies.categogyName WHERE username = '******' ORDER BY transactionTime DESC");
try
{
while (reader.Read())
{
TransactionModel transactionModel = new TransactionModel();
transactionModel.Username = (string)reader["username"];
transactionModel.WalletName = (string)reader["walletName"];
transactionModel.Type = (string)reader["transactionType"];
transactionModel.Value = (double)reader["transactionValue"];
transactionModel.Note = (string)reader["transactionNote"];
string date1 = reader.GetDateTime(7).ToString("yyyy-MM-dd");
transactionModel.Time = DateTime.Parse(date1);
Transaction transaction = new Transaction(transactionModel.Type, this.user);
transaction.Value.Text = String.Format("{0:n0}", transactionModel.Value);
transaction.id = (int)reader["id"];
transaction.Wallet.Text = transactionModel.WalletName;
transaction.note = (string)reader["transactionNote"];
transaction.Time.Text = transactionModel.Time.ToString("dd-MM-yyyy");
transaction.Categogy.Image = ImageProccess.ByteToImage((byte[])reader["categogyImage"]);
transaction.MouseClick += ModifyTransaction;
this.TransactionContainer.Controls.Add(transaction);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Connection.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
Connection.Connect();
SqlDataReader reader = Connection.Select("SELECT * FROM categogies");
try
{
while (reader.Read())
{
PictureBox pic = new PictureBox();
pic.Image = ImageProccess.ByteToImage((byte[])reader["categogyImage"]);
pic.Name = (string)reader["categogyName"];
pic.Cursor = Cursors.Hand;
pic.MouseClick += new MouseEventHandler(GetName);
this.flowLayoutPanel1.Controls.Add(pic);
}
Connection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void SubmitBtn_Click(object sender, EventArgs e)
{
if (valid())
{
this.wallet = new WalletModel(this.WalletName.Text, (double)this.Amount.Value, ImageProccess.ImageToByte(icon));
this.DialogResult = DialogResult.OK;
}
else
{
this.DialogResult = DialogResult.None;
}
}