private void BindFormView() { try { List <DC_LiverFunctionReports> _lstDC_VitalSignsReports = new List <DC_LiverFunctionReports>(); DC_LiverFunctionReports _objvsr = new DC_LiverFunctionReports(); _lstDC_VitalSignsReports.Add(_objvsr); grdvwLiverFunctionDetails.DataSource = _lstDC_VitalSignsReports; grdvwLiverFunctionDetails.DataBind(); } catch (Exception) { throw; } }
public DC_Message AddUpdateLiverFunReports(DC_LiverFunctionReports _objSave) { DC_Message _msg = new DC_Message(); try { using (CLMS_DBEntities context = new CLMS_DBEntities()) { if (_objSave.LFR_TestReportID != null && _objSave.LFR_TestReportID != Guid.Empty) { var isDuplicate = (from x in context.tbl_LiverFunctionReports where x.LFR_TestReportID != _objSave.LFR_TestReportID && x.PatientID == x.PatientID && x.TestDate == _objSave.TestDate select x).Count() == 0 ? false : true; if (isDuplicate) { _msg.StatusMessage = "Report " + ReadOnlyMessage.strAlreadyExist; _msg.StatusCode = ReadOnlyMessage.StatusCode.Duplicate; return(_msg); } var report = context.tbl_LiverFunctionReports.Find(_objSave.LFR_TestReportID); if (report != null) { report.TestDate = _objSave.TestDate; report.IsActive = _objSave.IsActive; report.EditedBy = _objSave.EditedBy; report.EditedDate = _objSave.EditedDate; report.SBilirubin = _objSave.SBilirubin; report.SGOT = _objSave.SGOT; report.SGPT = _objSave.SGPT; report.GGT = _objSave.GGT; report.SAlkPhosphate = _objSave.SAlkPhosphate; report.SProtein = _objSave.SProtein; report.Albumin = _objSave.Albumin; report.Globulin = _objSave.Globulin; report.AGRatio = _objSave.AGRatio; if (context.SaveChanges() == 1) { _msg.StatusMessage = "Liver Function has been" + ReadOnlyMessage.strUpdatedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = "Liver Function has been" + ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } else { tbl_LiverFunctionReports _objnew = new tbl_LiverFunctionReports(); _objnew.LFR_TestReportID = Guid.NewGuid(); _objnew.PatientID = _objSave.PatientID; _objnew.CreatedBy = _objSave.CreatedBy; _objnew.CreatedDate = _objSave.CreatedDate; _objnew.IsActive = _objSave.IsActive; _objnew.TestDate = _objSave.TestDate; _objnew.SBilirubin = _objSave.SBilirubin; _objnew.SGOT = _objSave.SGOT; _objnew.SGPT = _objSave.SGPT; _objnew.GGT = _objSave.GGT; _objnew.SAlkPhosphate = _objSave.SAlkPhosphate; _objnew.SProtein = _objSave.SProtein; _objnew.Albumin = _objSave.Albumin; _objnew.Globulin = _objSave.Globulin; _objnew.AGRatio = _objSave.AGRatio; context.tbl_LiverFunctionReports.Add(_objnew); if (context.SaveChanges() == 1) { _msg.StatusMessage = "Liver Function has been" + ReadOnlyMessage.strAddedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = "Liver Function has been" + ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } } else { tbl_LiverFunctionReports _objnew = new tbl_LiverFunctionReports(); _objnew.LFR_TestReportID = Guid.NewGuid(); _objnew.PatientID = _objSave.PatientID; _objnew.CreatedBy = _objSave.CreatedBy; _objnew.CreatedDate = _objSave.CreatedDate; _objnew.IsActive = _objSave.IsActive; _objnew.TestDate = _objSave.TestDate; _objnew.SBilirubin = _objSave.SBilirubin; _objnew.SGOT = _objSave.SGOT; _objnew.SGPT = _objSave.SGPT; _objnew.GGT = _objSave.GGT; _objnew.SAlkPhosphate = _objSave.SAlkPhosphate; _objnew.SProtein = _objSave.SProtein; _objnew.Albumin = _objSave.Albumin; _objnew.Globulin = _objSave.Globulin; _objnew.AGRatio = _objSave.AGRatio; context.tbl_LiverFunctionReports.Add(_objnew); if (context.SaveChanges() == 1) { _msg.StatusMessage = "Liver Function has been" + ReadOnlyMessage.strAddedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = "Liver Function has been" + ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } } } catch (Exception ex) { } return(_msg); }
protected void frmvwAddUpdateLiverFunction_ItemCommand(object sender, FormViewCommandEventArgs e) { #region Controls TextBox txtTestDate = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtTestDate"); TextBox txtSBilirubin = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtSBilirubin"); TextBox txtSGOT = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtSGOT"); TextBox txtSGPT = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtSGPT"); TextBox txtGGT = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtGGT"); TextBox txtSAlkPhosphate = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtSAlkPhosphate"); TextBox txtSProtein = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtSProtein"); TextBox txtAlbumin = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtAlbumin"); TextBox txtGlobulin = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtGlobulin"); TextBox txtAGRatio = (TextBox)frmvwAddUpdateLiverFunction.FindControl("txtAGRatio"); #endregion if (e.CommandName == "AddLiverFunction") { DC_Message _msg = new DC_Message(); DC_LiverFunctionReports _objAdd = new DC_LiverFunctionReports(); _objAdd.TestDate = Convert.ToDateTime(txtTestDate.Text); _objAdd.PatientID = GetPatientID(); _objAdd.SBilirubin = txtSBilirubin.Text; _objAdd.SGOT = txtSGOT.Text; _objAdd.SGPT = txtSGPT.Text; _objAdd.GGT = txtGGT.Text; _objAdd.SAlkPhosphate = txtSAlkPhosphate.Text; _objAdd.SProtein = txtSProtein.Text; _objAdd.Albumin = txtAlbumin.Text; _objAdd.Globulin = txtGlobulin.Text; _objAdd.AGRatio = txtAGRatio.Text; _objAdd.CreatedBy = "Ajay"; _objAdd.CreatedDate = DateTime.Today; _msg = _objDL.AddUpdateLiverFunReports(_objAdd); if (_msg.StatusCode == ReadOnlyMessage.StatusCode.Success) { BootstrapAlert.BootstrapAlertMessage(divmsg, _msg.StatusMessage, BootstrapAlertType.Success); frmvwAddUpdateLiverFunction.ChangeMode(FormViewMode.Insert); BindGridDetails(); } } if (e.CommandName == "UpdateLiverFunction") { DC_Message _msg = new DC_Message(); DC_LiverFunctionReports _objAdd = new DC_LiverFunctionReports(); _objAdd.LFR_TestReportID = Guid.Parse(Convert.ToString(frmvwAddUpdateLiverFunction.DataKey.Value)); _objAdd.TestDate = Convert.ToDateTime(txtTestDate.Text); _objAdd.SBilirubin = txtSBilirubin.Text; _objAdd.SGOT = txtSGOT.Text; _objAdd.SGPT = txtSGPT.Text; _objAdd.GGT = txtGGT.Text; _objAdd.SAlkPhosphate = txtSAlkPhosphate.Text; _objAdd.SProtein = txtSProtein.Text; _objAdd.Albumin = txtAlbumin.Text; _objAdd.Globulin = txtGlobulin.Text; _objAdd.AGRatio = txtAGRatio.Text; _objAdd.EditedBy = "Ajay"; _objAdd.EditedDate = DateTime.Today; _msg = _objDL.AddUpdateLiverFunReports(_objAdd); if (_msg.StatusCode == ReadOnlyMessage.StatusCode.Success) { BootstrapAlert.BootstrapAlertMessage(divmsg, _msg.StatusMessage, BootstrapAlertType.Success); frmvwAddUpdateLiverFunction.ChangeMode(FormViewMode.Insert); BindGridDetails(); } } }