// POST: api/Copier
        public IHttpActionResult Post([FromBody]Copier copier)
        {
            OperationResult operationResult = new Models.OperationResult();
            CopierData copierData = new CopierData();


            if (copier.ID == 0)
            {
                operationResult = copierData.AddCopier(copier);
                if (operationResult.Success)
                {
                    return Ok();
                }
                else
                {
                    return BadRequest(operationResult.ErrorMessage);
                }
            }
            else
            {
                operationResult = copierData.UpdateCopier(copier);
                if (operationResult.Success)
                {
                    return Ok();
                }
                else
                {
                    return BadRequest(operationResult.ErrorMessage);
                }
            }
        }
        // POST: api/EditFaxToEntry
        public IHttpActionResult Post([FromBody]SendFaxInformation faxEntry)
        {
            OperationResult operationResult = new Models.OperationResult();
            SendToData sendToData = new SendToData();
            faxEntry.FaxNumber = faxEntry.FaxNumber.Replace("-", "")
                .Replace(" ", "")
                .Replace("(", "")
                .Replace(")", "");

            if (faxEntry.Prefix == "Prefix")
            {
                faxEntry.Prefix = string.Empty;
            }

            if (faxEntry.Suffix == "Suffix")
            {
                faxEntry.Suffix = string.Empty;
            }

            faxEntry.Name = faxEntry.Prefix + " "
            + faxEntry.FirstName + " "
            + faxEntry.LastName + " "
            + faxEntry.Suffix;

            operationResult.Success = sendToData.UpdateFaxEntry(faxEntry);

            if (operationResult.Success)
            {
                return Ok();
            }
            else
            {
                return BadRequest(); 
            }
        }
        // DELETE: api/EditFaxToEntry/5
        public IHttpActionResult Delete(int id)
        {
            OperationResult operationResult = new Models.OperationResult();
            SendToRepository sendToData = new SendToRepository();
            operationResult = sendToData.DeleteFaxEntry(id);

            if (operationResult.Success)
            {
                return Ok();
            }
            else
            {
                return BadRequest();
            }
        }
Пример #4
0
        /// <summary>
        /// 把返回码映射为json。
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        public static string SerializeDBReturnCode(DBReturnCode code)
        {
            Models.OperationResult result = new Models.OperationResult();
            result.ErrorCode = (int)code;
            switch (code)
            {
            case DBReturnCode.BAD_REQUEST: result.ErrorMessage = "参数异常"; break;

            case DBReturnCode.DATA_CONFLICT: result.ErrorMessage = "数据库冲突"; break;

            case DBReturnCode.NOT_EXIST: result.ErrorMessage = "数据不存在"; break;

            case DBReturnCode.OP_ERROR: result.ErrorMessage = "操作失败"; break;

            case DBReturnCode.SUCCESS: result.ErrorMessage = "操作成功"; break;
            }
            return(JsonConvert.SerializeObject(result));
        }
