Esempio n. 1
0
 public static int PayStudentFees(FeeCollections newFees)
 {
     using (VedantaEntities ve = new VedantaEntities())
     {
         ve.AddToFeeCollections(newFees);
         return(ve.SaveChanges());
     }
 }
Esempio n. 2
0
        public static int UpdateFeeCollection(FeeCollections newFee)
        {
            using (VedantaEntities ve = new VedantaEntities())
            {
                FeeCollections oldFee = ve.FeeCollections.FirstOrDefault(st => st.Id == newFee.Id);

                if (oldFee == null)
                {
                    return(-1);//Admission record not found.
                }
                newFee.AdmissionId = oldFee.AdmissionId;
                var updatedFee = ve.ApplyCurrentValues(oldFee.GetType().Name, newFee);
                return(ve.SaveChanges());
            }
        }
Esempio n. 3
0
        public ActionResult EditFees(int id)
        {
            ViewData["PaymentHeads"] = Utilities.GetPaymentHeadsNameList();
            ViewData["PaymentModes"] = Utilities.GetPaymentModesNameList();

            FeeCollections feeColl = StudentModels.GetFeesCollectionById(id);

            ViewData.Model = feeColl;
            if (feeColl != null)
            {
                vw_Admissions admDeatails = StudentModels.GetAdmissionDetailsById(feeColl.AdmissionId);
                if (admDeatails != null)
                {
                    ViewData["StudentDetails"] = admDeatails;
                }
            }
            return(View());
        }
Esempio n. 4
0
 public static int UpdateAdmissionDetails(Admissions newAdmission)
 {
     using (VedantaEntities ve = new VedantaEntities())
     {
         Admissions oldAdmission = ve.Admissions.FirstOrDefault(st => st.Id == newAdmission.Id);
         if (oldAdmission == null)
         {
             return(-1);//Admission record not found.
         }
         FeeCollections fee = ve.FeeCollections.FirstOrDefault(fe => fe.AdmissionId == newAdmission.Id && fe.ManualreceiptNumber.Equals(oldAdmission.ManualReceiptNumber, StringComparison.OrdinalIgnoreCase));
         if (fee != null)
         {
             fee.Amount        = newAdmission.DownPayment;
             fee.Description   = newAdmission.Description;
             fee.TotalReceived = newAdmission.DownPayment;
             fee.PaymentDate   = newAdmission.AdmissionDate;
             fee.PaymentHeadId = 1;
             fee.PaymentModeId = newAdmission.PaymentModeId;
         }
         newAdmission.StudentId = oldAdmission.StudentId;
         var updatedAdmission = ve.ApplyCurrentValues(oldAdmission.GetType().Name, newAdmission);
         return(ve.SaveChanges());
     }
 }
Esempio n. 5
0
        public static int ProocessNewStudentAddmission(Students newStudent, Admissions newAdmission, FeeCollections newFeeCollection)
        {
            using (VedantaEntities ve = new VedantaEntities())
            {
                Students oldStudent = ve.Students.FirstOrDefault(st => st.ID == newStudent.ID);

                int newStudentId = 0; int oldStudentId = 0;
                //Add A New Student Record in DataBase if that student does not exists
                if (oldStudent == null)
                {
                    newStudent.CreatedDate = DateTime.Now.Date;
                    ve.AddToStudents(newStudent);
                    ve.SaveChanges();
                    newStudentId = newStudent.ID;
                }
                else
                {
                    oldStudentId = oldStudent.ID;
                }

                //If Student is already enrolled with us then no need to add new record for same student
                if (newStudentId == 0 && oldStudentId > 0)
                {
                    newStudentId = oldStudentId;
                }

                if (newStudentId > 0)
                {
                    newAdmission.StudentId = newStudentId;

                    Admissions oldAdmission = ve.Admissions.FirstOrDefault(ad => ad.StudentId == newStudentId && ad.CourseId == newAdmission.CourseId);
                    if (oldAdmission == null)
                    {
                        ve.AddToAdmissions(newAdmission);
                        int admResult = ve.SaveChanges();
                        return(admResult);
                        //if (admResult > 0)   //Admission of Student done successfully.
                        //{
                        //    newFeeCollection.AdmissionId = newAdmission.Id;
                        //    ve.AddToFeeCollections(newFeeCollection);
                        //    return ve.SaveChanges(); //Admission Fee Paid successfully.
                        //}
                        //else
                        //    return -2;
                    }
                    else
                    {
                        return(-2); //Student Record Entered but failed to take Admission of student.
                    }
                }
                else
                {
                    return(-1); //Student Record not entered;
                }
            }
        }
Esempio n. 6
0
        public ActionResult EditFees(FormCollection form, FeeCollections newFees)
        {
            ViewData["PaymentHeads"] = Utilities.GetPaymentHeadsNameList();
            ViewData["PaymentModes"] = Utilities.GetPaymentModesNameList();

            decimal?paidFeesAmount = 0; decimal?courseFee = 0; string regNumber = string.Empty;

            if (!ModelState.IsValid)
            {
                ApplicationMessages msg = new ApplicationMessages("Invalid entry.", MessageType.Error);
                ViewData["Message"] = msg;
                return(View());
            }
            ViewData.Model = newFees;
            vw_Admissions admDeatails = StudentModels.GetAdmissionDetailsById(newFees.AdmissionId);

            if (admDeatails != null)
            {
                regNumber = admDeatails.RegistrationNumber;
                courseFee = admDeatails.CourseFees ?? 0;
                ViewData["StudentDetails"] = admDeatails;
                List <vw_FeeCollections> feeCollected = null;
                feeCollected = StudentModels.GetStudentsPaidFeesByReg_Number(regNumber);
                List <vw_FeeCollections> exceptThisFeelist = feeCollected.Where(fe => fe.Id != newFees.Id).ToList();
                if (exceptThisFeelist != null && exceptThisFeelist.Count() > 0)
                {
                    //ViewData["CollectedFees"] = feeCollected;
                    paidFeesAmount = exceptThisFeelist.Sum(f => f.Amount);
                }

                if (courseFee >= paidFeesAmount + (newFees != null ? newFees.Amount : 0))
                {
                    if (admDeatails != null)
                    {
                        //newFees.AdmissionId = admDeatails.Id;
                        if (newFees.Amount != null && newFees.Amount > 0)
                        {
                            newFees.TotalReceived = newFees.Amount;
                            int result = StudentModels.UpdateFeeCollection(newFees);
                            if (result > 0)
                            {
                                Session["CurrentFeeId"] = newFees.Id;
                                // return RedirectToAction("FeeReceipt");
                                ApplicationMessages msg = new ApplicationMessages("Fees saved successfully.", MessageType.Success);
                                ViewData["Message"] = msg;
                                //ViewData["CollectedFees"] = StudentModels.GetStudentsPaidFeesByReg_Number(regNumber);
                            }
                            else
                            {
                                ApplicationMessages msg = new ApplicationMessages("Failed to save Fees. Please try again.", MessageType.Error);
                                ViewData["Message"] = msg;
                            }
                        }
                        else
                        {
                            ApplicationMessages msg = new ApplicationMessages("Fee Amount can not be zero or negative.", MessageType.Error);
                            ViewData["Message"] = msg;
                        }
                    }
                    else
                    {
                        ApplicationMessages msg = new ApplicationMessages("Failed to save Fees. Please try again.", MessageType.Error);
                        ViewData["Message"] = msg;
                    }
                }
                else
                {
                    ApplicationMessages msg = new ApplicationMessages("Fee Amount can not exceed Total Installment Amount.", MessageType.Error);
                    ViewData["Message"] = msg;
                }

                return(View());
            }
            else
            {
                ApplicationMessages msg = new ApplicationMessages("Invalid Enquiry", MessageType.Error);
                ViewData["Message"] = msg;
                return(View());
            }
        }
