// 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 Insert(
Guid renewalId,
string title,
string description,
bool ignored,
string url,
DateTime?acknowledgedAt,
string acknowledgedBy,
string productTag,
DateTime dateReleased,
string newVersion)
{
using (SqlConnection connection = DatabaseFunctions.CreateConnection())
{
using (SqlTransaction tr = connection.BeginTransaction())
{
try
{
MaintenanceRenewalItemDAL maintenanceRenewalItemDal = MaintenanceRenewalItemDAL.Insert(connection, tr, renewalId, title, description, ignored, url, acknowledgedAt, acknowledgedBy, productTag, dateReleased, newVersion);
tr.Commit();
return(maintenanceRenewalItemDal);
}
catch (Exception ex)
{
tr.Rollback();
NotificationItemDAL.log.Error((object)(string.Format("Can't INSERT maintenance renewal item: ") + ex.ToString()));
throw;
}
}
}
}
private static MaintenanceRenewalItemDAL Insert(
SqlConnection con,
SqlTransaction tr,
Guid renewalId,
string title,
string description,
bool ignored,
string url,
DateTime?acknowledgedAt,
string acknowledgedBy,
string productTag,
DateTime dateReleased,
string newVersion)
{
if (tr == null)
{
throw new ArgumentNullException(nameof(tr));
}
if (string.IsNullOrEmpty(productTag))
{
throw new ArgumentNullException(nameof(productTag));
}
if (dateReleased == DateTime.MinValue)
{
throw new ArgumentNullException(nameof(dateReleased));
}
if (string.IsNullOrEmpty(newVersion))
{
throw new ArgumentNullException(nameof(newVersion));
}
MaintenanceRenewalItemDAL maintenanceRenewalItemDal = NotificationItemDAL.Insert <MaintenanceRenewalItemDAL>(con, tr, renewalId, title, description, ignored, url, acknowledgedAt, acknowledgedBy);
if (maintenanceRenewalItemDal == null)
{
return((MaintenanceRenewalItemDAL)null);
}
using (SqlCommand sqlCommand = new SqlCommand("INSERT INTO NotificationMaintenanceRenewals (RenewalID, ProductTag, DateReleased, Version) VALUES (@RenewalID, @ProductTag, @DateReleased, @NewVersion)"))
{
sqlCommand.Parameters.AddWithValue("@RenewalID", (object)renewalId);
sqlCommand.Parameters.AddWithValue("@ProductTag", (object)productTag);
sqlCommand.Parameters.AddWithValue("@DateReleased", (object)dateReleased);
sqlCommand.Parameters.AddWithValue("@NewVersion", (object)newVersion);
if (SqlHelper.ExecuteNonQuery(sqlCommand, con, tr) == 0)
{
maintenanceRenewalItemDal = (MaintenanceRenewalItemDAL)null;
}
else
{
maintenanceRenewalItemDal.ProductTag = productTag;
maintenanceRenewalItemDal.DateReleased = dateReleased;
maintenanceRenewalItemDal.NewVersion = newVersion;
}
}
return(maintenanceRenewalItemDal);
}
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);
}
}
}
// Token: 0x060008C9 RID: 2249 RVA: 0x0003F400 File Offset: 0x0003D600
public static MaintenanceRenewalItemDAL Insert(Guid renewalId, string title, string description, bool ignored, string url, DateTime?acknowledgedAt, string acknowledgedBy, string productTag, DateTime dateReleased, string newVersion)
{
MaintenanceRenewalItemDAL result;
using (SqlConnection sqlConnection = DatabaseFunctions.CreateConnection())
{
using (SqlTransaction sqlTransaction = sqlConnection.BeginTransaction())
{
try
{
MaintenanceRenewalItemDAL maintenanceRenewalItemDAL = MaintenanceRenewalItemDAL.Insert(sqlConnection, sqlTransaction, renewalId, title, description, ignored, url, acknowledgedAt, acknowledgedBy, productTag, dateReleased, newVersion);
sqlTransaction.Commit();
result = maintenanceRenewalItemDAL;
}
catch (Exception ex)
{
sqlTransaction.Rollback();
NotificationItemDAL.log.Error(string.Format("Can't INSERT maintenance renewal item: ", Array.Empty <object>()) + ex.ToString());
throw;
}
}
}
return(result);
}