public Task SelectARAPReport() { return(Task.Run(() => { lst_ModelPaymentDetails_RPT = new ObservableCollection <ModelPaymentReciept_RPT>(); string sql = "[SMS].[PaymentReport] " + this.Schoolid + ",'" + this.SelectedClass.StaticName + "','" + this.SelectedAcademicYear.StaticName + "'"; DataTable SearchResult = DAL.Select(sql); foreach (DataRow dr in SearchResult.Rows) { Models.ModelPaymentReciept_RPT obj = new Models.ModelPaymentReciept_RPT(); obj.AcademicYear = dr["AcademicYear"].ToString(); obj.Amount = dr["PaymentRecieved"].ToString(); obj.EnrollmentNo = dr["EnrollmentNo"].ToString(); obj.StudentName = dr["StudentName"].ToString(); obj.Class = dr["ClassRoom"].ToString(); lst_ModelPaymentDetails_RPT.Add(obj); } ModelSchooldDetails objSchooldetails = new ModelSchooldDetails(); objSchooldetails.SchoolName = Common.SchoolName; objSchooldetails.SchoolAddress = Common.SchoolAddress; objSchooldetails.SchoolLogo = @"c:\Temp\SMS\" + Common.SchoolLogo; lstSchoolDetails = new ObservableCollection <ModelSchooldDetails>(); lstSchoolDetails.Add(objSchooldetails); })); }
public Task SelectPaymentReport() { return(Task.Run(() => { lst_ModelPaymentDetails_RPT = new ObservableCollection <ModelPaymentReciept_RPT>(); string sql = "[SMS].[GetStudentPaymentDetails] " + PrimaryKey + "," + studentId + "," + schoolid; DataTable SearchResult = DAL.Select(sql); foreach (DataRow dr in SearchResult.Rows) { Models.ModelPaymentReciept_RPT obj = new Models.ModelPaymentReciept_RPT(); obj.AcademicYear = dr["AcademicYear"].ToString(); obj.Amount = dr["Amount"].ToString(); obj.CreatedDateTime = dr["CreatedDateTime"].ToString(); obj.EnrollmentNo = dr["EnrollmentNo"].ToString(); obj.ModeOfPayment = dr["ModeofPayment"].ToString(); obj.PaymentType = dr["PaymentType"].ToString(); obj.StudentName = dr["FullName"].ToString(); obj.RecieptID = dr["ID"].ToString(); obj.Class = dr["Class"].ToString(); lst_ModelPaymentDetails_RPT.Add(obj); } ModelSchooldDetails objSchooldetails = new ModelSchooldDetails(); objSchooldetails.SchoolName = Common.SchoolName; objSchooldetails.SchoolAddress = Common.SchoolAddress; objSchooldetails.SchoolLogo = @"c:\Temp\SMS\" + Common.SchoolLogo; lstSchoolDetails = new ObservableCollection <ModelSchooldDetails>(); lstSchoolDetails.Add(objSchooldetails); })); }