protected void GridView2_SelectedIndexChanged(object sender, EventArgs e) { var dbContext = new EntityFastWater.FastWaterContext(); String koords = GridView2.DataKeys[GridView2.SelectedIndex].Value.ToString(); int index_start = koords.IndexOf('('); String substr = koords.Substring(index_start + 1, koords.Length - index_start - 2); int index_space = substr.IndexOf(' '); longitude = substr.Substring(0, index_space); String substr2 = substr.Substring(index_space + 1); int index_space2 = substr2.IndexOf(' ') != (-1) ? substr2.IndexOf(' ') : substr2.Length; latitude = substr2.Substring(0, index_space2); // Define the name and type of the client scripts on the page. String csname = "UpdateGoogleMap"; Type cstype = this.GetType(); // Get a ClientScriptManager reference from the Page class. ClientScriptManager cs = Page.ClientScript; StringBuilder csTextFunction = new StringBuilder(); csTextFunction.Append("<script type=text/javascript> UpdateGoogleMap('latitude', 'longitude') </"); csTextFunction.Append("script>"); //cs.RegisterStartupScript(cstype, csname, csTextFunction.ToString()); cs.RegisterStartupScript(cstype, csname, $"UpdateGoogleMap('{latitude}', '{longitude}')", true); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { var dbContext = new EntityFastWater.FastWaterContext(); int idKoords = Convert.ToInt32(GridView1.DataKeys[GridView1.SelectedIndex].Value.ToString()); latitude = dbContext.GeographicalKoordinates.First(x => x.Id_GeographicalKoordinates == idKoords) .Koordinate.Latitude.ToString().Replace(',', '.'); longitude = dbContext.GeographicalKoordinates.First(x => x.Id_GeographicalKoordinates == idKoords) .Koordinate.Longitude.ToString().Replace(',', '.'); // Define the name and type of the client scripts on the page. String csname = "UpdateGoogleMap"; Type cstype = this.GetType(); // Get a ClientScriptManager reference from the Page class. ClientScriptManager cs = Page.ClientScript; StringBuilder csTextFunction = new StringBuilder(); csTextFunction.Append("<script type=text/javascript> UpdateGoogleMap('latitude', 'longitude') </"); csTextFunction.Append("script>"); //cs.RegisterStartupScript(cstype, csname, csTextFunction.ToString()); cs.RegisterStartupScript(cstype, csname, $"UpdateGoogleMap('{latitude}', '{longitude}')", true); }
protected void ButtonAll1_Click(object sender, EventArgs e) { using (var dbContext = new EntityFastWater.FastWaterContext()) { var objectPost = dbContext.Floods.Select(x => new { x.Post.Locality.NameLocality, x.Post.GeographicalKoordinate.Id_GeographicalKoordinates, x.Post.GeographicalKoordinate.KoordinateText, x.DateAndTimes, x.LevelSnow, x.LevelWater, x.WarningFlood }).OrderBy(x => x.DateAndTimes).ToList(); GridView1.DataSource = objectPost; GridView1.DataBind(); GridView2.DataSource = dbContext.ALLInformationOnPosts.Select(x => new { x.NameLocality, x.Koordinate, x.DateAndTimes, x.ChangeLevelSnowInHour, x.ChangeLevelWaterInHour, x.WarningFlood }).OrderBy(x => x.DateAndTimes).ToList(); GridView2.DataBind(); } }
protected void LoginButton_Click(object sender, EventArgs e) { var userContext = new EntityFastWater.FastWaterContext(); EntityFastWater.User user; user = userContext.Users.ToList(). Where(x => x.Login.Equals(Login1.UserName)).Where(x => x.Password.Equals(Login1.Password)).FirstOrDefault(); if (user != null) { Response.Redirect("/AdministrativePage.aspx"); } else { Login1.FailureText = "Ошибка авторизации!"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var dbContext = new EntityFastWater.FastWaterContext()) { GridViewKoords.DataSource = DatabaseFastWaterService.GeographyKordinatesService.GetGeographicalKoordinatesEf() .Select(x => new { x.Id_GeographicalKoordinates, x.SRID, x.Koordinate, x.KoordinateText, x.HeighSeaLevel, x.TypeKoordinates, x.RadiusAction, x.description }); GridViewKoords.DataBind(); //GridViewFlood.DataSource = DatabaseFastWaterService.ALLInformationOnPostService.GetALLInformationOnPostEf(). // Select(x => new { x.Id_Post, x.NameLocality, x.Koordinate, x.DateAndTimes, x.LongitudeDay, x.}); GridViewPost.DataSource = DatabaseFastWaterService.PostService.GetPostEf(). Select(x => new { x.Id_Post, x.NamePost, x.Id_GeographicalKoordinates, x.Basin.NameBasin, x.Ground.TypeGround, x.Locality.NameLocality, x.DistanceBeetwenSensors, x.description }); GridViewPost.DataBind(); DropListIdKoordinat.DataSource = DatabaseFastWaterService.GeographyKordinatesService.GetGeographicalKoordinatesEf() .Select(x => x.Id_GeographicalKoordinates); DropListIdKoordinat.DataBind(); DropListBasin.DataSource = dbContext.Basins.Select(x => x.NameBasin).ToList(); DropListBasin.DataBind(); DropListGround.DataSource = dbContext.Grounds.Select(x => x.TypeGround).ToList(); DropListGround.DataBind(); DropListLocal.DataSource = dbContext.Localities.Select(x => x.NameLocality).ToList(); DropListLocal.DataBind(); } } }
protected void Button2_Click(object sender, EventArgs e) { if (DropListTypeKoords.SelectedValue.Equals("LINESTRING")) { GeographyKordinatesService.UpdateGeographyKoord(Convert.ToInt32(TextBoxIdKoords.Text), Convert.ToInt32(TextBoxSRID.Text), Convert.ToInt32(TextBoxRadiusKoords.Text), Convert.ToInt32(TextBoxHeightSea.Text), TextBoxDescriptionKoords.Text, DropListTypeKoords.SelectedValue, Convert.ToDouble(TextBoxKoords1.Text), Convert.ToDouble(TextBoxKoords2.Text), Convert.ToDouble(TextBoxKoords3.Text), Convert.ToDouble(TextBoxKoords4.Text)); } else if (DropListTypeKoords.SelectedValue.Equals("POINT")) { GeographyKordinatesService.UpdateGeographyKoord(Convert.ToInt32(TextBoxIdKoords.Text), Convert.ToInt32(TextBoxSRID.Text), Convert.ToInt32(TextBoxRadiusKoords.Text), Convert.ToInt32(TextBoxHeightSea.Text), TextBoxDescriptionKoords.Text, DropListTypeKoords.SelectedValue, Convert.ToDouble(TextBoxKoords1.Text), Convert.ToDouble(TextBoxKoords2.Text)); } using (var dbContext = new EntityFastWater.FastWaterContext()) { GridViewKoords.DataSource = DatabaseFastWaterService.GeographyKordinatesService.GetGeographicalKoordinatesEf() .Select(x => new { x.Id_GeographicalKoordinates, x.SRID, x.Koordinate, x.KoordinateText, x.HeighSeaLevel, x.TypeKoordinates, x.RadiusAction, x.description }); GridViewKoords.DataBind(); } }
protected void ButtonSearch1_Click(object sender, EventArgs e) { int level = DropListLevel1.SelectedValue.Equals("Превышен") == true ? 1 : 0; string koords = TextBoxKoords1.Text.Equals("") == true ? "." : TextBoxKoords1.Text; DateTime firstrDate = new DateTime(Int32.Parse(DropListDateFirst1.SelectedValue.Substring(6, 4)), Int32.Parse(DropListDateFirst1.SelectedValue.Substring(3, 2)), Int32.Parse(DropListDateFirst1.SelectedValue.Substring(0, 2))); DateTime secondDate = new DateTime(Int32.Parse(DropListDateSecond1.Text.Substring(6, 4)), Int32.Parse(DropListDateSecond1.Text.Substring(3, 2)), Int32.Parse(DropListDateSecond1.Text.Substring(0, 2)), 23, 59, 59); using (var dbContext = new EntityFastWater.FastWaterContext()) { var objectPost = dbContext.Floods.Select(x => new { x.Post.Locality.NameLocality, x.Post.GeographicalKoordinate.Id_GeographicalKoordinates, x.Post.GeographicalKoordinate.KoordinateText, x.DateAndTimes, x.LevelSnow, x.LevelWater, x.WarningFlood }).ToList(); var allInform = dbContext.ALLInformationOnPosts.Select(x => new { x.NameLocality, x.Koordinate, x.DateAndTimes, x.ChangeLevelSnowInHour, x.ChangeLevelWaterInHour, x.WarningFlood, }).ToList(); if (!DropListNameLocal1.SelectedValue.Equals("") && !DropListLevel1.SelectedValue.Equals("")) { GridView1.DataSource = objectPost.Where(x => x.DateAndTimes >= firstrDate).Where(x => x.DateAndTimes <= secondDate) .Where(x => x.NameLocality.Equals(DropListNameLocal1.SelectedValue)).Where(x => x.KoordinateText.Contains(koords)) .Where(x => x.WarningFlood == level) .OrderBy(x => x.DateAndTimes); GridView1.DataBind(); GridView2.DataSource = allInform.Where(x => x.DateAndTimes >= firstrDate).Where(x => x.DateAndTimes <= secondDate) .Where(x => x.NameLocality.Equals(DropListNameLocal1.SelectedValue)).Where(x => x.Koordinate.AsText().Contains(koords)) .Where(x => x.WarningFlood == level) .OrderBy(x => x.DateAndTimes); GridView2.DataBind(); } else if (DropListNameLocal1.SelectedValue.Equals("") && !DropListLevel1.SelectedValue.Equals("")) { GridView1.DataSource = objectPost.Where(x => x.DateAndTimes >= firstrDate).Where(x => x.DateAndTimes <= secondDate) .Where(x => x.KoordinateText.Contains(koords)) .Where(x => x.WarningFlood == level) .OrderBy(x => x.DateAndTimes); GridView1.DataBind(); GridView2.DataSource = allInform.Where(x => x.DateAndTimes >= firstrDate).Where(x => x.DateAndTimes <= secondDate) .Where(x => x.Koordinate.AsText().Contains(koords)) .Where(x => x.WarningFlood == level) .OrderBy(x => x.DateAndTimes); GridView2.DataBind(); } else if (!DropListNameLocal1.SelectedValue.Equals("") && DropListLevel1.SelectedValue.Equals("")) { GridView1.DataSource = objectPost.Where(x => x.DateAndTimes >= firstrDate).Where(x => x.DateAndTimes <= secondDate) .Where(x => x.NameLocality.Equals(DropListNameLocal1.SelectedValue)).Where(x => x.KoordinateText.Contains(koords)) .OrderBy(x => x.DateAndTimes); GridView1.DataBind(); GridView2.DataSource = allInform.Where(x => x.DateAndTimes >= firstrDate).Where(x => x.DateAndTimes <= secondDate) .Where(x => x.NameLocality.Equals(DropListNameLocal1.SelectedValue)).Where(x => x.Koordinate.AsText().Contains(koords)) .OrderBy(x => x.DateAndTimes); GridView2.DataBind(); } else if (DropListNameLocal1.SelectedValue.Equals("") && DropListLevel1.SelectedValue.Equals("")) { GridView1.DataSource = objectPost.Where(x => x.DateAndTimes >= firstrDate).Where(x => x.DateAndTimes <= secondDate) .Where(x => x.KoordinateText.Contains(koords)).OrderBy(x => x.DateAndTimes); GridView1.DataBind(); GridView2.DataSource = allInform.Where(x => x.DateAndTimes >= firstrDate).Where(x => x.DateAndTimes <= secondDate) .Where(x => x.Koordinate.AsText().Contains(koords)).OrderBy(x => x.DateAndTimes); GridView2.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { //GeographyKordinatesService.AddGeographyKoordToDataBase(4326, 10, 5, "Светлый", "POINT", -76.345, -75.355); //GeographyKordinatesService.AddGeographyKoordToDataBase(4326, 10, 5, "Лужа", "POLYGON",10.245,10.246,13.245,13.246,12.246,11.900, 10.245, 10.246); //GeographyKordinatesService.RemoveGeographicalKoordinatesEf(12); //GeographyKordinatesService.UpdateGeographyKoord(12, 4326, 10, 5, "Озеро", "POLYGON", 11.245, 10.246, 13.245, 13.246, 12.246, 11.900, 11.245, 10.246); DateTime newDateTime = new DateTime(2018, 01, 02); //FloodService.UpdateFlood(6,6,newDateTime, 5, 0, 0.001m, 0.0002m, 4.4m, 10, -5, 1, 1, 3, 4, 0, 0.6m); //FloodService.RemoveFloodEf(6); if (!IsPostBack) { // Validate initially to force asterisks // to appear before the first roundtrip. using (var dbContext = new EntityFastWater.FastWaterContext()) { var objectPost = dbContext.Floods.Select(x => new { x.Post.Locality.NameLocality, x.Post.GeographicalKoordinate.Id_GeographicalKoordinates, x.Post.GeographicalKoordinate.KoordinateText, x.DateAndTimes, x.LevelSnow, x.LevelWater, x.WarningFlood }).OrderBy(x => x.DateAndTimes).ToList(); GridView1.DataSource = objectPost; GridView1.DataBind(); GridView2.DataSource = dbContext.ALLInformationOnPosts.Select(x => new { x.NameLocality, x.Koordinate, x.DateAndTimes, x.ChangeLevelSnowInHour, x.ChangeLevelWaterInHour, x.WarningFlood }).OrderBy(x => x.DateAndTimes).ToList(); GridView2.DataBind(); GridView3.DataSource = dbContext.PredictionLevelSnows.Select(x => new { x.Post.Locality.NameLocality, x.Post.GeographicalKoordinate.KoordinateText, x.Date_, x.Time_, x.ChangeLevelSnow, x.LevelSnow, x.WarningFlood }).OrderBy(x => x.Date_).OrderBy(x => x.Time_).ToList(); GridView3.DataBind(); GridView4.DataSource = dbContext.PredictionLevelWaters.Select(x => new { x.Post.Locality.NameLocality, x.Post.GeographicalKoordinate.KoordinateText, x.Date_, x.Time_, x.ChangeLevelWater, x.LevelWater, x.WarningFlood }).OrderBy(x => x.Date_).OrderBy(x => x.Time_).ToList(); GridView4.DataBind(); } using (var dbContext = new EntityFastWater.FastWaterContext()) { List <string> locallitiesList = dbContext.Localities.Select(x => x.NameLocality).ToList(); locallitiesList.Add(""); DropListNameLocal1.DataSource = locallitiesList.OrderBy(x => x).Distinct(); DropListNameLocal1.DataBind(); var objectDate = dbContext.Floods.Select(x => new { x.DateAndTimes }).ToList(); DropListDateFirst1.DataSource = objectDate.Select(x => x.DateAndTimes.Date).OrderBy(x => x.Date).Distinct(); DropListDateFirst1.DataBind(); DropListDateSecond1.DataSource = objectDate.Select(x => x.DateAndTimes.Date).OrderByDescending(x => x.Date).Distinct(); DropListDateSecond1.DataBind(); DropListNameLocal2.DataSource = locallitiesList.OrderBy(x => x).Distinct(); DropListNameLocal2.DataBind(); } } }