public disaster Insert(disaster id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DISASTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_name", id.disaster_name); cmd.Parameters.AddWithValue("@disaster_type", id.disaster_type); cmd.Parameters.AddWithValue("@disaster_start_date", id.disaster_start_date); cmd.Parameters.AddWithValue("@disaster_end_date", id.disaster_end_date); cmd.Parameters.AddWithValue("@disaster_north_latitude", id.disaster_north_latitude); cmd.Parameters.AddWithValue("@disaster_north_longitude", id.disaster_north_longitude); cmd.Parameters.AddWithValue("@disaster_south_latitude", id.disaster_south_latitude); cmd.Parameters.AddWithValue("@disaster_south_longitude", id.disaster_south_longitude); cmd.Parameters.AddWithValue("@disaster_east_latitude", id.disaster_east_latitude); cmd.Parameters.AddWithValue("@disaster_east_longitude", id.disaster_east_longitude); cmd.Parameters.AddWithValue("@disaster_west_latitude", id.disaster_west_latitude); cmd.Parameters.AddWithValue("@disaster_west_longitude", id.disaster_west_longitude); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DISASTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_name", id.disaster_name); cmd.Parameters.AddWithValue("@disaster_type", id.disaster_type); cmd.Parameters.AddWithValue("@disaster_start_date", id.disaster_start_date); cmd.Parameters.AddWithValue("@disaster_end_date", id.disaster_end_date); cmd.Parameters.AddWithValue("@disaster_north_latitude", id.disaster_north_latitude); cmd.Parameters.AddWithValue("@disaster_north_longitude", id.disaster_north_longitude); cmd.Parameters.AddWithValue("@disaster_south_latitude", id.disaster_south_latitude); cmd.Parameters.AddWithValue("@disaster_south_longitude", id.disaster_south_longitude); cmd.Parameters.AddWithValue("@disaster_east_latitude", id.disaster_east_latitude); cmd.Parameters.AddWithValue("@disaster_east_longitude", id.disaster_east_longitude); cmd.Parameters.AddWithValue("@disaster_west_latitude", id.disaster_west_latitude); cmd.Parameters.AddWithValue("@disaster_west_longitude", id.disaster_west_longitude); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.disaster_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public disaster Select(int id) { disaster disaster = new disaster(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DISASTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { disaster.disaster_id = rdr.GetInt32(0); } else { disaster.disaster_id = 0; } if (!rdr.IsDBNull(1)) { disaster.disaster_name = rdr.GetString(1); } else { disaster.disaster_name = " "; } if (!rdr.IsDBNull(2)) { disaster.disaster_type = rdr.GetString(2); } else { disaster.disaster_type = " "; } if (!rdr.IsDBNull(3)) { disaster.disaster_start_date = rdr.GetDateTime(3); } else { disaster.disaster_start_date = DateTime.Now; } if (!rdr.IsDBNull(4)) { disaster.disaster_end_date = rdr.GetDateTime(4); } else { disaster.disaster_end_date = DateTime.Now; } if (!rdr.IsDBNull(5)) { disaster.disaster_north_latitude = rdr.GetDecimal(5); } else { disaster.disaster_north_latitude = 0; } if (!rdr.IsDBNull(6)) { disaster.disaster_north_longitude = rdr.GetDecimal(6); } else { disaster.disaster_north_longitude = 0; } if (!rdr.IsDBNull(7)) { disaster.disaster_south_latitude = rdr.GetDecimal(7); } else { disaster.disaster_south_latitude = 0; } if (!rdr.IsDBNull(8)) { disaster.disaster_south_longitude = rdr.GetDecimal(8); } else { disaster.disaster_south_longitude = 0; } if (!rdr.IsDBNull(9)) { disaster.disaster_east_latitude = rdr.GetDecimal(9); } else { disaster.disaster_east_latitude = 0; } if (!rdr.IsDBNull(10)) { disaster.disaster_east_longitude = rdr.GetDecimal(10); } else { disaster.disaster_east_longitude = 0; } if (!rdr.IsDBNull(11)) { disaster.disaster_west_latitude = rdr.GetDecimal(11); } else { disaster.disaster_west_latitude = 0; } if (!rdr.IsDBNull(12)) { disaster.disaster_west_longitude = rdr.GetDecimal(12); } else { disaster.disaster_west_longitude = 0; } } else { disaster.SetColumnDefaults(); } } catch (Exception ex) { disaster.SetColumnDefaults(); return(disaster); } finally { con.Close(); } return(disaster); }
public disaster Select(int id) { disaster disaster = new disaster(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DISASTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { disaster.disaster_id = rdr.GetInt32(0); } else { disaster.disaster_id = 0; } if (!rdr.IsDBNull(1)) { disaster.disaster_name = rdr.GetString(1); } else { disaster.disaster_name = " "; } if (!rdr.IsDBNull(2)) { disaster.disaster_type = rdr.GetString(2); } else { disaster.disaster_type = " "; } if (!rdr.IsDBNull(3)) { disaster.disaster_start_date = rdr.GetDateTime(3); } else { disaster.disaster_start_date = DateTime.Now; } if (!rdr.IsDBNull(4)) { disaster.disaster_end_date = rdr.GetDateTime(4); } else { disaster.disaster_end_date = DateTime.Now; } if (!rdr.IsDBNull(5)) { disaster.disaster_north_latitude = rdr.GetDecimal(5); } else { disaster.disaster_north_latitude = 0; } if (!rdr.IsDBNull(6)) { disaster.disaster_north_longitude = rdr.GetDecimal(6); } else { disaster.disaster_north_longitude = 0; } if (!rdr.IsDBNull(7)) { disaster.disaster_south_latitude = rdr.GetDecimal(7); } else { disaster.disaster_south_latitude = 0; } if (!rdr.IsDBNull(8)) { disaster.disaster_south_longitude = rdr.GetDecimal(8); } else { disaster.disaster_south_longitude = 0; } if (!rdr.IsDBNull(9)) { disaster.disaster_east_latitude = rdr.GetDecimal(9); } else { disaster.disaster_east_latitude = 0; } if (!rdr.IsDBNull(10)) { disaster.disaster_east_longitude = rdr.GetDecimal(10); } else { disaster.disaster_east_longitude = 0; } if (!rdr.IsDBNull(11)) { disaster.disaster_west_latitude = rdr.GetDecimal(11); } else { disaster.disaster_west_latitude = 0; } if (!rdr.IsDBNull(12)) { disaster.disaster_west_longitude = rdr.GetDecimal(12); } else { disaster.disaster_west_longitude = 0; } } else { disaster.SetColumnDefaults(); } } catch (Exception ex) { disaster.SetColumnDefaults(); return disaster; } finally { con.Close(); } return disaster; }
public disaster Insert(disaster id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DISASTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_name", id.disaster_name); cmd.Parameters.AddWithValue("@disaster_type", id.disaster_type); cmd.Parameters.AddWithValue("@disaster_start_date", id.disaster_start_date); cmd.Parameters.AddWithValue("@disaster_end_date", id.disaster_end_date); cmd.Parameters.AddWithValue("@disaster_north_latitude", id.disaster_north_latitude); cmd.Parameters.AddWithValue("@disaster_north_longitude", id.disaster_north_longitude); cmd.Parameters.AddWithValue("@disaster_south_latitude", id.disaster_south_latitude); cmd.Parameters.AddWithValue("@disaster_south_longitude", id.disaster_south_longitude); cmd.Parameters.AddWithValue("@disaster_east_latitude", id.disaster_east_latitude); cmd.Parameters.AddWithValue("@disaster_east_longitude", id.disaster_east_longitude); cmd.Parameters.AddWithValue("@disaster_west_latitude", id.disaster_west_latitude); cmd.Parameters.AddWithValue("@disaster_west_longitude", id.disaster_west_longitude); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DISASTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_name", id.disaster_name); cmd.Parameters.AddWithValue("@disaster_type", id.disaster_type); cmd.Parameters.AddWithValue("@disaster_start_date", id.disaster_start_date); cmd.Parameters.AddWithValue("@disaster_end_date", id.disaster_end_date); cmd.Parameters.AddWithValue("@disaster_north_latitude", id.disaster_north_latitude); cmd.Parameters.AddWithValue("@disaster_north_longitude", id.disaster_north_longitude); cmd.Parameters.AddWithValue("@disaster_south_latitude", id.disaster_south_latitude); cmd.Parameters.AddWithValue("@disaster_south_longitude", id.disaster_south_longitude); cmd.Parameters.AddWithValue("@disaster_east_latitude", id.disaster_east_latitude); cmd.Parameters.AddWithValue("@disaster_east_longitude", id.disaster_east_longitude); cmd.Parameters.AddWithValue("@disaster_west_latitude", id.disaster_west_latitude); cmd.Parameters.AddWithValue("@disaster_west_longitude", id.disaster_west_longitude); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.disaster_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }