protected void Button1_Click(object sender, EventArgs e)
{
using (RaborContext db = new RaborContext())
{
Rabor app = new Rabor()
{
ID_oboryd = int.Parse(DropDownList1.Text),
ID_vid_rabot = int.Parse(DropDownList2.Text),
Data_polychen = DateTime.Parse(TextBox1.Text),
Data_vipolnen = DateTime.Parse(TextBox2.Text)
};
db.Rabor.Add(app);
db.SaveChanges();
}
Response.Redirect("WebForm1.aspx");
}
protected void Button3_Click(object sender, EventArgs e)
{
using (RaborContext db = new RaborContext())
{
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);
Rabor delId = db.Rabor.Where(s => s.Id == id).FirstOrDefault();
if (delId != null)
{
db.Rabor.Remove(delId);
db.SaveChanges();
}
}
}
Response.Redirect("WebForm1.aspx");
}
}
public void GetData(DateTime d1, DateTime d2)
{
DataTable mainTable = new DataTable();
if (mainTable.Columns.Count == 0)
{
mainTable.Columns.Add("Id", typeof(int));
mainTable.Columns.Add("ID_oboryd", typeof(string));
mainTable.Columns.Add("ID_vid_rabot", typeof(string));
mainTable.Columns.Add("Data_polychen", typeof(DateTime));
mainTable.Columns.Add("Data_vipolnen", typeof(DateTime));
}
using (Vid_rabotContext db = new Vid_rabotContext())
{
DataTable vid_rabotTable = new DataTable();
if (vid_rabotTable.Columns.Count == 0)
{
vid_rabotTable.Columns.Add("Id", typeof(int));
vid_rabotTable.Columns.Add("Name_vid_rabot", typeof(string));
}
var vid_rabot = db.Vid_rabot;
foreach (Vid_rabot p in vid_rabot)
{
DataRow row = vid_rabotTable.NewRow();
row[0] = p.Id;
row[1] = p.Name_vid_rabot;
vid_rabotTable.Rows.Add(row);
}
}
using (OborydContext db = new OborydContext())
{
DataTable oborydTable = new DataTable();
if (oborydTable.Columns.Count == 0)
{
oborydTable.Columns.Add("Id", typeof(int));
oborydTable.Columns.Add("Model_oboryd", typeof(string));
}
var oboryd = db.Oboryd;
foreach (Oboryd s in oboryd)
{
DataRow row = oborydTable.NewRow();
row[0] = s.Id;
row[1] = s.Model_oboryd;
oborydTable.Rows.Add(row);
}
}
using (RaborContext db = new RaborContext())
{
var rabot = db.Rabor;
foreach (Rabor app in rabot)
{
DateTime data = app.Data_polychen;
DateTime data2 = app.Data_vipolnen;
if ((data >= d1 && data <= d2) || (data2 >= d1 && data2 <= d2))
{
DataRow row = mainTable.NewRow();
row[0] = app.Id;
using (OborydContext db1 = new OborydContext())
{
Oboryd oboryd = db1.Oboryd.Where(s => s.Id == app.ID_oboryd).FirstOrDefault();
row[1] = oboryd.Model_oboryd;
}
using (Vid_rabotContext db2 = new Vid_rabotContext())
{
var vid_rabot = db2.Vid_rabot.Where(p => p.Id == app.ID_vid_rabot).FirstOrDefault();
row[2] = vid_rabot.Name_vid_rabot;
}
string[] d = app.Data_polychen.ToString().Split(' ');
string[] dd = app.Data_vipolnen.ToString().Split(' ');
row[3] = d[0];
row[4] = dd[0];
mainTable.Rows.Add(row);
}
}
GridView1.DataSource = mainTable;
GridView1.DataBind();
}
}