public bool doesCliExist(string cli, JurisUtility _jurisUtility)
{
bool ret = false;
String sql = "select * from client where dbo.jfn_FormatClientCode(clicode) = '" + cli + "'";
DataSet fd = _jurisUtility.RecordsetFromSQL(sql);
if (fd != null && fd.Tables.Count > 0 && fd.Tables[0].Rows.Count > 0)
{
ret = true;
}
return(ret);
}
public bool doesMatExist(string cli, JurisUtility _jurisUtility, string mat)
{
bool ret = false;
String sql = "select * from matter inner join client on clisysnbr = matclinbr where dbo.jfn_FormatMatterCode(matcode) = '" + mat + "' and dbo.jfn_FormatClientCode(clicode) = '" + cli + "'";
DataSet fd = _jurisUtility.RecordsetFromSQL(sql);
if (fd != null && fd.Tables.Count > 0 && fd.Tables[0].Rows.Count > 0)
{
ret = true;
}
return(ret);
}
public bool doesPTExist(string PT, JurisUtility _jurisUtility)
{
bool ret = false;
String sql = "Select * from PersonnelType where PrsTypCode = '" + PT + "'";
DataSet fd = _jurisUtility.RecordsetFromSQL(sql);
if (fd != null && fd.Tables.Count > 0 && fd.Tables[0].Rows.Count > 0)
{
ret = true;
}
return(ret);
}
public bool isRateNumeric(string rate, JurisUtility _jurisUtility)
{
bool ret = false;
try
{
double aa = Convert.ToDouble(rate);
ret = true;
}
catch (Exception vvt)
{ }
return(ret);
}
public UtilityBaseMain()
{
InitializeComponent();
_jurisUtility = new JurisUtility();
listViewClient.MultiSelect = true;
listViewClient.CheckBoxes = true;
listViewClient.FullRowSelect = true;
setColumns();
lvwColumnSorter1 = new ListViewColumnSorter();
this.listViewClient.ListViewItemSorter = lvwColumnSorter1;
comboBox1.SelectedIndex = 1;
comboBox2.SelectedIndex = 0;
comboBox3.SelectedIndex = 0;
comboBox4.SelectedIndex = 0;
}
public ClientBranchSelector(JurisUtility _jurisUtility, string windowText, string tableName)
{
InitializeComponent();
this.Text = windowText;
tName = tableName;
dataGridView1.ColumnCount = 1;
dataGridView2.ColumnCount = 1;
dataGridView1.Columns[0].Name = "Client Codes ";
dataGridView2.Columns[0].Name = "Branches ";
JU = _jurisUtility;
DataSet client = _jurisUtility.RecordsetFromSQL("select client from " + tableName);
DataSet branch = _jurisUtility.RecordsetFromSQL("select branch from " + tableName);
fillRecordSet(client, dataGridView1);
fillRecordSet(branch, dataGridView2);
}
public UtilityBaseMain()
{
InitializeComponent();
_jurisUtility = new JurisUtility();
}
public UtilityBaseMain()
{
InitializeComponent();
_jurisUtility = new JurisUtility();
dateTimePicker1.Value = DateTime.Now.AddDays(-90);
}
public DBInfo()
{
InitializeComponent();
_jurisUtility = new JurisUtility();
}
public TimeProcessor(JurisUtility _ju)
{
_jurisUtility = _ju;
}
public BothProcessor(JurisUtility _ju)
{
_jurisUtility = _ju;
}