Esempio n. 7
0
        public ActionResult Fees(string Submit, FormCollection form, FeeCollections newFees)
        {
            ViewData["PaymentHeads"] = Utilities.GetPaymentHeadsNameList();
            ViewData["PaymentModes"] = Utilities.GetPaymentModesNameList();
            decimal?paidFeesAmount = 0;
            string  regNumber = string.Empty; decimal?courseFee = 0;

            if (!string.IsNullOrEmpty(form["txtReg_Number"]))
            {
                regNumber = form["txtReg_Number"].ToString();
                ViewData["RegistrationNumber"] = regNumber;
                List <vw_FeeCollections> feeCollected = null;
                feeCollected = StudentModels.GetStudentsPaidFeesByReg_Number(regNumber);
                if (feeCollected != null && feeCollected.Count() > 0)
                {
                    ViewData["CollectedFees"] = feeCollected;
                    paidFeesAmount            = feeCollected.Sum(f => f.Amount);
                }
                vw_Admissions admDeatails = StudentModels.GetAdmissionDetailsByReg_Number(regNumber);
                if (admDeatails != null)
                {
                    courseFee = admDeatails.CourseFees ?? 0;
                    ViewData["StudentDetails"] = admDeatails;
                }
                else
                {
                    ApplicationMessages msg = new ApplicationMessages("Invalid Registration Number.", MessageType.Error);
                    ViewData["Message"] = msg;
                    return(View());
                }

                if (!string.IsNullOrEmpty(Submit))
                {
                    switch (Submit.ToLower())
                    {
                    case "search":
                        ModelState.Clear();
                        break;

                    case "submit":

                        if (!ModelState.IsValid)
                        {
                            ApplicationMessages msg = new ApplicationMessages("Invalid entry.", MessageType.Error);
                            ViewData["Message"] = msg;
                            return(View());
                        }


                        if (courseFee >= paidFeesAmount + (newFees != null ? newFees.Amount : 0))
                        {
                            if (admDeatails != null)
                            {
                                newFees.AdmissionId = admDeatails.Id;
                                if (newFees.Amount != null && newFees.Amount > 0)
                                {
                                    newFees.TotalReceived = newFees.Amount;
                                    int result = StudentModels.PayStudentFees(newFees);
                                    if (result > 0)
                                    {
                                        Session["CurrentFeeId"] = newFees.Id;
                                        return(RedirectToAction("FeeReceipt"));
                                        // ApplicationMessages msg = new ApplicationMessages("Fees paid successfully.", MessageType.Success);
                                        // ViewData["Message"] = msg;
                                        // ViewData["CollectedFees"] = StudentModels.GetStudentsPaidFeesByReg_Number(regNumber);
                                    }
                                    else
                                    {
                                        ApplicationMessages msg = new ApplicationMessages("Failed to Pay Fees. Please try again.", MessageType.Error);
                                        ViewData["Message"] = msg;
                                    }
                                }
                                else
                                {
                                    ApplicationMessages msg = new ApplicationMessages("Fee Amount can not be zero or negative.", MessageType.Error);
                                    ViewData["Message"] = msg;
                                }
                            }
                            else
                            {
                                ApplicationMessages msg = new ApplicationMessages("Failed to Pay Fees. Please try again.", MessageType.Error);
                                ViewData["Message"] = msg;
                            }
                        }
                        else
                        {
                            ApplicationMessages msg = new ApplicationMessages("Fee Amount can not exceed Total Installment Amount.", MessageType.Error);
                            ViewData["Message"] = msg;
                        }
                        break;
                    }
                }
                return(View());
            }
            else
            {
                ApplicationMessages msg = new ApplicationMessages("Invalid Registration Number.", MessageType.Error);
                ViewData["Message"] = msg;
                return(View());
            }
        }