public Boolean Update(house id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_HOUSE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@house_id", id.house_id); cmd.Parameters.AddWithValue("@house_name", id.house_name); cmd.Parameters.AddWithValue("@house_eligibility", id.house_eligibility); cmd.Parameters.AddWithValue("@house_request_date", id.house_request_date); cmd.Parameters.AddWithValue("@house_voucher_amt", id.house_voucher_amt); cmd.Parameters.AddWithValue("@house_voucher_begin_date", id.house_voucher_begin_date); cmd.Parameters.AddWithValue("@house_voucher_exp_date", id.house_voucher_exp_date); cmd.Parameters.AddWithValue("@house_voucher_num", id.house_voucher_num); cmd.Parameters.AddWithValue("@house_voucher_schedule", id.house_voucher_schedule); cmd.Parameters.AddWithValue("@house_wait_list", id.house_wait_list); cmd.ExecuteReader(); con.Close(); return(true); } catch (Exception ex) { return(false); } finally { con.Close(); } }
public house Insert(house id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_HOUSE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@house_name", id.house_name); cmd.Parameters.AddWithValue("@house_eligibility", id.house_eligibility); cmd.Parameters.AddWithValue("@house_request_date", id.house_request_date); cmd.Parameters.AddWithValue("@house_voucher_amt", id.house_voucher_amt); cmd.Parameters.AddWithValue("@house_voucher_begin_date", id.house_voucher_begin_date); cmd.Parameters.AddWithValue("@house_voucher_exp_date", id.house_voucher_exp_date); cmd.Parameters.AddWithValue("@house_voucher_num", id.house_voucher_num); cmd.Parameters.AddWithValue("@house_voucher_schedule", id.house_voucher_schedule); cmd.Parameters.AddWithValue("@house_wait_list", id.house_wait_list); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_HOUSE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@house_name", id.house_name); cmd.Parameters.AddWithValue("@house_eligibility", id.house_eligibility); cmd.Parameters.AddWithValue("@house_request_date", id.house_request_date); cmd.Parameters.AddWithValue("@house_voucher_amt", id.house_voucher_amt); cmd.Parameters.AddWithValue("@house_voucher_begin_date", id.house_voucher_begin_date); cmd.Parameters.AddWithValue("@house_voucher_exp_date", id.house_voucher_exp_date); cmd.Parameters.AddWithValue("@house_voucher_num", id.house_voucher_num); cmd.Parameters.AddWithValue("@house_voucher_schedule", id.house_voucher_schedule); cmd.Parameters.AddWithValue("@house_wait_list", id.house_wait_list); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.house_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public Boolean Update(house id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_HOUSE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@house_id", id.house_id); cmd.Parameters.AddWithValue("@house_name", id.house_name); cmd.Parameters.AddWithValue("@house_eligibility", id.house_eligibility); cmd.Parameters.AddWithValue("@house_request_date", id.house_request_date); cmd.Parameters.AddWithValue("@house_voucher_amt", id.house_voucher_amt); cmd.Parameters.AddWithValue("@house_voucher_begin_date", id.house_voucher_begin_date); cmd.Parameters.AddWithValue("@house_voucher_exp_date", id.house_voucher_exp_date); cmd.Parameters.AddWithValue("@house_voucher_num", id.house_voucher_num); cmd.Parameters.AddWithValue("@house_voucher_schedule", id.house_voucher_schedule); cmd.Parameters.AddWithValue("@house_wait_list", id.house_wait_list); cmd.ExecuteReader(); con.Close(); return true; } catch (Exception ex) { return false; } finally { con.Close(); } }
public house Select(int id) { house house = new house(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_HOUSE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@house_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { house.house_id = rdr.GetInt32(0); } else { house.house_id = 0; } if (!rdr.IsDBNull(1)) { house.house_name = rdr.GetString(1); } else { house.house_name = " "; } if (!rdr.IsDBNull(2)) { house.house_eligibility = rdr.GetString(2); } else { house.house_eligibility = " "; } if (!rdr.IsDBNull(3)) { house.house_request_date = rdr.GetDateTime(3); } else { house.house_request_date = DateTime.Now; } if (!rdr.IsDBNull(4)) { house.house_voucher_amt = rdr.GetDecimal(4); } else { house.house_voucher_amt = 0; } if (!rdr.IsDBNull(5)) { house.house_voucher_begin_date = rdr.GetDateTime(5); } else { house.house_voucher_begin_date = DateTime.Now; } if (!rdr.IsDBNull(6)) { house.house_voucher_exp_date = rdr.GetDateTime(6); } else { house.house_voucher_exp_date = DateTime.Now; } if (!rdr.IsDBNull(7)) { house.house_voucher_num = rdr.GetInt32(7); } else { house.house_voucher_num = 0; } if (!rdr.IsDBNull(8)) { house.house_voucher_schedule = rdr.GetString(8); } else { house.house_voucher_schedule = " "; } if (!rdr.IsDBNull(9)) { house.house_wait_list = rdr.GetInt32(9); } else { house.house_wait_list = 0; } } else { house.SetColumnDefaults(); } } catch (Exception ex) { house.SetColumnDefaults(); return house; } finally { con.Close(); } return house; }
public house Insert(house id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_HOUSE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@house_name", id.house_name); cmd.Parameters.AddWithValue("@house_eligibility", id.house_eligibility); cmd.Parameters.AddWithValue("@house_request_date", id.house_request_date); cmd.Parameters.AddWithValue("@house_voucher_amt", id.house_voucher_amt); cmd.Parameters.AddWithValue("@house_voucher_begin_date", id.house_voucher_begin_date); cmd.Parameters.AddWithValue("@house_voucher_exp_date", id.house_voucher_exp_date); cmd.Parameters.AddWithValue("@house_voucher_num", id.house_voucher_num); cmd.Parameters.AddWithValue("@house_voucher_schedule", id.house_voucher_schedule); cmd.Parameters.AddWithValue("@house_wait_list", id.house_wait_list); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_HOUSE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@house_name", id.house_name); cmd.Parameters.AddWithValue("@house_eligibility", id.house_eligibility); cmd.Parameters.AddWithValue("@house_request_date", id.house_request_date); cmd.Parameters.AddWithValue("@house_voucher_amt", id.house_voucher_amt); cmd.Parameters.AddWithValue("@house_voucher_begin_date", id.house_voucher_begin_date); cmd.Parameters.AddWithValue("@house_voucher_exp_date", id.house_voucher_exp_date); cmd.Parameters.AddWithValue("@house_voucher_num", id.house_voucher_num); cmd.Parameters.AddWithValue("@house_voucher_schedule", id.house_voucher_schedule); cmd.Parameters.AddWithValue("@house_wait_list", id.house_wait_list); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.house_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public house Select(int id) { house house = new house(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_HOUSE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@house_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { house.house_id = rdr.GetInt32(0); } else { house.house_id = 0; } if (!rdr.IsDBNull(1)) { house.house_name = rdr.GetString(1); } else { house.house_name = " "; } if (!rdr.IsDBNull(2)) { house.house_eligibility = rdr.GetString(2); } else { house.house_eligibility = " "; } if (!rdr.IsDBNull(3)) { house.house_request_date = rdr.GetDateTime(3); } else { house.house_request_date = DateTime.Now; } if (!rdr.IsDBNull(4)) { house.house_voucher_amt = rdr.GetDecimal(4); } else { house.house_voucher_amt = 0; } if (!rdr.IsDBNull(5)) { house.house_voucher_begin_date = rdr.GetDateTime(5); } else { house.house_voucher_begin_date = DateTime.Now; } if (!rdr.IsDBNull(6)) { house.house_voucher_exp_date = rdr.GetDateTime(6); } else { house.house_voucher_exp_date = DateTime.Now; } if (!rdr.IsDBNull(7)) { house.house_voucher_num = rdr.GetInt32(7); } else { house.house_voucher_num = 0; } if (!rdr.IsDBNull(8)) { house.house_voucher_schedule = rdr.GetString(8); } else { house.house_voucher_schedule = " "; } if (!rdr.IsDBNull(9)) { house.house_wait_list = rdr.GetInt32(9); } else { house.house_wait_list = 0; } } else { house.SetColumnDefaults(); } } catch (Exception ex) { house.SetColumnDefaults(); return(house); } finally { con.Close(); } return(house); }