private void dataGridView1_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { Workers workers = new Workers(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(), 0, Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString()), Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString()), "", 0); CalcSalary calcSalary = new CalcSalary(workers); calcSalary.ShowDialog(); }
private void btEnter_Click(object sender, EventArgs e) { string Group = ""; string Log = ""; string Password = ""; int startsalary = 0; DateTime dateTime = DateTime.Now; //MessageBox.Show(Environment.CurrentDirectory); SQLiteConnection DB = new SQLiteConnection(@"Data Source=" + Environment.CurrentDirectory + "/x86/Salary.db;Pooling=true;FailIfMissing=false;Version=3"); SQLiteCommand Enter = new SQLiteCommand(DB); Enter.Connection = DB; Enter.CommandText = "select MainInfo.'Group', StartSalary, EntryDate, FIO,Password from MainInfo where FIO = @FIO and Password = @Password"; Enter.Parameters.AddWithValue("@FIO", tbLogin.Text); Enter.Parameters.AddWithValue("@Password", tbPassword.Text); Enter.Connection.Open(); SQLiteDataReader dr = Enter.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { dateTime = dr.GetDateTime(2); startsalary = dr.GetInt32(1); Group = dr.GetString(0); Log = dr.GetString(3); Password = dr.GetString(4); } } else { MessageBox.Show("Проверьте имя пользователя и пароль"); } Workers work = new Workers(Log, 0, dateTime, startsalary, Password, 0); dr.Close(); Enter.Connection.Close(); switch (Group) { case "1)Работник": this.Visible = false; Form form = new CalcSalary(work); form.Show(); break; case "2)Менеджер": Form form1 = new CalcSalary(work); this.Visible = false; form1.Show(); break; case "3)Продавец": Form form3 = new CalcSalary(work); this.Visible = false; form3.Show(); break; case "": break; default: this.Visible = false; Form form4 = new MainWindow(); form4.Show(); break; } }