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);
}
