//load the found disaster into the dropdown list box protected void loadDisaster() { disaster currentDisaster = new disaster(); { try { DataTable dtlw = currentDisaster.Select("1=1"); ddlDisaster.Items.Clear(); ddlDisaster.Items.Add(""); if (dtlw.Rows.Count > 0) { for (int i = 0; i < dtlw.Rows.Count; i++) { ddlDisaster.Items.Add(new ListItem(dtlw.Rows[i]["disaster_name"].ToString(), dtlw.Rows[i]["disaster_id"].ToString())); } } else { ddlDisaster.Items.Add("No Disasters"); } } catch { } } }
//display the disaster on screen protected void ddlDisaster_SelectedIndexChanged(object sender, EventArgs e) { try { disaster disaster = new disaster(); GlobalVariables.DisasterID = Convert.ToInt32(ddlDisaster.SelectedItem.Value); disaster = disaster.Select(Convert.ToInt32(ddlDisaster.SelectedItem.Value)); nLat = disaster.disaster_north_latitude; nLong = disaster.disaster_north_longitude; sLat = disaster.disaster_south_latitude; sLong = disaster.disaster_south_longitude; eLat = disaster.disaster_east_latitude; eLong = disaster.disaster_east_longitude; wLat = disaster.disaster_west_latitude; wLong = disaster.disaster_west_longitude; Alert_Type_TextBox.Text = "Disaster Related: " + Convert.ToString(disaster.disaster_name); Page page = HttpContext.Current.Handler as Page; ScriptManager.RegisterStartupScript(page, page.GetType(), "plotPoly", "plotPoly();", true); } catch { } }
protected void ddlDisaster_SelectedIndexChanged(object sender, EventArgs e) { try { disaster disaster = new disaster(); GlobalVariables.DisasterID = Convert.ToInt32(ddlDisaster.SelectedItem.Value); } catch { } }
///////////////////////// //////////////////////// /////////////////////// ////////////////////// ///////////////////// //Insert Tab Methods protected void Insert_ddlDisaster_SelectedIndexChanged(object sender, EventArgs e) { try { disaster disaster = new disaster(); GlobalVariables.DisasterID = Convert.ToInt32(Insert_ddlDisaster.SelectedItem.Value); } catch { } }
public disaster Insert_disaster_select(int ID) { disaster = disaster.Select(ID); Insert_disaster_name_txt.Text = Convert.ToString(disaster.disaster_name); Insert_disaster_type_txt.Text = Convert.ToString(disaster.disaster_type); Insert_disaster_start_date_txt.Text = Convert.ToString(disaster.disaster_start_date); Insert_disaster_end_date_txt.Text = Convert.ToString(disaster.disaster_end_date); Insert_disaster_north_latitude_txt.Text = Convert.ToString(disaster.disaster_north_latitude); Insert_disaster_north_longitude_txt.Text = Convert.ToString(disaster.disaster_north_longitude); Insert_disaster_south_latitude_txt.Text = Convert.ToString(disaster.disaster_south_latitude); Insert_disaster_south_longitude_txt.Text = Convert.ToString(disaster.disaster_south_longitude); Insert_disaster_east_latitude_txt.Text = Convert.ToString(disaster.disaster_east_latitude); Insert_disaster_east_longitude_txt.Text = Convert.ToString(disaster.disaster_east_longitude); Insert_disaster_west_latitude_txt.Text = Convert.ToString(disaster.disaster_west_latitude); Insert_disaster_west_longitude_txt.Text = Convert.ToString(disaster.disaster_west_longitude); return(disaster); }
private void EditDisaster() { if (CheckExist()) { return; } var context = new PSOConnect(); var reason = context.reason.FirstOrDefault(reasons => reasons.idReason == _idReason); var disaster = context.disaster.FirstOrDefault(disasters => disasters.idDisaster == reason.idDisaster); var checkExistDisaster = context.disaster.FirstOrDefault(disasters => disasters.country.Equals(CountryField.Text) && disasters.city.Equals(CityField.Text) && EntityFunctions.TruncateTime(disasters.date.Value) == EntityFunctions.TruncateTime(DateField.Value)); disaster currentDisaster; reason.reason1 = ReasonField.Text; reason.typeReason = TypeField.SelectedItem.ToString(); if (disaster.reason.Count == 1) { currentDisaster = disaster; currentDisaster.country = CountryField.Text; currentDisaster.city = CityField.Text; currentDisaster.date = DateField.Value; } else if (checkExistDisaster != null) { currentDisaster = checkExistDisaster; checkExistDisaster.reason.Add(reason); } else { currentDisaster = new disaster { idDisaster = context.disaster.Count() > 0 ? context.disaster.Max(idDisaster => idDisaster.idDisaster) + 1 : 1, country = CountryField.Text, city = CityField.Text, date = DateField.Value }; currentDisaster.reason.Add(reason); context.disaster.Add(currentDisaster); } _updatedListInfo?.Invoke($"{reason.idReason}-ТИП: {TypeField.SelectedItem} ПРИЧИНА: {ReasonField.Text} СТРАНА: {CountryField.Text} ГОРОД: {CityField.Text} ДАТА: {DateField.Value.ToLongDateString()}"); context.SaveChanges(); }
public disaster Delete_disaster_select(int ID) { disaster = disaster.Select(ID); Delete_disaster_id_txt_lbl.Text = Convert.ToString(disaster.disaster_id); Delete_disaster_name_txt_lbl.Text = Convert.ToString(disaster.disaster_name); Delete_disaster_type_txt_lbl.Text = Convert.ToString(disaster.disaster_type); Delete_disaster_start_date_txt_lbl.Text = Convert.ToString(disaster.disaster_start_date); Delete_disaster_end_date_txt_lbl.Text = Convert.ToString(disaster.disaster_end_date); Delete_disaster_north_latitude_txt_lbl.Text = Convert.ToString(disaster.disaster_north_latitude); Delete_disaster_north_longitude_txt_lbl.Text = Convert.ToString(disaster.disaster_north_longitude); Delete_disaster_south_latitude_txt_lbl.Text = Convert.ToString(disaster.disaster_south_latitude); Delete_disaster_south_longitude_txt_lbl.Text = Convert.ToString(disaster.disaster_south_longitude); Delete_disaster_east_latitude_txt_lbl.Text = Convert.ToString(disaster.disaster_east_latitude); Delete_disaster_east_longitude_txt_lbl.Text = Convert.ToString(disaster.disaster_east_longitude); Delete_disaster_west_latitude_txt_lbl.Text = Convert.ToString(disaster.disaster_west_latitude); Delete_disaster_west_longitude_txt_lbl.Text = Convert.ToString(disaster.disaster_west_longitude); return disaster; }
private void AddDisaster() { var context = new PSOConnect(); var disaster = context.disaster.FirstOrDefault(disasters => disasters.country.Equals(CountryField.Text) && disasters.city.Equals(CityField.Text) && EntityFunctions.TruncateTime(disasters.date.Value) == EntityFunctions.TruncateTime(DateField.Value)); disaster currentDisaster = null; if (disaster == null) { currentDisaster = new disaster { idDisaster = context.disaster.Count() > 0 ? context.disaster.Max(disasters => disasters.idDisaster) + 1 : 1, country = CountryField.Text, city = CityField.Text, date = DateField.Value }; context.disaster.Add(currentDisaster); } else { currentDisaster = disaster; } var reason = context.reason.FirstOrDefault(reasons => reasons.typeReason.Equals(TypeField.SelectedItem.ToString()) && reasons.reason1.Equals(ReasonField.Text) && reasons.idDisaster == currentDisaster.idDisaster); reason currentReason = null; if (reason == null) { currentReason = new reason { idReason = context.reason.Count() > 0 ? context.reason.Max(reasons => reasons.idReason) + 1 : 1, typeReason = TypeField.Text, reason1 = ReasonField.Text, }; currentDisaster.reason.Add(currentReason); context.reason.Add(currentReason); } context.SaveChanges(); }
public disaster disaster_insert() { disaster.disaster_name = Insert_disaster_name_txt.Text; disaster.disaster_type = Insert_disaster_type_txt.Text; disaster.disaster_start_date = Convert.ToDateTime(Insert_disaster_start_date_txt.Text); disaster.disaster_end_date = Convert.ToDateTime(Insert_disaster_end_date_txt.Text); disaster.disaster_north_latitude = Convert.ToDecimal(Insert_disaster_north_latitude_txt.Text); disaster.disaster_north_longitude = Convert.ToDecimal(Insert_disaster_north_longitude_txt.Text); disaster.disaster_south_latitude = Convert.ToDecimal(Insert_disaster_south_latitude_txt.Text); disaster.disaster_south_longitude = Convert.ToDecimal(Insert_disaster_south_longitude_txt.Text); disaster.disaster_east_latitude = Convert.ToDecimal(Insert_disaster_east_latitude_txt.Text); disaster.disaster_east_longitude = Convert.ToDecimal(Insert_disaster_east_longitude_txt.Text); disaster.disaster_west_latitude = Convert.ToDecimal(Insert_disaster_west_latitude_txt.Text); disaster.disaster_west_longitude = Convert.ToDecimal(Insert_disaster_west_longitude_txt.Text); disaster = disaster.Insert(disaster); Insert_disaster_GridView.DataBind(); Update_disaster_GridView.DataBind(); Delete_disaster_GridView.DataBind(); return(disaster); }
public disaster disaster_update(int ID) { disaster = disaster.Select(ID); disaster.disaster_id = Convert.ToInt32(Update_disaster_id_txt.Text); disaster.disaster_name = Update_disaster_name_txt.Text; disaster.disaster_type = Update_disaster_type_txt.Text; disaster.disaster_start_date = Convert.ToDateTime(Update_disaster_start_date_txt.Text); disaster.disaster_end_date = Convert.ToDateTime(Update_disaster_end_date_txt.Text); disaster.disaster_north_latitude = Convert.ToDecimal(Update_disaster_north_latitude_txt.Text); disaster.disaster_north_longitude = Convert.ToDecimal(Update_disaster_north_longitude_txt.Text); disaster.disaster_south_latitude = Convert.ToDecimal(Update_disaster_south_latitude_txt.Text); disaster.disaster_south_longitude = Convert.ToDecimal(Update_disaster_south_longitude_txt.Text); disaster.disaster_east_latitude = Convert.ToDecimal(Update_disaster_east_latitude_txt.Text); disaster.disaster_east_longitude = Convert.ToDecimal(Update_disaster_east_longitude_txt.Text); disaster.disaster_west_latitude = Convert.ToDecimal(Update_disaster_west_latitude_txt.Text); disaster.disaster_west_longitude = Convert.ToDecimal(Update_disaster_west_longitude_txt.Text); disaster.Update(disaster); Insert_disaster_GridView.DataBind(); Update_disaster_GridView.DataBind(); Delete_disaster_GridView.DataBind(); return(disaster); }
//display the disaster on screen (data and poly points) protected void ddlDisaster_SelectedIndexChanged(object sender, EventArgs e) { try { Page page = HttpContext.Current.Handler as Page; ScriptManager.RegisterStartupScript(page, page.GetType(), "plotPoly", "plotPoly();", true); disaster disaster = new disaster(); GlobalVariables.DisasterID = Convert.ToInt32(ddlDisaster.SelectedItem.Value); disaster = disaster.Select(GlobalVariables.DisasterID); HFDisasterName.Value = disaster.disaster_name.ToString(); HFDisasterType.Value = disaster.disaster_type.ToString(); HFNorthLat.Value = disaster.disaster_north_latitude.ToString(); HFNorthLong.Value = disaster.disaster_north_longitude.ToString(); HFSouthLat.Value = disaster.disaster_south_latitude.ToString(); HFSouthLong.Value = disaster.disaster_south_longitude.ToString(); HFEastLat.Value = disaster.disaster_east_latitude.ToString(); HFEastLong.Value = disaster.disaster_east_longitude.ToString(); HFWestLat.Value = disaster.disaster_west_latitude.ToString(); HFWestLong.Value = disaster.disaster_west_longitude.ToString(); } catch { } }
//display the disaster on screen protected void ddlDisaster_SelectedIndexChanged(object sender, EventArgs e) { try { disaster disaster = new disaster(); GlobalVariables.DisasterID = Convert.ToInt32(ddlDisaster.SelectedItem.Value); disaster = disaster.Select(Convert.ToInt32(ddlDisaster.SelectedItem.Value)); nLat = disaster.disaster_north_latitude; nLong = disaster.disaster_north_longitude; sLat = disaster.disaster_south_latitude; sLong = disaster.disaster_south_longitude; eLat = disaster.disaster_east_latitude; eLong = disaster.disaster_east_longitude; wLat = disaster.disaster_west_latitude; wLong = disaster.disaster_west_longitude; Page.ClientScript.RegisterStartupScript(this.GetType(), "plotPoly", "plotPoly()", true); } catch { } }
//display the disaster on screen (data and poly points) protected void ddlDisaster_SelectedIndexChanged(object sender, EventArgs e) { try { Page page = HttpContext.Current.Handler as Page; ScriptManager.RegisterStartupScript(page, page.GetType(), "plotPoly", "plotPoly();", true); disaster disaster = new disaster(); GlobalVariables.DisasterID = Convert.ToInt32(ddlDisaster.SelectedItem.Value); disaster = disaster.Select(GlobalVariables.DisasterID); txtDisasterName.Text = disaster.disaster_name.ToString(); txtDisasterType.Text = disaster.disaster_type.ToString(); txtNorthLat.Text = disaster.disaster_north_latitude.ToString(); txtNorthLong.Text = disaster.disaster_north_longitude.ToString(); txtSouthLat.Text = disaster.disaster_south_latitude.ToString(); txtSouthLong.Text = disaster.disaster_south_longitude.ToString(); txtEastLat.Text = disaster.disaster_east_latitude.ToString(); txtEastLong.Text = disaster.disaster_east_longitude.ToString(); txtWestLat.Text = disaster.disaster_west_latitude.ToString(); txtWestLong.Text = disaster.disaster_west_longitude.ToString(); } catch { } }
public disaster disaster_insert() { disaster.disaster_name = Insert_disaster_name_txt.Text; disaster.disaster_type = Insert_disaster_type_txt.Text; disaster.disaster_start_date = Convert.ToDateTime(Insert_disaster_start_date_txt.Text); disaster.disaster_end_date = Convert.ToDateTime(Insert_disaster_end_date_txt.Text); disaster.disaster_north_latitude = Convert.ToDecimal(Insert_disaster_north_latitude_txt.Text); disaster.disaster_north_longitude = Convert.ToDecimal(Insert_disaster_north_longitude_txt.Text); disaster.disaster_south_latitude = Convert.ToDecimal(Insert_disaster_south_latitude_txt.Text); disaster.disaster_south_longitude = Convert.ToDecimal(Insert_disaster_south_longitude_txt.Text); disaster.disaster_east_latitude = Convert.ToDecimal(Insert_disaster_east_latitude_txt.Text); disaster.disaster_east_longitude = Convert.ToDecimal(Insert_disaster_east_longitude_txt.Text); disaster.disaster_west_latitude = Convert.ToDecimal(Insert_disaster_west_latitude_txt.Text); disaster.disaster_west_longitude = Convert.ToDecimal(Insert_disaster_west_longitude_txt.Text); disaster = disaster.Insert(disaster); Insert_disaster_GridView.DataBind(); Update_disaster_GridView.DataBind(); Delete_disaster_GridView.DataBind(); return disaster; }
protected void Insert_Select_Record(object sender, EventArgs e) { disaster = Insert_disaster_select(Convert.ToInt32(Insert_disaster_GridView.SelectedValue)); }
protected void UPDATE(object sender, EventArgs e) { disaster = disaster_update(Convert.ToInt32(Update_disaster_GridView.SelectedValue)); }
protected void Update_Select_Record(object sender, EventArgs e) { disaster = Update_disaster_select(Convert.ToInt32(Update_disaster_GridView.SelectedValue)); }
private void Awake() { instance = this; }
protected void INSERT(object sender, EventArgs e) { disaster = disaster_insert(); }
public disaster disaster_update(int ID) { disaster = disaster.Select(ID); disaster.disaster_id = Convert.ToInt32(Update_disaster_id_txt.Text); disaster.disaster_name = Update_disaster_name_txt.Text; disaster.disaster_type = Update_disaster_type_txt.Text; disaster.disaster_start_date = Convert.ToDateTime(Update_disaster_start_date_txt.Text); disaster.disaster_end_date = Convert.ToDateTime(Update_disaster_end_date_txt.Text); disaster.disaster_north_latitude = Convert.ToDecimal(Update_disaster_north_latitude_txt.Text); disaster.disaster_north_longitude = Convert.ToDecimal(Update_disaster_north_longitude_txt.Text); disaster.disaster_south_latitude = Convert.ToDecimal(Update_disaster_south_latitude_txt.Text); disaster.disaster_south_longitude = Convert.ToDecimal(Update_disaster_south_longitude_txt.Text); disaster.disaster_east_latitude = Convert.ToDecimal(Update_disaster_east_latitude_txt.Text); disaster.disaster_east_longitude = Convert.ToDecimal(Update_disaster_east_longitude_txt.Text); disaster.disaster_west_latitude = Convert.ToDecimal(Update_disaster_west_latitude_txt.Text); disaster.disaster_west_longitude = Convert.ToDecimal(Update_disaster_west_longitude_txt.Text); disaster.Update(disaster); Insert_disaster_GridView.DataBind(); Update_disaster_GridView.DataBind(); Delete_disaster_GridView.DataBind(); return disaster; }
private void InitFields() { var context = new PSOConnect(); var team = context.team.FirstOrDefault(teams => teams.idTeam == Login.CurrentUser.idTeam); foreach (var disaster in context.disaster) { SelectDisasterField.Items.Add($"{ disaster.idDisaster}-СТРАНА: { disaster.country} ГОРОД: { disaster.city} ДАТА: { disaster.date.Value.ToLongDateString()}"); if (team.idDisaster == null || team.idDisaster != disaster.idDisaster) { continue; } SelectDisasterField.SelectedItem = SelectDisasterField.Items[SelectDisasterField.Items.Count - 1]; _disaster = disaster; CountyResultText.Text = disaster.country.ToString(); CityResultText.Text = disaster.city.ToString(); DateResultText.Text = disaster.date.Value.ToShortDateString(); ReasonText.Text = disaster.reason.Count > 1 ? "Причины" : "Причина"; foreach (var reason in disaster.reason) { ListInfo.Items.Add($"ТИП: {reason.typeReason} ПРИЧИНА: {reason.reason1}"); } } NoFoundDisasterText.Hide(); if (team.idDisaster == null) { ListInfo.Hide(); ReasonText.Hide(); DateResultText.Hide(); DateText.Hide(); CountryText.Hide(); CountyResultText.Hide(); CityResultText.Hide(); CityText.Hide(); SelectDisasterField.Show(); SelectDisasterText.Show(); SelectedButton.Show(); CompletedButton.Hide(); if (SelectDisasterField.Items.Count > 0) { SelectDisasterField.SelectedIndex = 0; } else { SelectedButton.Hide(); NoFoundDisasterText.Show(); SelectDisasterField.Hide(); } } else { ListInfo.Show(); ReasonText.Show(); DateResultText.Show(); DateText.Show(); CountryText.Show(); CountyResultText.Show(); CityResultText.Show(); CityText.Show(); SelectDisasterField.Hide(); SelectDisasterText.Hide(); SelectedButton.Hide(); CompletedButton.Show(); } if (SelectDisasterField.Items.Count == 0) { SelectDisasterField.Hide(); NoFoundDisasterText.Show(); CompletedButton.Hide(); } }