public Form2()
{
InitializeComponent();
panelMainDashboard.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainPaySomething.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainSendMail.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainSettings.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainTransfer.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainDashboard.Visible = true;
panelMainPaySomething.Visible = false;
panelMainSendMail.Visible = false;
panelMainTransfer.Visible = false;
panelMainSettings.Visible = false;
pictureFailed.Visible = false;
pictureValid.Visible = false;
lastMenupanel = panelMainDashboard;
UIDashboardAccountFrame.generateDashboard(ibanList, panelMainDashboard, exchangeTbl);
labelLastName.Text = DataManagement.getLastName();
using (var context = new MitBankDBEntities2())
{
var result2 = context.getLastLogin(DataManagement.getIdUsername());
foreach (var item in result2)
{
labelLastLogin.Text = item.ToString();
}
}
}
private void label11_Click(object sender, EventArgs e)
{
using (var context = new MitBankDBEntities())
{
var result = context.insertLastLogin(DataManagement.getIdUsername(), DateTime.Now.ToString());
}
Application.Exit();
}
public Form2()
{
InitializeComponent();
panelMainDashboard.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainPaySomething.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainSendMail.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainSettings.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainTransfer.BackColor = System.Drawing.Color.FromArgb(100, 100, 40);
panelMainDashboard.Visible = true;
panelMainPaySomething.Visible = false;
panelMainSendMail.Visible = false;
panelMainTransfer.Visible = false;
panelMainSettings.Visible = false;
pictureFailed.Visible = false;
pictureValid.Visible = false;
lastMenupanel = panelMainDashboard;
UIDashboardAccountFrame.generateDashboard(ibanList, panelMainDashboard, exchangeTbl);
labelLastName.Text = DataManagement.getLastName();
using (var context = new MitBankDBEntities())
{
var result2 = context.getLastLogin(DataManagement.getIdUsername());
foreach (var item in result2)
{
labelLastLogin.Text = item.ToString();
}
}
labelChangeEmail.Visible = false;
textBoxChangeEmail.Visible = false;
using (var context = new MitBankDBEntities())
{
var result = context.selectOnIndividuals(DataManagement.getIdUsername()).ToArray();
foreach (var items in result)
{
labelLastNameSettings.Text = items.LastName;
labelFirstNameSettings.Text = items.FirstName;
labelEmailSettings.Text = items.Email;
labelBirthdateSettings.Text = items.Birthday.ToShortDateString();
int idInd = items.ID;
}
}
}
private void logoutButton_Click(object sender, EventArgs e)
{
var result = MessageBox.Show("Are you sure?", "Info",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
using (var context = new MitBankDBEntities())
{
var result2 = context.insertLastLogin(DataManagement.getIdUsername(), DateTime.Now.ToString());
}
this.Hide();
Form1 frm = new Form1();
this.Refresh();
this.Invalidate();
frm.Refresh();
frm.Invalidate();
frm.Show();
}
}
private void buttonGenerateHistoryTranz_Click(object sender, EventArgs e)
{
char delim = ';';
DataTable tb = new DataTable();
DataColumn ordId = new DataColumn("IdTranzaction");
ordId.DataType = typeof(int);
tb.Columns.Add(ordId);
DataColumn usAccount = new DataColumn("UserId");
usAccount.DataType = typeof(string);
usAccount.MaxLength = 100;
tb.Columns.Add(usAccount);
DataColumn fAccount = new DataColumn("From Account");
fAccount.DataType = typeof(string);
fAccount.MaxLength = 100;
tb.Columns.Add(fAccount);
DataColumn tAccount = new DataColumn("To Account");
tAccount.DataType = typeof(string);
tAccount.MaxLength = 100;
tb.Columns.Add(tAccount);
DataColumn typeTranz = new DataColumn("Type Transaction");
typeTranz.DataType = typeof(string);
typeTranz.MaxLength = 100;
tb.Columns.Add(typeTranz);
DataColumn val = new DataColumn("Value");
val.DataType = typeof(float);
tb.Columns.Add(val);
DataColumn dateTrans = new DataColumn("Date");
dateTrans.DataType = typeof(DateTime);
tb.Columns.Add(dateTrans);
DataColumn tipTranz = new DataColumn("Type Trnsaction");
tipTranz.DataType = typeof(string);
tb.Columns.Add(tipTranz);
using (var context = new MitBankDBEntities())
{
var result = context.HistoryTransactionProc(DataManagement.getIdUsername()).ToArray();
foreach (var items in result)
{
if (items.TypeTransaction.Value == 4)
{
tb.Rows.Add(items.ID, items.UserAccountID, items.fromAccount, items.toWichAccount, items.TypeTransaction
, items.Value, items.DateTransaction, "transfer");
}
else
{
if (items.TypeTransaction.Value == 3)
{
tb.Rows.Add(items.ID, items.UserAccountID, items.fromAccount, items.toWichAccount, items.TypeTransaction
, items.Value, items.DateTransaction, "pay bill");
}
}
}
StringBuilder sb = new StringBuilder();
foreach (DataRow row in tb.Rows)
{
string[] fields = row.ItemArray.Select(field => field.ToString()).
ToArray();
sb.AppendLine(string.Join(",", fields));
}
if (comboBoxTakeFormat.SelectedItem == "Excel Format")
{
WriteToExcel(tb, "C:\\Users\\" + Environment.UserName + "\\Desktop\\History Transaction " + DataManagement.getLastName() + ".xlsx");
MessageBox.Show("It`s saved. Please see file on desktop!");
}
else
if (comboBoxTakeFormat.SelectedItem == "CSV Format")
{
File.WriteAllText("C:\\Users\\" + Environment.UserName + "\\Desktop\\History Transaction " + DataManagement.getLastName() + ".csv", sb.ToString());
MessageBox.Show("It`s saved. Please see file on desktop!");
}
}
//order.Rows.Add("O9876", 10, 2001);
}