public getStudentDiscountsList getStudentDiscountsList() { var model = new getStudentDiscountsList(); try { var StudentDiscountsList = _StudentDiscountsRepo.GetAll().ToList(); var FeeTypesList = _FeeTypesRepo.GetAll().ToList(); var studentsList = _studentsRepo.GetAll().ToList(); var classList = _classesRepo.GetAll().ToList(); var query = (from _StudentDiscounts in StudentDiscountsList join _FeeTypes in FeeTypesList on _StudentDiscounts?.FeeTypeId equals _FeeTypes?.Id join _students in studentsList on _StudentDiscounts?.StudentId equals _students?.Id join _class in classList on _students?.ClassId equals _class?.Id select new { _StudentDiscounts, _FeeTypes, _students, _class }); var list = new List <getStudentDiscountsList_StudentDiscounts>(); foreach (var item in query) { var temp = new getStudentDiscountsList_StudentDiscounts() { Id = item._StudentDiscounts.Id, RegistrationNo = item._students.RegistrationNo, StudentId = item._StudentDiscounts.StudentId, StudentName = item._students.FirstName + " " + item._students.LastName, ClassId = item._students.ClassId, ClassName = item._class.Name, FeeTypeId = item._StudentDiscounts.FeeTypeId, FeeType = item._FeeTypes.Name, DiscountAmout = item._StudentDiscounts.DiscountAmout }; list.Add(temp); } ; model = new getStudentDiscountsList() { _StudentDiscounts = list }; } catch (Exception) { } return(model); }
public getStudentPaymentsList getStudentPaymentsList() { var model = new getStudentPaymentsList(); try { var StudentPaymentsList = _StudentPaymentsRepo.GetAll().ToList(); var FeeTypesList = _FeeTypesRepo.GetAll().ToList(); var studentsList = _studentsRepo.GetAll().ToList(); var query = (from _StudentPayments in StudentPaymentsList join _FeeTypes in FeeTypesList on _StudentPayments?.FeeTypeId equals _FeeTypes?.Id join _Students in studentsList on _StudentPayments?.StudentId equals _Students?.Id select new { _StudentPayments, _Students, _FeeTypes }); var list = new List <getStudentPaymentsList_StudentPayments>(); foreach (var item in query) { var temp = new getStudentPaymentsList_StudentPayments() { Id = item._StudentPayments.Id, ClassId = item._StudentPayments.ClassId, FeeYearDate = item._StudentPayments.FeeYearDate, StudentId = item._StudentPayments.StudentId, StudentName = item._Students.FirstName + " " + item._Students.LastName, FeeTypeId = item._StudentPayments.FeeTypeId, FeeType = item._FeeTypes.Name, Fine = item._StudentPayments.Fine, PaidAmount = item._StudentPayments.PaidAmount, PaymentDate = item._StudentPayments.PaymentDate, Remarks = item._StudentPayments.Remarks }; list.Add(temp); } ; model = new getStudentPaymentsList() { _StudentPayments = list }; } catch (Exception) { } return(model); }
public getFeeStructuresList getFeeStructuresList() { var model = new getFeeStructuresList(); try { var FeeStructuresList = _FeeStructuresRepo.GetAll().ToList(); var FeeTypesList = _FeeTypesRepo.GetAll().ToList(); var classList = _classesRepo.GetAll().ToList(); var query = (from _FeeStructure in FeeStructuresList join _FeeTypes in FeeTypesList on _FeeStructure?.FeeTypeId equals _FeeTypes?.Id join _class in classList on _FeeStructure?.ClassId equals _class?.Id select new { _FeeStructure, _FeeTypes, _class }); var list = new List <getFeeStructuresList_FeeStructures>(); foreach (var item in query) { var temp = new getFeeStructuresList_FeeStructures() { Id = item._FeeStructure.Id, ClassId = item._FeeStructure.ClassId, Class = item._class.Name, FeeTypeId = item._FeeStructure.FeeTypeId, FeeType = item._FeeTypes.Name, FeeTypeMood = item._FeeStructure.YearlyTermNo, Amount = item._FeeStructure.Amount, StartingYear = item._FeeStructure.StartingYear, EndingYear = item._FeeStructure.EndingYear, IsActive = item._FeeStructure.IsActive }; list.Add(temp); } ; model = new getFeeStructuresList() { _FeeStructures = list }; } catch (Exception) { } return(model); }
public getFeeTypesList getFeeTypesList() { var model = new getFeeTypesList(); try { var FeeTypesList = _FeeTypesRepo.GetAll().ToList(); var classList = _classesRepo.GetAll().ToList(); var query = (from _FeeTypes in FeeTypesList join _Class in classList on _FeeTypes?.ClassId equals _Class?.Id orderby _FeeTypes.ClassId ascending select new { _FeeTypes, _Class }); var list = new List <getFeeTypesList_FeeTypes>(); foreach (var item in query) { var temp = new getFeeTypesList_FeeTypes() { Id = item._FeeTypes.Id, ClassId = item._FeeTypes.ClassId, ClassName = item._Class.Name, Name = item._FeeTypes.Name, IsActive = item._FeeTypes.IsActive }; list.Add(temp); } ; model = new getFeeTypesList() { _FeeTypes = list }; } catch (Exception) { } return(model); }
public GetFeeTermDescriptionsList GetFeeTermDescriptionsList() { var model = new GetFeeTermDescriptionsList(); try { var FeeTermDescriptionsList = _FeeTermDescriptionsRepo.GetAll().ToList(); var FeeStructures = _FeeStructuresRepo.GetAll().ToList(); var FeeTypes = _FeeTypesRepo.GetAll().ToList(); var classList = _classesRepo.GetAll().ToList(); var query = (from _FeeTermDescriptions in FeeTermDescriptionsList join feeStucture in FeeStructures on _FeeTermDescriptions.FeeStructureId equals feeStucture.Id join feeTypes in FeeTypes on feeStucture.FeeTypeId equals feeTypes.Id join cls in classList on feeStucture.ClassId equals cls.Id select new { _FeeTermDescriptions, feeStucture, feeTypes, cls }); var list = new List <GetFeeTermDescriptionsList_FeeTermDescriptions>(); foreach (var item in query) { var temp = new GetFeeTermDescriptionsList_FeeTermDescriptions() { Id = item._FeeTermDescriptions.Id, FeeStructureId = item._FeeTermDescriptions.FeeStructureId, TermNo = item._FeeTermDescriptions.TermNo, TermName = item._FeeTermDescriptions.TermName, ClassName = item.cls.Name, FeeType = item.feeTypes.Name, ClassId = item.feeStucture.ClassId, FeeTypeId = item.feeStucture.FeeTypeId }; list.Add(temp); } ; model = new GetFeeTermDescriptionsList() { _FeeTermDescriptions = list }; } catch (Exception) { } return(model); }