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); }