private void contextMenuStrip1_Click(object sender, EventArgs e) { string getBill = gridView2.GetFocusedRowCellValue("OPID").ToString(); lblPatientID.Text = getBill; DAL.Model.DischargeBill patientBill = new DAL.Model.DischargeBill(); patientBill.OPID = getBill; patientBill = new MedicalManager().GetDischargeBill_Update(patientBill); txtdoctorcharge.Text = patientBill.TConsultBill; txtservicecharge.Text = patientBill.ServiceCharge.ToString("f"); lblReg.Text = patientBill.RegNo; txtpathology.Text = patientBill.PBill.ToString("f"); txtdischargeTime.Text = patientBill.DiscTime; txtdischargedate.Text = Convert.ToDateTime(patientBill.DeisDate).ToString("d"); lblPatientName.Text = patientBill.PatientName; txtBedCharge.Text = patientBill.TotalBedCharge; txtmedicaineCharge.Text = patientBill.PharmacyBill.ToString("f"); txtOTSerivce.Text = patientBill.OTservice.ToString("f"); txtOTMedicine.Text = patientBill.OTMedicine.ToString("f"); txthospitalcharge.Text = patientBill.HospitalCharge.ToString("f"); txtnoofdays.Text = patientBill.NoOfDay; txttotalBill.Text = patientBill.TotalBill.ToString("f"); txtadvancePaid.Text = patientBill.AdvancedPayble.ToString("f"); txtremarks.Text = patientBill.Remarks; txtbill.Text = patientBill.BillNo; xtraTabPage1.Show(); specialButton1.Text = "Update"; }
private void CosulultDoctor() { DataTable AllDoctor = new MedicalManager().GetAllCosultDoctor(null); repositoryItemLookUpEdit1.DataSource = AllDoctor; repositoryItemLookUpEdit1.DisplayMember = "DoctorID"; repositoryItemLookUpEdit1.ValueMember = "DoctorID"; }
private void GetIpdAllDoctor() { DataTable AllDoctor = new MedicalManager().GetAllCosultDoctor(null); searchLookUpEditConsultant.Properties.DataSource = AllDoctor; searchLookUpEditConsultant.Properties.DisplayMember = "DoctorName"; searchLookUpEditConsultant.Properties.ValueMember = "DoctorID"; }
public void GetDischargeInfo() { aMedicalManager = new MedicalManager(); DataTable data = new DataTable(); data = aMedicalManager.GetDischargeInfoMaster(); gridControlDischarge.DataSource = data; }
public MedicalTreatment() { InitializeComponent(); aMedicalManager = new MedicalManager(); Control buttonControl = new ButtonPermissionAccess().UserButton(this.panel5, this.Name); btnUpdate.Enabled = false; btnDelete.Enabled = false; }
public void GetDischargeInfoMaster() { string FromDate = Convert.ToString(dataFromDate.Value); string ToDate = Convert.ToString(DateToDate.Value); DataTable data = new DataTable(); data = new MedicalManager().GetDischargeInfoMaster(FromDate, ToDate); gridControlDischarge.DataSource = data; }
private void GetFollowCount() { DataTable dt = new MedicalManager().GetFollowUpCount(cmbPid.Text, FolluwUpDate.Value); LblCountDaily.Text = dt.Rows[0][0].ToString(); DataTable dt1 = new MedicalManager().GetTotalFollowUpCount(cmbPid.Text); TotalFollowup.Text = dt1.Rows[0][0].ToString(); }
public void GetIPGidchargeBillNo() { DataTable dt = new MedicalManager().getIPGischargeBillID(); if (dt != null && dt.Rows.Count > 0) { txtbill.Text = dt.Rows[0][0].ToString(); } }
private void gridViewFollowUp_DoubleClick(object sender, EventArgs e) { xtraTabPage1.Show(); Followup followup = new Followup(); string Department = gridViewFollowUp.GetFocusedRowCellValue("Deparment").ToString(); followup.OPID = gridViewFollowUp.GetFocusedRowCellValue("OPID").ToString(); cmbPid.Text = gridViewFollowUp.GetFocusedRowCellValue("OPID").ToString(); txtFollowupSlNo.Text = gridViewFollowUp.GetFocusedRowCellValue("SerialFollowUp").ToString(); followup.SerialId = txtFollowupSlNo.Text; txtShift.Text = gridViewFollowUp.GetFocusedRowCellValue("Shift").ToString(); txtName.Text = gridViewFollowUp.GetFocusedRowCellValue("PatientName").ToString(); //txtSuggetion.Text = gridViewFollowUp.GetFocusedRowCellValue("ExtraNoteSpecial").ToString(); //txtExtraNotes.Text = gridViewFollowUp.GetFocusedRowCellValue("ExtraNote").ToString(); cmbDoctor.Text = gridViewFollowUp.GetFocusedRowCellValue("DoctorName").ToString(); FolluwUpDate.Text = gridViewFollowUp.GetFocusedRowCellValue("Date").ToString(); cmbDept.Text = Department; aMedicalManager = new MedicalManager(); DataTable dt = aMedicalManager.UpdateFollowUpSheet(followup.OPID, txtFollowupSlNo.Text); //gridControl1.DataSource = dt; for (int i = 0; i < gridView1.RowCount; i++) { //string ItemID =gridView1.GetRowCellValue(i, "MasterId").ToString() ; foreach (DataRow row in dt.Rows) { if (row["FollowUpItemID"].ToString() == gridView1.GetRowCellValue(i, "MasterId").ToString()) { string values = row["Particulars"].ToString(); gridView1.SetRowCellValue(i, "Value", values); } } } //dgvServices.DataSource = null; //drugTable.Rows.Clear(); DataTable dataTable = new DataTable(); dataTable = new MedicalManager().GetPatientFollowupByOpid(followup); drugTable.Rows.Clear(); for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow rows1 = drugTable.NewRow(); rows1["DrugId"] = dataTable.Rows[i]["Drug"]; rows1["Drug"] = dataTable.Rows[i]["ProductName"]; rows1["Dous"] = dataTable.Rows[i]["Dous"]; rows1["ExtraNote"] = dataTable.Rows[i]["ExtraNote"]; rows1["ExtraNoteSpecial"] = dataTable.Rows[i]["ExtraNoteSpecial"]; drugTable.Rows.Add(rows1); } dgvServices.DataSource = drugTable; btnSave.Enabled = false; btnUpdate.Enabled = true; btnDelete.Enabled = true; }
private void CosulultDoctor() { DataTable AllDoctor = new MedicalManager().GetAllCosultDoctor(null); searchLookSurgeonName.Properties.DataSource = AllDoctor; searchLookSurgeonName.Properties.DisplayMember = "DoctorName"; searchLookSurgeonName.Properties.ValueMember = "DoctorID"; txtAnastheisLogist.Properties.DataSource = AllDoctor; txtAnastheisLogist.Properties.DisplayMember = "DoctorName"; txtAnastheisLogist.Properties.ValueMember = "DoctorID"; }
public void SaveAndUpdateDischargePatient() { // DischargePatient _dischargePatients = new DischargePatient(); try { _dischargePatient.FatherHusbandName = txtFahterHusbandName.Text; _dischargePatient.Gender = txtGender.Text; _dischargePatient.Age = txtAge.Text; _dischargePatient.BloodGroup = txtBebyGender.Text; _dischargePatient.Consult = txtConsult.SelectedValue.ToString(); _dischargePatient.Cabin_BedNo = txtCabinBedNo.Text; _dischargePatient.ContactNo = txtContactNo.Text; _dischargePatient.AddmissionOn = Convert.ToDateTime(txtAdmissionOnDate.Text); _dischargePatient.DiagOnAdmission = txtDiagonsisAdmisson.Text; _dischargePatient.OPID = cmbPatient.Properties.View.GetFocusedRowCellValue("OPID").ToString(); _dischargePatient.DischargeOn = Convert.ToDateTime(txtDischargeOnDate.Text); DateTime dt = txtDischareTime.Value; TimeSpan st = new TimeSpan(dt.Hour, dt.Minute, dt.Second); _dischargePatient.DischargeTime = st; _dischargePatient.RegNo = txtRegNo.Text; _dischargePatient.StatusOnDischarge = txtBreafHistory.Text; _dischargePatient.weight = txtWeight.Text; _dischargePatient.DiagOnDischarge = txtDiagOnDischarge.Text; _dischargePatient.BreffHistory = txtBreafHistory.Text; _dischargePatient.Tempdatatable = tempDrug; if (btnSave.Enabled) { MessageModel messageModel = new MedicalManager().SaveDischargePatient(_dischargePatient); MessageBox.Show(messageModel.MessageBody, messageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); reset(); } else if (btnEdit.Enabled) { MessageModel messageModel = new MedicalManager().UpdateDischargePatient(_dischargePatient); MessageBox.Show(messageModel.MessageBody, messageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); reset(); } } catch (Exception ex) { //throw; } }
public void SaveItemValue() { Followup followup = new Followup(); followup.OPID = cmbPid.Text; followup.SerialId = txtFollowupSlNo.Text; followup.Bp = txtBP.Text; followup.DocId = cmbDoctor.SelectedValue.ToString(); followup.Shift = txtShift.Text; followup.Date = FolluwUpDate.Value; followup.Date = FolluwUpDate.Value; followup.AFollowupList = GetFollowUP(); MessageModel message = new MedicalManager().SaveRegularFollowUp(followup); MessageBox.Show(message.MessageBody, message.MessageTitle); }
private void searchLookUpGetDischargeInfo_EditValueChanged(object sender, EventArgs e) { //PatientByOPID(cmbPatient.Properties.View.GetFocusedRowCellValue("OPID").ToString()); //txtDiagonsisAdmisson.Focus(); DischargePatient _dischargePatient = new DischargePatient(); _dischargePatient.OPID = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("OPID").ToString(); txtFahterHusbandName.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("FatherHusbandName").ToString(); txtRegNo.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("RegNo").ToString(); txtFahterHusbandName.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("FatherHusbandName").ToString(); txtGender.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("Gender").ToString(); txtAge.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("Age").ToString(); txtBloodGroup.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("BloodGroup").ToString(); txtConsult.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("Consult").ToString(); txtWeight.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("weight").ToString(); txtCabinBedNo.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("Cabin_BedNo").ToString(); txtContactNo.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("ContactNo").ToString(); txtDiagonsisAdmisson.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("DiagOnAdmission").ToString(); txtDiagOnDischarge.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("DiagOnDischarge").ToString(); txtAdmissionOnDate.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("AddmissionOn").ToString(); txtDischargeOnDate.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("DischargeOn").ToString(); aMedicalManager = new MedicalManager(); DataTable dataTable = new DataTable(); gridControl1.DataSource = null; dataTable = aMedicalManager.GetDischargeDetails(_dischargePatient); for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow rows = tempDrug.NewRow(); tempDrug.Rows.Add(rows); rows["DrugId"] = dataTable.Rows[i]["DrugId"]; rows["DrugName"] = dataTable.Rows[i]["DrugName"]; rows["Doose"] = dataTable.Rows[i]["Doose"]; rows["Description"] = dataTable.Rows[i]["Description"]; rows["Id"] = dataTable.Rows[i]["Id"]; } gridControl1.DataSource = tempDrug; btnSave.Enabled = false; btnEdit.Enabled = true; }
public void Cellvaluechnaged(string value) { try { var docId = new MedicalManager().GetAllCosultDoctor(value.ToString()); string doc = docId.Rows[0]["DoctorID"].ToString(); var Degree = docId.Rows[0]["AcademicDegree"].ToString(); // var Total = docId.Rows[0]["TotalConsFee"]; gridView.SetFocusedRowCellValue("ConsultId", doc); gridView.SetFocusedRowCellValue("DoctorName", docId.Rows[0]["DoctorName"].ToString()); gridView.SetFocusedRowCellValue("Degree", Degree.ToString()); gridView.SetFocusedRowCellValue("Specialization", docId.Rows[0]["Specialization"].ToString()); gridView.SetFocusedRowCellValue("ConsultBillDate", dtpConsultBill.Value); gridView.SetFocusedRowCellValue("ConFee", Convert.ToDouble("0.00")); gridView.SetFocusedRowCellValue("ConQty", "1"); gridView.SetFocusedRowCellValue("TotalConsFee", Convert.ToDouble("0.00")); } catch (Exception) { // throw; } }
public void LoadAllData() { DataTable GetAllPaitentId = new IpdManager().GetAllIpdPatientSl(); cmbPid.DataSource = GetAllPaitentId; cmbPid.DisplayMember = "OPID"; cmbPid.ValueMember = "OPID"; //.............................................. DataTable GetAllDoctor = new MedicalManager().GetAllDoctor(); cmbDoctor.DataSource = GetAllDoctor; cmbDoctor.DisplayMember = "DoctorName"; cmbDoctor.ValueMember = "DoctorID"; DataTable GetAllDrug = new MedicalManager().GetAllDrug(); cmbDrug.DataSource = GetAllDrug; cmbDrug.ValueMember = "ProductCode"; cmbDrug.DisplayMember = "ProductName"; //**************************************GetAllPatientFollowup }
private void searchLookTreatmentInfo_EditValueChanged(object sender, EventArgs e) { Followup followup = new Followup(); followup.OPID = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("OPID").ToString(); //txtName.Text = pidSearchLookUpEdit.Properties.View.GetFocusedRowCellValue("PatientName").ToString(); cmbPid.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("OPID").ToString(); txtFollowupSlNo.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("SerialFollowUp").ToString(); //txtFollowupSlNo.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("Drug").ToString(); txtFollowupSlNo.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("DoctorID").ToString(); txtName.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("PatientName").ToString(); txtGender.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("Gender").ToString(); //txtFollowupSlNo.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("Dous").ToString(); txtFollowupSlNo.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("FollowupId").ToString(); txtFollowupSlNo.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("BP").ToString(); txtExtraNotes.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("ExtraNote").ToString(); txtSuggetion.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("ExtraNoteSpecial").ToString(); FolluwUpDate.Text = searchLookTreatmentInfo.Properties.View.GetFocusedRowCellValue("Date").ToString(); aMedicalManager = new MedicalManager(); //dgvServices.DataSource = null; //drugTable.Rows.Clear(); DataTable dataTable = new DataTable(); dataTable = new MedicalManager().GetPatientFollowupByOpid(followup); for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow rows = drugTable.NewRow(); rows["DrugId"] = dataTable.Rows[i]["DrugId"]; rows["Drug"] = dataTable.Rows[i]["Drug"]; rows["Dous"] = dataTable.Rows[i]["Dous"]; rows["ExtraNote"] = dataTable.Rows[i]["ExtraNote"]; rows["ExtraNoteSpecial"] = dataTable.Rows[i]["ExtraNoteSpecial"]; } dgvServices.DataSource = drugTable; }
public MedicalController(MedicalManager medicalManager) { this._medicalManager = medicalManager; }
public void GetPatient(string pid) { DataTable patienTable = new MedicalManager().DischargeRequestPatient(); gridControl1.DataSource = patienTable; }
private void DrugListLoad() { var AllDrug = new MedicalManager().GetAllDrug(); cmbDrug.Properties.DataSource = AllDrug; }
private void getFollowUpView() { DataTable dt = new MedicalManager().GetFollowupView(cmbDept.Text); gridControl1.DataSource = dt; }
private void gridViewDischarge_DoubleClick(object sender, EventArgs e) { flag = true; xtraTabPage1.Show(); _dischargePatient.OPID = gridViewDischarge.GetFocusedRowCellValue("OPID").ToString(); cmbPatient.Properties.NullValuePrompt = gridViewDischarge.GetFocusedRowCellValue("PatientName").ToString(); DataTable data = new DataTable(); data = new MedicalManager().GetDischargeInfo(_dischargePatient); //data = aMedicalManager.GetDischargeInfoMaster(); //gridControlDischarge.DataSource = data; if (data.Rows.Count > 0) { txtFahterHusbandName.Text = data.Rows[0]["FatherName"].ToString(); txtRegNo.Text = data.Rows[0]["RegNo"].ToString(); txtGender.Text = data.Rows[0]["Gender"].ToString(); txtGender.Text = data.Rows[0]["Gender"].ToString(); txtAge.Text = data.Rows[0]["Age"].ToString(); txtBloodGroup.Text = data.Rows[0]["BloodGroup"].ToString(); //txtConsult.Text = data.Rows[0]["Consult"].ToString(); txtWeight.Text = data.Rows[0]["weight"].ToString(); txtContactNo.Text = data.Rows[0]["Phone"].ToString(); txtDiagonsisAdmisson.Text = data.Rows[0]["DiagOnAdmission"].ToString(); txtDiagOnDischarge.Text = data.Rows[0]["DiagOnDischarge"].ToString(); txtAdmissionOnDate.Text = data.Rows[0]["InputDate"].ToString(); txtDischargeOnDate.Text = data.Rows[0]["DischargeOn"].ToString(); txtAddress.Text = data.Rows[0]["Address"].ToString(); txtCabinBedNo.Text = data.Rows[0]["BedName"].ToString(); bool Crued = Convert.ToBoolean(data.Rows[0]["Cured"]); if (Crued) { cured.Checked = true; } else { cured.Checked = false; } bool dor = Convert.ToBoolean(data.Rows[0]["Dor"]); if (dor) { Dor.Checked = true; } else { Dor.Checked = false; } bool Improved = Convert.ToBoolean(data.Rows[0]["Improved"]); if (Improved) { improved.Checked = true; } else { improved.Checked = false; } bool dorb = Convert.ToBoolean(data.Rows[0]["Dorb"]); if (dorb) { Dorb.Checked = true; } else { Dorb.Checked = false; } bool notImproved = Convert.ToBoolean(data.Rows[0]["NotImproved"]); if (notImproved) { NotImproved.Checked = true; } else { NotImproved.Checked = false; } } //Grid view start here aMedicalManager = new MedicalManager(); DataTable dataTable = new DataTable(); gridControl1.DataSource = null; dataTable = aMedicalManager.GetDischargeDetails(_dischargePatient); for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow rows = tempDrug.NewRow(); tempDrug.Rows.Add(rows); rows["DrugId"] = dataTable.Rows[i]["DrugId"]; rows["DrugName"] = dataTable.Rows[i]["DrugName"]; rows["Doose"] = dataTable.Rows[i]["Doose"]; rows["Description"] = dataTable.Rows[i]["Description"]; rows["Route"] = dataTable.Rows[i]["Route"]; rows["RelatedToMeal"] = dataTable.Rows[i]["RelatedToMeal"]; rows["Id"] = dataTable.Rows[i]["Id"]; } gridControl1.DataSource = tempDrug; btnSave.Enabled = false; btnEdit.Enabled = true; }
public void SaveAndUpdateDischargePatient() { // DischargePatient _dischargePatients = new DischargePatient(); try { _dischargePatient.FatherHusbandName = txtFahterHusbandName.Text; _dischargePatient.Gender = txtGender.Text; _dischargePatient.Age = txtAge.Text; _dischargePatient.BloodGroup = txtBloodGroup.Text; //_dischargePatient.Consult = txtConsult.SelectedValue.ToString(); _dischargePatient.Cabin_BedNo = txtCabinBedNo.Text; _dischargePatient.ContactNo = txtContactNo.Text; _dischargePatient.AddmissionOn = Convert.ToDateTime(txtAdmissionOnDate.Text); _dischargePatient.DiagOnAdmission = txtDiagonsisAdmisson.Text; _dischargePatient.OPID = cmbPatient.Properties.View.GetFocusedRowCellValue("OPID").ToString(); _dischargePatient.DischargeOn = Convert.ToDateTime(txtDischargeOnDate.Text); _dischargePatient.BreffHistory = txtBreafHistory.Text; DateTime dt = txtDischareTime.Value; TimeSpan st = new TimeSpan(dt.Hour, dt.Minute, dt.Second); _dischargePatient.DischargeTime = st; _dischargePatient.RegNo = txtRegNo.Text; _dischargePatient.StatusOnDischarge = txtBreafHistory.Text; _dischargePatient.weight = txtWeight.Text; _dischargePatient.DiagOnDischarge = txtDiagOnDischarge.Text; _dischargePatient.Cured = cured.Checked; _dischargePatient.Improved = improved.Checked; _dischargePatient.Dorb = Dorb.Checked; _dischargePatient.Dor = Dor.Checked; _dischargePatient.NotImproved = NotImproved.Checked; _dischargePatient.BreffHistory = txtBreafHistory.Text; _dischargePatient.Tempdatatable = tempDrug; _dischargePatient.Route = txtRoute.Text; _dischargePatient.ReleatedToMeal = txtRealtedToMeal.Text; //**************************************************************************************** List <Advice> Advice = new List <Advice>(); foreach (ListViewItem listViewItem in listViewAdvice.Items) { Advice.Add(new Advice() { AdviceName = listViewItem.SubItems[1].Text }); } _dischargePatient.ListofAdvice = Advice; if (btnSave.Enabled) { MessageModel messageModel = new MedicalManager().SaveDischargePatient(_dischargePatient); MessageBox.Show(messageModel.MessageBody, messageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); reset(); } else if (btnEdit.Enabled) { MessageModel messageModel = new MedicalManager().UpdateDischargePatient(_dischargePatient); MessageBox.Show(messageModel.MessageBody, messageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); reset(); } } catch (Exception ex) { //throw; } }
public void GenerateFollowSerialNo() { string serialNo = new MedicalManager().GetFlowupSerial(); txtFollowupSlNo.Text = serialNo; }
public void ViewFollowUP() { DataTable GetAllPatientFollowup = new MedicalManager().GetAllPatientFollowup(Fromdate.Value, ToDate.Value); gridControlFollowUp.DataSource = GetAllPatientFollowup; }
private void DrugListLoad() { var AllDrug = new MedicalManager().GetAllDrug(); }