protected void Button11_Click(object sender, EventArgs e)
{
BuildingTableAdapter bu = new BuildingTableAdapter();
FarmTableAdapter ff = new FarmTableAdapter();
SensorTableAdapter SS = new SensorTableAdapter();
string nf = ff.GetDataBy4(N_F1.Text).Rows[0][0].ToString();
string inb = "B" + (Convert.ToInt32(bu.ScalarQuery1()) + 1).ToString("0000");
Session["NewB"] = inb;
bu.InsertQuery(inb, N_B.Text, 0, "-", S_B.Text + " m.", nf, FileUpload1.FileName.ToString(), "0", "-");
string ins = "S" + (Convert.ToInt32(SS.ScalarQuery1()) + 1).ToString("0000");
SS.InsertQuery(ins, "วัดอุณหภูมิ", "วัดอุณหภูมิ", "T0001", inb);
string ins1 = "S" + (Convert.ToInt32(SS.ScalarQuery1()) + 1).ToString("0000");
SS.InsertQuery(ins1, "วัดแอมโมเนีย", "วัดแอมโมเนีย", "T0002", inb);
string ins2 = "S" + (Convert.ToInt32(SS.ScalarQuery1()) + 1).ToString("0000");
SS.InsertQuery(ins2, "วัดความเร็วลม", "วัดความเร็วลม", "T0003", inb);
string ins3 = "S" + (Convert.ToInt32(SS.ScalarQuery1()) + 1).ToString("0000");
SS.InsertQuery(ins3, "วัดความชื้น", "วัดความชื้น", "T0004", inb);
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
