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 async Task <ActionResult <StudentsModel[]> > Get(bool includeSubjects = false) { //try //{ var results = await _repo.GetAll(includeSubjects); return(_mapper.Map <StudentsModel[]>(results)); //} //catch (Exception) //{ // return this.StatusCode(StatusCodes.Status500InternalServerError, "Database Failure -Talkss"); // //return Ok("Under Maintenance."); //} }
public getStudentPromotionsList getStudentPromotionsList() { var model = new getStudentPromotionsList(); try { var StudentPromotionsList = _StudentPromotionsRepo.GetAll().ToList(); var studentsList = _studentsRepo.GetAll().ToList(); var classList = _classesRepo.GetAll().ToList(); var query = (from _StudentPromotion in StudentPromotionsList join _Class in classList on _StudentPromotion?.ClassId equals _Class?.Id join _student in studentsList on _StudentPromotion?.StudentId equals _student?.Id select new { _StudentPromotion, _Class, _student }); var list = new List <getStudentPromotionsList_StudentPromotions>(); foreach (var item in query) { var temp = new getStudentPromotionsList_StudentPromotions() { Id = item._StudentPromotion.Id, ClassId = item._StudentPromotion.ClassId, ClassName = item._Class.Name, StudentId = item._StudentPromotion.StudentId, RegistrationNo = item._student.RegistrationNo, RollNo = item._StudentPromotion.RollNo, ClassYear = item._StudentPromotion.ClassYear, IsActive = item._StudentPromotion.IsActive, AddedBy = item._StudentPromotion.AddedBy, AddedDate = item._StudentPromotion.AddedDate, ModifiedBy = item._StudentPromotion.ModifiedBy, ModifiedDate = item._StudentPromotion.ModifiedDate, DataType = item._StudentPromotion.DataType }; list.Add(temp); } ; model = new getStudentPromotionsList() { _StudentPromotions = list, }; } catch (Exception) { } return(model); }
public GetFeeStructuresByClass GetFeeStructuresByClass(long StudentId, long ClassId, long ClassYear) { var model = new GetFeeStructuresByClass(); try { var StudentPaymentsList = _StudentPaymentsRepo.GetAll().ToList(); var studentsList = _studentsRepo.GetAll().ToList(); var FeeTypesList = _FeeTypesRepo.GetAll().ToList(); var classes = _classesRepo.GetAll().ToList(); var feeStructure = _FeeStructuresRepo.GetAll().ToList(); var studentPromotion = _StudentPromotionsRepo.GetAll().ToList(); var studentDiscount = _StudentDiscountsRepo.GetAll().ToList(); var feeTermDescription = _FeeTermDescriptions.GetAll().ToList(); var StudentDetails = (from c in studentsList where c.Id == StudentId select c).SingleOrDefault(); var getClass = (from cls in classes where cls.Id == ClassId select cls).SingleOrDefault(); var getStuFeeYear = (from sp in studentPromotion where sp.StudentId == StudentId && sp.ClassId == ClassId select sp).SingleOrDefault(); //[Note: Step 1- Get Student from promotion table for all class ] var query = (from sp in studentPromotion where sp.StudentId == StudentId join s in studentsList on sp.StudentId equals s.Id join c in classes on sp.ClassId equals c.Id join f in FeeTypesList on c?.Id equals f?.ClassId into allFeeTypes from feeTypes in allFeeTypes.DefaultIfEmpty() join fs in feeStructure on feeTypes?.Id equals fs?.FeeTypeId into allfeeStructure from feeStucture in allfeeStructure.DefaultIfEmpty() select new { Id = sp.Id, StudentId = StudentId, StuClassId = sp.ClassId, StuFeeYear = sp?.ClassYear, StuFeeType = feeStucture.FeeTypeId, StuClassName = c.Name, FeeTypeName = feeTypes?.Name, FeeAmount = feeStucture?.Amount, StuPaymentDate = (dynamic)null, StuPaidAmount = 0, StuFine = 0, StuRemarks = "", StuDiscount = 0 }).ToList(); //[NOTE:Step 2- get discount of the student if exist] studentDiscount = studentDiscount.Where(s => s.StudentId == StudentId).ToList(); if (query != null) { //var list = new List<SearchPaymentDetailById_StudentPayments>(); var list = new List <GetFeeStructuresByClass_FeeStructures>(); //decimal? totalPaid = 0; //decimal? totalDiscount = 0; //decimal? totalFeeAmount = 0; //decimal? totalFine = 0; foreach (var item in query) { var getFeeTerm = from ft in feeTermDescription join fs in feeStructure on ft.FeeStructureId equals fs.Id //where fs.ClassId == ClassId && fs.FeeTypeId == item.StuFeeType && fs.StartingYear <= item.StuFeeYear && fs.EndingYear >= item.StuFeeYear where fs.ClassId == ClassId && fs.FeeTypeId == item.StuFeeType select new { ft, fs }; //[NOTE:Step 3- find feetype discount if exist] decimal?currentTypeDiscountAmount = 0; if (studentDiscount.Count() > 0) { currentTypeDiscountAmount = (from s in studentDiscount where s.FeeTypeId == item.StuFeeType select s.DiscountAmout).FirstOrDefault(); } foreach (var item2 in getFeeTerm) { //[NOTE: get existing payment of the student if exist] var GetPaymentListOfTheStudent = (from p in StudentPaymentsList where p.StudentId == StudentId && p.ClassId == item2.fs.ClassId && p.FeeTermDescriptionId == item2.ft.Id && p.FeeTypeId == item2.fs.FeeTypeId && (p.FeeYearDate.Value.Year == ClassYear) select p).FirstOrDefault(); var temp = new GetFeeStructuresByClass_FeeStructures() { Id = item.Id, ClassId = item.StuClassId, FeeTypeId = item.StuFeeType, FeeType = item.FeeTypeName, FeeTypeMood = item2.ft.TermNo, Amount = item.FeeAmount != null ? (dynamic)item.FeeAmount : 0, Fine = GetPaymentListOfTheStudent != null ? GetPaymentListOfTheStudent.Fine : 0, FeeTermDescriptionId = item2.ft.Id, TermNo = item2.ft.TermNo, TermName = item2.ft.TermName, PaidAmount = GetPaymentListOfTheStudent != null ? GetPaymentListOfTheStudent.PaidAmount : 0, Remarks = item.StuRemarks, StartingYear = item2.fs.StartingYear, EndingYear = item2.fs.EndingYear, DiscountAmount = (dynamic)currentTypeDiscountAmount, IsActive = item2.fs.IsActive }; list.Add(temp); } } ; model = new GetFeeStructuresByClass() { ClassName = getClass.Name, FeeYear = getStuFeeYear.ClassYear.Value.Year, _FeeStructures = list }; } } catch (Exception ex) { var msg = ex.Message; } return(model); }
public getStudentsList.getStudentsList getStudentList(getStudentsList.getStudentsList obj) { var model = (dynamic)null; try { var studentsList = _studentsRepo.GetAll().ToList(); var StudentPromotionsList = _StudentPromotionsRepo.GetAll().ToList(); var thisYear = DateTime.Now.Year; var ClassList = _classesRepo.GetAll().ToList(); var GendersList = _GendersRepo.GetAll().ToList(); var query = (from _students in studentsList join _Classes in ClassList on _students?.ClassId equals _Classes?.Id join _Genders in GendersList on _students?.GenderId equals _Genders?.Id join _studentPromotion in StudentPromotionsList on _students.Id equals _studentPromotion.StudentId join _promotionClass in ClassList on _studentPromotion.ClassId equals _promotionClass.Id where _studentPromotion.StudentId == _students.Id && _studentPromotion.ClassYear.Value.Year == thisYear orderby _students.ClassId, _students.FirstName ascending select new { _students, _Classes, _Genders, _studentPromotion, _promotionClass }); var list = new List <getStudentsList.getStudentsList_Students>(); foreach (var item in query) { string path = string.IsNullOrEmpty(item._students.IP300X200) ? "" : item._students.IP300X200; var temp = new getStudentsList.getStudentsList_Students() { Id = item._students.Id, ClassId = item._students.ClassId, RollNO = item._studentPromotion.RollNo, CurrentClassId = item._studentPromotion.ClassId, CurrentYear = item._studentPromotion.ClassYear, ClassName = item._Classes.Name, GenderId = item._students.GenderId, RegistrationNo = item._students.RegistrationNo, GenderName = item._Genders.Name, FirstName = item._students.FirstName, LastName = item._students.LastName, StudentName = item._students.FirstName + " " + item._students.LastName, IP300X200 = _commonServ.CommImage_WrapperDefaultImage(path, obj.WebRootPath, item._students.GenderId), AdmittedYear = item._students.AdmittedYear, PresentAddress = item._students.PresentAddress, PermanentAddress = item._students.PermanentAddress, DOB = item._students.DOB, IsActive = item._students.IsActive, AddedBy = 0, AddedDate = DateTime.Now, ModifiedBy = 0, ModifiedDate = DateTime.Now, DataType = null }; list.Add(temp); } ; model = new getStudentsList.getStudentsList() { _Students = list }; } catch (Exception) { } return(model); }