public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
bool denyToNonAdmins = !AppUsers.GetCurrentLogin().View.IsAdmin.ToBool();
scrud.DenyAdd = denyToNonAdmins;
scrud.DenyEdit = denyToNonAdmins;
scrud.DenyDelete = denyToNonAdmins;
scrud.KeyColumn = "api_access_policy_id";
scrud.TableSchema = "policy";
scrud.Table = "api_access_policy";
scrud.ViewSchema = "policy";
scrud.View = "api_access_policy";
scrud.PageSize = 100;
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.UseDisplayViewsAsParents = true;
scrud.Text = "API Access Policy";
this.ScrudPlaceholder.Controls.Add(scrud);
this.RegisterJavascript();
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
bool denyToNonAdmins = !AppUsers.GetCurrent().View.IsAdmin.ToBool();
scrud.DenyAdd = denyToNonAdmins;
scrud.DenyEdit = denyToNonAdmins;
scrud.DenyDelete = denyToNonAdmins;
scrud.ExcludeEdit = "user_id";
scrud.KeyColumn = "policy_id";
scrud.TableSchema = "policy";
scrud.Table = "auto_verification_policy";
scrud.ViewSchema = "policy";
scrud.View = "auto_verification_policy_scrud_view";
scrud.PageSize = 100;
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.UseDisplayViewsAsParents = true;
scrud.Text = Titles.AutoVerificationPolicy;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "item_type_id";
scrud.TableSchema = "core";
scrud.Table = "item_types";
scrud.ViewSchema = "core";
scrud.View = "item_type_scrud_view";
scrud.Text = Titles.ItemTypes;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "cash_flow_heading_id";
scrud.TableSchema = "core";
scrud.Table = "cash_flow_headings";
scrud.ViewSchema = "core";
scrud.View = "cash_flow_heading_scrud_view";
scrud.Text = Titles.CashFlowHeadings;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
protected void LoadControl()
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "sales_team_id";
scrud.TableSchema = "core";
scrud.Table = "sales_teams";
scrud.ViewSchema = "core";
scrud.View = "sales_team_scrud_view";
scrud.Text = Titles.SalesTeams;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "tax_master_id";
scrud.TableSchema = "core";
scrud.Table = "tax_master";
scrud.ViewSchema = "core";
scrud.View = "tax_master_scrud_view";
scrud.Text = Titles.TaxMaster;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "salesperson_bonus_setup_id";
scrud.TableSchema = "core";
scrud.Table = "salesperson_bonus_setups";
scrud.ViewSchema = "core";
scrud.View = "salesperson_bonus_setup_scrud_view";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.Text = Titles.AgentBonusSlabAssignment;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "cost_center_id";
scrud.TableSchema = "office";
scrud.Table = "cost_centers";
scrud.ViewSchema = "office";
scrud.View = "cost_center_scrud_view";
scrud.Text = Titles.CostCenters;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "lead_status_id";
scrud.TableSchema = "crm";
scrud.Table = "lead_statuses";
scrud.ViewSchema = "crm";
scrud.View = "lead_statuses";
scrud.Text = Titles.LeadStatuses;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "bonus_slab_detail_id";
scrud.TableSchema = "core";
scrud.Table = "bonus_slab_details";
scrud.ViewSchema = "core";
scrud.View = "bonus_slab_detail_scrud_view";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.Text = Titles.BonusSlabDetails;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "unit_id";
scrud.TableSchema = "core";
scrud.Table = "units";
scrud.ViewSchema = "core";
scrud.View = "unit_scrud_view";
scrud.Text = Titles.UnitsOfMeasure;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "fiscal_year_code";
scrud.TableSchema = "core";
scrud.Table = "fiscal_year";
scrud.ViewSchema = "core";
scrud.View = "fiscal_year_scrud_view";
scrud.Text = Titles.FiscalYear;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "item_group_id";
scrud.TableSchema = "core";
scrud.Table = "item_groups";
scrud.ViewSchema = "core";
scrud.View = "item_group_scrud_view";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.Text = Titles.ItemGroups;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "county_sales_tax_id";
scrud.TableSchema = "core";
scrud.Table = "county_sales_taxes";
scrud.ViewSchema = "core";
scrud.View = "county_sales_tax_scrud_view";
scrud.Text = Titles.CountySalesTaxes;
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "smtp_id";
scrud.ExcludeEdit = "key";
scrud.TableSchema = "config";
scrud.Table = "smtp";
scrud.ViewSchema = "config";
scrud.View = "smtp";
scrud.Text = Titles.SMTPConfiguration;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "ageing_slab_id";
scrud.TableSchema = "core";
scrud.Table = "ageing_slabs";
scrud.ViewSchema = "core";
scrud.View = "ageing_slab_scrud_view";
scrud.Text = Titles.AgeingSlabs;
this.AddScrudCustomValidatorErrorMessages();
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "recurring_invoice_id";
scrud.TableSchema = "core";
scrud.Table = "recurring_invoices";
scrud.ViewSchema = "core";
scrud.View = "recurring_invoice_scrud_view";
scrud.Text = Titles.RecurringInvoices;
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.UseDisplayViewsAsParents = true;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "merchant_fee_setup_id";
scrud.TableSchema = "core";
scrud.Table = "merchant_fee_setup";
scrud.ViewSchema = "core";
scrud.View = "merchant_fee_setup_scrud_view";
scrud.Text = Titles.MerchantFeeSetup;
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.UseDisplayViewsAsParents = true;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "key";
scrud.ExcludeEdit = "key";
scrud.TableSchema = "config";
scrud.DenyDelete = true;
scrud.Table = "db_parameters";
scrud.ViewSchema = "config";
scrud.View = "db_parameter_scrud_view";
scrud.Text = Titles.DatabaseParameters;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "payment_term_id";
scrud.TableSchema = "core";
scrud.Table = "payment_terms";
scrud.ViewSchema = "core";
scrud.View = "payment_term_scrud_view";
scrud.Text = Titles.PaymentTerms;
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
this.AddScrudCustomValidatorErrorMessages();
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "cash_repository_id";
scrud.TableSchema = "office";
scrud.Table = "cash_repositories";
scrud.ViewSchema = "office";
scrud.View = "cash_repository_scrud_view";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.Text = Titles.CashRepositories;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "item_id";
scrud.TableSchema = "core";
scrud.Table = "items";
scrud.ViewSchema = "core";
scrud.View = "item_scrud_view";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.UseDisplayViewsAsParents = true;
scrud.ExcludeEdit = "item_code, maintain_stock, item_group_id";
scrud.Text = Titles.Items;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.TableSchema = "core";
scrud.Table = "accounts";
scrud.KeyColumn = "account_id";
scrud.ViewSchema = "core";
scrud.View = "account_scrud_view";
scrud.Exclude = "sys_type";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.Text = Titles.ChartOfAccounts;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "key";
scrud.ExcludeEdit = "key";
scrud.TableSchema = "config";
scrud.DenyDelete = true;
scrud.Table = "open_exchange_rates";
scrud.ViewSchema = "config";
scrud.View = "open_exchange_rates";
scrud.Text = Titles.OpenExchangeRatesParameters;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "office_id";
scrud.TableSchema = "office";
scrud.Table = "offices";
scrud.ViewSchema = "office";
scrud.View = "office_scrud_view";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.ExcludeEdit = "currency_code";
scrud.Text = Titles.OfficeSetup;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "recurring_invoice_setup_id";
scrud.TableSchema = "core";
scrud.Table = "recurring_invoice_setup";
scrud.ViewSchema = "core";
scrud.View = "recurring_invoice_setup_scrud_view";
scrud.Text = Titles.RecurringInvoiceSetup;
scrud.ExcludeEdit =
"recurrence_type_id, recurring_frequency_id, recurring_duration, recurs_on_same_calendar_date, account_id";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.UseDisplayViewsAsParents = true;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
protected void LoadControl()
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "salesperson_id";
scrud.TableSchema = "core";
scrud.Table = "salespersons";
scrud.ViewSchema = "core";
scrud.View = "salesperson_scrud_view";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.UseDisplayViewsAsParents = true;
scrud.SelectedValues = GetSelectedValues();
scrud.Text = Titles.SalesPersons;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "shipping_address_id";
scrud.TableSchema = "core";
scrud.Table = "shipping_addresses";
scrud.ViewSchema = "core";
scrud.View = "shipping_address_scrud_view";
//Shipping address code will be automatically generated on the database.
scrud.Exclude = "shipping_address_code";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.Text = Titles.ShippingAddressMaintenance;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
private void AddScrud()
{
using (Scrud scrud = new Scrud())
{
scrud.DenyAdd = true;
scrud.DenyDelete = true;
scrud.DenyEdit = true;
scrud.KeyColumn = "relname";
scrud.PageSize = 500;
scrud.TableSchema = "public";
scrud.Table = "db_stat";
scrud.ViewSchema = "public";
scrud.View = "db_stat";
scrud.Text = Titles.DatabaseStatistics;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}
public override void OnControlLoad(object sender, EventArgs e)
{
using (Scrud scrud = new Scrud())
{
scrud.KeyColumn = "shipper_id";
scrud.TableSchema = "core";
scrud.Table = "shippers";
scrud.ViewSchema = "core";
scrud.View = "shipper_scrud_view";
//The following fields will be automatically generated on the database server.
scrud.Exclude = "shipper_code, shipper_name";
scrud.DisplayFields = GetDisplayFields();
scrud.DisplayViews = GetDisplayViews();
scrud.SelectedValues = GetSelectedValues();
scrud.Text = Titles.Shippers;
this.ScrudPlaceholder.Controls.Add(scrud);
}
}