public static void Write(int sourcePlayerID, string action) { logfile myLog = new logfile(); myLog.sourceplayer = sourcePlayerID; myLog.logdate = DateTime.Now; myLog.action = action; myLog.Save(); }
private void log() { if (TextBox1.Text == "" || TextBox2.Text == "") { MessageBox.Show("Please Complete the data"); } else { MySqlConnection myconn = new MySqlConnection(connection); MySqlDataReader r; try { myconn.Open(); MySqlCommand selectcomm = new MySqlCommand("employee", myconn); selectcomm.CommandType = CommandType.StoredProcedure; selectcomm.Parameters.AddWithValue("@k", "login"); selectcomm.Parameters.AddWithValue("@Id_par1", 0); selectcomm.Parameters.AddWithValue("@Name_par2", "None"); selectcomm.Parameters.AddWithValue("@Job_par3", "None"); selectcomm.Parameters.AddWithValue("@Phone_par4", 0); selectcomm.Parameters.AddWithValue("@Address_par5", "None"); selectcomm.Parameters.AddWithValue("@User_par6", TextBox1.Text); selectcomm.Parameters.AddWithValue("@Pass_par7", TextBox2.Text); selectcomm.Parameters.AddWithValue("@Salary_par8", 0); selectcomm.Parameters.AddWithValue("@Shift_par9", 0); user = TextBox1.Text; MySqlDataAdapter adapter = new MySqlDataAdapter(selectcomm); DataTable datatb = new DataTable(); adapter.Fill(datatb); if (datatb.Rows.Count == 1) { r = selectcomm.ExecuteReader(); r.Read(); if (r.GetValue(2).ToString() == "Casher") { Form1 dh = new Form1(); dh.Show(); this.Hide(); } else if (r.GetValue(2).ToString() == "Admin") { adminHome ad = new adminHome(); ad.Show(); this.Hide(); } logfile log = new logfile(); bool result = log.logfilee("select user,pass,Job from employee where user = user_par6 and pass = pass_par7"); } else { MessageBox.Show("Username or password incorrect"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { myconn.Close(); } } }
private void button1_Click(object sender, EventArgs e) { if (openFileDialog1.ShowDialog() == DialogResult.OK) { FileStream fs = null; StreamReader sr = null; try { fs = new FileStream(openFileDialog1.FileName, FileMode.Open, FileAccess.Read); sr = new StreamReader(fs); // String s; // s = sr.ReadLine(); string bankaccount; bankaccount = sr.ReadLine(); while (bankaccount != null) { // s = sr.ReadLine(); // listBox1.Items.Add(s); string start, end, nrdeposit, useraccount, useramount, logid; //logid = sr.ReadLine(); // s = sr.ReadLine(); bankaccount = sr.ReadLine(); start = sr.ReadLine(); end = sr.ReadLine(); // nrdeposit = sr.ReadLine(); useraccount = sr.ReadLine(); nrdeposit = sr.ReadLine(); useramount = sr.ReadLine(); // listBox1.Items.Add(s); // foreach(ListBox items in listBox1.Items) // label1.Text = s; // s = sr.ReadLine(); logfile temp = new logfile(bankaccount, start, end, nrdeposit, useraccount, useramount); mylog.Add(temp); bankaccount = sr.ReadLine(); //bankaccount = sr.ReadLine(); // s = sr.ReadLine(); } } catch (IOException) { MessageBox.Show("something went wrong, IOException was thrown"); } finally { if (sr != null) { sr.Close(); } if (fs != null) { fs.Close(); } } MessageBox.Show("*************loading is done*********************"); } else { MessageBox.Show("there was an error opening the windows"); } foreach (var v in mylog) { int nrAdded = LogData.savelog((v.BankAccountID), v.StartDate, v.EndDate, v.NrOfDeposit, v.UserAccount, v.amount); if (nrAdded > 0) { MessageBox.Show("successfully added to the database"); } else { MessageBox.Show("you made an error please try again"); } } }