public static SIHOT_Suites Read(SqlDataReader reader) { SIHOT_Suites retval = new SIHOT_Suites(); for (int i = 0; i < reader.FieldCount; i++) { switch (reader.GetName(i)) { case "PCIID": retval.PCIID = Helper.ToInt32(reader[i]); break; case "RN": retval.SuiteRN = Helper.ToString(reader[i]); break; case "RN1": retval.RN1 = Helper.ToString(reader[i]); break; case "RN2": retval.RN2 = Helper.ToString(reader[i]); break; case "RN3": retval.RN3 = Helper.ToString(reader[i]); break; case "RN4": retval.RN4 = Helper.ToString(reader[i]); break; case "RN5": retval.RN5 = Helper.ToString(reader[i]); break; case "PH0": retval.PH0 = Helper.ToString(reader[i]); break; case "PH1": retval.PH1 = Helper.ToString(reader[i]); break; case "PH2": retval.PH2 = Helper.ToString(reader[i]); break; case "PH3": retval.PH3 = Helper.ToString(reader[i]); break; case "PH4": retval.PH4 = Helper.ToString(reader[i]); break; case "PH5": retval.PH5 = Helper.ToString(reader[i]); break; } } return retval; }
public static void InsertSIHOT_Suites(SIHOT_Suites value) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PCIID", value.PCIID), new SqlParameter("@SuiteRN", value.SuiteRN), new SqlParameter("@RN1", value.RN1), new SqlParameter("@RN2", value.RN2), new SqlParameter("@RN3", value.RN3), new SqlParameter("@RN4", value.RN4), new SqlParameter("@RN5", value.RN5), new SqlParameter("@PH0", value.PH0), new SqlParameter("@PH1", value.PH1), new SqlParameter("@PH2", value.PH2), new SqlParameter("@PH3", value.PH3), new SqlParameter("@PH4", value.PH4), new SqlParameter("@PH5", value.PH5) }; SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure, "insert_tblSIHOT_Suites", param); }