public ClaimDetail(int iFileID, int iRecordSequence, string sVersion, ClaimLayoutType clt)
{
cltLayout = clt;
FileVersion = sVersion;
lsFields = new List <Field>();
var query = (from c in db.FileFieldValues
join f in db.Fields on c.FieldID equals f.FieldID
where c.FileID == iFileID &&
c.recordType == RecordType.ClaimDetail &&
c.recordSequence == iRecordSequence
select new
{
ClaimType = f.ClaimType,
Comments = f.Comments,
Description = f.Description,
DisplayName = f.DisplayName,
EndPOS = f.EndPOS,
FieldID = f.FieldID,
FileVersion = f.FileVersion,
Format = f.Format,
FormFieldName = f.FormFieldName,
FormFieldPosition = f.FormFieldPosition,
FormGroup = f.FormGroup,
IsDisplayed = f.IsDisplayed,
Name = f.Name,
PseudoCode = f.PseudoCode,
RecordType = f.RecordType,
StartPOS = f.StartPOS,
ts = c.ts,
Value = c.value,
WebDEFieldName = f.WebDEFieldName
});
var vfields = query.ToList().Select(r => new Field
{
ClaimType = r.ClaimType,
Comments = r.Comments,
Description = r.Description,
DisplayName = r.DisplayName,
EndPOS = r.EndPOS,
FieldID = r.FieldID,
FileVersion = r.FileVersion,
Format = r.Format,
FormFieldName = r.FormFieldName,
FormFieldPosition = r.FormFieldPosition,
FormGroup = r.FormGroup,
IsDisplayed = r.IsDisplayed,
Name = r.Name,
PseudoCode = r.PseudoCode,
RecordType = r.RecordType,
StartPOS = r.StartPOS,
ts = r.ts,
Value = r.Value,
WebDEFieldName = r.WebDEFieldName
}).ToList();
lsFields.AddRange(vfields);
}
public ClaimDetail(string sSource, string sVersion, ClaimLayoutType clt)
{
Source = sSource;
cltLayout = clt;
FileVersion = sVersion;
if (!db.Fields.Where(x => x.FileVersion == FileVersion && x.RecordType == RecordType.ClaimDetail && x.ClaimType == cltLayout).Any())
{
throw new Exception("File Version is " + FileVersion + ". There are no Claim Detail Fields setup for this version.");
}
lsFields = db.Fields.Where(x => x.FileVersion == FileVersion && x.RecordType == RecordType.ClaimDetail && x.ClaimType == cltLayout).ToList();
}
// Details: ClaimFiles/Details/5
public ActionResult Details(int?id)
{
try
{
ParsedViewModel pvm = new ParsedViewModel();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClaimFile claimFile = db.ClaimFiles.Find(id);
if (claimFile == null)
{
return(HttpNotFound());
}
int iFileID = (int)id;
pvm.cf = claimFile;
pvm.cf.fh = new FileHeader(iFileID);
pvm.cf.fh.lsdch = new List <ClaimHeader>();
pvm.lsCHTVM = new List <ClaimHeaderTableViewModel>();
List <FileFieldValue> lsClaims = db.FileFieldValues.Where(x => x.FileID == id && x.recordType == RecordType.ClaimHeader).ToList();
for (int i = 0; i < pvm.cf.fh.NumberofClaims; i++)
{
int iMinRecordSequence = lsClaims.Min(x => x.recordSequence);
List <FileFieldValue> lsClaim = lsClaims.Where(x => x.recordSequence == iMinRecordSequence).ToList();
var ffvct = (from c in db.FileFieldValues
join f in db.Fields on c.FieldID equals f.FieldID
where f.Name == "STD_BATCH_TYPE_CODE" &&
c.FileID == iFileID &&
c.recordType == RecordType.ClaimHeader &&
c.recordSequence == iMinRecordSequence
select new { value = c.value });
string sClaimTypeCode = ffvct.First().value;
ClaimLayoutType clt = Utility.GetCLT(sClaimTypeCode);
Field fDCN = db.Fields.Where(x => x.RecordType == RecordType.PaperHeader && x.ClaimType == clt && x.FileVersion == pvm.cf.fh.FileVersion && x.Name.Trim().ToUpper() == "ENDORSEMENT NUMBER").Single();
FileFieldValue ffvDCN = db.FileFieldValues.Where(x => x.FieldID == fDCN.FieldID && x.FileID == id && x.recordSequence == iMinRecordSequence + 1).Single();
ClaimHeaderTableViewModel chtvm = new ClaimHeaderTableViewModel(iFileID, pvm.cf.fh.FileVersion, ffvDCN.value, sClaimTypeCode, iMinRecordSequence);
pvm.lsCHTVM.Add(chtvm);
foreach (FileFieldValue ffv in lsClaim)
{
lsClaims.Remove(ffv);
}
}
return(View(pvm));
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "ClaimFiles", "Index")));
}
}
public ClaimHeader(string sSource, string sVersion)
{
Source = sSource;
string sClaimTypeCode = (Source.Substring(2, 3));
ClaimLayoutType ct = Utility.GetCLT(sClaimTypeCode);
FileVersion = sVersion;
if (!db.Fields.Where(x => x.FileVersion == FileVersion && x.RecordType == RecordType.ClaimHeader && x.ClaimType == ct).Any())
{
throw new Exception("File Version is " + FileVersion + ". There are no Claim Header Fields setup for this version.");
}
lsFields = db.Fields.Where(x => x.FileVersion == FileVersion && x.RecordType == RecordType.ClaimHeader && x.ClaimType == ct).ToList();
string s = ClaimType;
}
// ClaimInfo: ClaimFiles/ClaimInfo
public ActionResult ClaimInfo(int FileID, int recordsequence, string FileVersion, ClaimLayoutType ClaimLayout, string DCN)
{
try
{
ParsedViewModel pvm = new ParsedViewModel();
ClaimFile claimFile = db.ClaimFiles.Find(FileID);
if (claimFile == null)
{
return(HttpNotFound());
}
int iFileID = FileID;
pvm.cf = claimFile;
pvm.cf.fh = new FileHeader(iFileID);
pvm.cf.fh.lsdch = new List <ClaimHeader>();
pvm.lsCHTVM = new List <ClaimHeaderTableViewModel>();
ClaimHeader ch = new ClaimHeader(FileID, recordsequence, FileVersion, DCN);
PaperHeader ph = new PaperHeader(FileID, recordsequence + 1, FileVersion, ClaimLayout);
ch.ph = ph;
ch.lscd = new List <ClaimDetail>();
for (int x = 0; x < ch.NumberofDetails; x++)
{
int iCDRecordSeq = recordsequence + 2 + (x * 2);
ClaimDetail cd = new ClaimDetail(FileID, iCDRecordSeq, FileVersion, ClaimLayout);
ch.lscd.Add(cd);
}
pvm.cf.fh.lsdch.Add(ch);
return(View(pvm));
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "ClaimFiles", "Index")));
}
}
