public async Task <Payment> InsertPaymentMasterAsync(string Id)
        {
            Payment payment;
            //RegistrationViewModel model;
            var registrationMasterData = (await dapperService.GetAllRegistrationDetailsAsync()).FirstOrDefault(f => f.RefNo == Id);

            if (registrationMasterData != null)
            {
                payment = new Payment()
                {
                    UniqueId      = Guid.NewGuid().ToString().GetHashCode().ToString("x"),
                    RegPayId      = 0,
                    RefNo         = registrationMasterData.RefNo,
                    OrderId       = registrationMasterData.RefNo.ToString() + DateTime.Now.ToString("ddMMyyyyhhmm"),
                    Fee           = 1200,
                    ServiceCharge = 50,
                    TotalFee      = 1250,
                    PaidStatus    = 0,
                    PaidBy        = "USER",
                    PaidOn        = DateTime.Now
                };

                await dbContext.PaymentMaster.AddAsync(payment);

                var result = await dbContext.SaveChangesAsync();

                return(await GetPaymentMasterByOrderIdAsync(payment.OrderId));
            }

            return(null);
        }
        public async Task <RegistrationViewModel> GetRegistrationDetailsByUserIdAsync(string Id)
        {
            RegistrationViewModel model;
            var registrationMasterData = (await dapperService.GetAllRegistrationDetailsAsync()).FirstOrDefault(f => f.UserId == Id);
            var QualifyingExamData     = (await dapperService.GetQualifyingExamsAsync()).Where(w => w.RefNo == registrationMasterData.RefNo);

            if (registrationMasterData != null && QualifyingExamData != null)
            {
                model = new RegistrationViewModel
                {
                    UserId                      = registrationMasterData.UserId,
                    Name                        = registrationMasterData.Name,
                    FatherName                  = registrationMasterData.FatherName,
                    MotherName                  = registrationMasterData.MotherName,
                    Dob                         = registrationMasterData.Dob,
                    MobileNo                    = registrationMasterData.MobileNo,
                    EmailAddress                = registrationMasterData.EmailAddress,
                    Gender                      = registrationMasterData.Gender,
                    Year                        = registrationMasterData.Year,
                    ExamCenter                  = registrationMasterData.ExamCenter,
                    CourseName                  = registrationMasterData.CourseName,
                    StudentGroup                = registrationMasterData.StudentGroup,
                    MaritalStatus               = registrationMasterData.MaritalStatus,
                    Nationality                 = registrationMasterData.Nationality,
                    IsDomicileOfUttarakhand     = registrationMasterData.IsDomicileOfUttarakhand,
                    Category                    = registrationMasterData.Category,
                    IsFreedomFighter            = registrationMasterData.IsFreedomFighter,
                    IsDefencePersonal           = registrationMasterData.IsDefencePersonal,
                    IsPhysicallyChallenged      = registrationMasterData.IsPhysicallyChallenged,
                    PhysicallyChallengedType    = registrationMasterData.PhysicallyChallengedType,
                    IsPunishedByCourt           = registrationMasterData.IsPunishedByCourt,
                    IsDebarredByUniversity      = registrationMasterData.IsDebarredByUniversity,
                    StateName                   = registrationMasterData.StateName,
                    Address                     = registrationMasterData.Address,
                    City                        = registrationMasterData.City,
                    Pincode                     = registrationMasterData.Pincode,
                    PhotoPath                   = registrationMasterData.PhotoPath,
                    SignaturePath               = registrationMasterData.SignaturePath,
                    IsEconomicallyWeakerSection = registrationMasterData.IsEconomicallyWeakerSection,
                    RefNo                       = registrationMasterData.RefNo,
                    IsAppearing                 = registrationMasterData.IsAppearing,
                    IsKumaunUniversity          = registrationMasterData.IsKumaunUniversity
                };

                foreach (var item in QualifyingExamData)
                {
                    if (item.CourseName.Trim() == "B.Ed")
                    {
                        if (item.QualifyingType == "1")
                        {
                            model.GradutionName            = item.Name;
                            model.GradutionStream          = item.Stream;
                            model.GradutionUniversity      = item.University;
                            model.GradutionPassingYear     = item.PassingYear;
                            model.GradutionMaxMarks        = item.MaxMarks;
                            model.GradutionObtMarks        = item.ObtMarks;
                            model.GradutionPercentageMarks = item.PercentageMarks;
                        }
                        else if (item.QualifyingType == "2")
                        {
                            model.PostGradutionName         = item.Name;
                            model.PGradutionStream          = item.Stream;
                            model.PGradutionUniversity      = item.University;
                            model.PGradutionPassingYear     = item.PassingYear;
                            model.PGradutionMaxMarks        = item.MaxMarks;
                            model.PGradutionObtMarks        = item.ObtMarks;
                            model.PGradutionPercentageMarks = item.PercentageMarks;
                        }
                    }
                    else
                    {
                        if (item.QualifyingType == "3")
                        {
                            model.TheoryExamName     = item.Name;
                            model.TheoryExamMaxMarks = item.MaxMarks;
                            model.TheoryExamObtMarks = item.ObtMarks;
                        }
                        else if (item.QualifyingType == "4")
                        {
                            model.PracticalExamName     = item.Name;
                            model.PracticalExamMaxMarks = item.MaxMarks;
                            model.PracticalExamObtMarks = item.ObtMarks;
                        }

                        model.M_EdExamUniversity  = item.University;
                        model.M_EdExamPassingYear = item.PassingYear;
                        model.M_EdTotalPercentage = item.PercentageMarks;
                    }
                }

                return(model);
            }

            model = new RegistrationViewModel();

            return(model);
        }