// Token: 0x060008C7 RID: 2247 RVA: 0x0003F258 File Offset: 0x0003D458 public static MaintenanceRenewalItemDAL GetItemForProduct(string productTag) { if (string.IsNullOrEmpty(productTag)) { throw new ArgumentNullException("productTag"); } MaintenanceRenewalItemDAL result; using (SqlCommand sqlCommand = new SqlCommand("SELECT * FROM NotificationMaintenanceRenewals LEFT JOIN NotificationItems ON \r\n NotificationMaintenanceRenewals.RenewalID = NotificationItems.NotificationID\r\n WHERE ProductTag=@ProductTag")) { sqlCommand.Parameters.AddWithValue("@ProductTag", productTag); using (IDataReader dataReader = SqlHelper.ExecuteReader(sqlCommand)) { if (dataReader.Read()) { MaintenanceRenewalItemDAL maintenanceRenewalItemDAL = new MaintenanceRenewalItemDAL(); maintenanceRenewalItemDAL.LoadFromReader(dataReader); result = maintenanceRenewalItemDAL; } else { result = null; } } } return(result); }
public static MaintenanceRenewalItemDAL GetItemForProduct( string productTag) { if (string.IsNullOrEmpty(productTag)) { throw new ArgumentNullException(nameof(productTag)); } using (SqlCommand sqlCommand = new SqlCommand("SELECT * FROM NotificationMaintenanceRenewals LEFT JOIN NotificationItems ON \r\n NotificationMaintenanceRenewals.RenewalID = NotificationItems.NotificationID\r\n WHERE ProductTag=@ProductTag")) { sqlCommand.Parameters.AddWithValue("@ProductTag", (object)productTag); using (IDataReader rd = SqlHelper.ExecuteReader(sqlCommand)) { if (!rd.Read()) { return((MaintenanceRenewalItemDAL)null); } MaintenanceRenewalItemDAL maintenanceRenewalItemDal = new MaintenanceRenewalItemDAL(); maintenanceRenewalItemDal.LoadFromReader(rd); return(maintenanceRenewalItemDal); } } }