protected void Button1_Click(object sender, EventArgs e) { using (Arenda_bookContext db = new Arenda_bookContext()) { Arenda_book app = new Arenda_book() { id_book = int.Parse(DropDownList1.Text), id_fio = int.Parse(DropDownList2.Text), Data_1 = DateTime.Parse(TextBox1.Text), Data_2 = DateTime.Parse(TextBox2.Text) }; db.Arenda_book.Add(app); db.SaveChanges(); } Response.Redirect("WebForm1.aspx"); }
protected void Button3_Click(object sender, EventArgs e) { using (Arenda_bookContext db = new Arenda_bookContext()) { foreach (GridViewRow rowInGrid in GridView1.Rows) { CheckBox checkBox = (CheckBox)rowInGrid.FindControl("CheckBox1"); if (checkBox != null && checkBox.Checked) { int id = int.Parse(GridView1.Rows[rowInGrid.RowIndex].Cells[1].Text); Arenda_book delId = db.Arenda_book.Where(s => s.Id == id).FirstOrDefault(); if (delId != null) { db.Arenda_book.Remove(delId); db.SaveChanges(); } } } Response.Redirect("WebForm1.aspx"); } }
protected void Button2_Click(object sender, EventArgs e) { if (TextBox1.Text == "" || TextBox2.Text == "") { DataTable T_A_book = new DataTable(); if (T_A_book.Columns.Count == 0) { T_A_book.Columns.Add("Код", typeof(int)); T_A_book.Columns.Add("Книга", typeof(string)); T_A_book.Columns.Add("ФИО", typeof(string)); T_A_book.Columns.Add("Дата взятия", typeof(DateTime)); T_A_book.Columns.Add("Дата возрата", typeof(DateTime)); } using (Arenda_bookContext db = new Arenda_bookContext()) { foreach (Arenda_book app in db.Arenda_book) { DataRow row = T_A_book.NewRow(); row[0] = app.Id; using (BookContext db1 = new BookContext()) { row[1] = db1.Book.Where(s => s.Id == app.id_book).FirstOrDefault().Name_book; } using (FIOContext db2 = new FIOContext()) { row[2] = db2.FIO.Where(p => p.Id == app.id_fio).FirstOrDefault().Fio; } string[] d = app.Data_1.ToString().Split(' '); string[] dd = app.Data_2.ToString().Split(' '); row[3] = d[0]; row[4] = dd[0]; T_A_book.Rows.Add(row); } GridView1.DataSource = T_A_book; GridView1.DataBind(); } } else if (TextBox1.Text != "" || TextBox2.Text != "") { DateTime data_1 = DateTime.Parse(TextBox1.Text); DateTime data_2 = DateTime.Parse(TextBox2.Text); DataTable T_A_book = new DataTable(); if (T_A_book.Columns.Count == 0) { T_A_book.Columns.Add("Код", typeof(int)); T_A_book.Columns.Add("Книга", typeof(string)); T_A_book.Columns.Add("ФИО", typeof(string)); T_A_book.Columns.Add("Дата взятия", typeof(DateTime)); T_A_book.Columns.Add("Дата возрата", typeof(DateTime)); } using (Arenda_bookContext db = new Arenda_bookContext()) { foreach (Arenda_book app in db.Arenda_book) { if ((app.Data_1 >= data_1 && app.Data_1 <= data_2) || (app.Data_2 >= data_1 && app.Data_2 <= data_2)) { DataRow row = T_A_book.NewRow(); row[0] = app.Id; using (BookContext db1 = new BookContext()) { row[1] = db1.Book.Where(s => s.Id == app.id_book).FirstOrDefault().Name_book; } using (FIOContext db2 = new FIOContext()) { row[2] = db2.FIO.Where(p => p.Id == app.id_fio).FirstOrDefault().Fio; } string[] date_1 = app.Data_1.ToString().Split(' '); string[] date_2 = app.Data_2.ToString().Split(' '); row[3] = date_1[0]; row[4] = date_2[0]; T_A_book.Rows.Add(row); } } GridView1.DataSource = T_A_book; GridView1.DataBind(); } } }