public Edit_Cost_Codes(COMMethods mbapi)
{
MBAPI = mbapi;
ProgInfo = mbapi.GetProgramInfo();
InitializeComponent();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="job"></param>
public WorkOrderExportJobConfigUI()
{
InitializeComponent();
_jobConfig = new WorkOrderExportJobConfig();
_jobConfig.LookBackPeriod = 1M;
_methods = new COMMethods();
}
public Multi_Union_Selector(COMMethods mbapi)
{
MBAPI = mbapi;
ProgInfo = mbapi.GetProgramInfo();
InitializeComponent();
}
public ViewAuditLog(COMMethods mbapi)
{
MBAPI = mbapi;
ProgInfo = mbapi.GetProgramInfo();
InitializeComponent();
}
public Multi_Paygroup_Selector(COMMethods mbapi, bool include_zero_paygroup=false)
{
MBAPI = mbapi;
ProgInfo = mbapi.GetProgramInfo();
_include_zero = include_zero_paygroup;
InitializeComponent();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="job"></param>
public ExportBillingUpdatesJobConfigUI()
{
InitializeComponent();
_jobConfig = new ExportBillingUpdatesJobConfig();
_methods = new COMMethods();
LoadConfig();
}
public Assembly_Editor(COMMethods mbapi, bool StandAlone = false)
{
MBAPI = mbapi;
ProgInfo = mbapi.GetProgramInfo();
InitializeComponent();
menuStrip1.Visible = StandAlone;
IsStandAlone = StandAlone;
}
public void LoadDbfToExcel(COMMethods mbapi, string dbfname, string template, string sheetName, string namedRange)
{
mbapi.smartGetSMBDir();
using(var con = Connections.GetOLEDBConnection())
{
var dbfdata = con.GetDataTable("dbfdata", "select * from {0}", dbfname.FoxproQuote());
dbfdata.ConfigurableWriteToExcel(template, sheetName, namedRange);
con.Close();
// ExcelAddinUtil.app.Visible = true;
}
}
static void Main(string[] args)
{
var methods = new COMMethods();
var username = methods.RequireSMBLogin();
// SysconCommon.SMBReversed.SysconFldlib.EnsureSysconFldlibExists();
Console.WriteLine("User [{0}] logged in", username);
/*
SysconCommon.SMBReversed.SysconFldlib.AddSFieldDefinition(
"dedmap", "uninum", "Union Number", "payuni.recnum", "N", true, true, 0, 999999999);
*/
methods.EditTableWithGrid("dedmap");
// Console.ReadKey();
}
public static IEnumerable<_SelectRow> SelectPaygroups(COMMethods mbapi, bool include_zero_paygrp=false)
{
var frm = new Multi_Paygroup_Selector(mbapi,include_zero_paygroup:include_zero_paygrp);
frm.ShowDialog();
return frm.SelectedItems;
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="job"></param>
public WorkOrderImportJobConfigUI()
{
InitializeComponent();
_jobConfig = new WorkOrderImportJobConfig();
_methods = new COMMethods();
}
/// <summary>
/// Ctor
/// </summary>
public SimpleLogJobConfigUI()
{
InitializeComponent();
_jobConfig = new SimpleLogJobConfig();
_methods = new COMMethods();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="job"></param>
public PayTimeImportJobConfigUI()
{
InitializeComponent();
_jobConfig = new PayTimeImportJobConfig();
_methods = new COMMethods();
}
public SMBLogin(COMMethods _methods)
{
methods = _methods == null ? new COMMethods() : _methods;
InitializeComponent();
}