protected void AddTemp_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
string date = dt.ToShortDateString();
string time = dt.ToLongTimeString();
//conn = new NpgsqlConnection(connString);
conn.Open();
query = string.Format("SELECT \"Date\" FROM \"Temperature_indicators\" WHERE \"Date\" = '{0}'", date);
cmd = new NpgsqlCommand(query, conn);
pgReader = cmd.ExecuteReader();
pgReader.Read();
if (pgReader.HasRows == false)
{
conn.Close();
conn.Open();
query = string.Format("insert into \"Temperature_indicators\" values ('{0}', '{1}', {2},{3},{4}) ", date, time, Convert.ToInt32(TBtempKab.Text), Convert.ToInt32(TBtempSpal.Text), SessionFacade.UserId);
cmd = new NpgsqlCommand(query, conn);
cmd.ExecuteReader();
conn.Close();
GVTemp.DataBind();
}
else
{
ExData.Text = "Сегодня уже добавлена температура";
}
TBtempKab.Text = "";
TBtempSpal.Text = "";
}
protected void OutputPr_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
string date = dt.ToShortDateString();
string time = dt.ToLongTimeString();
conn.Open();
query = string.Format("SELECT \"Date\" FROM \"Walks\" WHERE \"Date\" = '{0}' and \"Time_of_return\"= '00:00:00'", date);
cmd = new NpgsqlCommand(query, conn);
pgReader = cmd.ExecuteReader();
pgReader.Read();
if (pgReader.HasRows == true)
{
conn.Close();
conn.Open();
query = string.Format("Update \"Walks\" SET \"Return_children\"= {0}, \"Time_of_return\"='{1}', \"Comment\"='{2}' where\"Return_children\"= 0 ", Convert.ToInt32(TBChildKol.Text), time, TBKoment.Text);
cmd = new NpgsqlCommand(query, conn);
cmd.ExecuteReader();
conn.Close();
GVTemp.DataBind();
GVProgulka.DataBind();
}
else
{
conn.Close();
conn.Open();
query = string.Format("insert into \"Walks\" values ('{0}','{1}', {2},'00:00:00',{3},'-',{4}) ", date, time, Convert.ToInt32(TBChildKol.Text), a, SessionFacade.UserId);
cmd = new NpgsqlCommand(query, conn);
cmd.ExecuteReader();
conn.Close();
GVProgulka.DataBind();
}
TBChildKol.Text = " ";
TBKoment.Text = " ";
}
