public void Update(List <tblPathologyDetail> lst, tblPathology tblpath)
{
try
{
tblPathology path = (from tbl in objData.tblPathologies
where tbl.PatientId == tblpath.PatientId
select tbl).FirstOrDefault();
if (path != null)
{
path.FinalComment = tblpath.FinalComment;
}
foreach (tblPathologyDetail item in lst)
{
tblPathologyDetail tblpat = (from tbl in objData.tblPathologyDetails
where tbl.LabId == item.LabId &&
tbl.TestParaId == item.TestParaId &&
tbl.Isdelete == false
select tbl).FirstOrDefault();
if (tblpat != null)
{
tblpat.Result = item.Result;
tblpat.UnitId = item.UnitId;
tblpat.TestMethodId = item.TestMethodId;
tblpat.Comment = item.Comment;
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public int Save(tblPathology pathology, List <tblPathologyDetail> lst)
{
int?Id = 0;
objData.STP_Insert_tblPathology(Convert.ToInt32(pathology.PatientId), Convert.ToInt32(pathology.TestId), Convert.ToDateTime(DateTime.Now.Date), pathology.FinalComment, pathology.TestDoneById, ref Id);
foreach (tblPathologyDetail item in lst)
{
tblPathologyDetail objtestDetails = new tblPathologyDetail()
{
LabId = Convert.ToInt32(Id),
TestParaId = item.TestParaId,
UnitId = item.UnitId,
TestMethodId = item.TestMethodId,
Result = item.Result,
Comment = item.Comment,
Isdelete = false,
};
objData.tblPathologyDetails.InsertOnSubmit(objtestDetails);
}
objData.SubmitChanges();
return(1);
}
