public static App_PatientLabs_Labs_Parms Mapper(this PatientLabs_Labs_Parms source)
{
return(new App_PatientLabs_Labs_Parms
{
Id = source.Id,
TestId = source.TestId,
ParmId = source.ParmId,
ParmValue = source.ParmValue,
PatientLabId = source.PatientLabId
});
}
public static AppLab_Parm_ForPatient Mapper_LabParmMapper_ForPatient(PatientLabs_Labs_Parms parm, long testId)
{
return(new AppLab_Parm_ForPatient
{
Id = parm.Id,
NormarVal = parm.Lab_Parms.NormarVal,
Name = parm.Lab_Parms.Name,
ActualVal = parm.ParmValue,
TestId = testId,
//Price = source.Price ?? 0,
ParmId = parm.ParmId
});
}
public static App_PatientLabs_Labs AddPatientLabs(List <AppLab_Parm_ForPatient> labs)
{
var lab = new PatientLabs_Labs
{
PatientLabId = labs.First().PatientLabId,
TestId = labs.First().TestId,
};
using (var dbContext = new HMSEntities())
{
try
{
dbContext.PatientLabs_Labs.Add(lab);
dbContext.SaveChanges();
var patientLabId = long.MaxValue;
foreach (var lo in labs)
{
var parm = new PatientLabs_Labs_Parms
{
Id = 0,
TestId = lo.TestId,
ParmId = lo.ParmId,
ParmValue = lo.ActualVal ?? "",
PatientLabId = lo.PatientLabId
};
patientLabId = lo.PatientLabId;
dbContext.PatientLabs_Labs_Parms.Add(parm);
}
var dbtest = dbContext.PatientLabs.FirstOrDefault(t => t.Id == patientLabId);
if (dbtest != null)
{
if (labs.Any(l => !string.IsNullOrEmpty(l.ActualVal)))
{
dbtest.Reported = DateTime.Now;
}
}
dbContext.SaveChanges();
}
catch (Exception dd)
{
}
var allTestDbs = dbContext.PatientLabs_Labs.Include("Lab_Tests").ToList();
var totalFeeTillNow = allTestDbs.Where(o => o.PatientLabId == lab.PatientLabId).ToList().Sum(o => o.Lab_Tests.Fee);
var thistest = allTestDbs.Where(o => o.PatientLabId == lab.PatientLabId && o.TestId == labs.First().TestId);
var final = thistest.FirstOrDefault().MapperHm();
final.TotalFee = totalFeeTillNow; // to show on the screen
var rec = dbContext.PatientLabs.FirstOrDefault(p => p.Id == lab.PatientLabId);
rec.Amount = totalFeeTillNow;
dbContext.SaveChanges();
return(final);
}
}
