//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 { }
 }
Example #4
0
 /////////////////////////
 ////////////////////////
 ///////////////////////
 //////////////////////
 /////////////////////
 //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 { }
 }
Example #5
0
 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);
 }
Example #6
0
        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;
 }
Example #8
0
        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();
        }
Example #9
0
 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);
 }
Example #10
0
 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);
 }
Example #11
0
 //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;
 }
Example #15
0
 protected void Insert_Select_Record(object sender, EventArgs e)
 {
     disaster = Insert_disaster_select(Convert.ToInt32(Insert_disaster_GridView.SelectedValue));
 }
Example #16
0
 protected void UPDATE(object sender, EventArgs e)
 {
     disaster = disaster_update(Convert.ToInt32(Update_disaster_GridView.SelectedValue));
 }
Example #17
0
 protected void Update_Select_Record(object sender, EventArgs e)
 {
     disaster = Update_disaster_select(Convert.ToInt32(Update_disaster_GridView.SelectedValue));
 }
Example #18
0
 private void Awake()
 {
     instance = this;
 }
        //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 { }
        }
 protected void INSERT(object sender, EventArgs e)
 {
     disaster = disaster_insert();
 }
Example #21
0
 protected void INSERT(object sender, EventArgs e)
 {
     disaster = disaster_insert();
 }
 protected void Insert_Select_Record(object sender, EventArgs e)
 {
     disaster = Insert_disaster_select(Convert.ToInt32(Insert_disaster_GridView.SelectedValue));
 }
 protected void Update_Select_Record(object sender, EventArgs e)
 {
     disaster = Update_disaster_select(Convert.ToInt32(Update_disaster_GridView.SelectedValue));
 }
 protected void UPDATE(object sender, EventArgs e)
 {
     disaster = disaster_update(Convert.ToInt32(Update_disaster_GridView.SelectedValue));
 }
 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;
 }
Example #26
0
        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();
            }
        }