public DC_Message AddUpdateVitalSignDetails(DC_VitalSingsDetails _objSave)
{
DC_Message _msg = new DC_Message();
try
{
using (CLMS_DBEntities context = new CLMS_DBEntities())
{
if (_objSave.TestReportID != null && _objSave.TestReportID != Guid.Empty) //Edit
{
var isExist = (from p in context.tbl_VitalSingsDetails
where p.TestReportID != _objSave.TestReportID
select p).Count() == 0 ? false : true;
}
else //Add
{
tbl_VitalSingsDetails _objP = new tbl_VitalSingsDetails
{
TestReportID = Guid.NewGuid(),
PatientID = _objSave.PatientID,
BP = _objSave.BP,
Weight = Convert.ToDecimal(_objSave.Weight),
Temperature = Convert.ToDecimal(_objSave.Temperature),
Pluse = _objSave.Pluse,
CreatedBy = _objSave.CreatedBy,
CreatedDate = DateTime.Now,
IsActive = _objSave.IsActive,
};
context.tbl_VitalSingsDetails.Add(_objP);
if (context.SaveChanges() == 1)
{
_msg.StatusMessage = strClassFor + ReadOnlyMessage.strAddedSuccessfully;
_msg.StatusCode = ReadOnlyMessage.StatusCode.Success;
}
else
{
_msg.StatusMessage = strClassFor + ReadOnlyMessage.strFailed;
_msg.StatusCode = ReadOnlyMessage.StatusCode.Failed;
}
}
}
}
catch (Exception)
{
_msg.StatusMessage = ReadOnlyMessage.strFailed;
_msg.StatusCode = ReadOnlyMessage.StatusCode.Failed;
}
return(_msg);
}
public DC_Message AddUpdateVitalDetails(DC_VitalSingsDetails _objSave)
{
DC_Message _msg = new DC_Message();
try
{
using (CLMS_DBEntities context = new CLMS_DBEntities())
{
if ((_objSave.PatientID != null && _objSave.PatientID != Guid.Empty) && (_objSave.TestReportID != null && _objSave.TestReportID != Guid.Empty)) //Edit
{
//var isduplicate = (from p in context.tbl_VitalSingsDetails
// where p.PatientID != _objSave.PatientID && p.TestReportID ==
// select p).Count() == 0 ? false : true;
//if (isduplicate)
//{
// _msg.StatusMessage = strClassFor + ReadOnlyMessage.strAlreadyExist;
// _msg.StatusCode = ReadOnlyMessage.StatusCode.Duplicate;
// return _msg;
//}
var Vital = context.tbl_VitalSingsDetails.Where(p => p.PatientID == _objSave.PatientID && p.TestReportID == _objSave.TestReportID).FirstOrDefault();
if (Vital != null)
{
Vital.TestDate = _objSave.TestDate;
Vital.BP = _objSave.BP;
Vital.Pluse = _objSave.Pluse;
Vital.Weight = 232;
Vital.Temperature = Convert.ToDecimal(_objSave.Temperature);
Vital.EditedBy = _objSave.EditedBy;
Vital.EditedDate = DateTime.Now;
Vital.IsActive = _objSave.IsActive;
if (context.SaveChanges() == 1)
{
_msg.StatusMessage = strClassFor + ReadOnlyMessage.strUpdatedSuccessfully;
_msg.StatusCode = ReadOnlyMessage.StatusCode.Success;
}
else
{
_msg.StatusMessage = strClassFor + ReadOnlyMessage.strFailed;
_msg.StatusCode = ReadOnlyMessage.StatusCode.Failed;
}
}
else
{
}
}
else //Add
{
tbl_VitalSingsDetails _objnew = new tbl_VitalSingsDetails();
_objnew.TestReportID = Guid.NewGuid();
_objnew.TestDate = _objSave.TestDate;
_objnew.PatientID = _objSave.PatientID;
_objnew.BP = _objSave.BP;
_objnew.Pluse = _objSave.Pluse;
_objnew.Weight = 232;
_objnew.Temperature = Convert.ToDecimal(_objSave.Temperature);
_objnew.CreatedBy = _objSave.CreatedBy;
_objnew.CreatedDate = DateTime.Now;
_objnew.IsActive = _objSave.IsActive;
context.tbl_VitalSingsDetails.Add(_objnew);
if (context.SaveChanges() == 1)
{
_msg.StatusMessage = strClassFor + ReadOnlyMessage.strAddedSuccessfully;
_msg.StatusCode = ReadOnlyMessage.StatusCode.Success;
}
else
{
_msg.StatusMessage = strClassFor + ReadOnlyMessage.strFailed;
_msg.StatusCode = ReadOnlyMessage.StatusCode.Failed;
}
}
}
}
catch (Exception ex)
{
_msg.StatusMessage = ReadOnlyMessage.strFailed;
_msg.StatusCode = ReadOnlyMessage.StatusCode.Failed;
}
return(_msg);
}
