public Hours Select(int id) { Hours Hours = new Hours(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_HOURS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Hours_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Hours.Hours_ID = rdr.GetInt32(0); } else { Hours.Hours_ID = 0; } if (!rdr.IsDBNull(1)) { Hours.Hours_Worked = rdr.GetInt32(1); } else { Hours.Hours_Worked = 0; } } else { Hours.SetColumnDefaults(); } } catch (Exception ex) { Hours.SetColumnDefaults(); return(Hours); } finally { con.Close(); } return(Hours); }
public Hours Insert(Hours id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_HOURS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_HOURS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.Hours_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public Hours Insert(Hours id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_HOURS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_HOURS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.Hours_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public Hours Select(int id) { Hours Hours = new Hours(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_HOURS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Hours_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Hours.Hours_ID = rdr.GetInt32(0); } else { Hours.Hours_ID = 0; } if (!rdr.IsDBNull(1)) { Hours.Hours_Worked = rdr.GetInt32(1); } else { Hours.Hours_Worked = 0; } } else { Hours.SetColumnDefaults(); } } catch (Exception ex) { Hours.SetColumnDefaults(); return Hours; } finally { con.Close(); } return Hours; }