public Inspection_Status Insert(Inspection_Status id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_INSPECTION_STATUS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Evacuation_Area_ID", id.Evacuation_Area_ID); cmd.Parameters.AddWithValue("@Address_ID", id.Address_ID); cmd.Parameters.AddWithValue("@Inspection_Code", id.Inspection_Code); cmd.Parameters.AddWithValue("@Client_Found", id.Client_Found); cmd.Parameters.AddWithValue("@Client_Found_Status", id.Client_Found_Status); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_INSPECTION_STATUS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Evacuation_Area_ID", id.Evacuation_Area_ID); cmd.Parameters.AddWithValue("@Address_ID", id.Address_ID); cmd.Parameters.AddWithValue("@Inspection_Code", id.Inspection_Code); cmd.Parameters.AddWithValue("@Client_Found", id.Client_Found); cmd.Parameters.AddWithValue("@Client_Found_Status", id.Client_Found_Status); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.InspectionStatus_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public Inspection_Status Select(int id) { Inspection_Status Inspection_Status = new Inspection_Status(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_INSPECTION_STATUS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@InspectionStatus_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Inspection_Status.InspectionStatus_ID = rdr.GetInt32(0); } else { Inspection_Status.InspectionStatus_ID = 0; } if (!rdr.IsDBNull(1)) { Inspection_Status.Evacuation_Area_ID = rdr.GetInt32(1); } else { Inspection_Status.Evacuation_Area_ID = 0; } if (!rdr.IsDBNull(2)) { Inspection_Status.Address_ID = rdr.GetInt32(2); } else { Inspection_Status.Address_ID = 0; } if (!rdr.IsDBNull(3)) { Inspection_Status.Inspection_Code = rdr.GetString(3); } else { Inspection_Status.Inspection_Code = " "; } if (!rdr.IsDBNull(4)) { Inspection_Status.Client_Found = rdr.GetString(4); } else { Inspection_Status.Client_Found = " "; } if (!rdr.IsDBNull(5)) { Inspection_Status.Client_Found_Status = rdr.GetString(5); } else { Inspection_Status.Client_Found_Status = " "; } } else { Inspection_Status.SetColumnDefaults(); } } catch (Exception ex) { Inspection_Status.SetColumnDefaults(); return(Inspection_Status); } finally { con.Close(); } return(Inspection_Status); }
public Inspection_Status Insert(Inspection_Status id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_INSPECTION_STATUS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Evacuation_Area_ID", id.Evacuation_Area_ID); cmd.Parameters.AddWithValue("@Address_ID", id.Address_ID); cmd.Parameters.AddWithValue("@Inspection_Code", id.Inspection_Code); cmd.Parameters.AddWithValue("@Client_Found", id.Client_Found); cmd.Parameters.AddWithValue("@Client_Found_Status", id.Client_Found_Status); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_INSPECTION_STATUS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Evacuation_Area_ID", id.Evacuation_Area_ID); cmd.Parameters.AddWithValue("@Address_ID", id.Address_ID); cmd.Parameters.AddWithValue("@Inspection_Code", id.Inspection_Code); cmd.Parameters.AddWithValue("@Client_Found", id.Client_Found); cmd.Parameters.AddWithValue("@Client_Found_Status", id.Client_Found_Status); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.InspectionStatus_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public Inspection_Status Select(int id) { Inspection_Status Inspection_Status = new Inspection_Status(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_INSPECTION_STATUS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@InspectionStatus_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Inspection_Status.InspectionStatus_ID = rdr.GetInt32(0); } else { Inspection_Status.InspectionStatus_ID = 0; } if (!rdr.IsDBNull(1)) { Inspection_Status.Evacuation_Area_ID = rdr.GetInt32(1); } else { Inspection_Status.Evacuation_Area_ID = 0; } if (!rdr.IsDBNull(2)) { Inspection_Status.Address_ID = rdr.GetInt32(2); } else { Inspection_Status.Address_ID = 0; } if (!rdr.IsDBNull(3)) { Inspection_Status.Inspection_Code = rdr.GetString(3); } else { Inspection_Status.Inspection_Code = " "; } if (!rdr.IsDBNull(4)) { Inspection_Status.Client_Found = rdr.GetString(4); } else { Inspection_Status.Client_Found = " "; } if (!rdr.IsDBNull(5)) { Inspection_Status.Client_Found_Status = rdr.GetString(5); } else { Inspection_Status.Client_Found_Status = " "; } } else { Inspection_Status.SetColumnDefaults(); } } catch (Exception ex) { Inspection_Status.SetColumnDefaults(); return Inspection_Status; } finally { con.Close(); } return Inspection_Status; }