public FeesPaymentDetail FeesPaymentDataService(FeesPaymentDetail ObjFeesPaymentDetail, StudentParentDetail ObjStudentParentDetail)
        {
            Double TotalAmount = 0.0;

            if (!string.IsNullOrEmpty(ObjFeesPaymentDetail.ExistingClientUid))
            {
                if (ObjStudentParentDetail != null)
                {
                    Schoolfeedetails ObjSchoolfeedetails = GetFeeDetailByClassDetailUid(ObjStudentParentDetail.ClassDetailUid);
                    if (ObjSchoolfeedetails != null)
                    {
                        foreach (var Fees in ObjFeesPaymentDetail.feesDetail)
                        {
                            if (ObjSchoolfeedetails.IsFeeChanged)
                            {
                                if (Fees.ForMonth == Convert.ToDateTime(ObjSchoolfeedetails.AffectedDate).Month - 1)
                                {
                                    TotalAmount += ObjSchoolfeedetails.NewAmount;
                                }
                                else
                                {
                                    TotalAmount += ObjSchoolfeedetails.Amount;
                                }
                            }
                            else
                            {
                                TotalAmount += ObjSchoolfeedetails.Amount;
                            }
                        }
                        ObjFeesPaymentDetail.Mobile      = ObjStudentParentDetail.FatherMobileno;
                        ObjFeesPaymentDetail.Email       = ObjStudentParentDetail.Fatheremailid;
                        ObjFeesPaymentDetail.PersonName  = ObjStudentParentDetail.FatherFirstName + " " + ObjStudentParentDetail.FatherLastName;
                        ObjFeesPaymentDetail.TotalAmount = TotalAmount;
                        ObjFeesPaymentDetail.PayeeCode   = 1;
                    }
                }
            }
            return(ObjFeesPaymentDetail);
        }
        public Schoolfeedetails GetFeeDetailByClassDetailUid(string ClassDetailUid)
        {
            Schoolfeedetails ObjSchoolfeedetails = new Schoolfeedetails();
            String           ResultSet           = null;

            DbParam[] param = new DbParam[]
            {
                new DbParam(ClassDetailUid, typeof(System.String), "_classDetailUid"),
                new DbParam(userDetail.schooltenentId, typeof(System.String), "_tenentUid")
            };
            DataSet ds = db.GetDataset("sp_GetFeeDetail_ByClassDetailUid", param);

            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                ObjSchoolfeedetails = userDefineMapping.ConvertToObject(ds.Tables[0], ObjSchoolfeedetails.GetType(), out ResultSet) as Schoolfeedetails;
                if (ResultSet != "100")
                {
                    return(null);
                }
            }
            return(ObjSchoolfeedetails);
        }