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