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