private void SaveSelection() { int gridID = int.Parse(Request["grid"]); string col1 = Request["c1"]; string col2 = Request["c2"]; double value = double.Parse(Request["val"]); bool selected = Request["sel"] == "true"; string sql = selected ? "INSERT INTO TblSelection (fGridRef, fColor1, fColor2, fValue) VALUES (@fGridRef, @fColor1, @fColor2, @fValue)" : "DELETE FROM TblSelection WHERE fGridRef=@fGridRef AND fColor1=@fColor1 AND fColor2=@fColor2"; using (SqlConnection con = new SqlConnection(dbsource.main)) { con.Open(); using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.Parameters.AddWithValue("@fGridRef", gridID); cmd.Parameters.AddWithValue("@fColor1", col1); cmd.Parameters.AddWithValue("@fColor2", col2); if (selected) { cmd.Parameters.AddWithValue("@fValue", value); } cmd.ExecuteNonQuery(); } double total = 0; String query = "SELECT * FROM TblSelection WHERE fGridRef = @fGridRef"; using (SqlCommand cmd = new SqlCommand(query, con)) { cmd.Parameters.AddWithValue("@fGridRef", gridID); using (SqlDataReader set = cmd.ExecuteReader()) { while (set.Read() == true) { double val = (double)set["fValue"]; total += val; } } } ColorRamp ramp = new ColorRamp(); ramp.Load(Server.MapPath("images/ramp.png")); String color = ramp.GetColor(total / 100); Response.Write(Math.Round(total) + "|" + color); } }
protected void LoadSelection() { using (SqlConnection con = new SqlConnection(dbsource.main)) { con.Open(); GridTools gt = new GridTools(con, Context); int featureID = int.Parse(Request["fid"]); int i1 = gt.GetIndicatorID(Request["i1"]); int i2 = gt.GetIndicatorID(Request["i2"]); int gridID = gt.GetGridID(featureID, i1, i2); double total = 0; bool valFound = false; String query = "SELECT * FROM TblSelection WHERE fGridRef = @fGridRef"; using (SqlCommand cmd = new SqlCommand(query, con)) { cmd.Parameters.AddWithValue("@fGridRef", gridID); using (SqlDataReader set = cmd.ExecuteReader()) { while (set.Read() == true) { double val = (double)set["fValue"]; total += val; valFound = true; } } } if (valFound == true) { ColorRamp ramp = new ColorRamp(); ramp.Load(Server.MapPath("images/ramp.png")); String color = ramp.GetColor(total / 100); Response.Write(Request["id"] + "|" + Math.Round(total) + "|" + color); } else { Response.Write(Request["id"] + "|" + "0" + "|" + "#ffffff"); } } }