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