コード例 #1
0
        public string InsertStudentPayment(InsertStudentPayment obj)
        {
            string returnResult = (dynamic)null;

            try
            {
                if (obj != null)
                {
                    //[Note: insert 'states' table]
                    if (obj._StudentPayments != null)
                    {
                        var getPayment = _StudentPaymentsRepo.GetAll().ToList();
                        foreach (var item in obj._StudentPayments)
                        {
                            DateTime feeYear = DateTime.ParseExact(item.FeeYear, "yyyy", null);
                            var      isExist = (from sp in getPayment
                                                where sp.ClassId == item.ClassId && sp.FeeTypeId == item.FeeTypeId && sp.StudentId == item.StudentId && sp.FeeTermDescriptionId == item.FeeTermDescriptionId && sp.FeeYearDate.Value.Year == feeYear.Year
                                                select sp).SingleOrDefault();
                            if (isExist != null)
                            {
                                isExist.ClassId              = item.ClassId;
                                isExist.FeeYearDate          = feeYear;
                                isExist.PaymentDate          = item.PaymentDate;
                                isExist.StudentId            = item.StudentId;
                                isExist.FeeTypeId            = item.FeeTypeId;
                                isExist.FeeTermDescriptionId = item.FeeTermDescriptionId;
                                isExist.Fine       = item.Fine;
                                isExist.PaidAmount = item.PaidAmount;
                                isExist.Remarks    = item.Remarks != null ? item.Remarks:"";
                                _StudentPaymentsRepo.Update(isExist);
                            }
                            else
                            {
                                var StudentPayments = new InsertStudentPayment_StudentPayments()
                                {
                                    ClassId              = item.ClassId,
                                    FeeTypeId            = item.FeeTypeId,
                                    FeeTermDescriptionId = item.FeeTermDescriptionId,
                                    FeeYearDate          = feeYear,
                                    PaymentDate          = item.PaymentDate,
                                    StudentId            = item.StudentId,
                                    Fine       = item.Fine,
                                    PaidAmount = item.PaidAmount,
                                    Remarks    = item.Remarks
                                };
                                _StudentPaymentsRepo.Insert(StudentPayments);
                            }
                        }
                        returnResult = "Saved";
                    }
                }
            }
            catch (Exception ex)
            {
                returnResult = "ERROR102:ClassesServ/InsertClassessList - " + ex.Message;
            }
            return(returnResult);
        }
        public JsonResult InsertStudentPayment(IndexPaymentDetailByIdVM obj)
        {
            var    result  = (dynamic)null;
            string message = (dynamic)null;

            try
            {
                if (obj.StudentPayments != null)
                {
                    var paymentLists = new List <InsertStudentPayment_StudentPayments>();
                    foreach (var item in obj._FeeStructure)
                    {
                        var payment = new InsertStudentPayment_StudentPayments()
                        {
                            PaymentDate          = obj.StudentPayments.PaymentDate,
                            StudentId            = obj.StudentPayments.StudentId,
                            FeeTypeId            = item.FeeTypeId,
                            ClassId              = obj.StudentPayments.ClassId,
                            FeeTermDescriptionId = item.TermNo,
                            FeeYear              = obj.StudentPayments.FeeYear,
                            Fine       = item.Fine,
                            PaidAmount = item.PaidAmount,
                            Remarks    = item.Remarks
                        };
                        paymentLists.Add(payment);
                    }
                    var model = new InsertStudentPayment()
                    {
                        _StudentPayments = paymentLists
                    };
                    message = _StudentPaymentsServ.InsertStudentPayment(model);
                    result  = Json(new { success = true, Message = message });
                }
            }
            catch (Exception ex)
            {
                result = Json(new { success = false, Message = "ERROR101:StudentPayment/InsertStudentPayment - " + ex.Message });
            }
            return(result);
        }