/// <summary>
/// Creates command for updating files into database table by concrete values
/// </summary>
/// <param name="fileName"></param>
/// <param name="barcode"></param>
/// <param name="fileId"></param>
/// <param name="content"></param>
/// <returns></returns>
public static SqlCommand CreateUpdateFileCommand(DbClientVoucher voucher)
{
const string sql = @"UPDATE FILES " +
"SET " +
"RetailerID = @RetailerID, " +
"VoucherID = @VoucherID, " +
"BarCode = @BarCode, " +
"VoucherImage = @VoucherImage, " +
"BarCodeImage = @BarCodeImage, " +
"DateInserted = @DateInserted " +
"WHERE SiteCode = @SiteCode AND CountryID = @CountryID";
SqlCommand command = MSSQL.CreateCommand(ConnectionString,
sql,
new SqlParameter("@CountryID", voucher.CountryID),
new SqlParameter("@RetailerID", voucher.RetailerID),
new SqlParameter("@VoucherID", voucher.VoucherID),
new SqlParameter("@BarCode", voucher.BarCode),
new SqlParameter("@VoucherImage", voucher.VoucherImage),
new SqlParameter("@BarCodeImage", voucher.BarCodeImage),
new SqlParameter("@DateInserted", DateTime.Now),
new SqlParameter("@SiteCode", voucher.SiteCode));
return(command);
}
/// <summary>
/// Updates files int database table by concrete values asynchronously
/// </summary>
/// <param name="fileName"></param>
/// <param name="barcode"></param>
/// <param name="fileId"></param>
/// <param name="content"></param>
/// <param name="success"></param>
/// <param name="error"></param>
public static void UpdateFileAsync(DbClientVoucher voucher, EventHandler success, ThreadExceptionEventHandler error)
{
SQLWorker.Default.Add(CreateUpdateFileCommand(voucher), success, error);
}
/// <summary>
/// Updates files into database table by concrete values
/// </summary>
/// <param name="fileName"></param>
/// <param name="barcode"></param>
/// <param name="fileId"></param>
/// <param name="content"></param>
/// <returns></returns>
public static int UpdateFile(DbClientVoucher voucher)
{
return(SQL.ExecuteNonQuery(CreateUpdateFileCommand(voucher)));
}
