private void loadmembers() { try { if (Object.ReferenceEquals(hehe, null)) { string[] taes = { "member_id", "concat_ws(',', family_name, first_name) as name" }; loanmems = _addloanconn.Select("members", taes).GetQueryData(); mlist.DataSource = loanmems; mlist.Columns["member_id"].Visible = false; //cbBorrower.AutoCompleteSource = ; } else { /*_addloanconn.Select("LoansM", "member_id", "concat_ws(',', family_name, first_name) as name") * .Where("date_terminated", null) * .GetQueryData();*/ loanmems = _addloanconn.storedProc("loansM"); mlist.DataSource = loanmems; mlist.Columns["member_id"].Visible = false; } } catch (Exception ee) { //MessageBox.Show(ee.ToString()); } }
private void Rifrish() { try { var tae = new DatabaseConn(); dataGridView1.DataSource = tae.storedProc("viewloanrequests"); if (dataGridView1.Rows.Count != 0) { dataGridView1.Height = dataGridView1.GetRowDisplayRectangle(0, true).Bottom *dataGridView1.RowCount + dataGridView1.ColumnHeadersHeight; } dataGridView1.Columns["member_id"].Visible = false; dataGridView1.Columns["loan_account_id"].Visible = false; dataGridView1.Columns["loan_type"].HeaderText = "Loan Type"; dataGridView1.Columns["request_type"].HeaderText = "Request Type"; dataGridView1.Columns["term"].HeaderText = "Term"; dataGridView1.Columns["orig_amount"].HeaderText = "Amount"; dataGridView1.Columns["interest_rate"].HeaderText = "Interest Rate"; conn.Close(); var x = new DataGridViewButtonColumn(); x.DefaultCellStyle.BackColor = button1.BackColor; var columnIndex = dataGridView1.ColumnCount; foreach (DataGridViewColumn col in dataGridView1.Columns) { dataGridView1.Columns[col.Name].SortMode = DataGridViewColumnSortMode.NotSortable; } } catch (Exception ee) { //MessageBox.Show(ee.ToString()); conn.Close(); } dataGridView1.ClearSelection(); convert(); }
public void details() { dataGridView2.DataSource = null; if (dataGridView2.Rows.Count != 0) { dataGridView2.Rows.Clear(); } dataGridView2.Columns.Clear(); dataGridView2.Refresh(); try { var tae = new DatabaseConn(); dataGridView2.DataSource = tae.storedProc("viewloansched"); dataGridView2.Columns["member_id"].Visible = false; dataGridView2.Columns["loan_account_id"].Visible = false; int height = 0; foreach (DataGridViewRow row in dataGridView2.Rows) { height += row.Height; } height += dataGridView2.ColumnHeadersHeight; int width = dataGridView2.Width; dataGridView2.ClientSize = new Size(width, height); var x = new DataGridViewButtonColumn(); x.DefaultCellStyle.BackColor = button1.BackColor; var columnIndex = dataGridView2.ColumnCount; dataGridView2.Columns["term"].HeaderText = "Term"; dataGridView2.Columns["due_date"].HeaderText = "Due Date"; dataGridView2.Columns["orig_amount"].HeaderText = "Original Amount"; dataGridView2.Columns["outstanding_balance"].HeaderText = "Beginning Balance as of Jan 02, 2017"; foreach (DataGridViewColumn col in dataGridView2.Columns) { dataGridView2.Columns[col.Name].SortMode = DataGridViewColumnSortMode.NotSortable; } } catch (Exception ee) { //MessageBox.Show(ee.ToString()); } dataGridView2.ClearSelection(); }
public void trans(int mo) { dataGridView2.DataSource = null; if (dataGridView2.Rows.Count != 0) { dataGridView2.Rows.Clear(); } dataGridView2.Refresh(); try { foreach (int n in loanids) { var tae = new DatabaseConn(); var dt = new DataTable(); dt = tae.storedProc("monthview", "loanid", n, "mo", mo); if (dataGridView2.ColumnCount == 0) { foreach (DataColumn column in dt.Columns) { dataGridView2.Columns.Add(column.ColumnName, column.ColumnName); } } DataRow row = dt.Rows[0]; dataGridView2.Rows.Add(row.ItemArray); } var x = new DataGridViewButtonColumn(); x.DefaultCellStyle.BackColor = button1.BackColor; var columnIndex = dataGridView2.ColumnCount; foreach (DataGridViewColumn col in dataGridView2.Columns) { dataGridView2.Columns[col.Name].SortMode = DataGridViewColumnSortMode.NotSortable; } } catch (Exception ee) { //MessageBox.Show(ee.ToString()); } dataGridView2.ClearSelection(); }
private void populatedatagridParent(string Command, int n) { datagridTableParent.DataSource = null; //remove datasource link for datagridProduct //MessageBox.Show("Parent - " + selectCommand,"",MessageBoxButtons.OK); try { if (n == 0) { var tae = new DatabaseConn(); //opens the connection BindingSource bs = new BindingSource(); bs.DataSource = tae.storedProc(Command); datagridTableParent.DataSource = bs; conn.Close(); datagridTableParent.AutoResizeRows(); } else if (n == 1) { conn.Open(); //opens the connection MySqlCommand query = new MySqlCommand(Command, conn); //query to select all entries in tbl_productcatalog MySqlDataAdapter adp = new MySqlDataAdapter(query); //adapter for query DataTable dt = new DataTable(); //datatable for adapter BindingSource bs = new BindingSource(); dt.Locale = System.Globalization.CultureInfo.InvariantCulture; adp.Fill(dt); bs.DataSource = dt; datagridTableParent.DataSource = bs; datagridTableChild.DataSource = bs; conn.Close(); datagridTableChild.AutoResizeRows(); datagridTableParent.AutoResizeRows(); } else if (n == 2) { var tae = new DatabaseConn(); //opens the connection BindingSource bs = new BindingSource(); DateTime dt = capitalDTP.Value; bs.DataSource = tae.storedProc(Command, "yr", dt.Year, "accountstatus", 1, "likephrase", "%"); datagridTableParent.DataSource = bs; datagridTableChild.DataSource = bs; conn.Close(); datagridTableParent.AutoResizeRows(); } else if (n == 3) { var tae = new DatabaseConn(); //opens the connection BindingSource bs = new BindingSource(); DateTime dt = savingsMDTP.Value; if (dt.Month == 3 || dt.Month == 6 || dt.Month == 9 || dt.Month == 12) { bs.DataSource = tae.storedProc("displayQuarterMonthTable", "mn", dt.Month, "yr", dt.Year, "accountstatus", 1, "likephrase", "%"); } else { bs.DataSource = tae.storedProc("displayMonthTable", "mn", dt.Month, "yr", dt.Year, "accountstatus", 1, "likephrase", "%"); } datagridTableParent.DataSource = bs; datagridTableChild.DataSource = bs; conn.Close(); } } catch (Exception x) { MessageBox.Show("Error in populating datagridTable : " + x.ToString()); conn.Close(); } }
private void Rifrish() { try { var tae = new DatabaseConn(); dataGridView1.DataSource = tae.storedProc("viewloanschedname"); dataGridView1.Columns["member_id"].Visible = false; dataGridView1.Columns["loan_account_id"].Visible = false; dataGridView1.Columns["date_granted"].HeaderText = "Date Granted"; int height = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { height += row.Height; } height += dataGridView1.ColumnHeadersHeight; int width = 0; foreach (DataGridViewColumn col in dataGridView1.Columns) { if (col.Visible == true) { width += col.Width; } } width += dataGridView1.RowHeadersWidth; dataGridView1.ClientSize = new Size(width + 3, height + 2); foreach (DataGridViewColumn col in dataGridView1.Columns) { dataGridView1.Columns[col.Name].SortMode = DataGridViewColumnSortMode.NotSortable; } dataGridView3.DataSource = tae.storedProc("viewloanstotal"); dataGridView3.Columns["member_id"].Visible = false; height = 0; foreach (DataGridViewRow row in dataGridView3.Rows) { height += row.Height; } height += dataGridView3.ColumnHeadersHeight; width = 0; foreach (DataGridViewColumn col in dataGridView3.Columns) { if (col.Visible == true) { width += col.Width; } } width += dataGridView3.RowHeadersWidth; dataGridView3.ClientSize = new Size(width + 3, height + 2); foreach (DataGridViewColumn col in dataGridView3.Columns) { dataGridView3.Columns[col.Name].SortMode = DataGridViewColumnSortMode.NotSortable; } dataGridView4.DataSource = tae.storedProc("viewagingsched"); height = 0; foreach (DataGridViewRow row in dataGridView4.Rows) { height += row.Height; } height += dataGridView4.ColumnHeadersHeight; dataGridView4.ClientSize = new Size(633, height + 2); foreach (DataGridViewColumn col in dataGridView4.Columns) { dataGridView4.Columns[col.Name].SortMode = DataGridViewColumnSortMode.NotSortable; } } catch (Exception ee) { //MessageBox.Show(ee.ToString()); } dataGridView1.ClearSelection(); loanids.Clear(); for (int i = 0; i < dataGridView1.RowCount; i++) { loanids.Add(int.Parse(dataGridView1.Rows[i].Cells["loan_account_id"].Value.ToString())); } }