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