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 = " "; }