private static Label getPacketLabel(string iban) { Label date = new Label(); date.Text = DataManagement.getIbanPacket(iban); switch (date.Text.Trim()) { case "STUDENT PE+": date.Font = new Font("Comic Sans MS", 12, FontStyle.Regular); date.ForeColor = Color.YellowGreen; break; case "GOLD PE+": date.Font = new Font("Times New Roman", 12, FontStyle.Regular); date.ForeColor = Color.Yellow; break; default: date.Font = new Font("Century Ghotic", 10, FontStyle.Regular); break; } //position date.Top = 30; date.Left = 10; date.AutoSize = false; date.Size = new Size(200, 50); return(date); }
public static Label getExchangeTable() { Label lb = new Label(); // text lb.ForeColor = Color.FromArgb(255, 255, 240); lb.Font = new Font("Century Ghotic", 15, FontStyle.Bold); //position lb.Top = 20; lb.Left = 540; lb.AutoSize = false; lb.Size = new Size(170, 170); lb.BackColor = Color.FromArgb(30, 35, 35); List <string> list = DataManagement.getExchange().Split(' ').ToList(); lb.Controls.Add(getLabelInTable(1, 2, "BUY")); lb.Controls.Add(getLabelInTable(1, 3, "SELL")); int top = 2, left = 1; foreach (string str in list) { lb.Controls.Add(getLabelInTable(top, left, str)); left++; if (left > 3) { left = 1; top++; } } return(lb); }
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 loginButon_Click(object sender, EventArgs e) { Properties.Settings.Default.Reload(); string pass = DataManagement.getPass(passwordLoginTxtbox.Text); if (DataManagement.tryConnection(usernameLoginTxtbox.Text, pass)) { this.Visible = false; this.Hide(); if (isAdmin) { FormAdmin frm = new FormAdmin(); frm.Show(); isAdmin = false; } else { Form2 frm = new Form2(); frm.Show(); } } else { MessageBox.Show("Conexiunea nu se poate stabili!"); } }
private void comboBoxSelectTransfer_SelectedIndexChanged(object sender, EventArgs e) { comboBoxToTransferMyIBAN.Items.Clear(); if (comboBoxSelectTransfer.Text.ToString() == "My another account") { label12.Visible = false; textBoxWriteIBAN.Visible = false; comboBoxToTransferMyIBAN.Visible = true; List <Page> lp = new List <Page>(); lp = DataManagement.getIbanList(); foreach (var item in lp) { int index = -1; index = comboBoxToTransferMyIBAN.FindString(item.Data.ToString()); if (index == -1 && item.Data.ToString() != comboBoxIBAN.Text.ToString()) { comboBoxToTransferMyIBAN.Items.Add(item.Data.ToString()); } } } else { label12.Visible = true; comboBoxToTransferMyIBAN.Visible = false; textBoxWriteIBAN.Visible = true; labelcurrencyToIban.Text = "-"; } }
private void bunifuFlatButton3_Click(object sender, EventArgs e) { lastMenupanel.Visible = false; panelMainTransfer.Visible = true; lastMenupanel.SendToBack(); lastMenupanel = panelMainTransfer; using (var context = new MitBankDBEntities2()) { List <Page> listIban = new List <Page>(); listIban = DataManagement.getIbanList(); foreach (var item in listIban) { int index = -1; index = comboBoxIBAN.FindString(item.Data.ToString()); if (index == -1) { comboBoxIBAN.Items.Add(item.Data.ToString()); } } if (listIban.Count() != 0) { comboBoxIBAN.SelectedIndex = 0; comboBoxSelectTransfer.SelectedIndex = 0; } } }
private void label11_Click(object sender, EventArgs e) { using (var context = new MitBankDBEntities()) { var result = context.insertLastLogin(DataManagement.getIdUsername(), DateTime.Now.ToString()); } Application.Exit(); }
private void buttonAddInd_Click(object sender, EventArgs e) { if (textPassword.Text != textPassword2.Text) { MessageBox.Show("parolele nu coincid!"); return; } string username = this.textUsername.Text; string password = DataManagement.getPass(this.textPassword.Text); if (radioIndivid.Checked) { var individ = new Individual { FirstName = this.textFirstName.Text, LastName = this.textLastName.Text, Email = this.textEmail.Text, Birthday = new DateTime( Int32.Parse(this.comboYear.Text), Int32.Parse(this.comboMonth.Text), Int32.Parse(this.comboDay.Text) ), CNP = this.textCNP.Text, }; DataManagement.addIndividualCustomer(individ, username, password); } else { var individ = new Individual { FirstName = this.textFirstName.Text, LastName = this.textLastName.Text, Email = this.textEmail.Text, Birthday = new DateTime( Int32.Parse(this.comboYear.Text), Int32.Parse(this.comboMonth.Text), Int32.Parse(this.comboDay.Text) ), CNP = this.textCNP.Text, }; var company = new Company { CIF = Int32.Parse(this.textCif.Text), Name = this.textCompany.Text, Address = this.textAddress.Text }; DataManagement.addCompany(individ, company, username, password); } }
private void comboBoxIBAN_SelectedIndexChanged(object sender, EventArgs e) { Page pg = DataManagement.getSold(comboBoxIBAN.SelectedItem.ToString()); labelshowsold.Text = pg.Data; Page pg2 = DataManagement.getCurrency(comboBoxIBAN.SelectedItem.ToString()); labelshowcurrency.Text = pg2.Data; comboBoxToTransferMyIBAN.Refresh(); comboBoxSelectTransfer.SelectedIndex = -1; }
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 static Label getCurrencyLabel(string iban) { Label currency = new Label(); currency.Text = DataManagement.getIbanCurrency(iban); currency.ForeColor = Color.Yellow; currency.Font = new Font("Century Ghotic", 25, FontStyle.Bold); //position currency.Top = 40; currency.Left = 400; currency.AutoSize = false; currency.Size = new Size(200, 50); return(currency); }
private static Label getSoldLabel(string iban) { Label sold = new Label(); sold.Text = DataManagement.getIbanSold(iban); sold.ForeColor = Color.FromArgb(255, 255, 240); sold.Font = new Font("Century Ghotic", 18, FontStyle.Bold); sold.TextAlign = ContentAlignment.TopRight; //position sold.Top = 47; sold.Left = 250; sold.AutoSize = false; sold.Size = new Size(150, 50); return(sold); }
private static Label getDateLabel(string iban) { Label date = new Label(); date.Text = "Valid until "; date.Text += DataManagement.getIbanDate(iban).Substring(0, 9); date.ForeColor = Color.FromArgb(255, 255, 240); date.Font = new Font("Century Ghotic", 8, FontStyle.Italic); //position date.Top = 70; date.Left = 10; date.AutoSize = false; date.Size = new Size(200, 50); return(date); }
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(); } }
public static void generateDashboard(List <Label> ibanList, Panel panelMainDashboard, Label exchangeTbl) { ibanList.Clear(); int i = 0; List <string> list = DataManagement.getDashboardInfo(); foreach (string iban in list) { var context = new MitBankDBEntities(); Label lb = UIDashboardAccountFrame.createFrame(iban, i); i++; ibanList.Add(lb); } foreach (Label lb in ibanList) { panelMainDashboard.Controls.Add(lb); lb.BringToFront(); } exchangeTbl = UIDashboardAccountFrame.getExchangeTable(); panelMainDashboard.Controls.Add(exchangeTbl); }
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); }
private void button1_Click(object sender, EventArgs e) { PdfDocument document = new PdfDocument(); document.Info.Title = "Account request informations"; // Create an empty page PdfPage page = document.AddPage(); // Get an XGraphics object for drawing XGraphics gfx = XGraphics.FromPdfPage(page); // Create a font XFont font = new XFont("Verdana", 11, XFontStyle.Regular); // Draw the text string infoBank = "MITBank Society, Military Technical Academy"; string infoBank2 = "Sucursala Bucuresti, Sector 4"; string text1 = "Extras de cont din " + DateTime.Now.ToString(); string text2 = " Conform dispozitiilor in vigoare, va instiintăm ca, in evidenţele"; string text3 = "noastre contabile, la data de ............., unitatea dvs. figurează"; string text4 = "cu următoarele conturi................................................"; string text5 = "Conturi curente "; gfx.DrawString(infoBank, font, XBrushes.Black, new XRect(10, 0, page.Width, page.Height), XStringFormats.TopLeft); gfx.DrawString(infoBank2, font, XBrushes.Black, new XRect(10, 12, page.Width, page.Height), XStringFormats.TopLeft); gfx.DrawString(text1, font, XBrushes.Black, new XRect(10, 32, page.Width, page.Height), XStringFormats.TopCenter); gfx.DrawString(text2, font, XBrushes.Black, new XRect(10, 60, page.Width, page.Height), XStringFormats.TopLeft); gfx.DrawString(text3, font, XBrushes.Black, new XRect(10, 72, page.Width, page.Height), XStringFormats.TopLeft); gfx.DrawString(text4, font, XBrushes.Black, new XRect(10, 84, page.Width, page.Height), XStringFormats.TopLeft); gfx.DrawString(text5, font, XBrushes.Black, new XRect(10, 100, page.Width, page.Height), XStringFormats.TopCenter); List <string> lc = new List <string>(); lc = DataManagement.getAllInfoAccunts(); string text11 = "ID" + " " + "IBAN" + " " + "Bank Packet" + " " + "VALABILITY" + " " + "SOLD" + " " + "CURRENCY"; gfx.DrawString(text11, font, XBrushes.Black, new XRect(30, 130, page.Width, page.Height), XStringFormats.TopLeft); int x = 160; foreach (string c in lc) { string text0 = c.ToString(); gfx.DrawString(text0, font, XBrushes.Black, new XRect(30, x, page.Width, page.Height), XStringFormats.TopLeft); x += 20; } string text12 = "Pentru mai multe informatii, contactati-ne la 0722222222, director adjunct SSSSSSS SSS"; gfx.DrawString(text12, font, XBrushes.Black, new XRect(30, 300, page.Width, page.Height), XStringFormats.TopLeft); // Save the document... string filename = "Account request " + DataManagement.getLastName(); document.Save(filename); // ...and start a viewer. Process.Start(filename); }
private void buttonSubmitTransfer_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Are you sure?", "Warning", MessageBoxButtons.YesNo); try { if (dialogResult == DialogResult.Yes) { double ValWithouComiss = 0; ValWithouComiss = double.Parse(textoxValueToTransfer.Text); double comiss = 0; comiss = double.Parse(labelComisionValue.Text); double valToTransfer = 1; if (labelExchangeValue.Text != "-") { valToTransfer = double.Parse(labelExchangeValue.Text); } double getsold = 0; if (labelComisionValue.Text != "-") { using (var context = new MitBankDBEntities()) { var result = DataManagement.getSold(comboBoxIBAN.SelectedItem.ToString()); getsold = double.Parse(result.Data); } if (getsold > (ValWithouComiss + comiss)) { using (var context = new MitBankDBEntities()) { if (comboBoxSelectTransfer.SelectedItem.ToString() == "My another account") { var result = context.transferMoney(comboBoxIBAN.SelectedItem.ToString(), comboBoxToTransferMyIBAN.SelectedItem.ToString(), ((ValWithouComiss + comiss)), valToTransfer); DataManagement.addOnHistory(comboBoxIBAN.SelectedItem.ToString(), comboBoxToTransferMyIBAN.SelectedItem.ToString(), 4, (ValWithouComiss + comiss)); } else if (comboBoxSelectTransfer.SelectedItem.ToString() == "Anyone else account") { var result = context.transferMoney(comboBoxIBAN.SelectedItem.ToString(), textBoxWriteIBAN.Text, ((ValWithouComiss + comiss)), valToTransfer); DataManagement.addOnHistory(comboBoxIBAN.SelectedItem.ToString(), textBoxWriteIBAN.Text, 4, (ValWithouComiss + comiss)); } labelComisionValue.Text = "-"; labelExchangeValue.Text = "-"; MessageBox.Show("Done!"); } } else { MessageBox.Show("You dont have enought money!!!"); } } } } catch (Exception) { MessageBox.Show("Put all informations or something wrong!"); } }
private void textoxValueToTransfer_OnValueChanged(object sender, EventArgs e) { int parsedValue; if (!int.TryParse(textoxValueToTransfer.Text, out parsedValue)) { if (textoxValueToTransfer.Text != "") { MessageBox.Show("Ups! Only numbers"); textoxValueToTransfer.Text = "0"; } } double Val = 0; if (labelshowcurrency.Text != labelcurrencyToIban.Text && labelcurrencyToIban.Text != "-" && textoxValueToTransfer.Text != "") { if (labelshowcurrency.Text == "RON") { double getToConvert = DataManagement.getCurrencyValueBuy(labelcurrencyToIban.Text); Val = double.Parse(textoxValueToTransfer.Text); double exch = Math.Round(Val / getToConvert, 4); labelExchangeValue.Text = exch.ToString(); labelshowToCurrency.Text = labelcurrencyToIban.Text; labelshowFromCurrency.Text = labelshowcurrency.Text; } else if (labelcurrencyToIban.Text == "RON") { double getToConvert = DataManagement.getCurrencyValueBuy(labelshowcurrency.Text); Val = double.Parse(textoxValueToTransfer.Text); labelExchangeValue.Text = (Val * getToConvert).ToString(); labelshowToCurrency.Text = labelcurrencyToIban.Text; labelshowFromCurrency.Text = labelshowcurrency.Text; } else if (labelcurrencyToIban.Text != "RON" && labelshowcurrency.Text != "RON") { double getToConvertFrom = DataManagement.getCurrencyValueBuy(labelshowcurrency.Text); double getToConvertTo = DataManagement.getCurrencyValueBuy(labelcurrencyToIban.Text); Val = double.Parse(textoxValueToTransfer.Text); double exch = Math.Round(Val * getToConvertFrom / getToConvertTo, 2); labelExchangeValue.Text = exch.ToString(); labelshowToCurrency.Text = labelcurrencyToIban.Text; labelshowFromCurrency.Text = labelshowcurrency.Text; } } string fromIBAN = comboBoxIBAN.Text; Page pg = new Page(); ///////////////////make txt for numberrs if (pg.Data != "" && comboBoxIBAN.SelectedIndex != -1) { pg = DataManagement.getComision(fromIBAN.ToString()); } if (textoxValueToTransfer.Text != "" && comboBoxIBAN.SelectedIndex != -1) { Val = double.Parse(textoxValueToTransfer.Text); double comVal = 0; comVal = double.Parse(pg.Data); labelComisionValue.Text = (Val * comVal / 100).ToString(); } else { labelComisionValue.Text = "-"; } }