public Pet_Deceased Insert(Pet_Deceased id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_PET_DECEASED", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Pet_Deceased_ID", id.Pet_Deceased_ID); cmd.Parameters.AddWithValue("@Date_Deceased", id.Date_Deceased); cmd.Parameters.AddWithValue("@Location_ID", id.Location_ID); cmd.Parameters.AddWithValue("@Funeral", id.Funeral); cmd.Parameters.AddWithValue("@Cemetary_Name", id.Cemetary_Name); cmd.Parameters.AddWithValue("@Deceased_Type", id.Deceased_Type); cmd.Parameters.AddWithValue("@Date_Created", id.Date_Created); cmd.Parameters.AddWithValue("@Date_Modified", id.Date_Modified); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_PET_DECEASED", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Date_Deceased", id.Date_Deceased); cmd.Parameters.AddWithValue("@Location_ID", id.Location_ID); cmd.Parameters.AddWithValue("@Funeral", id.Funeral); cmd.Parameters.AddWithValue("@Cemetary_Name", id.Cemetary_Name); cmd.Parameters.AddWithValue("@Deceased_Type", id.Deceased_Type); cmd.Parameters.AddWithValue("@Date_Created", id.Date_Created); cmd.Parameters.AddWithValue("@Date_Modified", id.Date_Modified); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.Pet_Deceased_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public Pet_Deceased Select(int id) { Pet_Deceased Pet_Deceased = new Pet_Deceased(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_PET_DECEASED", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Pet_Deceased_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Pet_Deceased.Pet_Deceased_ID = rdr.GetInt32(0); } else { Pet_Deceased.Pet_Deceased_ID = 0; } if (!rdr.IsDBNull(1)) { Pet_Deceased.Date_Deceased = rdr.GetDateTime(1); } else { Pet_Deceased.Date_Deceased = DateTime.Now; } if (!rdr.IsDBNull(2)) { Pet_Deceased.Location_ID = rdr.GetInt32(2); } else { Pet_Deceased.Location_ID = 0; } if (!rdr.IsDBNull(3)) { Pet_Deceased.Funeral = rdr.GetString(3); } else { Pet_Deceased.Funeral = " "; } if (!rdr.IsDBNull(4)) { Pet_Deceased.Cemetary_Name = rdr.GetString(4); } else { Pet_Deceased.Cemetary_Name = " "; } if (!rdr.IsDBNull(5)) { Pet_Deceased.Deceased_Type = rdr.GetString(5); } else { Pet_Deceased.Deceased_Type = " "; } if (!rdr.IsDBNull(6)) { Pet_Deceased.Date_Created = rdr.GetDateTime(6); } else { Pet_Deceased.Date_Created = DateTime.Now; } if (!rdr.IsDBNull(7)) { Pet_Deceased.Date_Modified = rdr.GetDateTime(7); } else { Pet_Deceased.Date_Modified = DateTime.Now; } } else { Pet_Deceased.SetColumnDefaults(); } } catch (Exception ex) { Pet_Deceased.SetColumnDefaults(); return(Pet_Deceased); } finally { con.Close(); } return(Pet_Deceased); }
public Pet_Deceased Insert(Pet_Deceased id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_PET_DECEASED", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Pet_Deceased_ID", id.Pet_Deceased_ID); cmd.Parameters.AddWithValue("@Date_Deceased", id.Date_Deceased); cmd.Parameters.AddWithValue("@Location_ID", id.Location_ID); cmd.Parameters.AddWithValue("@Funeral", id.Funeral); cmd.Parameters.AddWithValue("@Cemetary_Name", id.Cemetary_Name); cmd.Parameters.AddWithValue("@Deceased_Type", id.Deceased_Type); cmd.Parameters.AddWithValue("@Date_Created", id.Date_Created); cmd.Parameters.AddWithValue("@Date_Modified", id.Date_Modified); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_PET_DECEASED", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Date_Deceased", id.Date_Deceased); cmd.Parameters.AddWithValue("@Location_ID", id.Location_ID); cmd.Parameters.AddWithValue("@Funeral", id.Funeral); cmd.Parameters.AddWithValue("@Cemetary_Name", id.Cemetary_Name); cmd.Parameters.AddWithValue("@Deceased_Type", id.Deceased_Type); cmd.Parameters.AddWithValue("@Date_Created", id.Date_Created); cmd.Parameters.AddWithValue("@Date_Modified", id.Date_Modified); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.Pet_Deceased_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public Pet_Deceased Select(int id) { Pet_Deceased Pet_Deceased = new Pet_Deceased(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_PET_DECEASED", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Pet_Deceased_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Pet_Deceased.Pet_Deceased_ID = rdr.GetInt32(0); } else { Pet_Deceased.Pet_Deceased_ID = 0; } if (!rdr.IsDBNull(1)) { Pet_Deceased.Date_Deceased = rdr.GetDateTime(1); } else { Pet_Deceased.Date_Deceased = DateTime.Now; } if (!rdr.IsDBNull(2)) { Pet_Deceased.Location_ID = rdr.GetInt32(2); } else { Pet_Deceased.Location_ID = 0; } if (!rdr.IsDBNull(3)) { Pet_Deceased.Funeral = rdr.GetString(3); } else { Pet_Deceased.Funeral = " "; } if (!rdr.IsDBNull(4)) { Pet_Deceased.Cemetary_Name = rdr.GetString(4); } else { Pet_Deceased.Cemetary_Name = " "; } if (!rdr.IsDBNull(5)) { Pet_Deceased.Deceased_Type = rdr.GetString(5); } else { Pet_Deceased.Deceased_Type = " "; } if (!rdr.IsDBNull(6)) { Pet_Deceased.Date_Created = rdr.GetDateTime(6); } else { Pet_Deceased.Date_Created = DateTime.Now; } if (!rdr.IsDBNull(7)) { Pet_Deceased.Date_Modified = rdr.GetDateTime(7); } else { Pet_Deceased.Date_Modified = DateTime.Now; } } else { Pet_Deceased.SetColumnDefaults(); } } catch (Exception ex) { Pet_Deceased.SetColumnDefaults(); return Pet_Deceased; } finally { con.Close(); } return Pet_Deceased; }