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