/// <summary>
/// Updates a Access into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="access_id">access_id</param>
/// <param name="company_id">company_id</param>
/// <param name="iPaddress">iPaddress</param>
/// <param name="access_type">access_type</param>
/// <param name="entry_datetime">entry_datetime</param>
public static void UpdateAccess(int @access_id, int @company_id, string @iPaddress, string @access_type, DateTime @entry_datetime)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateAccess(@access_id, @company_id, @iPaddress, @access_type, @entry_datetime, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a RewardSetting from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="setting_id">setting_id</param>
public static void DeleteRewardSetting(int @setting_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeleteRewardSetting(@setting_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a PurchaseOrderItem from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="purchaseorder_id">purchaseorder_id</param>
/// <param name="product_code">product_code</param>
public static void DeletePurchaseOrderItem(int @purchaseorder_id, string @product_code)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeletePurchaseOrderItem(@purchaseorder_id, @product_code, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a DocketItem into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="docketitem_id">docketitem_id</param>
/// <param name="docket_id">docket_id</param>
/// <param name="product_code">product_code</param>
/// <param name="description">description</param>
/// <param name="quantity">quantity</param>
/// <param name="product_barcode">product_barcode</param>
/// <param name="department">department</param>
/// <param name="cost_ex">cost_ex</param>
/// <param name="sale_ex">sale_ex</param>
/// <param name="category">category</param>
/// <param name="sale_inc">sale_inc</param>
public static void UpdateDocketItem(int @docketitem_id, int @docket_id, string @product_code, string @description, double @quantity, string @product_barcode, string @department, decimal @cost_ex, decimal @sale_ex, string @category, decimal @sale_inc)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateDocketItem(@docketitem_id, @docket_id, @product_code, @description, @quantity, @product_barcode, @department, @cost_ex, @sale_ex, @category, @sale_inc, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a Admin from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="admin_id">admin_id</param>
public static void DeleteAdmin(int @admin_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeleteAdmin(@admin_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a Company into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="company_id">company_id</param>
/// <param name="name">name</param>
/// <param name="brand_name">brand_name</param>
/// <param name="company_number">company_number</param>
/// <param name="contact_name">contact_name</param>
/// <param name="contact_email">contact_email</param>
/// <param name="transactions_email">transactions_email</param>
/// <param name="address">address</param>
/// <param name="suburb">suburb</param>
/// <param name="state">state</param>
/// <param name="country">country</param>
/// <param name="postcode">postcode</param>
/// <param name="phone">phone</param>
/// <param name="website">website</param>
/// <param name="api_key">api_key</param>
/// <param name="notes">notes</param>
/// <param name="is_active">is_active</param>
/// <param name="is_customer">is_customer</param>
/// <param name="is_supplier">is_supplier</param>
/// <param name="is_manufacturer">is_manufacturer</param>
/// <param name="paidto_datetime">paidto_datetime</param>
/// <param name="creation_datetime">creation_datetime</param>
/// <param name="has_POSSystem">has_POSSystem</param>
public static void UpdateCompany(int @company_id, string @name, string @brand_name, string @company_number, string @contact_name, string @contact_email, string @transactions_email, string @address, string @suburb, string @state, string @country, string @postcode, string @phone, string @website, string @api_key, string @notes, bool @is_active, bool @is_customer, bool @is_supplier, bool @is_manufacturer, DateTime @paidto_datetime, DateTime @creation_datetime, bool @has_POSSystem)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateCompany(@company_id, @name, @brand_name, @company_number, @contact_name, @contact_email, @transactions_email, @address, @suburb, @state, @country, @postcode, @phone, @website, @api_key, @notes, @is_active, @is_customer, @is_supplier, @is_manufacturer, @paidto_datetime, @creation_datetime, @has_POSSystem, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a AllowedStore into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="entry_id">entry_id</param>
/// <param name="customer_id">customer_id</param>
/// <param name="supplier_id">supplier_id</param>
/// <param name="account_number">account_number</param>
/// <param name="is_member">is_member</param>
/// <param name="authoriser_email">authoriser_email</param>
/// <param name="creation_datetime">creation_datetime</param>
public static void UpdateAllowedStore(int @entry_id, int @customer_id, int @supplier_id, string @account_number, bool @is_member, string @authoriser_email, DateTime @creation_datetime)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateAllowedStore(@entry_id, @customer_id, @supplier_id, @account_number, @is_member, @authoriser_email, @creation_datetime, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a PurchaseOrder from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="purchaseorder_id">purchaseorder_id</param>
public static void DeletePurchaseOrder(int @purchaseorder_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeletePurchaseOrder(@purchaseorder_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a PurchaseOrder into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="purchaseorder_id">purchaseorder_id</param>
/// <param name="customer_id">customer_id</param>
/// <param name="supplier_id">supplier_id</param>
/// <param name="person">person</param>
/// <param name="creation_datetime">creation_datetime</param>
/// <param name="local_code">local_code</param>
/// <param name="is_submitted">is_submitted</param>
/// <param name="submitted_datetime">submitted_datetime</param>
/// <param name="due_datetime">due_datetime</param>
public static void UpdatePurchaseOrder(int @purchaseorder_id, int @customer_id, int @supplier_id, string @person, DateTime @creation_datetime, string @local_code, bool @is_submitted, DateTime @submitted_datetime, DateTime @due_datetime)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdatePurchaseOrder(@purchaseorder_id, @customer_id, @supplier_id, @person, @creation_datetime, @local_code, @is_submitted, @submitted_datetime, @due_datetime, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a OutgoingSMS from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="outgoingSMS_id">outgoingSMS_id</param>
public static void DeleteOutgoingSMS(int @outgoingSMS_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeleteOutgoingSMS(@outgoingSMS_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Insert a OutgoingSMS into the data store based on the primitive properties. This can be used as the
/// insert method for an ObjectDataSource.
/// </summary>
/// <param name="admin_id">admin_id</param>
/// <param name="billingitem_id">billingitem_id</param>
/// <param name="customerlist_id">customerlist_id</param>
/// <param name="message_text">message_text</param>
/// <param name="notes">notes</param>
/// <param name="receipient_list">receipient_list</param>
/// <param name="count">count</param>
/// <param name="verification_sms">verification_sms</param>
/// <param name="unsubscribe_list">unsubscribe_list</param>
/// <param name="sent_datetime">sent_datetime</param>
/// <param name="response_list">response_list</param>
/// <param name="broken_list">broken_list</param>
public static void InsertOutgoingSMS(int @admin_id, int @billingitem_id, int @customerlist_id, string @message_text, string @notes, string @receipient_list, int @count, string @verification_sms, string @unsubscribe_list, DateTime @sent_datetime, string @response_list, string @broken_list)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
InsertOutgoingSMS(@admin_id, @billingitem_id, @customerlist_id, @message_text, @notes, @receipient_list, @count, @verification_sms, @unsubscribe_list, @sent_datetime, @response_list, @broken_list, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a PointsLog from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="pointlog_id">pointlog_id</param>
public static void DeletePointsLog(int @pointlog_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeletePointsLog(@pointlog_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a PointsLog into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="pointlog_id">pointlog_id</param>
/// <param name="customer_id">customer_id</param>
/// <param name="company_id">company_id</param>
/// <param name="reward_points">reward_points</param>
/// <param name="description">description</param>
/// <param name="creation_datetime">creation_datetime</param>
/// <param name="docket_id">docket_id</param>
/// <param name="voucher_id">voucher_id</param>
/// <param name="admin_id">admin_id</param>
public static void UpdatePointsLog(int @pointlog_id, int @customer_id, int @company_id, int @reward_points, string @description, DateTime @creation_datetime, int @docket_id, int @voucher_id, int @admin_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdatePointsLog(@pointlog_id, @customer_id, @company_id, @reward_points, @description, @creation_datetime, @docket_id, @voucher_id, @admin_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a BillingItem into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="billingitem_id">billingitem_id</param>
/// <param name="invoice_id">invoice_id</param>
/// <param name="company_id">company_id</param>
/// <param name="description">description</param>
/// <param name="quantity">quantity</param>
/// <param name="unit_cost">unit_cost</param>
/// <param name="total_amount">total_amount</param>
/// <param name="creation_datetime">creation_datetime</param>
public static void UpdateBillingItem(int @billingitem_id, int @invoice_id, int @company_id, string @description, int @quantity, decimal @unit_cost, decimal @total_amount, DateTime @creation_datetime)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateBillingItem(@billingitem_id, @invoice_id, @company_id, @description, @quantity, @unit_cost, @total_amount, @creation_datetime, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a RequestedAd into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="admatch_id">admatch_id</param>
/// <param name="uploadedad_id">uploadedad_id</param>
/// <param name="num_wanted">num_wanted</param>
/// <param name="daily_quota">daily_quota</param>
/// <param name="num_printed">num_printed</param>
/// <param name="is_active">is_active</param>
public static void UpdateRequestedAd(int @admatch_id, int @uploadedad_id, int @num_wanted, int @daily_quota, int @num_printed, bool @is_active)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateRequestedAd(@admatch_id, @uploadedad_id, @num_wanted, @daily_quota, @num_printed, @is_active, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a Company into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="company_id">company_id</param>
/// <param name="name">name</param>
/// <param name="abn">abn</param>
/// <param name="contact_name">contact_name</param>
/// <param name="contact_email">contact_email</param>
/// <param name="address">address</param>
/// <param name="suburb">suburb</param>
/// <param name="state">state</param>
/// <param name="postcode">postcode</param>
/// <param name="phone">phone</param>
/// <param name="fax">fax</param>
/// <param name="mobile">mobile</param>
/// <param name="technical_contact">technical_contact</param>
/// <param name="website">website</param>
/// <param name="notes">notes</param>
/// <param name="is_advertiser">is_advertiser</param>
/// <param name="is_retailer">is_retailer</param>
/// <param name="is_active">is_active</param>
/// <param name="creation_datetime">creation_datetime</param>
/// <param name="is_rewards">is_rewards</param>
/// <param name="paidto_datetime">paidto_datetime</param>
/// <param name="mailchimp_apikey">mailchimp_apikey</param>
/// <param name="mc_masterlist_id">mc_masterlist_id</param>
/// <param name="country">country</param>
/// <param name="smsEnabled">smsEnabled</param>
public static void UpdateCompany(int @company_id, string @name, string @abn, string @contact_name, string @contact_email, string @address, string @suburb, string @state, string @postcode, string @phone, string @fax, string @mobile, string @technical_contact, string @website, string @notes, bool @is_advertiser, bool @is_retailer, bool @is_active, DateTime @creation_datetime, bool @is_rewards, DateTime @paidto_datetime, string @mailchimp_apikey, string @mc_masterlist_id, string @country, bool @smsEnabled)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateCompany(@company_id, @name, @abn, @contact_name, @contact_email, @address, @suburb, @state, @postcode, @phone, @fax, @mobile, @technical_contact, @website, @notes, @is_advertiser, @is_retailer, @is_active, @creation_datetime, @is_rewards, @paidto_datetime, @mailchimp_apikey, @mc_masterlist_id, @country, @smsEnabled, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a Docket into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="docket_id">docket_id</param>
/// <param name="local_id">local_id</param>
/// <param name="code">code</param>
/// <param name="customer_id">customer_id</param>
/// <param name="store_id">store_id</param>
/// <param name="placedad_id">placedad_id</param>
/// <param name="total">total</param>
/// <param name="reward_points">reward_points</param>
/// <param name="raw_content">raw_content</param>
/// <param name="creation_datetime">creation_datetime</param>
public static void UpdateDocket(int @docket_id, int @local_id, string @code, int @customer_id, int @store_id, int @placedad_id, decimal @total, int @reward_points, string @raw_content, DateTime @creation_datetime)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateDocket(@docket_id, @local_id, @code, @customer_id, @store_id, @placedad_id, @total, @reward_points, @raw_content, @creation_datetime, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a PlacedAd into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="placedad_id">placedad_id</param>
/// <param name="admatch_id">admatch_id</param>
/// <param name="uploadedad_id">uploadedad_id</param>
/// <param name="owner_type">owner_type</param>
/// <param name="scanned_datetime">scanned_datetime</param>
/// <param name="scanned_store_id">scanned_store_id</param>
/// <param name="placement_datetime">placement_datetime</param>
/// <param name="trigger_id">trigger_id</param>
public static void UpdatePlacedAd(int @placedad_id, int @admatch_id, int @uploadedad_id, string @owner_type, DateTime @scanned_datetime, int @scanned_store_id, DateTime @placement_datetime, int @trigger_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdatePlacedAd(@placedad_id, @admatch_id, @uploadedad_id, @owner_type, @scanned_datetime, @scanned_store_id, @placement_datetime, @trigger_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a AllowedStore from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="entry_id">entry_id</param>
public static void DeleteAllowedStore(int @entry_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeleteAllowedStore(@entry_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a PlacedAd from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="placedad_id">placedad_id</param>
public static void DeletePlacedAd(int @placedad_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeletePlacedAd(@placedad_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a DocketItem from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="docketitem_id">docketitem_id</param>
public static void DeleteDocketItem(int @docketitem_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeleteDocketItem(@docketitem_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a UploadedAd into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="uploadedad_id">uploadedad_id</param>
/// <param name="company_id">company_id</param>
/// <param name="title">title</param>
/// <param name="notes">notes</param>
/// <param name="footer">footer</param>
/// <param name="global_barcode">global_barcode</param>
/// <param name="is_active">is_active</param>
/// <param name="creation_datetime">creation_datetime</param>
/// <param name="data">data</param>
public static void UpdateUploadedAd(int @uploadedad_id, int @company_id, string @title, string @notes, string @footer, string @global_barcode, bool @is_active, DateTime @creation_datetime, string @data)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateUploadedAd(@uploadedad_id, @company_id, @title, @notes, @footer, @global_barcode, @is_active, @creation_datetime, @data, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a Trigger into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="trigger_id">trigger_id</param>
/// <param name="store_id">store_id</param>
/// <param name="uploadedad_id">uploadedad_id</param>
/// <param name="creator_id">creator_id</param>
/// <param name="priority">priority</param>
/// <param name="header">header</param>
/// <param name="type">type</param>
/// <param name="value">value</param>
/// <param name="notes">notes</param>
/// <param name="is_active">is_active</param>
/// <param name="creation_datetime">creation_datetime</param>
public static void UpdateTrigger(int @trigger_id, int @store_id, int @uploadedad_id, int @creator_id, int @priority, string @header, string @type, string @value, string @notes, bool @is_active, DateTime @creation_datetime)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateTrigger(@trigger_id, @store_id, @uploadedad_id, @creator_id, @priority, @header, @type, @value, @notes, @is_active, @creation_datetime, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a Permission into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="permission_id">permission_id</param>
/// <param name="role_nameId">role_nameId</param>
/// <param name="admin_id">admin_id</param>
/// <param name="company_id">company_id</param>
/// <param name="authoriser_id">authoriser_id</param>
/// <param name="company_position">company_position</param>
/// <param name="creation_datetime">creation_datetime</param>
public static void UpdatePermission(int @permission_id, string @role_nameId, int @admin_id, int @company_id, int @authoriser_id, string @company_position, DateTime @creation_datetime)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdatePermission(@permission_id, @role_nameId, @admin_id, @company_id, @authoriser_id, @company_position, @creation_datetime, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a Admin into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="admin_id">admin_id</param>
/// <param name="first_name">first_name</param>
/// <param name="last_name">last_name</param>
/// <param name="email">email</param>
/// <param name="phone">phone</param>
/// <param name="mobile">mobile</param>
/// <param name="password_hash">password_hash</param>
/// <param name="is_active">is_active</param>
/// <param name="creation_datetime">creation_datetime</param>
public static void UpdateAdmin(int @admin_id, string @first_name, string @last_name, string @email, string @phone, string @mobile, string @password_hash, bool @is_active, DateTime @creation_datetime)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateAdmin(@admin_id, @first_name, @last_name, @email, @phone, @mobile, @password_hash, @is_active, @creation_datetime, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a Role into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="role_name">role_name</param>
/// <param name="notes">notes</param>
public static void UpdateRole(string @role_name, string @notes)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateRole(@role_name, @notes, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a RewardSetting into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="setting_id">setting_id</param>
/// <param name="company_id">company_id</param>
/// <param name="expiry_days">expiry_days</param>
/// <param name="points_per_dollar">points_per_dollar</param>
/// <param name="points_threshold">points_threshold</param>
/// <param name="voucher_amount">voucher_amount</param>
/// <param name="enable_vouchers">enable_vouchers</param>
public static void UpdateRewardSetting(int @setting_id, int @company_id, int @expiry_days, int @points_per_dollar, int @points_threshold, decimal @voucher_amount, bool @enable_vouchers)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateRewardSetting(@setting_id, @company_id, @expiry_days, @points_per_dollar, @points_threshold, @voucher_amount, @enable_vouchers, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Deletes a RequestedAd from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="admatch_id">admatch_id</param>
/// <param name="uploadedad_id">uploadedad_id</param>
public static void DeleteRequestedAd(int @admatch_id, int @uploadedad_id)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
DeleteRequestedAd(@admatch_id, @uploadedad_id, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a PurchaseOrderItem into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="purchaseorder_id">purchaseorder_id</param>
/// <param name="product_code">product_code</param>
/// <param name="barcode">barcode</param>
/// <param name="description">description</param>
/// <param name="quantity">quantity</param>
/// <param name="cost_price">cost_price</param>
public static void UpdatePurchaseOrderItem(int @purchaseorder_id, string @product_code, string @barcode, string @description, double @quantity, decimal @cost_price)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdatePurchaseOrderItem(@purchaseorder_id, @product_code, @barcode, @description, @quantity, @cost_price, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}
/// <summary>
/// Updates a Customer into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="customer_id">customer_id</param>
/// <param name="email">email</param>
/// <param name="mobile">mobile</param>
/// <param name="title">title</param>
/// <param name="sex">sex</param>
/// <param name="first_name">first_name</param>
/// <param name="last_name">last_name</param>
/// <param name="postcode">postcode</param>
/// <param name="password_hash">password_hash</param>
/// <param name="is_active">is_active</param>
/// <param name="verification_code">verification_code</param>
/// <param name="creation_datetime">creation_datetime</param>
/// <param name="phone">phone</param>
/// <param name="suburb">suburb</param>
/// <param name="state">state</param>
/// <param name="email_broken">email_broken</param>
/// <param name="mobile_broken">mobile_broken</param>
public static void UpdateCustomer(int @customer_id, string @email, string @mobile, string @title, bool @sex, string @first_name, string @last_name, string @postcode, string @password_hash, bool @is_active, string @verification_code, DateTime @creation_datetime, string @phone, string @suburb, string @state, bool @email_broken, bool @mobile_broken)
{
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
UpdateCustomer(@customer_id, @email, @mobile, @title, @sex, @first_name, @last_name, @postcode, @password_hash, @is_active, @verification_code, @creation_datetime, @phone, @suburb, @state, @email_broken, @mobile_broken, helper);
helper.Commit();
}
catch
{
helper.Rollback();
throw;
}
}
}