private Student_Advance_Fee_View_Model Get_Advance_Pay_Details_By_Receipt_No(long Receipt_No)
{
Advance_Deposit_Fee advance_Deposit_Fee = new Advance_Deposit_Fee();
Student_Advance_Fee_View_Model model = advance_Deposit_Fee.Get_Advance_Pay_Details_By_Receipt_No(Receipt_No);
return(model);
}
public Student_Advance_Fee_View_Model Get_Advance_Pay_Details_By_Receipt_No(long Receipt_No)
{
Student_Advance_Fee_View_Model result;
using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings))
{
sqlService.AddParameter("@Receipt_No", SqlDbType.BigInt, Receipt_No);
using (SqlDataReader sqlDataReader = sqlService.ExecuteSPReader("dbo.USP_GET_Advance_Pay_Details_By_Receipt_No"))
{
Student_Advance_Fee_View_Model student_Advance_Fee_View_Model = new Student_Advance_Fee_View_Model();
student_Advance_Fee_View_Model.List_Student_Fee_Info_Months = sqlDataReader.MapToList <Student_Fee_Info_Months_Model>();
sqlDataReader.NextResult();
student_Advance_Fee_View_Model.List_Advance_Pay = sqlDataReader.MapToList <Advance_Pay_Model>();
result = student_Advance_Fee_View_Model;
}
}
return(result);
}
private void gridAdvancePay_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int rowIndex = e.RowIndex;
try
{
if (e.ColumnIndex == 0)
{
long receipt_No = Convert.ToInt64(gridAdvancePay.Rows[rowIndex].Cells["col_AP_Receipt_No"].Value);
Student_Advance_Fee_View_Model model = Get_Advance_Pay_Details_By_Receipt_No(receipt_No);
if (model != null)
{
ConstructGrid(model.List_Advance_Pay);
Advance_Pay_Receipt_Months(model.List_Student_Fee_Info_Months);
lblReceiptNoLabel.Visible = true;
lblReceiptNo.Visible = true;
lblReceiptNo.Text = Convert.ToString(gridAdvancePay.Rows[rowIndex].Cells["col_AP_Receipt_No"].Value);
dtpDate.Value = Convert.ToDateTime(gridAdvancePay.Rows[rowIndex].Cells["col_AP_Date"].Value);
}
}
if (e.ColumnIndex == 2)
{
long receipt_No = Convert.ToInt64(gridAdvancePay.Rows[rowIndex].Cells["col_AP_Receipt_No"].Value);
Advance_Pay_Report_Viewer_Form report = new Advance_Pay_Report_Viewer_Form(_studentID, receipt_No);
report.StartPosition = FormStartPosition.CenterParent;
report.ShowDialog(this);
}
if (e.ColumnIndex == 3)
{
long receipt_No = Convert.ToInt64(gridAdvancePay.Rows[rowIndex].Cells["col_AP_Receipt_No"].Value);
Delete_Records(receipt_No);
}
gridAdvancePay.ClearSelection();
}
catch (Exception ex)
{ }
finally
{ }
}
