private void GetAdmissionOrInvestigationInfo(string sl, string mm, string yy, int docId) { strErr = ""; if (rbtnAdmission.Checked || rbtnInvestigation.Checked) { var sql = "USP_Get_Admission_Investigation_Info " + sl + "," + mm + "," + yy + "," + (rbtnAdmission.Checked ? "1" : "2") + "," + docId + "," + Utility.DCP; objData.OpenConnection("AatickPC-Office", ref strErr); var dtInfo = objData.RetriveData(sql, ref strErr); objData.CloseConnection(); if (strErr != "") { MessageBox.Show("An error occured.\n\nTry again later."); } else { if (dtInfo.Rows.Count > 0) { grdInfo.DataSource = dtInfo; grdInfo.Columns[0].Visible = false; } else { MessageBox.Show("No " + (rbtnAdmission.Checked ? "Admission" : "Investigation") + " found."); grdInfo.DataSource = null; } grdDetails.DataSource = null; } } else { MessageBox.Show("Please select Admission or Investigation radio button."); } }
private void txtinvestigationid_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)Keys.Enter) { var arrInvSl = txtinvestigationid.Text.Trim().Split('/'); if (arrInvSl.Length == 3) { objData.OpenConnection("AatickPC-Office", ref strErr); var strSql = "SELECT PT.Name,PT.PresentAddress,DL.Title+' '+DL.Name+CHAR(13)+DL.Degree+CHAR(13)+DL.Specialist AS DocInfo"; strSql += " ,dbo.f_Get_Payable_Amount(INV.InvestigationID),dbo.f_get_inv_DiscountAmont(INV.InvestigationID),dbo.f_Get_Inv_PaidAmount(INV.InvestigationID),dbo.f_Get_Inv_ReturnAmount(INV.InvestigationID),INV.InvestigationID,CASE WHEN SP.Paid_Amount>0 THEN 1 ELSE CASE WHEN SP.InvestigationID IS NULL THEN 2 ELSE 0 END END IsPaid,INV.DiscountById,SP.Receive_By,INV.CreatedON "; strSql += " FROM dbo_Investigation INV "; strSql += " INNER JOIN dbo_Patient_info PT ON PT.P_ID=INV.P_ID"; strSql += " INNER JOIN dbo_Doctor_List DL ON DL.DocID=INV.DocID"; strSql += " LEFT JOIN Investigation_SpootCommission SP ON SP.InvestigationID=INV.InvestigationID"; strSql += " WHERE INV.Invetigation_SL=" + arrInvSl[0] + " AND MONTH(INV.CreatedON)=" + arrInvSl[1] + " AND YEAR(INV.CreatedON)=" + arrInvSl[2]; var spotCommissionInfo = objData.RetriveData(strSql, ref strErr); objData.CloseConnection(); if (strErr == "" && spotCommissionInfo.Rows.Count > 0) { lblName.Text = spotCommissionInfo.Rows[0][0].ToString(); lblAddress.Text = spotCommissionInfo.Rows[0][1].ToString(); lblDoctor.Text = spotCommissionInfo.Rows[0][2].ToString(); lbltotalamount.Text = spotCommissionInfo.Rows[0][3].ToString(); lbltotaldiscount.Text = spotCommissionInfo.Rows[0][4].ToString(); lbltotalpayamount.Text = (double.Parse(spotCommissionInfo.Rows[0][3].ToString()) - double.Parse(spotCommissionInfo.Rows[0][4].ToString())).ToString(); lbltotalpaid.Text = spotCommissionInfo.Rows[0][5].ToString(); lbltotalreturn.Text = spotCommissionInfo.Rows[0][6].ToString(); lbltotaldue.Text = (double.Parse(lbltotalpayamount.Text) - double.Parse(spotCommissionInfo.Rows[0][5].ToString()) - double.Parse(spotCommissionInfo.Rows[0][6].ToString())).ToString(); int.TryParse(spotCommissionInfo.Rows[0][7].ToString(), out investigationId); InvestigationCreationDate = spotCommissionInfo.Rows[0][11].ToString(); btnsave.Enabled = spotCommissionInfo.Rows[0][8].ToString() != "1"; if (spotCommissionInfo.Rows[0][8].ToString() == "1") { MessageBox.Show("Already paid spot commission."); txtreceiveby.Text = spotCommissionInfo.Rows[0][10].ToString(); } ShowReport(spotCommissionInfo.Rows[0][8].ToString() == "1"); } else { MessageBox.Show(@"Invalid investigation id."); ClearFields(); } } else { MessageBox.Show(@"Invalid investigation id."); ClearFields(); } } }
public frmHopitalAdmissionFront() { InitializeComponent(); txtgender.DataSource = new List <object> { new { Text = "Male", Value = "M" }, new { Text = "Female", Value = "F" } }; txtgender.DisplayMember = "Text"; txtgender.ValueMember = "Value"; txtgender.BackColor = Color.White; txtReligion.DataSource = new List <object> { new { Text = "Islam", Value = "Islam" }, new { Text = "Hinduism", Value = "Hinduism" }, new { Text = "Christianity", Value = "Christianity" }, new { Text = "Buddhism", Value = "Buddhism" }, new { Text = "Taoism", Value = "Taoism" }, new { Text = "Sikhism", Value = "Sikhism" }, new { Text = "Judaism", Value = "Judaism" } }; txtReligion.DisplayMember = "Text"; txtReligion.ValueMember = "Value"; txtReligion.BackColor = Color.White; objData.OpenConnection("AatickPC-Office", ref strErr); SetNewEnv(); objData.CloseConnection(); LoadDoctorList(lstdoctorsinformation, ""); LoadDoctorList(lstDoctors, ""); btnedit.Enabled = btnpreview.Enabled = false; }
private void frmPathologyLabProcess_Load(object sender, EventArgs e) { //var parentWindow = ((frmPathologylab)this.Owner); //var invID = parentWindow.loadInvestigationID(); txtInvestigstionID.Text = InvId; objData.OpenConnection("AzharPC-Office", ref strErr); fillGdv(); //loadReport(); objData.CloseConnection(); }
private void LoadList() { var strErr = ""; objData.OpenConnection("AatickPC-Office", ref strErr); var strSql = "SELECT BI_ID,Name,BI_Number BedNumber,Rate FROM Bed_Information ORDER BY Name"; var bedList = objData.RetriveData(strSql, ref strErr); lstBedInfo.DataSource = bedList; objData.CloseConnection(); }
public frmMarketingTargetSetup() { InitializeComponent(); objData.OpenConnection("AatickPC-Office", ref strErr); var sql = "SELECT EmpID,Name FROM dbo_Employee_Profiles"; var employeeList = objData.RetriveData(sql, ref strErr); objData.CloseConnection(); cmbEmployee.DisplayMember = "Name"; cmbEmployee.ValueMember = "EmpId"; cmbEmployee.DataSource = employeeList; cmbEmployee.SelectedIndex = -1; cmbEmployee.SelectedIndexChanged += cmbEmployee_SelectedIndexChanged; }
private void txtDoctorId_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)Keys.Enter) { btnsave.Enabled = false; var docId = txtDoctorId.Text.Trim(); if (docId == "") { MessageBox.Show("Please enter doctor id."); return; } objData.OpenConnection("AatickPC-Home", ref strErr); var sql = "USP_Doctor_Payment_Due_Amount " + docId + ",'I'," + Utility.DCP; var dtDoctorPayment = objData.RetriveData(sql, ref strErr); if (strErr == "" && dtDoctorPayment.Rows.Count > 0) { txtpayableamount.Text = dtDoctorPayment.Rows[0][0].ToString(); if (double.Parse(txtpayableamount.Text.Trim()) > 0) { btnsave.Enabled = true; } } else { txtpayableamount.Text = "0"; } strErr = ""; sql = "rpt_Doctor_Ledger " + docId + ",'I'," + Utility.DCP; var dtDoctorLedger = objData.RetriveData(sql, ref strErr); objData.CloseConnection(); if (strErr == "" && dtDoctorLedger.Rows.Count > 0) { var reportDoc = new ReportDocument(); var rptpath = Utility.ReportPath + "rptDoctorLedger.rpt"; reportDoc.Load(rptpath); reportDoc.SetDataSource(dtDoctorLedger); crViewer.ReportSource = reportDoc; crViewer.ToolPanelView = ToolPanelViewType.None; } else { crViewer.ReportSource = null; MessageBox.Show("No ledger found."); } } else { e.Handled = !char.IsDigit(e.KeyChar) && !char.IsControl(e.KeyChar); } }
private void ShowReport() { if (dgvDueCollection.SelectedCells.Count > 0) { var cashId = dgvDueCollection.Rows[dgvDueCollection.SelectedCells[0].RowIndex].Cells[14].Value; objData.OpenConnection("AatickPC-Office", ref strErr); var sqlCashMemoInfo = "SELECT CAST(CM.CM_SL AS VARCHAR(10))+'/'+CAST(MONTH(CM.CreatedOn) AS VARCHAR(2))+'/'+CAST(YEAR(CM.CreatedOn) AS VARCHAR(4)) AS CashMemoNo"; sqlCashMemoInfo += " , CAST(Inv.Invetigation_SL AS VARCHAR(10))+'/'+CAST(MONTH(Inv.CreatedOn) AS VARCHAR(2))+'/'+CAST(YEAR(Inv.CreatedOn) AS VARCHAR(4)) AS InvestigationSlNo"; sqlCashMemoInfo += " , Inv.CreatedOn,PI.Name,PI.Year,PI.Month,PI.Day,PI.Gender"; sqlCashMemoInfo += " , CM.Pay_Amount,Inv.DiscountTK,Inv.DiscountPasentance,Inv.DiscountByID,dbo.f_Get_Payable_Amount(Inv.InvestigationID) Payable_Amount,U.Name UserName"; sqlCashMemoInfo += " FROM dbo_CashMemo CM INNER JOIN dbo_Investigation Inv ON CM.InvetigationID=Inv.InvestigationID"; sqlCashMemoInfo += " INNER JOIN dbo_Patient_info PI ON PI.P_ID=Inv.P_ID "; sqlCashMemoInfo += " LEFT JOIN dbo_Users U ON U.User_Id=CM.UserId "; sqlCashMemoInfo += " WHERE CM.CM_ID=" + cashId; var dtCashMemoInfo = objData.RetriveData(sqlCashMemoInfo, ref strErr); objData.CloseConnection(); var dataset = new DataSet(); dataset.Tables.Add(dtCashMemoInfo); var reportviewer = new frmReport(); var rptpath = Utility.ReportPath + "rptDueMoneyReceipt.rpt"; reportviewer.ReportPath = rptpath; reportviewer.Reportds = dataset; reportviewer.Show(this); } }
private void frmInvestigationDueCollection_Load(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); frmlod(); objData.CloseConnection(); }
private void cmbInvestigation_SelectedIndexChanged(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); loadall(); objData.CloseConnection(); }
private void btnDocRefresh_Click(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); getDocList(); objData.CloseConnection(); }
private void button3_Click(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); frmLoad(); objData.CloseConnection(); }
private void btnnew_Click(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("PolinPC-Office", ref strErr); frmload(); objData.CloseConnection(); }
public bool SaveDoctorInfo(Doctor objDoctor) { string strErr = ""; objData = new C_Data_Batch(); objData.OpenConnection("PolinPC-Office", ref strErr); string sql = "Insert into dbo_Doctor_list(Title,DocID,Name,Degree,Doctype,Phone,IsPc,Address,Area,Specialist,MarketingBy)"; sql = sql + " values('" + objDoctor.Title + "','" + objDoctor.DoctorId + "','" + objDoctor.DoctorName + "','" + objDoctor.Degree + "'"; sql = sql + " ,'" + objDoctor.Doctype + "','" + objDoctor.Phone + "'," + objDoctor.IsPC + ",'" + objDoctor.Address + "'"; sql = sql + " ,'" + objDoctor.Area + "','" + objDoctor.Specialist + "'," + objDoctor.MarketingBy + ")"; objData.ExecuteQuery(sql, ref strErr); objData.CloseConnection(); //objData = null; if (strErr == "") { MessageBox.Show("Succefully Insert into Doctor List"); return(true); } else { return(false); } }
private void frmServiceWiseList_Load(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); frmload(); objData.CloseConnection(); }
private void btnsave_Click(object sender, EventArgs e) { //MessageBox.Show(dgvRetrurn.Rows[0].Cells[0].Value.ToString()); //MessageBox.Show(dgvRetrurn.Rows[1].Cells[17].Value.ToString()); objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); string strSQL = ""; objData.BeginTransaction(ref strErr); for (int i = 0; i < dgvRetrurn.Rows.Count - 1; i++) { if (Convert.ToInt16(dgvRetrurn.Rows[i].Cells[3].Value.ToString()) > 0) { strSQL = "update dbo_InvertigationServiceItem set isreturn =1, return_on = getdate(), Return_Amount = " + dgvRetrurn.Rows[i].Cells[3].Value + ", ReturnUserID =" + Utility.userID + " , ReturnUserPC='" + Utility.PcName + "' where ISI_ID=" + dgvRetrurn.Rows[i].Cells[17].Value; objData.ExecuteQuery(strSQL, ref strErr); } } if (strErr == "") { string strSqlSpotCommission = "USP_Inv_Calculate_SpotCommission " + txtInvestigationID.Text.Split('/')[0] + "," + txtInvestigationID.Text.Split('/')[1] + "," + txtInvestigationID.Text.Split('/')[2]; objData.ExecuteQuery(strSqlSpotCommission, ref strErr); MessageBox.Show("Investigation return succefully done."); objData.CommitTransaction(ref strErr); } else { MessageBox.Show("Investigation not return."); objData.Rollback(ref strErr); } }
private void btnSave_Click(object sender, EventArgs e) { string strSql = ""; hms.Include_Files.Utility.ComboboxItem Dept = cmbDepartment.SelectedItem as hms.Include_Files.Utility.ComboboxItem; if (Dept != null) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); strSql = "Insert into dbo_Designation(DeptID, Designation) values (" + Dept.Value.ToString() + ", '" + txtDesigntionName.Text.ToString() + "')"; objData.ExecuteQuery(strSql, ref strErr); if (strErr.ToString() != "") { MessageBox.Show("Designation inserted"); frmLoad(); } else { MessageBox.Show("Designation not inserted"); } objData.CloseConnection(); } else { MessageBox.Show("Please Select the Department."); } }
private void btnpreview_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtAdmissionId.Text.Trim())) { MessageBox.Show(@"Please select a patient."); return; } var isSummary = rbtnPatientSummary.Checked; if (rbtnPatientDetails.Checked || rbtnPatientSummary.Checked) { if (isSummary) { objData.OpenConnection("AatickPC-Office", ref strErr); var sqlBill = "USP_HospitalConsultantBill_Summery " + txtAdmissionId.Text; var dtBillInfo = objData.RetriveData(sqlBill, ref strErr); objData.CloseConnection(); var rptpath = Utility.ReportPath + "rptHospitalBill.rpt"; var report = new ReportDocument(); report.Load(rptpath); report.SetDataSource(dtBillInfo); report.SetParameterValue("UserName", Utility.UserName); var reportviewer = new frmReport(report); reportviewer.Show(this); } } else { MessageBox.Show(@"Please select any one report option."); } }
private void txtinvestigationid_KeyUp(object sender, KeyEventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); fillGridView(); objData.CloseConnection(); }
private void frmPathologylab_Load(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); frmLoad(); objData.CloseConnection(); }
private void lbPathlab_SelectedIndexChanged(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); fillGridView(); objData.CloseConnection(); }
private void loaddoctor() { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); getDocList(txtdoctorinformation.Text.Trim()); objData.CloseConnection(); }
private void lsttestname_SelectedIndexChanged(object sender, EventArgs e) { if (isFirstTime != "0") { return; } var sql = "select Amount from Dbo_Services where service_id = " + lsttestname.SelectedValue; //C_Data_Batch objData; strErr = ""; objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Office", ref strErr); var arrServicePrice = objData.RetriveData(sql, ref strErr); if (strErr == "") { if (arrServicePrice.Rows.Count > 0) { lblServicePrice.Text = arrServicePrice.Rows[0][0].ToString(); } else { lblServicePrice.Text = ""; } } else { lblServicePrice.Text = ""; } objData.CloseConnection(); }
private void fillDesignation() { //throw new NotImplementedException(); objetdata = new C_Data_Batch(); string strErr = ""; objetdata.OpenConnection("PolinPC-Office", ref strErr); string strSQL = ""; hms.Include_Files.Utility.ComboboxItem itms = cmbDepartment.SelectedItem as hms.Include_Files.Utility.ComboboxItem; var DeptID = 0; if (itms != null) { DeptID = itms.Value; strSQL = "select DegId, Designation from dbo_Designation where DeptID= " + DeptID + " order by DeptID Desc "; DataTable arrDept = objetdata.RetriveData(strSQL, ref strErr); objetdata.CloseConnection(); //DataSet ds = new DataSet(); //ds.Tables.Add(arrDept); //dgvEmpprofile.DataSource = ds.Tables["Table1"]; cmbDesignation.Items.Clear(); if (arrDept.Rows.Count > 0) { for (int i = 0; i < arrDept.Rows.Count; i++) { cmbDesignation.Items.Add(new hms.Include_Files.Utility.ComboboxItem(arrDept.Rows[i][1].ToString(), Convert.ToInt32(arrDept.Rows[i][0].ToString()))); } } } else { MessageBox.Show("Please select the Department"); } }
public int getDoctorId() { int doctorid = 0; string strErr = ""; string strSQL = "select max(DocID) from dbo_Doctor_list"; objData = new C_Data_Batch(); objData.OpenConnection("PolinPC-Office", ref strErr); DataTable dtMaxDictorID = objData.RetriveData(strSQL, ref strErr); //string[,] arrMaxDictorID = objData.RetriveDataArray(strSQL, ref strErr); objData.CloseConnection(); if (dtMaxDictorID.Rows.Count > 0) { if (dtMaxDictorID.Rows[0][0].ToString() != "") { doctorid = Convert.ToInt32(dtMaxDictorID.Rows[0][0].ToString()) + 1; } else { doctorid = 1; } } else { doctorid = 1; } return(doctorid); }
private void getEmployeeID() { //throw new NotImplementedException(); string strErr = ""; objetdata = new C_Data_Batch(); string strSQL = ""; strSQL = "select max(EmpID) from dbo_Employee_Profiles"; objetdata.OpenConnection("PolinPC-Office", ref strErr); Int32 EmpID = 0; DataTable arrEmpID = objetdata.RetriveData(strSQL, ref strErr); if (arrEmpID.Rows.Count > 0) { if (arrEmpID.Rows[0][0].ToString() != "") { EmpID = Convert.ToInt32(arrEmpID.Rows[0][0].ToString()) + 1; } else { EmpID = 1; } } else { EmpID = 1; } txtEmpployeeID.Text = EmpID.ToString(); }
private void btnedit_Click(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); DataEdit(); objData.CloseConnection(); }
private void frmDerpartmentSetup_Load(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); frmLoad(); objData.CloseConnection(); }
private void btnpreview_Click(object sender, EventArgs e) { objData = new C_Data_Batch(); string strErr = ""; objData.OpenConnection("PolinPC-Office", ref strErr); //txtCategoryID string strSQL = ""; strSQL = "SELECT st.[SIT_ID],s.[Service_Name],st.[OGroup],st.[Entity],st.[Unit],st.[RefRenge],st.[Result_B] FROM [Dbo_service_Itemwise_Test] ST inner Join Dbo_Services S On St.Service_ID=s.Service_ID order by st.[SIT_ID] desc"; DataTable arrCatList = objData.RetriveData(strSQL, ref strErr); objData.CloseConnection(); DataSet ds = new DataSet(); ds.Tables.Add(arrCatList); frmReport reportviewer = new frmReport(); var rptpath = Utility.ReportPath + "rptServicesWiseTest.rpt"; reportviewer.ReportPath = rptpath; reportviewer.Reportds = ds; reportviewer.Show(this); }
private void btnsave_Click(object sender, EventArgs e) { var strSQL = ""; var strStatus = ""; if (rbtnDischarge.Checked == true) { strStatus = rbtnDischarge.Text; } else if (rbtnPatientDeath.Checked) { strStatus = rbtnPatientDeath.Text; } else if (rbtntransfer.Checked) { strStatus = rbtntransfer.Text; } else { strStatus = "Unknown"; } strSQL = "update Patient_Bed SET isBooked = 0,Note='" + strStatus + "',release_on=getdate(), DischargeUserID = " + Utility.userID + ",DischargeUserPC='" + Utility.PcName + "' where Admission_id = " + txtAdmissionId.Text + " and isBooked = 1"; objData.OpenConnection("AzharPC-Office", ref strErr); objData.ExecuteQuery(strSQL, ref strErr); objData.CloseConnection(); MessageBox.Show(strErr != "" ? @"Patient Not Discharge." : @"Patient Discharge successfully."); Utility.ClearAllControls(this); }