public int GenerateAfFile(string basePath, RipsFilter ripsFilter, IEnumerable <Rips> rips) { var consecutive = Path.GetFileName(basePath); var afFiles = rips.Select(rip => new RipsAfFile { ProviderCode = rip.ProviderCode, BusinessName = rip.BusinessName, InitialDate = rip.InitialDate.Replace("-", "/"), FinalDate = rip.FinalDate.Replace("-", "/"), AdomIdentiticationNumber = rip.AdomIdentificationNumber, AdomIdentiticationTypeId = rip.AdomIdentificationType, Comission = 0, EntityCode = rip.EntityCode, EntityName = rip.EntityName, ContractNumber = "", BenefitPlan = "", PolicyNumber = "", InvoiceDate = ripsFilter.InvoiceDate.Replace("-", "/"), InvoiceNumber = ripsFilter.InvoiceNumber, NetValue = ripsFilter.NetValue, OtherValuesReceived = rip.OtherValuesReceived, TotalCopaymentReceived = ripsFilter.Copayment }).ToList(); var filePath = string.Format(@"{0}\AF{1}.txt", basePath, consecutive); using (var streamWriter = File.CreateText(filePath)) { var writer = new CsvWriter(streamWriter); writer.Configuration.HasHeaderRecord = false; writer.WriteRecords(afFiles); } return(afFiles.Count); }
public int GenerateApFile(string basePath, RipsFilter ripsFilter, IEnumerable <Rips> rips) { var consecutive = Path.GetFileName(basePath); var apFiles = ( from rip in rips where rip.ClassificationId == 2 select new RipsApFile { ProviderCode = rip.ProviderCode, DocumentTypeName = rip.DocumentTypeAbbreviation, PatientDocument = rip.PatientDocument, InvoiceNumber = ripsFilter.InvoiceNumber, FinalDate = ripsFilter.FinalDateIni.Replace("-", "/"), AuthorizationNumber = rip.AuthorizationNumber, RealizationScope = "1", ProcedurePurpose = "2", AttendandPerson = "4", Cie10 = rip.Cie10, Cups = rip.Cups, Rate = rip.Rate, }).ToList(); var filePath = string.Format(@"{0}\AP{1}.txt", basePath, consecutive); using (var streamWriter = File.CreateText(filePath)) { var writer = new CsvWriter(streamWriter); writer.Configuration.HasHeaderRecord = false; writer.WriteRecords(apFiles); } return(apFiles.Count); }
public int GenerateAtFile(string basePath, RipsFilter ripsFilter, IEnumerable <Rips> rips) { var consecutive = Path.GetFileName(basePath); var atFiles = new List <RipsAtFile>(); foreach (var rip in rips) { var supplies = _ripsRepository.GetServiceSupplies(rip.AssignServiceId); atFiles.AddRange(supplies.Select(sup => new RipsAtFile { InvoiceNumber = ripsFilter.InvoiceNumber, PatientDocument = rip.PatientDocument, ProviderCode = rip.ProviderCode, AuthorizationNumber = rip.AuthorizationNumber, DocumentTypeName = rip.DocumentTypeAbbreviation, ServiceType = "1", SupplyCode = sup.SupplyCode, SupplyQuantity = sup.Quantity, SupplyName = sup.SupplyName, SupplyTotalValue = (0 * sup.Quantity) })); } var filePath = string.Format(@"{0}\AT{1}.txt", basePath, consecutive); using (var streamWriter = File.CreateText(filePath)) { var writer = new CsvWriter(streamWriter); writer.Configuration.HasHeaderRecord = false; writer.WriteRecords(atFiles); } return(atFiles.Count); }
public ServiceResult <IEnumerable <Rips> > GetRipsServices(RipsFilter ripsFilter) { var result = _ripsRepository.GetServiceRips(ripsFilter); return(new ServiceResult <IEnumerable <Rips> > { Result = result, Errors = new[] { string.Empty }, Success = true }); }
public ServiceResult <IEnumerable <Rips> > Get([FromQuery] RipsFilter ripsFilter) { ServiceResult <IEnumerable <Rips> > result; try { result = _ripsDomainService.GetRipsServices(ripsFilter); } catch (Exception ex) { result = new ServiceResult <IEnumerable <Rips> >(); result.Errors = new[] { ex.Message }; result.Success = false; } return(result); }
public int GenerateAcFile(string basePath, RipsFilter ripsFilter, IEnumerable <Rips> rips) { var consecutive = Path.GetFileName(basePath); var acFiles = new List <RipsAcFile>(); foreach (var rip in rips) { var details = _ripsRepository.GetServiceDetail(rip.AssignServiceId); acFiles.AddRange(details.Select(item => new RipsAcFile { ProviderCode = rip.ProviderCode, DocumentTypeName = rip.DocumentTypeAbbreviation?.Replace("\"", "").Trim(), PatientDocument = rip.PatientDocument?.Replace("\"", "").Trim(), InvoiceNumber = ripsFilter.InvoiceNumber?.Replace("\"", "").Trim(), FinalDate = item.DateVisit?.Replace("-", "/"), AuthorizationNumber = rip.AuthorizationNumber?.Replace("\"", "").Trim(), Cups = rip.Cups?.Replace("\"", "").Trim(), Rate = rip.Rate, Consultation = rip.Consultation, Cie10 = rip.Cie10?.Replace("\"", "").Trim(), DiagnosticType = "2", External = rip.External, CopaymentPerSession = rip.CoPaymentAmount, NetValuePerSession = rip.Rate - rip.CoPaymentAmount })); } var filePath = string.Format(@"{0}\AC{1}.txt", basePath, consecutive); using (var streamWriter = File.CreateText(filePath)) { var writer = new CsvWriter(streamWriter); writer.Configuration.HasHeaderRecord = false; writer.WriteRecords(acFiles); } return(acFiles.Count); }
public IEnumerable <Rips> GetServiceRips(RipsFilter ripsFilter) { var whereClause = new StringBuilder("WHERE ags.StateId = 2 "); if (ripsFilter.EntityId > 0) { whereClause.Append("AND ent.EntityId = @EntityId "); } if (ripsFilter.EntityPlanId > 0) { whereClause.Append("AND pe.PlanEntityId = @EntityPlanId "); } if (ripsFilter.ServiceTypeId > 0) { whereClause.Append("AND ser.ServiceTypeId = @ServiceTypeId "); } if (!string.IsNullOrEmpty(ripsFilter.InitialDateIni)) { whereClause.Append("AND CONVERT(DATETIME,ags.InitialDate) >= CONVERT(DATETIME,@InitialDateIni, 105) "); } if (!string.IsNullOrEmpty(ripsFilter.InitialDateEnd)) { whereClause.Append("AND CONVERT(DATETIME,ags.InitialDate) <= CONVERT(DATETIME,@InitialDateEnd, 105) "); } if (!string.IsNullOrEmpty(ripsFilter.FinalDateIni)) { whereClause.Append("AND CONVERT(DATETIME,ags.FinalDate) >= CONVERT(DATETIME,@FinalDateIni, 105) "); } if (!string.IsNullOrEmpty(ripsFilter.FinalDateEnd)) { whereClause.Append("AND CONVERT(DATETIME,ags.FinalDate) <= CONVERT(DATETIME,@FinalDateEnd, 105) "); } var finalQuery = string.Format("{0} {1}", RipsQuerys.GetServiceRips, whereClause); return(_dbConnection.Query <Rips>(finalQuery, ripsFilter)); }