protected void BtnEdit_Click(object sender, EventArgs e) { try { EntityMakeDischarge entDischarge = new EntityMakeDischarge(); entDischarge.PatientId = Convert.ToInt32(Session["patientID"]); TimeSpan span = new TimeSpan(0, 0, 0); entDischarge.TypeOfDischarge = Convert.ToString(ddlDischargeType.SelectedItem.Text); entDischarge.Diagnosis = FirstCharToUpper(txtDiagnosis.Text); entDischarge.SurgeryId = Convert.ToInt32(ddlNameOfSurgery.SelectedValue); entDischarge.NameOfSurgery = Convert.ToString(ddlNameOfSurgery.SelectedItem.Text); entDischarge.OperationalProcedure = FirstCharToUpper(txtOperatonalProce.Text); entDischarge.HistoryClinical = FirstCharToUpper(txtHistory.Text); entDischarge.XRay = txtXRay.Text; entDischarge.ECG = txtECG.Text; entDischarge.Others = txtOthers.Text; entDischarge.TreatmentInHospitalisation = FirstCharToUpper(txtTreatmentHospital.Text); entDischarge.AdviceOnDischarge = FirstCharToUpper(txtAdviceDischarge.Text); entDischarge.FollowUp = txtFollowUp.Text; entDischarge.DischargeReceiptDate = Convert.ToDateTime(txtDischargeDate.Text).Add(span); entDischarge.Haemogram = txtHaemogram.Text; entDischarge.BUL = txtBUL.Text; entDischarge.SCreat = txtSCreat.Text; entDischarge.SElect = txtSElect.Text; entDischarge.BSL = txtBSL.Text; entDischarge.UrineR = txtUrineR.Text; entDischarge.Pulse = txtPulse.Text; entDischarge.Temp = txtTemp.Text; entDischarge.BP = txtBP.Text; entDischarge.RespRate = txtRespRate.Text; entDischarge.Pallor = txtPallor.Text; entDischarge.Oedema = txtOedema.Text; entDischarge.Cyanosis = txtCyanosis.Text; entDischarge.Clubbing = txtClubbing.Text; entDischarge.Icterus = txtIcterus.Text; entDischarge.Skin = txtSkin.Text; entDischarge.RespSystem = txtRespSystem.Text; entDischarge.CNS = txtCNS.Text; entDischarge.PerAbd = txtPerAbd.Text; entDischarge.CVS = txtCVS.Text; entDischarge.PreparedByName = Convert.ToString(Session["AdminName"]); int i = mobjDischarge.Update(entDischarge, Convert.ToInt32(Session["DischargeId"])); if (i > 0) { lblMsg.Text = "Record Updated Successfully"; } else { lblMsg.Text = "Record Not Updated"; } GetDischargeList(); } catch (Exception ex) { lblMessage.Text = ex.Message; } MultiView1.SetActiveView(View2); }
public EntityMakeDischarge GetDischargeDetails(int DischargeId) { EntityMakeDischarge entDis = new EntityMakeDischarge(); entDis = (from tbl in objData.tblDischarges where tbl.IsDelete == false && tbl.DichargeId == DischargeId select new EntityMakeDischarge { TypeOfDischarge = tbl.TypeOfDischarge, Diagnosis = tbl.Diagnosis, Surgery = tbl.NameOfSurgery, HistoryClinical = tbl.HistoryClinical, XRay = tbl.XRay, USG = tbl.USG, Others = tbl.Others, OperativeNotes = tbl.OperativeNotes, TreatmentInHospitalisation = tbl.TreatmentInHospitalisation, TreatmentOnDischarge = tbl.TreatmentOnDischarge, FollowUp = tbl.FollowUp, DischargeReceiptDate = tbl.DischargeReceiptDate, HB = tbl.HB, TLC = tbl.TLC, PLC = tbl.PLC, BUL = tbl.BUL, Creat = tbl.Creat, SE = tbl.SE, BSL = tbl.BSL, PP = tbl.PP, R = tbl.R, Urine = tbl.Urine, HIV = tbl.HIV, HBSAG = tbl.HBSAG, }).FirstOrDefault(); return(entDis); }
public int Save(EntityMakeDischarge entDischarge) { tblDischarge tbl = new tblDischarge() { PatientId = entDischarge.PatientId, TypeOfDischarge = entDischarge.TypeOfDischarge, Diagnosis = entDischarge.Diagnosis, NameOfSurgery = entDischarge.Surgery, HistoryClinical = entDischarge.HistoryClinical, XRay = entDischarge.XRay, USG = entDischarge.USG, Others = entDischarge.Others, OperativeNotes = entDischarge.OperativeNotes, TreatmentInHospitalisation = entDischarge.TreatmentInHospitalisation, TreatmentOnDischarge = entDischarge.TreatmentOnDischarge, FollowUp = entDischarge.FollowUp, DischargeReceiptDate = entDischarge.DischargeReceiptDate, HB = entDischarge.HB, TLC = entDischarge.TLC, PLC = entDischarge.PLC, BUL = entDischarge.BUL, Creat = entDischarge.Creat, SE = entDischarge.SE, BSL = entDischarge.BSL, PP = entDischarge.PP, R = entDischarge.R, Urine = entDischarge.Urine, HIV = entDischarge.HIV, HBSAG = entDischarge.HBSAG, IsDelete = false }; objData.tblDischarges.InsertOnSubmit(tbl); objData.SubmitChanges(); return(1); }
public int Update(EntityMakeDischarge entDischarge, int DischargeID) { tblDischarge obj = new tblDischarge(); obj = (from tbl in objData.tblDischarges where tbl.DichargeId.Equals(DischargeID) && tbl.IsDelete == false select tbl).FirstOrDefault(); obj.TypeOfDischarge = entDischarge.TypeOfDischarge; obj.Diagnosis = entDischarge.Diagnosis; obj.NameOfSurgery = entDischarge.Surgery; obj.HistoryClinical = entDischarge.HistoryClinical; obj.XRay = entDischarge.XRay; obj.USG = entDischarge.USG; obj.Others = entDischarge.Others; obj.OperativeNotes = entDischarge.OperativeNotes; obj.TreatmentInHospitalisation = entDischarge.TreatmentInHospitalisation; obj.TreatmentOnDischarge = entDischarge.TreatmentOnDischarge; obj.FollowUp = entDischarge.FollowUp; obj.DischargeReceiptDate = entDischarge.DischargeReceiptDate; obj.HB = entDischarge.HB; obj.TLC = entDischarge.TLC; obj.PLC = entDischarge.PLC; obj.BUL = entDischarge.BUL; obj.Creat = entDischarge.Creat; obj.SE = entDischarge.SE; obj.BSL = entDischarge.BSL; obj.PP = entDischarge.PP; obj.R = entDischarge.R; obj.Urine = entDischarge.Urine; obj.HIV = entDischarge.HIV; obj.HBSAG = entDischarge.HBSAG; objData.SubmitChanges(); return(1); }
protected void btnUpdate_Click(object sender, EventArgs e) { try { Session["Status"] = "Edit"; lblMessage.Text = string.Empty; ImageButton imgEdit = (ImageButton)sender; GridViewRow cnt = (GridViewRow)imgEdit.NamingContainer; Session["DischargeId"] = dgvTestInvoice.DataKeys[cnt.RowIndex].Value; EntityMakeDischarge lst = mobjDischarge.GetDischargeDetails(Convert.ToInt32(Session["DischargeId"])); if (lst != null) { ListItem item = ddlPatient.Items.FindByText(Convert.ToString(cnt.Cells[3].Text)); ddlPatient.SelectedValue = item.Value; ListItem itemSur = ddlNameOfSurgery.Items.FindByText(Convert.ToString(lst.NameOfSurgery)); ddlNameOfSurgery.SelectedValue = itemSur.Value; Session["patientID"] = ddlPatient.SelectedValue; Session["SurID"] = ddlNameOfSurgery.SelectedValue; ddlPatient.Enabled = false; ddlDischargeType.Text = lst.TypeOfDischarge; if (lst.TypeOfDischarge == "Routine") { lblFollowUp.Visible = true; txtFollowUp.Visible = true; } else { lblFollowUp.Visible = false; txtFollowUp.Visible = false; } txtDiagnosis.Text = lst.Diagnosis; txtDischargeDate.Text = Convert.ToDateTime(lst.DischargeReceiptDate).ToString("MM/dd/yyyy"); txtOperatonalProce.Text = lst.OperationalProcedure; txtHistory.Text = lst.HistoryClinical; txtXRay.Text = lst.XRay; txtHaemogram.Text = lst.Haemogram; txtOthers.Text = lst.Others; txtTreatmentHospital.Text = lst.TreatmentInHospitalisation; txtAdviceDischarge.Text = lst.AdviceOnDischarge; txtFollowUp.Text = lst.FollowUp; txtECG.Text = lst.ECG; txtBUL.Text = lst.BUL; txtSCreat.Text = lst.SCreat; txtSElect.Text = lst.SElect; txtBSL.Text = lst.BSL; txtUrineR.Text = lst.UrineR; txtTemp.Text = lst.Temp; txtPulse.Text = lst.Pulse; txtBP.Text = lst.BP; txtRespRate.Text = lst.RespRate; txtPallor.Text = lst.Pallor; txtOedema.Text = lst.Oedema; txtCyanosis.Text = lst.Cyanosis; txtClubbing.Text = lst.Clubbing; txtIcterus.Text = lst.Icterus; txtSkin.Text = lst.Skin; txtRespSystem.Text = lst.RespSystem; txtCNS.Text = lst.CNS; txtPerAbd.Text = lst.PerAbd; txtCVS.Text = lst.CVS; } } catch (Exception ex) { lblMessage.Text = ex.Message; } BtnUpdate.Visible = true; BtnSave.Visible = false; MultiView1.SetActiveView(View1); }