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