Пример #5
0
 /// <summary>
 /// 登陆操作
 /// </summary>
 /// <returns></returns>
 public ActionResult login()
 {
     Models.OperationResult result = new Models.OperationResult()
     {
         ErrorCode = 001, ErrorMessage = "参数错误"
     };
     try
     {
         string username = Request.Params.Get("username");
         string password = Request.Params.Get("password");
         using (Maintain mt = new Maintain())
         {
             result = DAL.UserService.Login(mt, username, password);
             if (result.ErrorCode == 0)
             {
                 Models.UserInfo user = DAL.UserService.GetUser(mt, username);
                 //不可把password明文传回客户端
                 String temp = user.Password;
                 user.Password = "";
                 var j = JsonConvert.SerializeObject(user);
                 user.Password = temp;
                 return(Json(j, JsonRequestBehavior.AllowGet));
             }
             else
             {
                 //登录失败返回错误信息
                 return(Json(JsonConvert.SerializeObject(result), JsonRequestBehavior.AllowGet));
             }
         }
     }
     catch (Exception e)
     {
         //异常时返回错误信息
         Console.WriteLine("error:" + e.Message);
         result.ErrorMessage = e.Message;
         var j = JsonConvert.SerializeObject(result);
         return(Json(j, JsonRequestBehavior.AllowGet));
     }
 }
        public OperationResult AddFolder(Folder folder)
        {
            OperationResult operationResult = new Models.OperationResult();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
            {
                try
                {

                    string query = "INSERT INTO [HoldFolders]"
                        + " ("
                        + " [ActiveDirectoryUser]"
                        + " ,[DocumentType]"
                        + " ,[FolderName]"
                        + " )"
                        + "VALUES"
                        + " ("
                        + " @ActiveDirectoryUser,@DocumentType,@FolderName"
                        + " )";

                    db.Execute(query, new
                    {
                        @ActiveDirectoryUser = Utility.GetUserName(),
                        @DocumentType = folder.DocumentType,
                        @FolderName = folder.FolderName
                    });

                    operationResult.Success = true;
                    return operationResult;
                }
                catch (Exception er)
                {
                    operationResult.Success = false;
                    operationResult.AddMessage(er.ToString());
                    return operationResult;
                }
            }
        }
        public void InsertFormsConsoleRecord(AppointmentInfo appointmentInfo)
        {
            OperationResult operationResult = new Models.OperationResult();

            if (CheckToSeeIfRecordIsPresent(appointmentInfo.AppointmentId) == false)
            {
                if (appointmentInfo.DateOfBirth == "1/1/0001 12:00:00 AM")
                {
                    appointmentInfo.DateOfBirth = string.Empty;
                }

                using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
                {
                    try
                    {
                        const string query = "INSERT INTO [FormsConsoleData]"
                            + " ("
                            + " [PersonApptDate]"
                            + " ,[PersonApptTime]"
                            + " ,[PersonResource]"
                            + " ,[PersonAppointmentId]"
                            + " ,[PersonResourceID]"
                            + " ,[PersonLocationName]"
                            + " ,[PersonPatientID]"
                            + " ,[PersonTypeAbbreviation]"
                            + " ,[PersonTypeAlternateName]"
                            + " ,[PersonStatus]"
                            + " ,[PersonChiefComplaint]"
                            + " ,[PersonType]"
                            + " ,[PersonFirstName]"
                            + " ,[PersonMiddleName1]"
                            + " ,[PersonLastName]"
                            + " ,[PersonGender]"
                            + " ,[PersonDateOfBirth]"
                            + " ,[PersonCellPhone1]"
                            + " ,[PersonPrimaryPhone]"
                            + " ,[PersonPrimaryWorkPhone]"
                            + " ,[PersonAddressLine1]"
                            + " ,[PersonAddressLine2]"
                            + " ,[PersonAddressCity]"
                            + " ,[PersonAddressState]"
                            + " ,[PersonAddressPostalCode]"
                            + " ,[PersonAddressCounty]"
                            + " ,[AltPatientID]"
                            + " ,[Occupation]"
                            + " ,[wcAddressLine1]"
                            + " ,[wcAddressLine2]"
                            + " ,[wcCity]"
                            + " ,[wcCounty]"
                            + " ,[wcEmployerID]"
                            + " ,[wcFax]"
                            + " ,[wcName]"
                            + " ,[wcPhone]"
                            + " ,[wcPostalCode]"
                            + " ,[wcState]"
                            + " ,[LastModifiedDate]"
                            + " ,[CreateDate]"
                            + " )"
                            + " VALUES"
                            + " ("
                            + " @PersonApptDate,@PersonApptTime,@PersonResource,@PersonAppointmentId,@PersonResourceID,@PersonLocationName"
                            + " ,@PersonPatientID,@PersonTypeAbbreviation,@PersonTypeAlternateName,@PersonStatus,@PersonChiefComplaint"
                            + " ,@PersonType,@PersonFirstName,@PersonMiddleName1,@PersonLastName,@PersonGender,@PersonDateOfBirth"
                            + " ,@PersonCellPhone1,@PersonPrimaryPhone,@PersonPrimaryWorkPhone,@PersonAddressLine1"
                            + " ,@PersonAddressLine2,@PersonAddressCity,@PersonAddressState,@PersonAddressPostalCode,@PersonAddressCounty,@AltPatientID,@Occupation"
                            + " ,@wcAddressLine1,@wcAddressLine2,@wcCity,@wcCounty,@wcEmployerID,@wcFax,@wcName,@wcPhone,@wcPostalCode,@wcState,@LastModifiedDate,@CreateDate"
                            + ")";

                        int rowsAffectd = db.Execute(query, new
                        {
                            @PersonApptDate = appointmentInfo.AppointmentDate.ToShortDateString(),
                            @PersonApptTime = appointmentInfo.AppointmentTime.ToShortTimeString(),
                            @PersonResource = appointmentInfo.Resource,
                            @PersonAppointmentId = appointmentInfo.AppointmentId,
                            @PersonResourceID = appointmentInfo.ResourceId,
                            @PersonLocationName = appointmentInfo.LocationName,
                            @PersonPatientID = appointmentInfo.PatientID,
                            @PersonTypeAbbreviation = appointmentInfo.TypeAbbreviation,
                            @PersonTypeAlternateName = appointmentInfo.TypeAlternateName,
                            @PersonStatus = appointmentInfo.Status,
                            @PersonChiefComplaint = appointmentInfo.ChiefComplaint,
                            @PersonType = appointmentInfo.Type,
                            @PersonFirstName = appointmentInfo.FirstName,
                            @PersonMiddleName1 = appointmentInfo.MiddleName1,
                            @PersonLastName = appointmentInfo.LastName,
                            @PersonDateOfBirth = appointmentInfo.DateOfBirth,
                            @PersonGender = appointmentInfo.Gender,
                            @PersonCellPhone1 = appointmentInfo.CellPhone1,
                            @PersonPrimaryPhone = appointmentInfo.PrimaryPhone,
                            @PersonPrimaryWorkPhone = appointmentInfo.PrimaryWorkPhone,
                            @PersonAddressLine1 = appointmentInfo.AddressLine1,
                            @PersonAddressLine2 = appointmentInfo.AddressLine2,
                            @PersonAddressCity = appointmentInfo.City,
                            @PersonAddressState = appointmentInfo.State,
                            @PersonAddressPostalCode = appointmentInfo.PostalCode,
                            @PersonAddressCounty = appointmentInfo.County,
                            @AltPatientID = appointmentInfo.AltPatientID,
                            @Occupation = appointmentInfo.Occupation,
                            @wcAddressLine1 = appointmentInfo.wcAddressLine1,
                            @wcAddressLine2 = appointmentInfo.wcAddressLine2,
                            @wcCity = appointmentInfo.wcCity,
                            @wcCounty = appointmentInfo.wcCounty,
                            @wcEmployerID = appointmentInfo.wcEmployerID,
                            @wcFax = appointmentInfo.wcFax,
                            @wcName = appointmentInfo.wcName,
                            @wcPhone = appointmentInfo.wcPhone,
                            @wcPostalCode = appointmentInfo.wcPostalCode,
                            @wcState = appointmentInfo.wcState,
                            @LastModifiedDate = DateTime.Now,
                            @CreateDate = appointmentInfo.DateCreated
                        });

                        //operationResult.Success = true;

                    }
                    catch (Exception er)
                    {
                        Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                    }
                }
            }
        }
        public void InsertWorkmancompRecord(WorkmanComp workmanComp)
        {
            OperationResult operationResult = new Models.OperationResult();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
            {
                try
                {

                    const string query = "INSERT INTO [WorkmanComp]"
                        + " ("
                        + " [EmployerID]"
                        + " ,[AddressLine1]"
                        + " ,[AddressLine2]"
                        + " ,[City]"
                        + " ,[State]"
                        + " ,[PostalCode]"
                        + " ,[County]"
                        + " ,[Phone]"
                        + " ,[Fax]"
                        + " ,[Name]"
                        + ")"
                        + " VALUES"
                        + " ("
                        + " @EmployerID,@AddressLine1,@AddressLine2,@City,@State,@PostalCode,@County,@Phone,@Fax,@Name"
                        + ")";

                    int rowsAffectd = db.Execute(query, new
                    {
                        @EmployerID = workmanComp.EmployerID,
                        @AddressLine1 = workmanComp.AddressLine1,
                        @AddressLine2 = workmanComp.AddressLine2,
                        @City = workmanComp.City,
                        @State = workmanComp.State,
                        @PostalCode = workmanComp.PostalCode,
                        @County = workmanComp.County,
                        @Phone = workmanComp.Phone,
                        @Fax = workmanComp.Fax,
                        @Name = workmanComp.Name
                    });

                    //operationResult.Success = true;

                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                }
            }
        }
        public void InsertGlobalPostOp(GlobalPostOp  globalPostOp)
        {
            OperationResult operationResult = new Models.OperationResult();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
            {
                try
                {

                    const string query = "INSERT INTO [GlobalPostOp]"
                        + " ("
                        + " [PatientId]"
                        + " ,[DateOfService]"
                        + " ,[ProcedureCode]"
                        + " ,[Charge]"
                        + " ,[Description]"
                        + " ,[RenderingProvider]"
                        + " ,[ChargeID]"
                        + ")"
                        + " VALUES"
                        + " ("
                        + " @PatientId,@DateOfService,@ProcedureCode,@Charge,@Description,@RenderingProvider,@ChargeID"
                        + ") ";


                    int rowsAffectd = db.Execute(query, new
                    {
                        @PatientId = globalPostOp.PatientId,
                        @DateOfService = globalPostOp.ServiceDate,
                        @ProcedureCode = globalPostOp.ProcedureCode,
                        @Charge = globalPostOp.Charge,
                        @Description = globalPostOp.ProcedureDescription,
                        @RenderingProvider = globalPostOp.RenderingProvider,
                        @ChargeID = globalPostOp.ChargeId

                    });

                    //operationResult.Success = true;

                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                }
            }
        }
        public void UpdateLastModifiedDate(DateTime lastModifiedDate)
        {
            OperationResult operationResult = new Models.OperationResult();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
            {
                try
                {
                    const string query = "update [Update]"
                        + " set LastModified = @LastModified";
                    int rowsAffectd = db.Execute(query, new
                    {
                        @LastModified = lastModifiedDate
                    });
                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                }
            }
        }
        // POST: api/SendFax
        public IHttpActionResult Post([FromBody] Fax faxValues)
        {

            Logging.LogErrors(ConfigurationValues.ErrorLogPath, "Start Creating Fax");

            OperationResult createFaxRecordOperationResult = new Models.OperationResult();
            OperationResult sendFaxToMultiTechOperationResult = new Models.OperationResult();

            FaxRepository faxData = new FaxRepository();
            DocumentRepository documentData = new DocumentRepository();

            string[] faxesToSendList = faxValues.FaxTo.Split('~');
            string permanentFaxPath = string.Empty;

            SendFax sendFax = new SendFax();

            try
            {
                for (int i = 0; i < faxesToSendList.Length - 1; i++)
                {

                    Logging.LogErrors(ConfigurationValues.ErrorLogPath, "Getting fax information");

                    FaxingInformation faxingInformatonInitial = new FaxingInformation();

                    faxingInformatonInitial.DocumentList = faxValues.DocumentList;
                    faxingInformatonInitial.FaxTo = faxesToSendList[i];
                    faxingInformatonInitial.Notes = faxValues.Notes;
                    faxingInformatonInitial.From = faxValues.From;
                    faxingInformatonInitial.Cover = faxValues.Cover;
                    faxingInformatonInitial.CoverSheetOnly = faxValues.CoverOnly;

                    Logging.LogErrors(ConfigurationValues.ErrorLogPath, "Getting fax information");                    
                    //Create Fax
                    FaxingInformation faxingInformatonComplete = sendFax.CreateFax(faxingInformatonInitial);

                    System.IO.File.Copy(ConfigurationValues.TemporaryFaxPath
                        + Utility.GetUserName() + "\\" + faxingInformatonComplete.FaxName,
                        ConfigurationValues.PernamentFaxPath
                        + faxingInformatonComplete.FaxName, true);

                    createFaxRecordOperationResult = faxData.SendFax(faxingInformatonComplete, ConfigurationValues.PernamentFaxPath
                        + faxingInformatonComplete.FaxName, faxValues.From, faxValues.Notes);

                    if (createFaxRecordOperationResult.Success)
                    {
                        sendFaxToMultiTechOperationResult = sendFaxMultitech.SendTheFax(faxingInformatonComplete.Name, faxingInformatonComplete.FaxPath,
                            faxValues.From, faxingInformatonComplete.FaxNumber, createFaxRecordOperationResult.MessageList[0], ConfigurationValues.ApplicationPath);
                        if (sendFaxToMultiTechOperationResult.Success)
                        {
                            archiveDocument = new ArchiveDocument();

                            CurrentDocuments faxTodocument = documentData.GetCurrentDocumentPathPDF(Utility.GetUserName());
                            string[] filesToDelete = faxTodocument.CurrentDocumentList.Split('~');
                            for (int j = 0; j < filesToDelete.Length - 1; j++)
                            {
                                //try
                                //{
                                //    File.Delete(ConfigurationValues.OutboundFaxDirectory + "\\" + Utility.GetUserName() + "\\" + filesToDelete[j]);
                                //}
                                //catch { }
                                try
                                {
                                    string[] fileParts = filesToDelete[j].Split('\\');

                                    archiveDocument.ArchiveTheDocument(fileParts[fileParts.Length - 1], filesToDelete[j], Utility.GetUserName());

                                    File.Delete(filesToDelete[j]);
                                }
                                catch { }

                                documentData.DeleteDocumentInFolder(filesToDelete[j]);
                            }

                            System.IO.File.Delete(ConfigurationValues.TemporaryFaxPath
                                + Utility.GetUserName()
                                + "\\" + faxingInformatonComplete.FaxName);
                        }
                        else
                        {
                            faxData.UpdateFaxRecord(createFaxRecordOperationResult.MessageList[0]);
                        }
                    }
                    else
                    {
                        return BadRequest(createFaxRecordOperationResult.ErrorMessage);
                    }
                }
            }
            catch (Exception er)
            {
                return InternalServerError(er);
            }

            CurrentDocuments documentsToDelete = documentData.GetCurrentDocumentPathPDF(Utility.GetUserName());

            try
            {
                File.Delete(documentData.GetFullPathToDocument(Utility.GetUserName()));
            }
            catch { }

            string[] faxesToDelete = documentsToDelete.CurrentDocumentList.Split('~');

            try
            {
                for (int i = 0; i < faxesToDelete.Length - 1; i++)
                {
                    System.IO.File.Delete(ConfigurationValues.OutboundFaxDirectory + "\\"
                        + Utility.GetUserName() + "\\"
                        + faxesToDelete[i]);
                }
            }
            catch { }
            return Ok();
        }
        public OperationResult AddReportingRecord(SendFaxesReporting sentNotesFax)
        {
            if (string.IsNullOrEmpty(sentNotesFax.CareProviderName))
            {
                sentNotesFax.CareProviderName = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.PatientName))
            {
                sentNotesFax.PatientName = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.PrimaryCareFaxNumber))
            {
                sentNotesFax.PrimaryCareFaxNumber = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.PrimaryCareFaxSent))
            {
                sentNotesFax.PrimaryCareFaxSent = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.PrimaryCareProvider))
            {
                sentNotesFax.PrimaryCareProvider = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.PrimaryCareReason))
            {
                sentNotesFax.PrimaryCareReason = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.PrimaryCareResult))
            {
                sentNotesFax.PrimaryCareResult = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.ReferringCareFaxNumber))
            {
                sentNotesFax.ReferringCareFaxNumber = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.ReferringCareFaxSent))
            {
                sentNotesFax.ReferringCareFaxSent = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.ReferringCareProvider))
            {
                sentNotesFax.ReferringCareProvider = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.ReferringCareReason))
            {
                sentNotesFax.ReferringCareReason = string.Empty;
            }

            if (string.IsNullOrEmpty(sentNotesFax.ReferringCareResult))
            {
                sentNotesFax.ReferringCareResult = string.Empty;
            }

            OperationResult operationResult = new Models.OperationResult();

            string now = DateTime.Now.ToShortDateString()
                + " " + DateTime.Now.ToShortTimeString();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.WaldenFaxConnection))
            {
                try
                {

                    const string query = "INSERT INTO [AutomatedFaxesSent]"
                        + "("
                        + "[DocumentID]"
                        + " ,[PatientID]"
                        + " ,[PatientName]"
                        + " ,[CareProviderID]"
                        + " ,[CareProviderName]"
                        + " ,[PrimaryCareProviderID]"
                        + " ,[PrimaryCareProvider]"
                        + " ,[PrimaryCareFaxNumber]"
                        + " ,[PrimaryCareFaxSent]"
                        + " ,[PrimaryCareReason]"
                        + " ,[PrimaryCareResult]"
                        + " ,[PrimaryCareSendID]"
                        + " ,[PrimaryCareCompletionTime]"
                        + " ,[ReferringCareProviderID]"
                        + " ,[ReferringCareProvider]"
                        + " ,[ReferringCareFaxNumber]"
                        + " ,[ReferringCareFaxSent]"
                        + " ,[ReferringCareReason]"
                        + " ,[ReferringCareResult]"
                        + " ,[ReferringCareSendID]"
                        + " ,[ReferringCareCompletionTime]"
                        + " ,[DateTimeCreated]"
                        + " ,[DateTimeSent]"
                        + ")"
                        + "VALUES"
                        + "("
                        + " @DocumentID,@PatientID,@PatientName,@CareProviderID,@CareProviderName,@PrimaryCareProviderID,"
                        + " @PrimaryCareProvider,@PrimaryCareFaxNumber,@PrimaryCareFaxSent,@PrimaryCareReason,@PrimaryCareResult,@PrimaryCareSendID,@PrimaryCareCompletionTime,"
                        + " @ReferringCareProviderID,@ReferringCareProvider,@ReferringCareFaxNumber,@ReferringCareFaxSent,@ReferringCareReason,@ReferringCareResult,"
                        + " @ReferringCareSendID,@ReferringCareCompletionTime,@DateTimeCreated,@DateTimeSent"
                        + " )";

                    int rowsAffectd = db.Execute(query, new
                    {

                        @DocumentID = sentNotesFax.DocumentID,
                        @PatientID = sentNotesFax.PatientID,
                        @PatientName = sentNotesFax.PatientName,
                        @CareProviderID = sentNotesFax.CareProviderID,
                        @CareProviderName = sentNotesFax.CareProviderName,
                        @PrimaryCareProviderID = sentNotesFax.PrimaryCareProviderID,
                        @PrimaryCareProvider = sentNotesFax.PrimaryCareProvider,
                        @PrimaryCareFaxNumber = sentNotesFax.PrimaryCareFaxNumber,
                        @PrimaryCareFaxSent = sentNotesFax.PrimaryCareFaxSent,
                        @PrimaryCareReason = sentNotesFax.PrimaryCareReason,
                        @PrimaryCareResult = sentNotesFax.PrimaryCareResult,
                        @PrimaryCareSendID = sentNotesFax.PrimaryCareSendID,
                        @PrimaryCareCompletionTime = string.Empty,
                        @ReferringCareProviderID = sentNotesFax.ReferringCareProviderID,
                        @ReferringCareProvider = sentNotesFax.ReferringCareProvider,
                        @ReferringCareFaxNumber = sentNotesFax.ReferringCareFaxNumber,
                        @ReferringCareFaxSent = sentNotesFax.ReferringCareFaxSent,
                        @ReferringCareReason = sentNotesFax.ReferringCareReason,
                        @ReferringCareResult = sentNotesFax.ReferringCareResult,
                        @ReferringCareSendID = sentNotesFax.ReferringCareSendID,
                        @ReferringCareCompletionTime = string.Empty,
                        @DateTimeCreated = now,
                        @DateTimeSent = now
                    });

                    sendFaxId = GetSendFaxID();
                    operationResult.Success = true;
                    operationResult.AddMessage(sendFaxId.ToString());

                    return operationResult;
                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                    operationResult.Success = false;
                    operationResult.AddMessage(er.ToString());
                    return operationResult;
                }
            }
        }
        public OperationResult InsertAllSignedNotes(SignedDocument document)
        {
            OperationResult operationResult = new Models.OperationResult();

            if (string.IsNullOrEmpty(document.DocumentID.ToString()))
            {
                document.DocumentID = 0;
            }

            if (string.IsNullOrEmpty(document.PatientID.ToString()))
            {
                document.PatientID = 0;
            }

            if (string.IsNullOrEmpty(document.PatientName))
            {
                document.PatientName = string.Empty;
            }

            if (string.IsNullOrEmpty(document.CareProviderID.ToString()))
            {
                document.CareProviderID = 0;
            }

            if (string.IsNullOrEmpty(document.CareProviderName))
            {
                document.CareProviderName = string.Empty;
            }

            if (string.IsNullOrEmpty(document.PrimaryCareProviderID.ToString()))
            {
                document.PrimaryCareProviderID = 0;
            }

            if (string.IsNullOrEmpty(document.PrimaryCareProvider))
            {
                document.PrimaryCareProvider = string.Empty;
            }

            if (string.IsNullOrEmpty(document.ReferringCareProviderID.ToString()))
            {
                document.ReferringCareProviderID = 0;
            }

            if (string.IsNullOrEmpty(document.ReferringCareProvider))
            {
                document.ReferringCareProvider = string.Empty;
            }

            if (string.IsNullOrEmpty(document.DocTypeName))
            {
                document.DocTypeName = string.Empty;
            }

            if (string.IsNullOrEmpty(document.SignerID.ToString()))
            {
                document.SignerID = 0;
            }

            using (IDbConnection db = new SqlConnection(ConfigurationValues.WaldenFaxConnection))
            {
                try
                {
                    const string query = "INSERT INTO [AllSignedNotes]"
                        + " ("
                        + " [DocumentID]"
                        + " ,[VisitID]"
                        + " ,[DateSigned]"
                        + " ,[PatientID]"
                        + " ,[PatientName]"
                        + " ,[CareProviderID]"
                        + " ,[CareProviderName]"
                        + " ,[PrimaryCareProviderID]"
                        + " ,[PrimaryCareProvider]"
                        + " ,[ReferringCareProviderID]"
                        + " ,[ReferringCareProvider]"
                        + " ,[DocTypeName]"
                        + " ,[SignerID]"
                        + ")"
                        + " VALUES"
                        + " ("
                        + " @DocumentID,@VisitID ,@DateSigned , @PatientID, @PatientName, @CareProviderID, @CareProviderName,"
                        + " @PrimaryCareProviderID, @PrimaryCareProvider, @ReferringCareProviderID, @ReferringCareProvider,"
                        + " @DocTypeName, @SignerID"
                        + " )";


                    int rowsAffectd = db.Execute(query, new
                    {
                        @DocumentID = document.DocumentID,
                        @VisitID = document.VisitID,
                        @DateSigned = document.DateSigned,
                        @PatientID = document.PatientID,
                        @PatientName = document.PatientName,
                        @CareProviderID = document.CareProviderID,
                        @CareProviderName = document.CareProviderName,
                        @PrimaryCareProviderID = document.PrimaryCareProviderID,
                        @PrimaryCareProvider = document.PrimaryCareProvider,
                        @ReferringCareProviderID = document.ReferringCareProviderID,
                        @ReferringCareProvider = document.ReferringCareProvider,
                        @DocTypeName = document.DocTypeName,
                        @SignerID = document.SignerID
                    });

                    operationResult.Success = true;
                    operationResult.AddMessage("Success");
                    return operationResult;
                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                    operationResult.Success = false;
                    operationResult.AddMessage(er.ToString());
                    return operationResult;
                }
            }
        }
        //public OperationResult SendFax(MiscFaxInformation miscFaxInformation, string permanentFaxPath, string from, string notes)
        public OperationResult SendFax( FaxingInformation miscFaxInformation, string permanentFaxPath, string from, string notes)
        {

            OperationResult operationResult = new Models.OperationResult();

            string now = DateTime.Now.ToShortDateString()
                + " "
                + DateTime.Now.ToShortTimeString();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.WaldenFaxConnection))
            {
                try
                {
                    const string query = "INSERT INTO [FaxesSendServer]("
                        + "[AccountID]"
                        + ",[UserID]"
                        + ",[FaxName]"
                        + ",[FaxPath]"
                        + ",[FaxNumber]"
                        + ",[RecipientName]"
                        + ",[Notes]"
                        + ",[PageCount]"
                        + ",[FaxSent]"
                        + ",[InUse]"
                        + ",[ToTif]"
                        + ",[CallWait]"
                        + ",[TimesCalled]"
                        + ",[Status]"
                        + ",[ShowFax]"
                        + ",[CreateTime]"
                        + ",[CompletionTime]"
                        + ",[DateStamp])"
                        + " VALUES("
                        + "@AccountID"
                        + ",@UserID"
                        + ",@FaxName"
                        + ",@FaxPath"
                        + ",@FaxNumber"
                        + ",@RecipientName"
                        + ",@Notes"
                        + ",@PageCount"
                        + ",@FaxSent"
                        + ",@InUse"
                        + ",@ToTif"
                        + ",@CallWait"
                        + ",@TimesCalled"
                        + ",@Status"
                        + ",@ShowFax"
                        + ",@CreateTime"
                        + ",@CompletionTime"
                        + ",@DateStamp)";

                    int rowsAffectd = db.Execute(query, new
                    {
                        @AccountID = 1001,
                        @UserID = Utility.GetUserName(),
                        @FaxName = miscFaxInformation.Name,
                        @FaxPath = permanentFaxPath,
                        @FaxNumber = miscFaxInformation.FaxNumber,
                        @RecipientName = from,
                        @Notes = notes,
                        @PageCount = miscFaxInformation.PageCount,
                        @FaxSent = "Y",
                        @InUse = "N",
                        @ToTif = "Y",
                        @CallWait = 0,
                        @TimesCalled = 0,
                        @Status = "New Fax Entry",
                        @ShowFax = "Y",
                        @CreateTime = now,
                        @CompletionTime = string.Empty,
                        @DateStamp = now
                    });

                    int sendFaxId = GetSendFaxID();
                    operationResult.Success = true;
                    operationResult.AddMessage(sendFaxId.ToString());

                    return operationResult;
                }
                catch (Exception er)
                {
                    operationResult.Success = false;
                    operationResult.AddMessage(er.ToString());
                    return operationResult;
                }
            }
        }
        // POST: api/SendFax
        public IHttpActionResult Post([FromBody] Fax faxValues)
        {
            OperationResult createFaxRecordOperationResult = new Models.OperationResult();
            OperationResult sendFaxToMultiTechOperationResult = new Models.OperationResult();
            
            FaxData faxData = new FaxData();

            string documentList = faxValues.DocumentList;
            string faxTo = faxValues.FaxTo;
            string notes = faxValues.Notes;
            string cover = faxValues.Cover;
            string from = faxValues.From;

            string faxPath = string.Empty;
            string[] faxes = faxTo.Split('~');
            string permanentFaxPath = string.Empty;

            Misc misc = new Misc();

            try
            {
                for (int i = 0; i < faxes.Length - 1; i++)
                {
                    FaxingInformation faxingInformatonInitial = new FaxingInformation();

                    faxingInformatonInitial.DocumentList = documentList;
                    faxingInformatonInitial.FaxTo = faxes[i];
                    faxingInformatonInitial.Notes = notes;
                    faxingInformatonInitial.From = from;
                    faxingInformatonInitial.Cover = cover;

                    FaxingInformation faxingInformatonComplete = misc.CreateFax(faxingInformatonInitial);

                    permanentFaxPath = Walden.CompleteFax.Library.Database.PernamentFaxPath
                            + Utility.GetUserName() + "\\" + faxingInformatonComplete.NameFromDateTimeString;

                    System.IO.File.Copy(ConfigurationValues.TemporaryFaxPath
                        + Utility.GetUserName() + "\\" + faxingInformatonComplete.NameFromDateTimeString,
                        ConfigurationValues.PernamentFaxPath
                        + faxingInformatonComplete.NameFromDateTimeString, true);

                    string now = DateTime.Now.ToShortDateString()
                        + " "
                        + DateTime.Now.ToShortTimeString();

                    createFaxRecordOperationResult = faxData.SendFax(faxingInformatonComplete, ConfigurationValues.PernamentFaxPath
                        + faxingInformatonComplete.NameFromDateTimeString, from, notes);

                    if (createFaxRecordOperationResult.Success)
                    {
                        sendFaxToMultiTechOperationResult = sendFaxMultitech.SendTheFax(faxingInformatonComplete.Name, faxingInformatonComplete.FaxPath,
                            from, faxingInformatonComplete.FaxNumber, createFaxRecordOperationResult.MessageList[0], ConfigurationValues.ApplicationPath);
                        if (sendFaxToMultiTechOperationResult.Success)
                        {
                            System.IO.File.Delete(ConfigurationValues.TemporaryFaxPath
                                + Utility.GetUserName()
                                + "\\" + faxingInformatonComplete.NameFromDateTimeString);
                        }
                        else
                        {
                            faxData.UpdateFaxRecord(createFaxRecordOperationResult.MessageList[0]);
                        }
                    }
                    else
                    {
                        return BadRequest(createFaxRecordOperationResult.ErrorMessage);
                    }
                }
            }
            catch (Exception er)
            {
                return InternalServerError(er);
            }

            string[] faxesToDelete = documentList.Split('~');

            for (int i = 0; i < faxesToDelete.Length - 1; i++)
            {
                System.IO.File.Delete(ConfigurationValues.TemporaryFaxPath
                    + Utility.GetUserName() + "\\"
                    + faxesToDelete[i]);
            }

            return Ok();
        }
        // DELETE: api/Copier/5
        public IHttpActionResult Delete([FromBody] Copier copier)
        {
            OperationResult operationResult = new Models.OperationResult();
            CopierData copierData = new CopierData();

            operationResult = copierData.DeleteCopier(copier);
            if (operationResult.Success)
            {
                return Ok();
            }
            else
            {
                return BadRequest(operationResult.ErrorMessage);
            }
        }
        public void UpdateStatusPrimaryCareFax(int primaryCareID, string primaryCareStatus)
        {

            OperationResult operationResult = new Models.OperationResult();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.WaldenFaxConnection))
            {
                try
                {
                    const string query = "Update AutomatedFaxesSent"
                        + " set PrimaryCareResult = @PrimaryCareResult"
                        + " where PrimaryCareSendID = @PrimaryCareSendID";

                    int rowsAffectd = db.Execute(query, new
                    {
                        @PrimaryCareSendID = primaryCareID,
                        @PrimaryCareResult = primaryCareStatus
                    });

                    //operationResult.Success = true;

                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                }
            }

        }
        public void InsertProviderDetail(ProviderDetail providerDetail)
        {
            OperationResult operationResult = new Models.OperationResult();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
            {
                try
                {

                    const string query = "INSERT INTO [ProviderDetail]"
                        + " ("
                        + " [LocationAddressID]"
                        + " ,[AddressID]"
                        + " ,[City]"
                        + " ,[State]"
                        + " ,[PostalCode]"
                        + " ,[ActiveLocation]"
                        + " ,[LocationName]"
                        + " ,[LocationID]"
                        + " ,[AddressLine1]"
                        + " ,[AddressLine2]"
                        + " ,[PhoneNum1]"
                        + " ,[PhoneNum2]"
                        + " ,[Country]"
                        + " )"
                        + " VALUES"
                        + " ("
                        + " @LocationAddressID,@AddressID,@City,@State,@PostalCode,@ActiveLocation,@LocationName,"
                        + " @LocationID,@AddressLine1,@AddressLine2,@PhoneNum1,@PhoneNum2,@Country"
                        + ")";
                    int rowsAffectd = db.Execute(query, new
                    {
                        @LocationAddressID = providerDetail.LocationAddressID,
                        @AddressID = providerDetail.AddressID,
                        @City = providerDetail.City,
                        @State = providerDetail.State,
                        @PostalCode = providerDetail.PostalCode,
                        @ActiveLocation = providerDetail.ActiveLocation,
                        @LocationName = providerDetail.LocationName,
                        @LocationID = providerDetail.LocationID,
                        @AddressLine1 = providerDetail.AddressLine1,
                        @AddressLine2 = providerDetail.AddressLine2,
                        @PhoneNum1 = providerDetail.PhoneNum1,
                        @PhoneNum2 = providerDetail.PhoneNum2,
                        @Country = providerDetail.Country
                    });

                    //operationResult.Success = true;

                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                }
            }
        }
        public OperationResult SendFax(SendFax sendFax)
        {
            OperationResult operationResult = new Models.OperationResult();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.WaldenFaxConnection))
            {
                try
                {
                    const string query = "INSERT INTO [FaxesSendServer]("
                        + "[AccountID]"
                        + ",[UserID]"
                        + ",[FaxName]"
                        + ",[FaxPath]"
                        + ",[FaxNumber]"
                        + ",[RecipientName]"
                        + ",[Notes]"
                        + ",[PageCount]"
                        + ",[FaxSent]"
                        + ",[InUse]"
                        + ",[ToTif]"
                        + ",[CallWait]"
                        + ",[TimesCalled]"
                        + ",[Status]"
                        + ",[ShowFax]"
                        + ",[CreateTime]"
                        + ",[CompletionTime]"
                        + ",[DateStamp])"
                        + " VALUES("
                        + "@AccountID"
                        + ",@UserID"
                        + ",@FaxName"
                        + ",@FaxPath"
                        + ",@FaxNumber"
                        + ",@RecipientName"
                        + ",@Notes"
                        + ",@PageCount"
                        + ",@FaxSent"
                        + ",@InUse"
                        + ",@ToTif"
                        + ",@CallWait"
                        + ",@TimesCalled"
                        + ",@Status"
                        + ",@ShowFax"
                        + ",@CreateTime"
                        + ",@CompletionTime"
                        + ",@DateStamp)";

                    int rowsAffectd = db.Execute(query, new
                    {
                        @AccountID = sendFax.AccountID,
                        @UserID = sendFax.UserID,
                        @FaxName = sendFax.FaxName,
                        @FaxPath = sendFax.FaxPath,
                        @FaxNumber = sendFax.FaxNumber,
                        @RecipientName = sendFax.RecipientName,
                        @Notes = sendFax.Notes,
                        @PageCount = sendFax.PageCount,
                        @FaxSent = sendFax.FaxSent,
                        @InUse = sendFax.InUse,
                        @ToTif = sendFax.ToTif,
                        @CallWait = sendFax.CallWait,
                        @TimesCalled = sendFax.TimesCalled,
                        @Status = sendFax.Status,
                        @ShowFax = sendFax.ShowFax,
                        @CreateTime = sendFax.CreateTime,
                        @CompletionTime = sendFax.CompletionTime,
                        @DateStamp = sendFax.DateStamp
                    });

                    sendFaxId = GetSendFaxID();
                    operationResult.Success = true;
                    operationResult.AddMessage(sendFaxId.ToString());

                    return operationResult;
                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                    operationResult.Success = false;
                    operationResult.AddMessage(er.ToString());
                    return operationResult;
                }
            }
        }
        public void DeleteProviderDetail()
        {
            OperationResult operationResult = new Models.OperationResult();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
            {
                try
                {

                    const string query = "delete from [ProviderDetail]"
                    ;
                    int rowsAffectd = db.Execute(query);

                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                }
            }
        }
        public void UpdateMaxAppointmentID(string appointmentId)
        {
            OperationResult operationResult = new Models.OperationResult();

            using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
            {
                try
                {
                    const string query = "update [Update]"
                        + " set AppointmentID = @AppointmentID";
                    int rowsAffectd = db.Execute(query, new
                    {
                        @AppointmentID = appointmentId
                    });

                }
                catch (Exception er)
                {
                    Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                }
            }
        }
        public void InsertSignedDocumentsFromGreenway(List<SignedDocument> signedDocumentList)
        {
            OperationResult operationResult = new Models.OperationResult();

            for (int i = 0; i < signedDocumentList.Count; i++)
                using (IDbConnection db = new SqlConnection(ConfigurationValues.WaldenFaxConnection))
                {
                    try
                    {
                        const string query = "INSERT INTO [SignedDocumentsFromGreenway]"
                            + " ("
                            + " [SequenceNumber]"
                            + " ,[Location]"
                            + " ,[VisitID]"
                            + " ,[DocumentID]"
                            + " ,[DateSigned]"
                            + " ,[PatientID]"
                            + " ,[PatientName]"
                            + " ,[CareProviderID]"
                            + " ,[CareProviderName]"
                            + " ,[PrimaryCareProviderID]"
                            + " ,[PrimaryCareProvider]"
                            + " ,[ReferringCareProviderID]"
                            + " ,[ReferringCareProvider]"
                            + " ,[DocTypeName]"
                            + " ,[SignerID]"
                            + " ,[CreatedByID]"
                            + " )"
                            + " VALUES"
                            + " ("
                            + " @SequenceNumber,@Location,@VisitID,@DocumentID,@DateSigned,@PatientID,@PatientName"
                            + " ,@CareProviderID,@CareProviderName,@PrimaryCareProviderID,@PrimaryCareProvider"
                            + " ,@ReferringCareProviderID,@ReferringCareProvider,@DocTypeName,@SignerID,@CreatedByID"
                            + ")";

                        int rowsAffectd = db.Execute(query,new 
                        {
                            @SequenceNumber = signedDocumentList[i].SequenceNumber,
                            @Location = signedDocumentList[i].Location,
                            @VisitID = signedDocumentList[i].VisitID,
                            @DocumentID = signedDocumentList[i].DocumentID,
                            @DateSigned = signedDocumentList[i].DateSigned,
                            @PatientID = signedDocumentList[i].PatientID,
                            @PatientName = signedDocumentList[i].PatientName,
                            @CareProviderID = signedDocumentList[i].CareProviderID,
                            @CareProviderName = signedDocumentList[i].CareProviderName,
                            @PrimaryCareProviderID = signedDocumentList[i].PrimaryCareProviderID,
                            @PrimaryCareProvider = signedDocumentList[i].PrimaryCareProvider,
                            @ReferringCareProviderID = signedDocumentList[i].ReferringCareProviderID,
                            @ReferringCareProvider = signedDocumentList[i].ReferringCareProvider,
                            @DocTypeName = signedDocumentList[i].DocTypeName,
                            @SignerID = signedDocumentList[i].SignerID,
                            CreatedByID = signedDocumentList[i].CreatedById
                        });
                    }
                    catch (Exception er)
                    {
                        Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
                    }
            }
        }