private void BindFormView() { try { List <DC_BloodCountReports> _lstDC_BloodCountReports = new List <DC_BloodCountReports>(); DC_BloodCountReports _objvsr = new DC_BloodCountReports(); _lstDC_BloodCountReports.Add(_objvsr); frmvwAddUpdateBloodCount.DataSource = _lstDC_BloodCountReports; frmvwAddUpdateBloodCount.DataBind(); } catch (Exception) { throw; } }
public DC_Message AddUpdateBloodCountReports(DC_BloodCountReports _objSave) { DC_Message _msg = new DC_Message(); try { using (CLMS_DBEntities context = new CLMS_DBEntities()) { if (_objSave.BCR_TestReportID != null && _objSave.BCR_TestReportID != Guid.Empty) { var isDuplicate = (from x in context.tbl_BloodCountReports where x.BCR_TestReportID != _objSave.BCR_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_BloodCountReports.Find(_objSave.BCR_TestReportID); if (report != null) { report.TestDate = _objSave.TestDate; report.IsActive = _objSave.IsActive; report.EditedBy = _objSave.EditedBy; report.EditedDate = _objSave.EditedDate; report.CBC = _objSave.CBC; report.WBC = _objSave.WBC; report.PLATELET = _objSave.PLATELET; report.MCV = _objSave.MCV; report.Neutrophils = _objSave.Neutrophils; report.Lymphocytes = _objSave.Lymphocytes; report.Eosinophil = _objSave.Eosinophil; report.Monocytes = _objSave.Monocytes; report.Basophils = _objSave.Basophils; report.ESR = _objSave.ESR; if (context.SaveChanges() == 1) { _msg.StatusMessage = "Vital Sign has been" + ReadOnlyMessage.strUpdatedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = "Vital Sign has been" + ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } else { tbl_BloodCountReports _objnew = new tbl_BloodCountReports(); _objnew.BCR_TestReportID = Guid.NewGuid(); _objnew.PatientID = _objSave.PatientID; report.TestDate = _objSave.TestDate; report.IsActive = _objSave.IsActive; _objnew.CreatedBy = _objSave.CreatedBy; _objnew.CreatedDate = _objSave.CreatedDate; report.CBC = _objSave.CBC; report.WBC = _objSave.WBC; report.PLATELET = _objSave.PLATELET; report.MCV = _objSave.MCV; report.Neutrophils = _objSave.Neutrophils; report.Lymphocytes = _objSave.Lymphocytes; report.Eosinophil = _objSave.Eosinophil; report.Monocytes = _objSave.Monocytes; report.Basophils = _objSave.Basophils; report.ESR = _objSave.ESR; context.tbl_BloodCountReports.Add(_objnew); if (context.SaveChanges() == 1) { _msg.StatusMessage = "Vital Sign has been" + ReadOnlyMessage.strAddedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = "Vital Sign has been" + ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } } else { tbl_BloodCountReports _objnew = new tbl_BloodCountReports(); _objnew.BCR_TestReportID = Guid.NewGuid(); _objnew.PatientID = _objSave.PatientID; _objnew.TestDate = _objSave.TestDate; _objnew.IsActive = _objSave.IsActive; _objnew.CreatedBy = _objSave.CreatedBy; _objnew.CreatedDate = _objSave.CreatedDate; _objnew.CBC = _objSave.CBC; _objnew.WBC = _objSave.WBC; _objnew.PLATELET = _objSave.PLATELET; _objnew.MCV = _objSave.MCV; _objnew.Neutrophils = _objSave.Neutrophils; _objnew.Lymphocytes = _objSave.Lymphocytes; _objnew.Eosinophil = _objSave.Eosinophil; _objnew.Monocytes = _objSave.Monocytes; _objnew.Basophils = _objSave.Basophils; _objnew.ESR = _objSave.ESR; context.tbl_BloodCountReports.Add(_objnew); if (context.SaveChanges() == 1) { _msg.StatusMessage = "Vital Sign has been" + ReadOnlyMessage.strAddedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = "Vital Sign has been" + ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } } } catch (Exception ex) { } return(_msg); }
protected void frmvwAddUpdateBloodCount_ItemCommand(object sender, FormViewCommandEventArgs e) { TextBox txtTestDate = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtTestDate"); TextBox txtCBC = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtCBC"); TextBox txtWBC = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtWBC"); TextBox txtPLATELET = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtPLATELET"); TextBox txtMCV = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtMCV"); TextBox txtNeutrophils = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtNeutrophils"); TextBox txtLymphocytes = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtLymphocytes"); TextBox txtEosinophil = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtEosinophil"); TextBox txtMonocytes = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtMonocytes"); TextBox txtBasophils = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtBasophils"); TextBox txtESR = (TextBox)frmvwAddUpdateBloodCount.FindControl("txtESR"); if (e.CommandName == "AddBloodCount") { DC_Message _msg = new DC_Message(); DC_BloodCountReports _objAdd = new DC_BloodCountReports(); _objAdd.TestDate = Convert.ToDateTime(txtTestDate.Text); _objAdd.PatientID = GetPatientID(); _objAdd.CBC = txtCBC.Text; _objAdd.WBC = txtWBC.Text; _objAdd.PLATELET = txtPLATELET.Text; _objAdd.MCV = txtMCV.Text; _objAdd.Neutrophils = txtNeutrophils.Text; _objAdd.Lymphocytes = txtLymphocytes.Text; _objAdd.Eosinophil = txtEosinophil.Text; _objAdd.Monocytes = txtMonocytes.Text; _objAdd.Basophils = txtBasophils.Text; _objAdd.ESR = txtESR.Text; _objAdd.CreatedBy = "Ajay"; _objAdd.CreatedDate = DateTime.Today; _msg = _objDL.AddUpdateBloodCountReports(_objAdd); if (_msg.StatusCode == ReadOnlyMessage.StatusCode.Success) { BootstrapAlert.BootstrapAlertMessage(divmsg, _msg.StatusMessage, BootstrapAlertType.Success); frmvwAddUpdateBloodCount.ChangeMode(FormViewMode.Insert); BindGridDetails(); } } if (e.CommandName == "UpdateBloodCount") { DC_Message _msg = new DC_Message(); DC_BloodCountReports _objAdd = new DC_BloodCountReports(); _objAdd.BCR_TestReportID = Guid.Parse(Convert.ToString(frmvwAddUpdateBloodCount.DataKey.Value)); _objAdd.TestDate = Convert.ToDateTime(txtTestDate.Text); _objAdd.PatientID = GetPatientID(); _objAdd.CBC = txtCBC.Text; _objAdd.WBC = txtWBC.Text; _objAdd.PLATELET = txtPLATELET.Text; _objAdd.MCV = txtMCV.Text; _objAdd.Neutrophils = txtNeutrophils.Text; _objAdd.Lymphocytes = txtLymphocytes.Text; _objAdd.Eosinophil = txtEosinophil.Text; _objAdd.Monocytes = txtMonocytes.Text; _objAdd.Basophils = txtBasophils.Text; _objAdd.ESR = txtESR.Text; _objAdd.EditedBy = "Ajay"; _objAdd.EditedDate = DateTime.Today; _msg = _objDL.AddUpdateBloodCountReports(_objAdd); if (_msg.StatusCode == ReadOnlyMessage.StatusCode.Success) { BootstrapAlert.BootstrapAlertMessage(divmsg, _msg.StatusMessage, BootstrapAlertType.Success); frmvwAddUpdateBloodCount.ChangeMode(FormViewMode.Insert); BindGridDetails(); } } }