private void FillGrid()
{
string sql = string.Format("SELECT LoanMonthlyData.MonthYear, LoanMonthlyData.EmpCode, EmpMST.EmpName, EmpMST.EmpFHName, LoanMonthlyData.LoanInstlmnt, LoanMonthlyData.TransID FROM LoanMonthlyData INNER JOIN EmpMST ON LoanMonthlyData.EmpCode = EmpMST.EmpCode where MonthYear = '{0}{1}'", DtStartDate.Text.Substring(0, 2), DtStartDate.Text.Substring(DtStartDate.Text.Length - 2, 2));
DataSet ds = ProjectFunctions.GetDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
LoanGrid.DataSource = ds.Tables[0];
LoanGridView.BestFitColumns();
}
else
{
LoanGrid.DataSource = null;
}
}
private void Btn_Edit_Click(object sender, EventArgs e)
{
var Dr = LoanGridView.GetFocusedDataRow();
if (btn_Edit.Enabled)
{
if (LoanGridView.DataSource != null)
{
if (LoanGridView.RowCount > 0)
{
using (var FMRU = new FrmLoanMonthlyData()
{
IsUpdate = true, LoanId = Dr["TransID"].ToString()
})
{
var P = ProjectFunctions.GetPositionInForm(this);
FMRU.Location = new Point(P.X + (ClientSize.Width / 2 - FMRU.Size.Width / 2), P.Y + (ClientSize.Height / 2 - FMRU.Size.Height / 2));
FMRU.Text = "Loan Monthly Editing";
FMRU.ShowDialog();
FillGrid();
}
}
else
{
XtraMessageBox.Show("No Records to Edit", "!Error");
}
}
else
{
XtraMessageBox.Show("No Datasource, Or Unable to fetch Data.", "!Error");
}
}
else
{
XtraMessageBox.Show("You have No permission.", "!Error");
}
}
