private void DbGrid_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { DbEntities db = new DbEntities(); List <Log> list; switch (e.ColumnIndex) { case 0: list = db.Log.OrderBy(c => c.Id).ToList(); break; case 1: list = db.Log.OrderBy(c => c.word).ToList(); break; case 2: list = db.Log.OrderBy(c => c.key).ToList(); break; case 3: list = db.Log.OrderBy(c => c.result).ToList(); break; case 4: list = db.Log.OrderBy(c => c.emcoded).ToList(); break; case 5: list = db.Log.OrderBy(c => c.datetime).ToList(); break; default: list = db.Log.ToList(); break; } list.Reverse(); DbGrid.DataSource = list; }
private void button1_Click_1(object sender, EventArgs e) { string word = txt_textToEncode.Text; string encrypted = Encoder.encode(word, key); txt_encrypted.Text = encrypted; DbEntities db = new DbEntities(); Log l = new Log(); l.datetime = System.DateTime.Now; l.key = key; l.word = word; l.result = encrypted; l.emcoded = true; db.Log.Add(l); db.SaveChanges(); DbGrid.DataSource = db.Log.ToList(); }
private void btn_search_Click(object sender, EventArgs e) { DbEntities db = new DbEntities(); switch (cb_searchType.SelectedIndex) { case 0: { int id; if (int.TryParse(txt_fieldToSearch.Text, out id)) { switch (searchWay) { case 2: DbGrid.DataSource = db.Log.Where(x => x.Id <= id).Select(x => x).ToList(); break; case 1: DbGrid.DataSource = db.Log.Where(x => x.Id == id).Select(x => x).ToList(); break; case 0: DbGrid.DataSource = db.Log.Where(x => x.Id >= id).Select(x => x).ToList(); break; } } } break; case 1: DbGrid.DataSource = db.Log.Where(x => x.word.Contains(txt_fieldToSearch.Text)).Select(x => x).ToList(); break; case 2: DbGrid.DataSource = db.Log.Where(x => x.key.Contains(txt_fieldToSearch.Text)).Select(x => x).ToList(); break; case 3: DbGrid.DataSource = db.Log.Where(x => x.result.Contains(txt_fieldToSearch.Text)).Select(x => x).ToList(); break; case 4: { DateTime time; System.Diagnostics.Debug.WriteLine("before"); if (DateTime.TryParse(txt_fieldToSearch.Text, out time)) { System.Diagnostics.Debug.WriteLine("parsed"); System.Diagnostics.Debug.WriteLine(time.ToString()); switch (searchWay) { case 0: DbGrid.DataSource = db.Log.Where(x => x.datetime <= time).Select(x => x).ToList(); break; case 1: DbGrid.DataSource = db.Log.Where(x => x.datetime == time).Select(x => x).ToList(); break; case 2: DbGrid.DataSource = db.Log.Where(x => x.datetime >= time).Select(x => x).ToList(); break; } } } break; case 5: DbGrid.DataSource = db.Log.Where(x => x.emcoded == checkbox_encodeSerch.Checked).Select(x => x).ToList(); break; } if (checkBox_Count.Checked) { textBox_Count.Text = DbGrid.RowCount + ""; } }