public static Page getComision(string accNr) { Page pg = new Page(); using (var context = new MitBankDBEntities()) { if (IDSession != 0 && accNr != "") { var result = context.takeComision(4, accNr).ToArray(); foreach (var item in result) { if (item.HasValue == true) { pg.Data = item.ToString(); } else { pg.Data = ""; } } } } return(pg); }
private void bunifuFlatButton3_Click(object sender, EventArgs e) { lastMenupanel.Visible = false; panelMainTransfer.Visible = true; lastMenupanel.SendToBack(); lastMenupanel = panelMainTransfer; using (var context = new MitBankDBEntities()) { 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; } } }
public static bool tryConnection(string username, string password) { using (var context = new MitBankDBEntities()) { if (context.getUandPProcedure(username, password).FirstOrDefault().HasValue) { IDSession = context.getUandPProcedure(username, password).FirstOrDefault().Value; // exemplu de intoarcere parametru din procedura stocata // ObjectParameter output = new ObjectParameter("result", typeof(bool)); context.IsAdmin(IDSession, output); if (Convert.ToBoolean(output.Value)) { Form1.isAdmin = true; } // return(true); } else { return(false); } } }
private void textBoxWriteIBAN_OnValueChanged(object sender, EventArgs e) { string getIBANfromTextBox = textBoxWriteIBAN.Text; Page pg = new Page(); using (var context = new MitBankDBEntities()) { var result = context.getAnyoneCurrency(getIBANfromTextBox).ToArray(); if (result.Length != 0) { pictureValid.Visible = true; pictureFailed.Visible = false; var result2 = context.getAnyoneCurrency(getIBANfromTextBox.ToString()).ToArray(); foreach (var item in result2) { labelcurrencyToIban.Text = item.ToString(); } } else { pictureFailed.Visible = true; pictureValid.Visible = false; labelcurrencyToIban.Text = "-"; } } }
public static List <string> getAllInfoAccunts() { List <string> lc = new List <string>(); using (var context = new MitBankDBEntities()) { var result = context.showAllMyAccounts(IDSession); foreach (var item in result) { var result2 = context.showIBANInformations(item.ToString()).ToArray(); foreach (var item2 in result2) { string info = item.ToString(); info = item2.ID + " " + info + " " + " " + item2.BankPacket + " " + item2.ValabilityUntil + " " + item2.Sold + " " + item2.Currency; lc.Add(info); } } } return(lc); }
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 static string getIbanCurrency(string iban) { using (var context = new MitBankDBEntities()) { var result = context.showIBANInformations(iban).FirstOrDefault(); return(result.Currency.ToString()); } }
public static string getIbanDate(string iban) { using (var context = new MitBankDBEntities()) { var result = context.showIBANInformations(iban).FirstOrDefault(); return(result.ValabilityUntil.ToString()); } }
public static string getIbanPacket(string iban) { using (var context = new MitBankDBEntities()) { var ibanInfo = context.showIBANInformations(iban).FirstOrDefault(); TypeBankingPacket packet = (from c in context.TypeBankingPackets where c.ID == ibanInfo.BankPacket select c).First(); return(packet.NameTypePacket.ToString()); } }
public static void addOnHistory(string userAccountIban, string toWichAccount, int TypeTransaction, double val) { using (var context = new MitBankDBEntities()) { var result = context.addHistoryTransaction(IDSession, userAccountIban , toWichAccount, TypeTransaction, -val, DateTime.Now.ToString()); var result2 = context.addHistoryTransaction(IDSession, toWichAccount, userAccountIban , TypeTransaction, +val, DateTime.Now.ToString()); } }
public static List <string> getDashboardInfo() { List <string> list = new List <string>(); using (var context = new MitBankDBEntities()) { var conturi = context.showAllMyAccounts(IDSession).ToArray(); foreach (var item in conturi) { list.Add(item.ToString()); } } return(list); }
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; } } }
public static double getCurrencyValueSell(string curr) { using (var context = new MitBankDBEntities()) { var exchInfo = from c in context.CurrentCurrencies select c; foreach (var item in exchInfo) { if (item.CurrencyName == curr) { return(item.ValueSel); } } } return(0); }
public static string getLastName() { string lastName = "Guest"; using (var context = new MitBankDBEntities()) { var result = context.selectOnIndividuals(IDSession); foreach (var item in result) { lastName = item.LastName.ToString(); } } return(lastName); }
public static Page getCurrencyAnyone(string iban) { using (var context = new MitBankDBEntities()) { Page pg = new Page(); if (IDSession != 0) { var result = context.getAnyoneCurrency(iban); foreach (var item in result) { pg.Data = item.ToString(); } } return(pg); } }
public static Page getCurrency(string iban) { using (var context = new MitBankDBEntities()) { Page pg = new Page(); if (IDSession != 0) { var result = context.showIBANInformations(iban).ToArray(); foreach (var item in result) { pg.Data = item.Currency.ToString(); } } return(pg); } }
public static string getExchange() { string data = ""; using (var context = new MitBankDBEntities()) { var exchInfo = from c in context.CurrentCurrencies select c; foreach (var item in exchInfo) { data += item.CurrencyName.ToString() + " "; data += item.ValueBuy + " "; data += item.ValueSel + " "; } } return(data); }
private void comboBoxToTransferMyIBAN_SelectedIndexChanged(object sender, EventArgs e) { string currencyFromIBAN = "-"; string currencyToIBAN = "-"; using (var context = new MitBankDBEntities()) { if (comboBoxToTransferMyIBAN.SelectedIndex != -1) { var result = context.getAnyoneCurrency(comboBoxToTransferMyIBAN.Text).ToArray(); foreach (var item in result) { currencyToIBAN = item.ToString(); } labelcurrencyToIban.Text = currencyToIBAN; } } }
public static List <Page> getIbanList() { List <Page> listIban = new List <Page>(); using (var context = new MitBankDBEntities()) { if (IDSession != 0) { var result = context.showAllMyAccounts(IDSession).ToArray(); foreach (var item in result) { Page pg = new Page(); pg.Data = item.ToString(); listIban.Add(pg); } } } return(listIban); }
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 cashDeposit() { using (var context = new MitBankDBEntities()) { // exemplu de utilizare tranzactie din Entity Framework // using (var transaction = context.Database.BeginTransaction()) { try { string iban = "RO93MITB0410120579132411"; int sum = -123; if (sum < 1) { throw new MitException("Poti depune cel putin o unitate monetara"); } var account = context.UserAccounts.Single(obj => obj.AccountNumber.Trim() == iban); if (account != null) { account.Sold += sum; } else { throw new MitException("Cont negasit!"); } transaction.Commit(); MessageBox.Show("depunereNumerar"); } catch (Exception e) { transaction.Rollback(); MessageBox.Show(e.Message); } } } }
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 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!"); } }
public static void addIndividualCustomer(Individual individ, string username, string password) { // Detached Entities // using (var context = new MitBankDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { try { var verificat = from entry in context.Individuals where entry.CNP == individ.CNP select entry; if (!verificat.Any()) { context.Individuals.Add(individ); var customer = new Customer { CustomerType = 1 }; context.Customers.Add(customer); var individualCustomer = new IndividualCustomer { Customer = customer, Individual = individ }; context.IndividualCustomers.Add(individualCustomer); context.SaveChanges(); var uname = new Username { UserType = 1, Username1 = username, Pass = password }; context.Usernames.Add(uname); var normalu = new NormalUser { Username = uname, Customer = customer }; context.NormalUsers.Add(normalu); context.SaveChanges(); } else { throw new MitException("CNP deja existent in baza de date"); } transaction.Commit(); } catch (MitException e) { MessageBox.Show(e.Message); transaction.Rollback(); } catch (Exception e) { MessageBox.Show("Eroare netratata:" + e.Message); MessageBox.Show(e.InnerException.GetBaseException().Message); transaction.Rollback(); } } } }