public void GetInpatientList()
        {
            var cs            = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
            var inPatientList = new List <GetPatientDetails>();

            using (var con = new SqlConnection(cs))
            {
                var cmd = new SqlCommand("SPGetInpatientDetails", con)
                {
                    CommandType = CommandType.StoredProcedure
                };
                con.Open();
                var dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    var inpatient = new GetPatientDetails
                    {
                        PatientID          = Convert.ToInt32(dr[0].ToString()),
                        PatientFirstName   = dr[1].ToString(),
                        PatientLastName    = dr[2].ToString(),
                        PatientDisease     = dr[3].ToString(),
                        PatientGender      = dr[4].ToString(),
                        PatientEmailId     = dr[5].ToString(),
                        PatientPhoneNumber = dr[6].ToString(),
                        PatientDOB         = Convert.ToDateTime(dr[7].ToString())
                    };
                    inPatientList.Add(inpatient);
                }
            }

            var js = new JavaScriptSerializer();

            Context.Response.Write(js.Serialize(inPatientList));
        }
        public async Task <Result <EnrollClientResponse> > Handle(EnrollClientCommand request, CancellationToken cancellationToken)
        {
            try
            {
                RegisterPersonService registerPersonService = new RegisterPersonService(_unitOfWork);
                var patientIdentifier = await registerPersonService.EnrollPatient(request.ClientEnrollment.EnrollmentNo,
                                                                                  request.ClientEnrollment.PatientId, request.ClientEnrollment.ServiceAreaId,
                                                                                  request.ClientEnrollment.CreatedBy, request.ClientEnrollment.DateOfEnrollment);

                GetPatientDetails patientDetails = new GetPatientDetails(_unitOfWork);


                var patientLookup = await patientDetails.GetPatientByPatientId(request.ClientEnrollment.PatientId);

                if (patientLookup.Count > 0 && patientLookup[0].ptn_pk == null)
                {
                    var dobPrecision = "EXACT";
                    var dob          = DateTime.Now;
                    if (patientLookup[0].DobPrecision.HasValue)
                    {
                        dobPrecision = patientLookup[0].DobPrecision.Value ? "ESTIMATED" : "EXACT";
                    }

                    if (patientLookup[0].DateOfBirth.HasValue)
                    {
                        dob = patientLookup[0].DateOfBirth.Value;
                    }


                    var response = await registerPersonService.InsertIntoBlueCard(
                        patientLookup[0].FirstName,
                        patientLookup[0].LastName,
                        patientLookup[0].MidName,
                        request.ClientEnrollment.DateOfEnrollment,
                        patientLookup[0].MaritalStatusName,
                        patientLookup[0].PhysicalAddress,
                        patientLookup[0].MobileNumber,
                        patientLookup[0].Gender,
                        dobPrecision,
                        dob,
                        request.ClientEnrollment.CreatedBy,
                        request.ClientEnrollment.PosId
                        );

                    if (response.Count > 0)
                    {
                        await registerPersonService.UpdatePatient(request.ClientEnrollment.PatientId,
                                                                  request.ClientEnrollment.DateOfEnrollment, request.ClientEnrollment.PosId);
                    }
                }


                return(Result <EnrollClientResponse> .Valid(new EnrollClientResponse()
                {
                    IdentifierId = patientIdentifier.Id,
                    IdentifierValue = request.ClientEnrollment.EnrollmentNo
                }));
            }
            catch (Exception e)
            {
                Log.Error(e.Message);
                return(Result <EnrollClientResponse> .Invalid(e.Message));
            }

            //using (var trans = _unitOfWork.Context.Database.BeginTransaction())
            //{
            //    try
            //    {
            //        var previouslyIdentifiers = await _unitOfWork.Repository<PatientIdentifier>().Get(y =>
            //                y.IdentifierValue == request.ClientEnrollment.EnrollmentNo && y.IdentifierTypeId == 8)
            //            .ToListAsync();

            //        if (previouslyIdentifiers.Count > 0)
            //        {
            //            var exception = new Exception("No: " + request.ClientEnrollment.EnrollmentNo + " already exists");
            //            throw exception;
            //        }

            //        var enrollmentVisitType = await _unitOfWork.Repository<LookupItemView>().Get(x => x.MasterName == "VisitType" && x.ItemName == "Enrollment").FirstOrDefaultAsync();
            //        int? visitType = enrollmentVisitType != null ? enrollmentVisitType.ItemId : 0;
            //        var patientMasterVisit = new PatientMasterVisit()
            //        {
            //            PatientId = request.ClientEnrollment.PatientId,
            //            ServiceId = request.ClientEnrollment.ServiceAreaId,
            //            Start = DateTime.Now,
            //            End = null,
            //            Active = false,
            //            VisitDate = DateTime.Now,
            //            VisitType = visitType,
            //            Status = 1,
            //            CreateDate = DateTime.Now,
            //            DeleteFlag = false,
            //            CreatedBy = request.ClientEnrollment.CreatedBy
            //        };

            //        await _unitOfWork.Repository<PatientMasterVisit>().AddAsync(patientMasterVisit);
            //        await _unitOfWork.SaveAsync();

            //        var patientEnrollment = new PatientEnrollment()
            //        {
            //            PatientId = request.ClientEnrollment.PatientId,
            //            ServiceAreaId = request.ClientEnrollment.ServiceAreaId,
            //            EnrollmentDate = request.ClientEnrollment.DateOfEnrollment,
            //            EnrollmentStatusId = 0,
            //            TransferIn = false,
            //            CareEnded = false,
            //            DeleteFlag = false,
            //            CreatedBy = request.ClientEnrollment.CreatedBy,
            //            CreateDate = DateTime.Now

            //        };

            //        await _unitOfWork.Repository<PatientEnrollment>().AddAsync(patientEnrollment);
            //        await _unitOfWork.SaveAsync();

            //        var patientIdentifier = new PatientIdentifier()
            //        {
            //            PatientId = request.ClientEnrollment.PatientId,
            //            PatientEnrollmentId = patientEnrollment.Id,
            //            IdentifierTypeId = 8,
            //            IdentifierValue = request.ClientEnrollment.EnrollmentNo,
            //            DeleteFlag = false,
            //            CreatedBy = request.ClientEnrollment.CreatedBy,
            //            CreateDate = DateTime.Now,
            //            Active = true

            //        };

            //        await _unitOfWork.Repository<PatientIdentifier>().AddAsync(patientIdentifier);
            //        await _unitOfWork.SaveAsync();

            //        GetPatientDetails patientDetails = new GetPatientDetails(_unitOfWork);
            //        LookupLogic lookupLogic = new LookupLogic(_unitOfWork);

            //        var patientLookup = await patientDetails.GetPatientByPatientId(request.ClientEnrollment.PatientId);

            //        if (patientLookup.Count > 0)
            //        {
            //            Facility facility = await _unitOfWork.Repository<Facility>().Get(x => x.DeleteFlag == 0).FirstOrDefaultAsync();
            //            var referralId = await lookupLogic.GetDecodeIdByName("VCT", 17);
            //            var maritalStatusId = await lookupLogic.GetDecodeIdByName(patientLookup[0].MaritalStatusName, 17);
            //            var address = patientLookup[0].PhysicalAddress == null ? " " : patientLookup[0].PhysicalAddress;
            //            var phone = patientLookup[0].MobileNumber == null ? " " : patientLookup[0].MobileNumber;
            //            var dobPrecision = patientLookup[0].DobPrecision ? 1 : 0;

            //            var gender = 0;
            //            if (patientLookup[0].Gender == "Male")
            //            {
            //                gender = 16;
            //            }
            //            else if (patientLookup[0].Gender == "Female")
            //            {
            //                gender = 17;
            //            }

            //            StringBuilder sql = new StringBuilder();
            //            sql.Append("exec pr_OpenDecryptedSession;");
            //            sql.Append("Insert Into mst_Patient(FirstName, LastName, MiddleName, LocationID, PatientEnrollmentID, ReferredFrom, RegistrationDate, Sex, DOB, DobPrecision, MaritalStatus, Address, Phone, UserID, PosId, Status, DeleteFlag, CreateDate,MovedToPatientTable)");
            //            sql.Append("Values(");
            //            sql.Append($"ENCRYPTBYKEY(KEY_GUID('Key_CTC'),'{patientLookup[0].FirstName}'),");
            //            sql.Append($"ENCRYPTBYKEY(KEY_GUID('Key_CTC'),'{patientLookup[0].LastName}'),");
            //            sql.Append($"ENCRYPTBYKEY(KEY_GUID('Key_CTC'),'{patientLookup[0].MidName}'),");
            //            sql.Append($"'{facility.FacilityID}',");
            //            sql.Append("' ',");
            //            sql.Append($"'{referralId}',");
            //            sql.Append($"'{request.ClientEnrollment.DateOfEnrollment.ToString("yyyy-MM-dd")}',");
            //            sql.Append($"'{gender}',");
            //            sql.Append($"'{patientLookup[0].DateOfBirth.ToString("yyyy-MM-dd")}',");
            //            sql.Append($"'{dobPrecision}',");
            //            sql.Append($"'{maritalStatusId}',");
            //            sql.Append($"ENCRYPTBYKEY(KEY_GUID('Key_CTC'),'{address}'),");
            //            sql.Append($"ENCRYPTBYKEY(KEY_GUID('Key_CTC'),'{phone}'),");
            //            sql.Append($"'{request.ClientEnrollment.CreatedBy}',");
            //            sql.Append($"'{facility.PosID}',");
            //            sql.Append("0,");
            //            sql.Append("0,");
            //            sql.Append($"'{request.ClientEnrollment.DateOfEnrollment.ToString("yyyy-MM-dd")}',");
            //            sql.Append("1");
            //            sql.Append(");");

            //            sql.Append("SELECT Ptn_Pk, CAST(DECRYPTBYKEY([FirstName]) AS VARCHAR(50)) AS FirstName, CAST(DECRYPTBYKEY([LastName]) AS VARCHAR(50)) AS LastName, LocationID FROM [dbo].[mst_Patient] WHERE [Ptn_Pk] = SCOPE_IDENTITY();");
            //            sql.Append("exec [dbo].[pr_CloseDecryptedSession];");

            //            var result = await _unitOfWork.Repository<MstPatient>().FromSql(sql.ToString());

            //            StringBuilder sqlBuilder = new StringBuilder();
            //            sqlBuilder.Append("Insert Into Lnk_PatientProgramStart(Ptn_pk, ModuleId, StartDate, UserID, CreateDate)");
            //            sqlBuilder.Append("Values(");
            //            sqlBuilder.Append($"'{result[0].Ptn_Pk}',");
            //            sqlBuilder.Append("283,");
            //            sqlBuilder.Append($"'{request.ClientEnrollment.DateOfEnrollment.ToString("yyyy-MM-dd")}',");
            //            sqlBuilder.Append($"'{request.ClientEnrollment.CreatedBy}',");
            //            sqlBuilder.Append($"'{request.ClientEnrollment.DateOfEnrollment.ToString("yyyy-MM-dd")}'");
            //            sqlBuilder.Append(");");

            //            var insertResult = await _unitOfWork.Context.Database.ExecuteSqlCommandAsync(sqlBuilder.ToString());

            //            StringBuilder sqlPatient = new StringBuilder();
            //            sqlPatient.Append($"UPDATE Patient SET ptn_pk = '{result[0].Ptn_Pk}' WHERE Id = '{request.ClientEnrollment.PatientId}';");
            //            var updateResult = await _unitOfWork.Context.Database.ExecuteSqlCommandAsync(sqlPatient.ToString());
            //        }

            //        trans.Commit();

            //        _unitOfWork.Dispose();

            //        return Result<EnrollClientResponse>.Valid(new EnrollClientResponse
            //        {
            //            IdentifierValue = request.ClientEnrollment.EnrollmentNo,
            //            IdentifierId = patientIdentifier.Id
            //        });
            //    }
            //    catch (Exception ex)
            //    {
            //        trans.Rollback();
            //        return Result<EnrollClientResponse>.Invalid(ex.Message);
            //    }
            //}
        }
        public async Task <Result <EnrollClientResponse> > Handle(EnrollClientCommand request, CancellationToken cancellationToken)
        {
            try
            {
                var transferIn = false;
                if (request.ClientEnrollment.transferIn)
                {
                    transferIn = true;
                }

                RegisterPersonService registerPersonService = new RegisterPersonService(_unitOfWork);
                await registerPersonService.DynamicEnrollment(request.ClientEnrollment.PatientId,
                                                              request.ClientEnrollment.ServiceAreaId, request.ClientEnrollment.CreatedBy,
                                                              request.ClientEnrollment.DateOfEnrollment, request.ClientEnrollment.ServiceIdentifiersList, transferIn);

                /*var patientIdentifier = await registerPersonService.EnrollPatient(request.ClientEnrollment.EnrollmentNo,
                 *  request.ClientEnrollment.PatientId, request.ClientEnrollment.ServiceAreaId,
                 *  request.ClientEnrollment.CreatedBy, request.ClientEnrollment.DateOfEnrollment);*/

                string cccNumber = String.Empty;
                int    moduleId  = 283;
                foreach (var item in request.ClientEnrollment.ServiceIdentifiersList)
                {
                    if (item.IdentifierId == 1)
                    {
                        cccNumber = item.IdentifierValue;
                        moduleId  = 203;
                    }
                }

                GetPatientDetails patientDetails = new GetPatientDetails(_unitOfWork);


                var patientLookup = await patientDetails.GetPatientByPatientId(request.ClientEnrollment.PatientId);

                if (patientLookup.Count > 0 && (patientLookup[0].ptn_pk == 0 || patientLookup[0].ptn_pk == null))
                {
                    var dobPrecision = "EXACT";
                    var dob          = DateTime.Now;
                    if (patientLookup[0].DobPrecision.HasValue)
                    {
                        dobPrecision = patientLookup[0].DobPrecision.Value ? "ESTIMATED" : "EXACT";
                    }

                    if (patientLookup[0].DateOfBirth.HasValue)
                    {
                        dob = patientLookup[0].DateOfBirth.Value;
                    }


                    var response = await registerPersonService.InsertIntoBlueCard(
                        patientLookup[0].FirstName,
                        patientLookup[0].LastName,
                        patientLookup[0].MidName,
                        request.ClientEnrollment.DateOfEnrollment,
                        cccNumber,
                        moduleId,
                        patientLookup[0].MaritalStatusName,
                        patientLookup[0].PhysicalAddress,
                        patientLookup[0].MobileNumber,
                        patientLookup[0].Gender,
                        dobPrecision,
                        dob,
                        request.ClientEnrollment.CreatedBy,
                        request.ClientEnrollment.PosId
                        );

                    if (response.Count > 0)
                    {
                        await registerPersonService.UpdatePatient(request.ClientEnrollment.PatientId,
                                                                  request.ClientEnrollment.DateOfEnrollment, request.ClientEnrollment.PosId);
                    }
                }
                else
                {
                    if (moduleId == 203)
                    {
                        await registerPersonService.UpdateBlueCard(patientLookup[0].ptn_pk, cccNumber, moduleId);
                    }
                }


                return(Result <EnrollClientResponse> .Valid(new EnrollClientResponse()
                {
                    Message = "Success"
                }));
            }
            catch (Exception e)
            {
                Log.Error(e.Message);
                return(Result <EnrollClientResponse> .Invalid(e.Message));
            }
        }