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) { if ( new DateTime(DateTime.Parse(AdmissionCreationDate).Year, DateTime.Parse(AdmissionCreationDate).Month, DateTime.Parse(AdmissionCreationDate).Day) < new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1)) { MessageBox.Show("This is a backdated admission id.\n\nYou can not pay it here."); return; } objData.OpenConnection("AatickPC-Office", ref strErr); var sql = "UPDATE dbo_InvertigationServiceItem SET CommissionPaidOn=GETDATE(),CommissionPaidUserid=" + Utility.userID + ",CommissionPaidUserPC='" + Utility.UserName + "' WHERE Investigationid IN (SELECT INV.InvestigationID FROM dbo_Admission AD INNER JOIN dbo_Investigation INV ON INV.Admission_id=AD.Admission_Id WHERE AD.Admission_Id=" + ADMISSION_ID + ")"; objData.ExecuteQuery(sql, ref strErr); sql = "INSERT INTO dbo_Admission_Doctor_Commission(Admission_Id,DocId,Commission,PaidOn,PaidUserId,PaidUserPC) SELECT AD.Admission_Id,AD.Reference_Doc_ID,dbo.f_Get_Admission_Commission(AD.Admission_Id," + Utility.DCP + "),GETDATE()," + Utility.userID + ",'" + Utility.PcName + "' FROM dbo_Admission AD WHERE AD.Admission_Id=" + ADMISSION_ID; objData.ExecuteQuery(sql, ref strErr); objData.CloseConnection(); if (strErr == "") { var isPrint = MessageBox.Show("Payement successfull.\n\nDo you want to print receipt?", @"Confirm", MessageBoxButtons.YesNo); if (isPrint == DialogResult.Yes) { Utility.Print((ReportDocument)crViewer.ReportSource, "", 1); } btnNew.PerformClick(); } }
private void btnSane_Click(object sender, EventArgs e) { var strSql = ""; //var strSqlInvItem = ""; DataTable arrData; objData.OpenConnection("AzharPC-Office", ref strErr); objData.BeginTransaction(ref strErr); for (int i = 0; i < dgvPathologyLabProcess.Rows.Count - 1; i++) { if (strErr == "") { if (dgvPathologyLabProcess.Rows[i].Cells[4].Value.ToString() != "") { strSql = "select ID From InvertigationServiceItemwise_testResult Where SIT_ID =" + dgvPathologyLabProcess.Rows[i].Cells[8].Value + " and InvestigationID =" + dgvPathologyLabProcess.Rows[i].Cells[9].Value; arrData = objData.RetriveData(strSql, ref strErr); if (arrData.Rows.Count > 0) { strSql = "update InvertigationServiceItemwise_testResult set Result= '" + dgvPathologyLabProcess.Rows[i].Cells[4].Value + "' Where SIT_ID =" + dgvPathologyLabProcess.Rows[i].Cells[8].Value + " and InvestigationID =" + dgvPathologyLabProcess.Rows[i].Cells[9].Value; //MessageBox.Show(strSql); objData.ExecuteQuery(strSql, ref strErr); } else { strSql = "Insert into InvertigationServiceItemwise_testResult (SIT_ID,InvestigationID, Result) values(" + dgvPathologyLabProcess.Rows[i].Cells[8].Value + "," + dgvPathologyLabProcess.Rows[i].Cells[9].Value + ",'" + dgvPathologyLabProcess.Rows[i].Cells[4].Value + "')"; //MessageBox.Show(strSql); objData.ExecuteQuery(strSql, ref strErr); } } } } if (strErr == "") { objData.CommitTransaction(ref strErr); } else { objData.Rollback(ref strErr); } if (strErr == "") { fillGdv(); //loadReport(); } objData.CloseConnection(); }
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); }
private void deleteData() { //throw new NotImplementedException(); objData = new C_Data_Batch(); string strErr = ""; objData.OpenConnection("PolinPC-Office", ref strErr); //txtCategoryID string strSQL = ""; strSQL = "Delete From Dbo_Service_Category where Category_ID = " + txtCategoryID.Text.ToString(); objData.ExecuteQuery(strSQL, ref strErr); if (strErr != "") { MessageBox.Show("Data not Deleted."); } else { MessageBox.Show("Data Deleted Succefully Done."); getcategorid(); clearCatName(); grdShow(); } objData.CloseConnection(); }
private void insertData() { //throw new NotImplementedException(); objData = new C_Data_Batch(); string strErr = ""; objData.OpenConnection("PolinPC-Office", ref strErr); //txtCategoryID string strSQL = ""; strSQL = "Insert into Dbo_Service_Category (Category_Name) values ('" + txtcategoryname.Text.ToString() + "')"; objData.ExecuteQuery(strSQL, ref strErr); if (strErr != "") { MessageBox.Show("Data not Saved."); } else { MessageBox.Show("Data Save Succefully Done."); getcategorid(); clearCatName(); grdShow(); } objData.CloseConnection(); }
private void btnsave_Click(object sender, EventArgs e) { strErr = ""; var empId = cmbEmployee.SelectedValue.ToString(); var target = 0.0; double.TryParse(txtsettergetamount.Text, out target); if (target <= 0) { MessageBox.Show(@"Please enter target amount."); return; } objData.OpenConnection("AatickPC-Office", ref strErr); var sql = "SELECT COUNT(1) FROM dbo_Marketing_Yearly_Target WHERE EmpID=" + empId + " AND TrgYearFrom=CASE WHEN MONTH(GETDATE())>6 THEN YEAR(GETDATE()) ELSE YEAR(GETDATE())-1 END AND TrgYearTo=CASE WHEN MONTH(GETDATE())>6 THEN YEAR(GETDATE())+1 ELSE YEAR(GETDATE()) END"; var dtCount = objData.RetriveData(sql, ref strErr); if (int.Parse(dtCount.Rows[0][0].ToString()) > 0) { objData.CloseConnection(); MessageBox.Show(@"The target has already been set up for this employee."); return; } sql = "USP_SET_MARKETING_TARGET " + empId + "," + target + "," + Utility.userID + ",'" + Utility.PcName + "'"; objData.ExecuteQuery(sql, ref strErr); objData.CloseConnection(); if (strErr == "") { MessageBox.Show(@"Target set up successfull."); } }
private void InsertData() { objData = new C_Data_Batch(); string strErr = ""; objData.OpenConnection("PolinPC-Office", ref strErr); //txtCategoryID hms.Include_Files.Utility.ComboboxItem commissionType = cmbCommission.SelectedItem as hms.Include_Files.Utility.ComboboxItem; hms.Include_Files.Utility.ComboboxItem DurationType = cmbDurationType.SelectedItem as hms.Include_Files.Utility.ComboboxItem; int isSample = 0; if (chkSample.Checked == true) { isSample = 1; } string strSQL = ""; strSQL = "insert into [Dbo_Services] ([Category_ID],[Amount],[Commission],[Commision_Type],[Dutaion],[Duraion_Type],[CC_PC],[isSample],[Sample_Type], [Service_Name] ) "; strSQL = strSQL + "Values (" + txtcatagory.Text.ToString() + ", " + txtservicecharge.Text.ToString() + ", " + txtcommistion.Text.ToString() + ", " + commissionType.Value.ToString() + ", " + txtDuration.Text.ToString() + ", " + DurationType.Value.ToString(); strSQL = strSQL + ", " + txtpc.Text.ToString() + ", " + isSample.ToString() + ", '" + txtSample.Text.ToString() + "', '" + txtservicename.Text.ToString() + "' )"; //MessageBox.Show(strSQL); objData.ExecuteQuery(strSQL, ref strErr); if (strErr != "") { MessageBox.Show("Data not Inserted."); } else { MessageBox.Show("Data Inserted Succefully Done."); 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 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 btnsave_Click(object sender, EventArgs e) { var docId = lstdocinformation.SelectedValue; var invId = lstInvestigationList.SelectedItems[0].SubItems[2].Text; var name = txtname.Text; var address = txtaddress.Text; var phone = txtphone.Text; var year = txtyear.Text; var month = txtmonth.Text; var day = txtday.Text; var sex = txtsex.Text; var pid = lstInvestigationList.SelectedItems[0].SubItems[3].Text; objData.OpenConnection("AatickPC-Office", ref strErr); var strSQL = "UPDATE dbo_Patient_info SET Name='" + name + "',Phone='" + phone + "',PresentAddress='" + address + "',Year=" + year + ",Month=" + month + ",Day=" + day + ",Gender='" + sex + "',UserId=" + Utility.userID + ",UserPc='" + Utility.PcName + "' WHERE P_ID=" + pid; strSQL += ";UPDATE dbo_Investigation SET DocId=" + docId + ",UserId=" + Utility.userID + ",UserPc='" + Utility.PcName + "' WHERE InvestigationID=" + invId; objData.ExecuteQuery(strSQL, ref strErr); objData.CloseConnection(); if (strErr == "") { MessageBox.Show("Update successfully."); ShowInvestigationReport(invId); } }
private void btnSave_Click(object sender, EventArgs e) { var bedName = txtName.Text; var bedNumber = txtBINumber.Text; var rate = txtRate.Text; var strErr = ""; objData.OpenConnection("AatickPC-Office", ref strErr); var insertBedInfo = "INSERT INTO Bed_Information(Name,BI_Number,Rate) VALUES('" + bedName + "','" + bedNumber + "'," + rate + ");"; objData.ExecuteQuery(insertBedInfo, ref strErr); MessageBox.Show(strErr != "" ? strErr : @"Bed Information inserted successfully."); objData.CloseConnection(); LoadList(); }
private void btnsave_Click(object sender, EventArgs e) { if (lstBedInfo.SelectedItems.Count > 0) { var arrData = lstBedInfo.SelectedItems[0].Tag.ToString().Split('#'); if (arrData[0] == "1") { MessageBox.Show("This bed is not free now."); } else { objData.OpenConnection("AatickPC-Office", ref strErr); var date = ""; var time = DateTime.Now; if (time < DateTime.Parse(DateTime.Today.ToShortDateString() + " 11:00:00 AM") || time > DateTime.Parse(DateTime.Today.ToShortDateString() + " 01:00:00 PM")) { var sqlText = "SELECT Rate FROM Bed_Information WHERE BI_ID=" + dgbpreviousbedinfo.Tag; var prev = double.Parse(objData.RetriveData(sqlText, ref strErr).Rows[0][0].ToString()); sqlText = "SELECT Rate FROM Bed_Information WHERE BI_ID=" + arrData[1]; var current = double.Parse(objData.RetriveData(sqlText, ref strErr).Rows[0][0].ToString()); if (time.ToString("tt", CultureInfo.InvariantCulture) == "AM") { date = (prev >= current) ? (DateTime.Today.ToShortDateString() + " 12:00 PM") : (DateTime.Today.AddDays(-1).ToShortDateString() + " 12:00 PM"); } else { date = (prev >= current) ? (DateTime.Today.AddDays(1).ToShortDateString() + " 12:00 PM") : (DateTime.Today.ToShortDateString() + " 12:00 PM"); } } var sql = "UPDATE Patient_Bed SET isBooked=0,release_on='" + date + "' WHERE BI_ID=" + dgbpreviousbedinfo.Tag + " AND Admission_id=" + txtadmissionid.Tag + ";INSERT INTO Patient_Bed(BI_ID,Admission_id,Booked_On,isBooked,isTransfer,Transfer_From,Transfer_On,Note,TransferUserID,TransferUserPC) VALUES(" + arrData[1] + "," + txtadmissionid.Tag + ",'" + date + "',1,1," + dgbpreviousbedinfo.Tag + ",'" + date + "','" + txtremarks.Text + "'," + Utility.userID + ",'" + Utility.PcName + "')"; objData.ExecuteQuery(sql, ref strErr); objData.CloseConnection(); if (strErr == "") { MessageBox.Show("Bed has been successfully transfered."); LoadBedInfo(); FillGridView(txtadmissionid.Tag.ToString()); } else { MessageBox.Show("An error occurred.\n\nTry again later."); } } } else { MessageBox.Show("Please select any free bed."); } }
private void DataSave() { //throw new NotImplementedException(); string strSql = ""; strSql = "INSERT INTO [Dbo_service_Itemwise_Test]([Service_ID],[OGroup],[Entity],[Unit],[RefRenge],[Result_B]) "; strSql = strSql + " values (" + txtServiceID.Text.ToString() + ", N'" + txtOGroup.Text.ToString() + "' "; strSql = strSql + ", N'" + txtEntity.Text.ToString() + "', N'" + txtUnit.Text.ToString() + "', N'" + txtRefRenge.Text.ToString() + "', N'" + txtResultB.Text.ToString() + "')"; objData.ExecuteQuery(strSql, ref strErr); if (strErr != "") { MessageBox.Show("Data Not inserted."); } else { MessageBox.Show("Data inserted succefully done."); frmload(); } }
private void btnsave_Click(object sender, EventArgs e) { var docId = lstdoctorsname.SelectedValue; if (docId == null) { MessageBox.Show("Please select a doctor."); lstdoctorsname.Focus(); return; } var addmissionId = lblAddmissionId.Text; if (addmissionId == "") { MessageBox.Show("Please enter addmission id."); txtAdmissionID.Focus(); return; } var visitType = 0; int.TryParse(cmbVisitType.SelectedValue.ToString(), out visitType); var visitNo = 0; int.TryParse(txtVisitNo.Text, out visitNo); visitNo = visitNo == 0 ? 1 : visitNo; var amount = txtvisitamount.Text; var procedure = txtproccedure.Text; var medicine = txtmedicine.Text; var comment = txtcomments.Text; var strErr = ""; objData.OpenConnection("AatickPC-Office", ref strErr); var strSql = "INSERT INTO dbo_Admission_Consultant_Visit_Charge(Doc_ID,Admission_ID,VisitId,Amount,Doc_Procedure,Doc_Medicin,Comment,UserId,UserPC,VisitNo) VALUES(" + docId + "," + addmissionId + "," + visitType + "," + amount + ",'" + procedure + "','" + medicine + "','" + comment + "'," + Utility.userID + ",'" + Utility.PcName + "'," + visitNo + ")"; objData.ExecuteQuery(strSql, ref strErr); objData.CloseConnection(); MessageBox.Show(strErr == "" ? "Successfully saved." : "Data not saved.\nPlease try again later."); //ClearAllFields(); LoadList(addmissionId); }
private void btnedit_Click(object sender, EventArgs e) { hms.Include_Files.Utility.ComboboxItem Maritms = cmbMarktingOfficer.SelectedItem as hms.Include_Files.Utility.ComboboxItem; var valMar = 0; if (Maritms != null) { valMar = Maritms.Value; } hms.Include_Files.Utility.ComboboxItem itms = drDoctorType.SelectedItem as hms.Include_Files.Utility.ComboboxItem; if (itms != null) { //MessageBox.Show(itms.Value.ToString()); int isPC = 0; if (chkbispc.Checked == true) { isPC = 1; } string strSql = ""; //strSql = "insert into dbo_Doctor_List ([Title],[Name],[Degree],[Phone],[IsPc],[Address],[Area],[Specialist],[Doctor_Type],[MarketingBy],[UserID],DocID, Doctype) "; //strSql = strSql + "Values ('" + txttitle.Text.ToString() + "', '" + txtdoctorname.Text.ToString(); //strSql = strSql + "', '" + txtdegree.Text.ToString() + "', '" + txtPhone.Text.ToString() + "'," + isPC.ToString(); //strSql = strSql + " ,'" + txtAddress.Text.ToString() + "','" + txtArea.Text.ToString() + "','" + txtspecialist.Text.ToString(); //strSql = strSql + "'," + itms.Value.ToString() + ", 1," + hms.Include_Files.Utility.userID.ToString() + ", " + txtdoctorsid.Text.ToString() + ", '' )"; strSql = "Update dbo_Doctor_List SET [Title] = '" + txttitle.Text.ToString() + "',[Name] = '" + txtdoctorname.Text.ToString() + "',[Degree] ='" + txtdegree.Text.ToString() + "'"; strSql = strSql + ",[Phone]='" + txtPhone.Text.ToString() + "',[IsPc]=" + isPC.ToString() + ",[Address]='" + txtAddress.Text.ToString() + "',[Area] = '" + txtArea.Text.ToString() + "',[Specialist] ='" + txtspecialist.Text.ToString() + "'"; strSql = strSql + ",[Doctor_Type] ='" + itms.Value.ToString() + "', MarketingBy = " + valMar + " where DocID =" + txtdoctorsid.Text.ToString(); objData = new C_Data_Batch(); objData.OpenConnection("sakhawat-pc", ref strErr); objData.ExecuteQuery(strSql, ref strErr); if (strErr.ToString() == "") { MessageBox.Show("Dotor setup Edit succefully done."); frmLoad(); } else { MessageBox.Show("Dotor setup Edit not succefully done."); } objData.CloseConnection(); } }
private void btnsave_Click(object sender, EventArgs e) { if ( new DateTime(DateTime.Parse(AdmissionCreationDate).Year, DateTime.Parse(AdmissionCreationDate).Month, DateTime.Parse(AdmissionCreationDate).Day) < new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1)) { MessageBox.Show("This is a backdated admission id.\n\nYou can not pay it here."); return; } var docId = Convert.ToInt32(cmbDoctorList.SelectedValue.ToString().Split('@')[0]); var visitId = Convert.ToInt32(cmbDoctorList.SelectedValue.ToString().Split('@')[1]); objData.OpenConnection("AatickPC-Office", ref strErr); var sql = "UPDATE dbo_Admission_Consultant_Visit_Charge SET PaidOn=getdate(), PaidUserId=" + Utility.userID + ", PaidUserPC='" + Utility.PcName + "' WHERE Admission_ID=" + ADMISSION_ID + " AND VisitID=" + visitId + " AND Doc_ID=" + docId; objData.ExecuteQuery(sql, ref strErr); if (strErr == "") { var isPrint = MessageBox.Show("Payement successfull.\n\nDo you want to print receipt?", @"Confirm", MessageBoxButtons.YesNo); if (isPrint == DialogResult.Yes) { objData.OpenConnection("AatickPC-Office", ref strErr); sql = "USP_rpt_spot_visit_charge " + ADMISSION_ID + ",1," + docId; var dtReport = objData.RetriveData(sql, ref strErr); objData.CloseConnection(); var rptpath = Utility.ReportPath + "rptDoctorSpotVisit.rpt"; var report = new ReportDocument(); report.Load(rptpath); report.SetDataSource(dtReport); report.SetParameterValue("printedBy", Utility.UserName); Utility.Print(report, rptpath, 1); } GetDocInfoWithCommission(txtAdmissionId.Text); txtPayableAmount.ResetText(); ShowReport(); } else { MessageBox.Show(@"An error occured.\nPlease try again later."); } objData.CloseConnection(); }
private void btnSave_Click(object sender, EventArgs e) { objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); string strSql = ""; strSql = "insert into dbo_Department(Name, Description) values('" + txtDeptName.Text.ToString() + "','" + rtbDeptDes.Text.ToString() + "')"; objData.ExecuteQuery(strSql, ref strErr); if (strErr.ToString() == "") { MessageBox.Show("Doctor list save Succefully Done"); frmLoad(); } else { MessageBox.Show("Doctor list not save Succefully."); } objData.CloseConnection(); }
private void btnsave_Click(object sender, EventArgs e) { var docId = txtDoctorId.Text.Trim(); var paidAmount = 0.0; double.TryParse(txtPaidAmount.Text.Trim(), out paidAmount); var payableAmount = 0.0; double.TryParse(txtpayableamount.Text.Trim(), out payableAmount); if (docId == "") { MessageBox.Show("Please enter doctor id."); return; } if (!(paidAmount > 0 && payableAmount > 0)) { MessageBox.Show("Payable amount & paid amount must be greater than 0."); return; } if (paidAmount > payableAmount) { MessageBox.Show("Paid amount must be less than or equal to payable amount."); return; } objData.OpenConnection("AatickPC-Home", ref strErr); var sql = "INSERT INTO dbo_Doctor_Payment(Doc_Id,Paid_Amount,Paid_On,Paid_Type,Remarks) VALUES(" + docId + "," + paidAmount + ",getdate(),'I','" + txtremark.Text + "')"; objData.ExecuteQuery(sql, ref strErr); objData.CloseConnection(); if (strErr == "") { MessageBox.Show("Payment Successfull."); btnnew.PerformClick(); } else { MessageBox.Show("An error occurred.\n\nTry again later."); } }
private void btnsave_Click(object sender, EventArgs e) { if ( new DateTime(DateTime.Parse(InvestigationCreationDate).Year, DateTime.Parse(InvestigationCreationDate).Month, DateTime.Parse(InvestigationCreationDate).Day) < new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1)) { MessageBox.Show("This is a backdated investigation.\n\nYou can not pay it here."); return; } objData.OpenConnection("AatickPC-Office", ref strErr); var sql = "UPDATE Investigation_SpootCommission SET Paid_Amount=Payable_Amount,Payable_Amount=0,Total_Due=0,Receive_By='" + txtreceiveby.Text + "',Paid_On=GETDATE(),Update_On=GETDATE(),UserId=" + Utility.userID + ",UserPc='" + Utility.PcName + "' WHERE InvestigationID=" + investigationId; objData.ExecuteQuery(sql, ref strErr); objData.CloseConnection(); if (strErr == "") { btnsave.Enabled = false; MessageBox.Show("Commission paid successfully."); ShowReport(true); } }
private void btnProcess_Click(object sender, EventArgs e) { if (!rbtnInvestigation.Checked && !rbtnAdmissionRefTo.Checked && !rbtnAdmissionReffBy.Checked) { MessageBox.Show(@"Please select a doctor type."); return; } if (txtInvAdvID.Text.Replace("/", "").Trim() == "") { MessageBox.Show(@"Please enter " + (rbtnInvestigation.Checked ? "Investigation" : "Admission") + @"Id"); return; } if (string.IsNullOrEmpty(txtdocid.Text.Trim())) { MessageBox.Show(@"Please enter replace doctor id.", @"Error", MessageBoxButtons.OK); return; } strErr = ""; var docId = int.Parse(txtdocid.Text); if (docId == PREV_DOC_ID) { MessageBox.Show(@"Existing doctor id and replace doctor id is same.", @"Information", MessageBoxButtons.OK); return; } var sql = ""; if (rbtnInvestigation.Checked) { sql = "UPDATE dbo_Investigation SET DocID=" + docId + ",UpdatedOn=GETDATE() WHERE InvestigationID=" + INV_ADM_ID + ";"; sql += " UPDATE Investigation_SpootCommission SET Doc_ID=" + docId + ",Update_On=GETDATE() WHERE InvestigationID=" + INV_ADM_ID + ";"; sql += " INSERT INTO InvestigationTransfer_Log(InvestigationID,Previus_Doctors_ID,Transfer_Doctors_ID,Transfer_ON,UserID,UserPC,Is_Admission_Ref_Changed,Remarks)"; sql += " VALUES(" + INV_ADM_ID + "," + PREV_DOC_ID + "," + docId + ",GETDATE()," + Utility.userID + ",'" + Utility.PcName + "',0,'" + txtRemark.Text + "') "; } else if (rbtnAdmissionReffBy.Checked) { sql = "UPDATE dbo_Admission SET Reference_Doc_ID=" + docId + ",UpdatedOn=GETDATE() WHERE Admission_Id=" + INV_ADM_ID + ";"; sql += sql += " INSERT INTO dbo_Admission_Doctor_Transfer_Log(Admission_Id,Previus_Doctors_ID,Transfer_Doctors_ID,Transfer_ON,UserID,UserPC,Doctor_Type,Remarks)"; sql += " VALUES(" + INV_ADM_ID + "," + PREV_DOC_ID + "," + docId + ",GETDATE()," + Utility.userID + ",'" + Utility.PcName + "',2,'" + txtRemark.Text + "'); "; sql += " UPDATE dbo_Admission_Doctor_Commission SET DocId=" + docId + " WHERE Admission_Id=" + INV_ADM_ID + ";"; sql += " UPDATE dbo_Investigation SET DocID=" + docId + " WHERE InvestigationID=" + INV_ADM_ID + ";"; sql += " UPDATE Investigation_SpootCommission SET Doc_ID=" + docId + " WHERE InvestigationID=" + INV_ADM_ID + ";"; sql += " INSERT INTO InvestigationTransfer_Log(InvestigationID,Previus_Doctors_ID,Transfer_Doctors_ID,Transfer_ON,UserID,UserPC,Is_Admission_Ref_Changed,Remarks)"; sql += " VALUES(" + INV_ADM_ID + "," + PREV_DOC_ID + "," + docId + ",GETDATE()," + Utility.userID + ",'" + Utility.PcName + "',1,'" + txtRemark.Text + "') "; } else if (rbtnAdmissionRefTo.Checked) { sql = "UPDATE dbo_Admission SET Under_Doc_ID=" + docId + ",UpdatedOn=GETDATE() WHERE Admission_Id=" + INV_ADM_ID + ";"; sql += " INSERT INTO dbo_Admission_Doctor_Transfer_Log(Admission_Id,Previus_Doctors_ID,Transfer_Doctors_ID,Transfer_ON,UserID,UserPC,Doctor_Type,Remarks)"; sql += " VALUES(" + INV_ADM_ID + "," + PREV_DOC_ID + "," + docId + ",GETDATE()," + Utility.userID + ",'" + Utility.PcName + "',1,'" + txtRemark.Text + "'); "; } if (sql != "") { objData.OpenConnection("AatickPC-Office", ref strErr); objData.ExecuteQuery(sql, ref strErr); objData.CloseConnection(); if (strErr == "") { MessageBox.Show(@"Doctor Replacement successful.", @"Success", MessageBoxButtons.OK); PREV_DOC_ID = docId; } else { MessageBox.Show("An error. occurred.\n\nTry again later.", @"Error", MessageBoxButtons.OK); } } }
private void btnDeliver_Click(object sender, EventArgs e) { var tD = 0; if (lbltotaldue.Text == "") { tD = 0; } else { tD = Convert.ToInt16(lbltotaldue.Text.ToString()); if (tD > 0) { MessageBox.Show("Please paid the due collection"); } else { string strSqlUpdateItems = ""; string strSqlInsertHistory = ""; string strIDs = ""; if (Convert.ToInt32(dgvFontDeskReport.Rows.Count) - 1 > 0) { for (int i = 0; i < dgvFontDeskReport.Rows.Count - 1; i++) { if ((bool)dgvFontDeskReport.Rows[i].Cells[0].FormattedValue == true) { if (strIDs.ToString() == "") { strIDs = dgvFontDeskReport.Rows[i].Cells[8].Value.ToString(); strSqlInsertHistory = " (" + dgvFontDeskReport.Rows[i].Cells[8].Value.ToString() + ", 6," + hms.Include_Files.Utility.userID + ",'" + Utility.PcName + "')"; } else { strIDs = strIDs + ", " + dgvFontDeskReport.Rows[i].Cells[8].Value.ToString(); strSqlInsertHistory = strSqlInsertHistory + ", (" + dgvFontDeskReport.Rows[i].Cells[8].Value.ToString() + ", 6," + hms.Include_Files.Utility.userID + ",'" + Utility.PcName + "')"; } } } } if (strIDs != "") { strSqlUpdateItems = "Update dbo_InvertigationServiceItem SET Status=6, Delivered= getdate() where [ISI_ID] in (" + strIDs + ")"; strSqlInsertHistory = "insert into Investigation_Serviceitem_History (ISI_ID, Status, UserID,userPC) values " + strSqlInsertHistory; //objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); objData.BeginTransaction(ref strErr); if (strErr == "") { objData.ExecuteQuery(strSqlUpdateItems, ref strErr); if (strErr == "") { objData.ExecuteQuery(strSqlInsertHistory, ref strErr); if (strErr == "") { MessageBox.Show("Report Delivery succefully done."); objData.CommitTransaction(ref strErr); frmLoad(); } else { objData.Rollback(ref strErr); MessageBox.Show("System cannot deal at this moment."); } } else { objData.Rollback(ref strErr); MessageBox.Show("System cannot deal at this moment."); } } } } } }
private void saveData() { //throw new NotImplementedException(); string strSqlUpdateItems = ""; string strSqlInsertHistory = ""; string strIDs = ""; if (Convert.ToInt32(dgvSampleCollection.Rows.Count) - 1 > 0) { for (int i = 0; i < dgvSampleCollection.Rows.Count - 1; i++) { if ((bool)dgvSampleCollection.Rows[i].Cells[0].FormattedValue == true) { if (strIDs.ToString() == "") { strIDs = dgvSampleCollection.Rows[i].Cells[9].Value.ToString(); strSqlInsertHistory = " (" + dgvSampleCollection.Rows[i].Cells[9].Value.ToString() + ", 1," + hms.Include_Files.Utility.userID + ",'" + Utility.PcName + "')"; } else { strIDs = strIDs + ", " + dgvSampleCollection.Rows[i].Cells[9].Value.ToString(); strSqlInsertHistory = strSqlInsertHistory + ", (" + dgvSampleCollection.Rows[i].Cells[9].Value.ToString() + ", 1," + hms.Include_Files.Utility.userID + ",'" + Utility.PcName + "')"; } } } } if (strIDs.ToString() != "") { strSqlUpdateItems = "Update dbo_InvertigationServiceItem SET Status=1 where [ISI_ID] in (" + strIDs.ToString() + ")"; strSqlInsertHistory = "insert into Investigation_Serviceitem_History (ISI_ID, Status, UserID,userPC) values " + strSqlInsertHistory; objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); objData.BeginTransaction(ref strErr); if (strErr.ToString() == "") { objData.ExecuteQuery(strSqlUpdateItems, ref strErr); if (strErr.ToString() == "") { objData.ExecuteQuery(strSqlInsertHistory, ref strErr); if (strErr.ToString() == "") { MessageBox.Show("sample collection saved succefully done."); objData.CommitTransaction(ref strErr); frmLoad(); } else { objData.Rollback(ref strErr); MessageBox.Show("System cannot deal at this moment."); } } else { objData.Rollback(ref strErr); MessageBox.Show("System cannot deal at this moment."); } } } }
private void SaveData() { var invid = cmbInvestigation.SelectedValue.ToString(); var DincountByID = cmbDiscount.SelectedIndex > -1 ? int.Parse(cmbDiscount.SelectedValue.ToString()) : 0; var invSL = cmbInvestigation.Text; string strSQLUpdateInvertigation = ""; string strSQLUpdateCashMemo = "select max(CM_SL) From dbo_CashMemo where month(CreatedOn) = month(getdate()) "; DataTable arrCashSL = objData.RetriveData(strSQLUpdateCashMemo, ref strErr); int cashSL = 0; if (arrCashSL.Rows.Count > 0) { if (arrCashSL.Rows[0][0].ToString() == "") { cashSL = 1000; } else { cashSL = Convert.ToInt16(arrCashSL.Rows[0][0].ToString()) + 1; } } else { cashSL = 1000; } string strSQLCASH = ""; int paidAmount = 0; if (txtpaidamount.ToString() == "") { paidAmount = 0; } else { paidAmount = Convert.ToInt16(txtpaidamount.Text); } int totalDueAmount = 0; if (txtremainingdue.Text == "") { totalDueAmount = 0; } else { totalDueAmount = Convert.ToInt16(txtremainingdue.Text); } var totalDiscountTake = 0; if (txtdiscount.Text != "") { totalDiscountTake = Convert.ToInt32(txtdiscount.Text); } var totalDiscountParsentence = 0; if (txtpersentance.Text != "") { totalDiscountParsentence = Convert.ToInt32(txtpersentance.Text); } objData.BeginTransaction(ref strErr); strSQLUpdateInvertigation = "update dbo_Investigation SET TotalDue = " + txtremainingdue.Text + " ,DiscountTK=" + totalDiscountTake + ", DiscountPasentance=" + totalDiscountParsentence + ", DiscountByID =" + DincountByID + ", UpdatedOn = getdate() where InvestigationID =" + invid; objData.ExecuteQuery(strSQLUpdateInvertigation, ref strErr); if (strErr == "") { var strDueCollection = "insert into dbo_Inv_Due_Collection (investigationID, Paid_Amount, Paid_Type, UserId, UserPC) "; strDueCollection += " Values (" + invid + ", " + paidAmount + ", 'DI'," + hms.Include_Files.Utility.userID + ", '" + hms.Include_Files.Utility.PcName + "' )"; objData.ExecuteQuery(strDueCollection, ref strErr); if (strErr == "") { strSQLCASH = "insert into [dbo_CashMemo]([CM_SL], [InvetigationID], [Pay_Amount], [Due], USERID,UserPC) "; strSQLCASH = strSQLCASH + "Values (" + cashSL + ", " + invid + ", " + paidAmount + ", " + totalDueAmount + ", " + hms.Include_Files.Utility.userID + ", '" + hms.Include_Files.Utility.PcName + "')"; objData.ExecuteQuery(strSQLCASH, ref strErr); if (strErr == "") { string strSqlSpotCommission = "USP_Inv_Calculate_SpotCommission " + cmbInvestigation.Text.Split('/')[0] + "," + cmbInvestigation.Text.Split('/')[1] + "," + cmbInvestigation.Text.Split('/')[2]; objData.ExecuteQuery(strSqlSpotCommission, ref strErr); MessageBox.Show("Due Collection succefullty done"); objData.CommitTransaction(ref strErr); string strSQL = ""; strSQL = "USP_INV_DUE_Collection " + invid; DataTable arrAllInfo = objData.RetriveData(strSQL, ref strErr); DataSet ds = new DataSet(); ds.Tables.Add(arrAllInfo); dgvDueCollection.DataSource = ds.Tables["Table1"]; dgvDueCollection.Columns["Cash Memo"].DisplayIndex = 0; dgvDueCollection.Columns["Invertigation"].DisplayIndex = 1; //dgvDueCollection.Columns["Pay_Amount"].DisplayIndex = 2; var maxCashMemo = "select max(CM_ID) from dbo_CashMemo "; var arrCashmemo = objData.RetriveData(maxCashMemo, ref strErr); var cashId = 0; if (arrCashmemo.Rows.Count > 0) { cashId = Convert.ToInt32(arrCashmemo.Rows[0][0].ToString()); } 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); DataSet dscsh = new DataSet(); dscsh.Tables.Add(dtCashMemoInfo); var rptpath = Utility.ReportPath + "rptDueMoneyReceipt.rpt"; var reportDoc = new ReportDocument(); reportDoc.Load(rptpath); reportDoc.SetDataSource(dscsh.Tables[0]); //ReportDoc.SetParameterValue("UserName", Utility.UserName); Utility.Print(reportDoc, rptpath, 2); } else { MessageBox.Show("cash memo not creted."); objData.Rollback(ref strErr); } } else { MessageBox.Show("investigation not updated."); objData.Rollback(ref strErr); } } else { MessageBox.Show("investigation not updated."); objData.Rollback(ref strErr); } }
private void insertData() { //throw new NotImplementedException(); objetdata = new C_Data_Batch(); string strErr = ""; hms.Include_Files.Utility.ComboboxItem Department = cmbDepartment.SelectedItem as hms.Include_Files.Utility.ComboboxItem; hms.Include_Files.Utility.ComboboxItem Designation = cmbDesignation.SelectedItem as hms.Include_Files.Utility.ComboboxItem; if (Department != null && Designation != null) { var ValDepartment = Department.Value.ToString(); var ValDesignation = Designation.Value.ToString(); //var DeptID = 0; objetdata.OpenConnection("PolinPC-Office", ref strErr); string strSQL = ""; var Gender = "M"; if (txtgender.Text.ToString() == "F") { Gender = "F"; } var IsCommession = 0; if (chkIsCommession.Checked == true) { IsCommession = 1; } var isDoc = 0; if (chkDoctor.Checked == true) { isDoc = 1; } var valDocID = 0; if (isDoc.ToString() == "1") { valDocID = Convert.ToInt32(txtDoctorId.Text.ToString()); } var isparmanent = 0; if (chkParmanent.Checked == true) { isparmanent = 1; } strSQL = "Insert into dbo_Employee_Profiles ([Name],[PresentAddress],[Gender],[BloodGroup],"; strSQL = strSQL + "[JoiningDate],[Phone],[DateOfBirth],[ParmanentAddress],[IsDoctor],[IsCommession],[IsEmployment],[FatherName],[MotherName], [DocID]) "; strSQL = strSQL + " values ('" + txtEmployeeName.Text.ToString() + "','" + rtbPresentAddress.Text + "','" + Gender + "','" + txtBloodGroup.Text + "',"; strSQL = strSQL + "'" + dtpJoinDate.Text + "','" + txtMobileNo.Text + "','" + dtpDateOfBirth.Text + "',"; strSQL = strSQL + "'" + txtParmanentAddress.Text + "'," + isDoc + "," + IsCommession + "," + isparmanent + ",'" + txtFatherName.Text + "','" + txtMotherName.Text + "', " + valDocID + ")"; objetdata.BeginTransaction(ref strErr); objetdata.ExecuteQuery(strSQL, ref strErr); if (strErr == "") { strSQL = "Select Max(EmpID) From dbo_Employee_Profiles"; var arr = objetdata.RetriveData(strSQL, ref strErr); var EmpId = 1; if (arr.Rows[0][0].ToString() != "") { EmpId = Convert.ToInt32(arr.Rows[0][0].ToString()); strSQL = "Insert into dbo_Employee_Designation (EmpID, DegID) values (" + EmpId.ToString() + ", " + ValDesignation + ")"; objetdata.ExecuteQuery(strSQL, ref strErr); if (strErr == "") { strSQL = "Insert into dbo_Employee_Salary(EmpID, Basic, HouseRent, Medical, Others, InActive) "; strSQL = strSQL + " Values(" + EmpId.ToString() + ", " + txtBasic.Text + ", " + txthouse.Text + ", " + txtmedical.Text + ", " + txtother.Text + ", 1)"; objetdata.ExecuteQuery(strSQL, ref strErr); if (strErr == "") { objetdata.CommitTransaction(ref strErr); MessageBox.Show("Employe Insert succefully done."); clearFields(); getEmployeeID(); fillDepartment(); ShowdgvEmpprofile(); } else { objetdata.Rollback(ref strErr); MessageBox.Show("Employe Not Insert"); } } else { objetdata.Rollback(ref strErr); MessageBox.Show("Employe Not Insert"); } } else { objetdata.Rollback(ref strErr); MessageBox.Show("Employe Not Insert"); } } else { objetdata.Rollback(ref strErr); MessageBox.Show("Employe Not Insert"); } } else { MessageBox.Show("Please select Department or Designation"); } }
private void btnsave_Click(object sender, EventArgs e) { var serviceId = lstserviceinfo.SelectedItems.Count == 0 ? 0 : int.Parse(lstserviceinfo.SelectedValue.ToString()); var serviceName = serviceId == 0 ? txtServiceInfo.Text : ""; if (string.IsNullOrEmpty(serviceName.Trim()) && serviceId == 0 && admissionId == 0) { MessageBox.Show("Please enter service name."); txtServiceInfo.Focus(); return; } if (admissionId > 0 && serviceId == 0) { MessageBox.Show("Please select a service from list."); lstserviceinfo.Focus(); return; } var amount = 0; int.TryParse(txtamount.Text, out amount); var quantity = 0; int.TryParse(txtsl.Text, out quantity); var head = txthead.Text; var rmayCha = txtRmayCha.Text; var intFixed = 0; int.TryParse(txtfixed.SelectedValue.ToString(), out intFixed); var dataFor = txtdatafor.Text; var remarks = txtremark.Text; var serviceTakenDate = txtDate.Value.ToShortDateString(); var sql = ""; var msg = ""; if (serviceId == 0 && admissionId == 0) { sql = "INSERT INTO Dbo_Other_Service_List(Name,Amount,Head,RMay_cha,Fiexed,Data_For) VALUES('" + serviceName + "'," + amount + ",'" + head + "','" + rmayCha + "'," + intFixed + ",'" + dataFor + "')"; msg = "Service has been saved successfully."; } else if (serviceId > 0 && admissionId == 0) { sql = "UPDATE Dbo_Other_Service_List SET Amount=" + amount + ",Head='" + head + "',RMay_cha='" + rmayCha + "',Fiexed=" + intFixed + ",Data_For='" + dataFor + "',UpdatedOn=getdate() WHERE OSL_ID=" + serviceId; msg = "Service has been updated successfully."; } else if (admissionId > 0 && serviceId > 0) { if (quantity == 0) { MessageBox.Show(@"Please enter quantity of service."); txtsl.Focus(); return; } quantity = quantity == 0 ? 1 : quantity; sql = "INSERT INTO PatientServiceTaken(Admission_ID,Quentity,OSL_ID,Remarks,Amount,ServiceTakenDate,UserPC, UserID) VALUES(" + admissionId + "," + quantity + "," + serviceId + ",'" + remarks + "'," + amount + ",'" + serviceTakenDate + "','" + Utility.PcName + "', " + Utility.userID + ")"; msg = "Service has been taken successfully."; } if (sql != "") { objdata.OpenConnection("AatickPC-Home", ref strErr); objdata.ExecuteQuery(sql, ref strErr); objdata.CloseConnection(); MessageBox.Show(strErr == "" ? msg : "Data not saved.\nPlease try again later."); if (strErr == "" && serviceId == 0 && admissionId == 0) { GetOtherServices(); } else if (strErr == "" && admissionId > 0 && serviceId > 0) { LoadGrid(admissionId.ToString()); } } }
private void saveData() { if (txtYear.Text.Trim() == "") { MessageBox.Show("Please enter year!"); return; } int year; int.TryParse(txtYear.Text, out year); int month; int.TryParse(txtMonth.Text, out month); DateTime thisDay = DateTime.Today; Int64 DateDiff = Convert.ToInt64(((year * 12) + month) * 30); DateTime totalDays = thisDay.AddDays(-DateDiff); string birthDate = totalDays.Date.ToShortDateString(); string strYear = totalDays.Year.ToString(); string strmonth = ""; if (totalDays.Month < 10) { strmonth = "0" + totalDays.Month;; } else { strmonth = totalDays.Month.ToString(); } string strDay = ""; if (totalDays.Day < 10) { strDay = "0" + totalDays.Day; } else { strDay = totalDays.Day.ToString(); } int intInvestigationType = 0; if (rbtngenaral.Checked == true) { intInvestigationType = 1; } else if (rbtnopd.Checked == true) { intInvestigationType = 2; } else { intInvestigationType = 1; } int intInvestigationDeptType = 0; if (rbtnpathology.Checked == true) { intInvestigationDeptType = 1; } else if (rbtndental.Checked == true) { intInvestigationDeptType = 2; } else if (rbtnbloodbank.Checked == true) { intInvestigationDeptType = 3; } else if (rbtndialysis.Checked == true) { intInvestigationDeptType = 4; } else { intInvestigationDeptType = 1; } var isUpdate = (rbtnindoor.Checked && !string.IsNullOrEmpty(txtAdmissionSl.Text.Trim())) ? true : false; objData.BeginTransaction(ref strErr); string strPatSql = ""; strPatSql = "INSERT INTO [dbo_Patient_info]([Name],[PresentAddress],[Phone],[Year],[Month],[Day],[Gender],[BirthDate], UserID,UserPC) "; strPatSql = strPatSql + "VALUES('" + txtname.Text + "','" + txtaddress.Text + "','" + txtphone.Text; strPatSql = strPatSql + "'," + year + "," + month + ",0,'" + txtsex.SelectedValue + "','" + birthDate + "', " + Utility.userID + ",'" + Utility.PcName + "')"; if (isUpdate) { strPatSql = "UPDATE dbo_Patient_info SET Name='" + txtname.Text + "',PresentAddress='" + txtaddress.Text + "',Phone='" + txtphone.Text + "',Year=" + txtYear.Text + ",Month=" + txtMonth.Text + ",Gender='" + txtsex.SelectedValue + "',BirthDate='" + birthDate + "',UserID=" + Utility.userID + " WHERE P_ID=" + txtid.Text + ";"; } objData.ExecuteQuery(strPatSql, ref strErr); if (strErr == "") { string strInvFndSL = ""; strInvFndSL = "select case when max(Invetigation_SL) is null then 1001 else max(Invetigation_SL)+1 end From dbo_Investigation where month(CreatedON) = month(getdate()) AND YEAR(CreatedON) = YEAR(getdate()) "; DataTable arrMaxInvSL = objData.RetriveData(strInvFndSL, ref strErr); if (strErr == "") { int maxInvSlL = 0; maxInvSlL = Convert.ToInt32(arrMaxInvSL.Rows[0][0].ToString()); string strP_ID = "select CASE WHEN max(p_ID) IS NULL THEN 0 ELSE max(p_ID) END From dbo_Patient_info "; DataTable arrp_ID = objData.RetriveData(strP_ID, ref strErr); int p_IDval = 0; p_IDval = Convert.ToInt32(arrp_ID.Rows[0][0].ToString()); if (isUpdate) { p_IDval = Convert.ToInt32(txtid.Text); } var pc = txtpc.Text; if (pc.Trim() == "") { pc = "0"; } var disciuntBy = lstDiscount.SelectedIndex == -1 ? "0" : lstDiscount.SelectedValue.ToString(); string strInvSql = ""; strInvSql = "INSERT INTO [dbo_Investigation]([DocID],[DiscountTK],[DiscountPasentance],[TotalDue],[InvestigationType],[InvestigationDeptType]"; strInvSql = strInvSql + " ,[P_ID],[Invetigation_SL],[PC_CC], [userID],[UserPC], DiscountByID" + (isUpdate ? ",[Admission_id]" : "") + ")"; strInvSql = strInvSql + " Values (" + txtdoctorid.Text + ", " + txtdiscount.Text + ", " + txtdiscouuntpersentnance.Text + ", " + txttotaldue.Text; strInvSql = strInvSql + ", " + intInvestigationType + ", " + intInvestigationDeptType + ", " + p_IDval + ", " + maxInvSlL + ", " + pc + "," + Utility.userID + ",'" + Utility.PcName + "'," + disciuntBy + (isUpdate ? "," + lblAdmissionId.Text : "") + " )"; objData.ExecuteQuery(strInvSql, ref strErr); if (strErr == "") { string strMaxInvID = ""; strMaxInvID = "select max(Investigationid) from dbo_Investigation"; DataTable arrMaxInvID = objData.RetriveData(strMaxInvID, ref strErr); if (strErr == "") { int maxInvID = 0; if (arrMaxInvID.Rows.Count > 0) { if (arrMaxInvID.Rows[0][0].ToString() == "") { maxInvID = 0; } else { maxInvID = Convert.ToInt32(arrMaxInvID.Rows[0][0].ToString()); } } else { maxInvID = 0; } string strSqlInvItem = ""; for (int i = 0; i < dgvInvestigation.Rows.Count; i++) { if (strSqlInvItem == "") { strSqlInvItem = " (" + maxInvID + ", " + dgvInvestigation.Rows[i].Cells[1].Value + ",getdate(), 0," + Utility.userID + ", " + dgvInvestigation.Rows[i].Cells[3].Value + ",'" + dgvInvestigation.Rows[i].Cells[4].Value + "' ,'" + dgvInvestigation.Rows[i].Cells[5].Value + "','" + Utility.PcName + "' )"; } else { strSqlInvItem = strSqlInvItem + ", (" + maxInvID + ", " + dgvInvestigation.Rows[i].Cells[1].Value + ",getdate(), 0," + Utility.userID + ", " + dgvInvestigation.Rows[i].Cells[3].Value + ",'" + dgvInvestigation.Rows[i].Cells[4].Value + "' ,'" + dgvInvestigation.Rows[i].Cells[5].Value + "','" + Utility.PcName + "' )"; } } if (strSqlInvItem != "") { string strSqlInvItemMain = "INSERT INTO [dbo_InvertigationServiceItem]([Investigationid],[Service_ID],[Date],[Status],[UserID],Amount, DeliveryOn, Remaks,UserPC) Values " + strSqlInvItem; objData.ExecuteQuery(strSqlInvItemMain, ref strErr); if (strErr == "") { string strSqlSpotCommission = "USP_Inv_Calculate_SpotCommission " + maxInvSlL + "," + DateTime.Today.Month + "," + DateTime.Today.Year; objData.ExecuteQuery(strSqlSpotCommission, ref strErr); getPrint(maxInvID.ToString()); objData.CommitTransaction(ref strErr); frmload(); objData.CloseConnection(); } else { objData.Rollback(ref strErr); } } } else { objData.Rollback(ref strErr); } } else { objData.Rollback(ref strErr); } } else { objData.Rollback(ref strErr); } } else { objData.Rollback(ref strErr); } }
private void SaveAdmissionInfo() { var userid = Utility.userID; var patientName = txtPatientName.Text; int d, m, y; int.TryParse(txtdd.Text, out d); int.TryParse(txtmm.Text, out m); int.TryParse(txtyyy.Text, out y); if (y == 0 && m == 0 && d == 0) { MessageBox.Show("Please enter age."); txtyyy.Focus(); return; } var day = d.ToString(); var month = m.ToString(); var year = y.ToString(); var gender = txtgender.SelectedValue; var isFathertemp = rbtnfathername.Checked; var isHusbandtemp = rbtnhusbandname.Checked; var txtFatherOrHusband = txtFatherOrHusbandname.Text; var mothername = txtMotherName.Text; var religion = txtReligion.SelectedValue; var occupation = txtoccupation.Text; var guardian = txtguardian.Text; var guardianAddress = txtGuardianAddress.Text; var patientPresentAddress = txtpresentaddress.Text; var patientParmanentAddress = txtpermanetaddress.Text; var patientPhone = txtphone.Text; var dtbirthDate = DateTime.Now.AddYears(int.Parse("-" + year)).AddMonths(int.Parse("-" + month)).AddDays(int.Parse("-" + day)); var isFather = isHusbandtemp ? 0 : 1; var hospitalFee = 0; int.TryParse(txtFee.Text, out hospitalFee); var advance = txtadvance.Text == "" ? "0" : txtadvance.Text; var selectedBed = lstBedInfo.CurrentRow; var strErr = ""; objData.OpenConnection("AatickPC-Office", ref strErr); objData.BeginTransaction(ref strErr); var p_id = 0; //var sqlpatientSl = "SELECT '" + dtbirthDate.ToString("yyyyMMdd") + "'+ CASE WHEN MAX(P_ID) IS NULL THEN '1' ELSE CAST((MAX(P_ID)+1) AS VARCHAR(20)) END FROM dbo_patient_info WHERE CreatedOn>='" + new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToShortDateString() + "'"; //var dtpatientSl = objData.RetriveData(sqlpatientSl, ref strErr); var insertPatientinfo = "Insert into dbo_patient_info(Name,PresentAddress,Phone,Year,Month,Day,Gender,BirthDate,UserID,UserPC) values"; insertPatientinfo += "('" + patientName + "','" + patientPresentAddress + "','" + patientPhone + "'," + year + "," + month + "," + day + ",'" + gender + "','" + dtbirthDate + "'," + userid + ",'" + Utility.PcName + "')"; objData.ExecuteQuery(insertPatientinfo, ref strErr); var intAdmissionId = ""; var maxCashId = ""; if (strErr == "") { var sqlSelectPatientId = "select max(p_id) from dbo_patient_info"; var dtSelectPatientId = objData.RetriveData(sqlSelectPatientId, ref strErr); if (strErr == "") { p_id = int.Parse(dtSelectPatientId.Rows[0][0].ToString()); var sqlInsertPatientOtherInfo = "Insert into dbo_Patient_other_info(P_ID,IsFather,ForH_Name,Region,Occupation,Guardian,Parmanent_address,Mother_Name,Gurdian_Address,Guardian_Relation) values"; sqlInsertPatientOtherInfo += "(" + p_id + "," + isFather + ",'" + txtFatherOrHusband + "','" + religion + "','" + occupation + "','" + guardian + "','" + patientParmanentAddress + "','" + mothername + "','" + guardianAddress + "','" + txtRelation.Text + "')"; objData.ExecuteQuery(sqlInsertPatientOtherInfo, ref strErr); if (strErr == "") { var refDocid = txtdoctorid.Text; var underDocid = txtadmissonunder.Text; var sqladmissionSl = "SELECT CASE WHEN MAX(Admission_SL) IS NULL THEN 1001 ELSE MAX(Admission_SL)+1 END FROM dbo_Admission WHERE CreatedOn>='" + new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToShortDateString() + "'"; var dtAddmissionSl = objData.RetriveData(sqladmissionSl, ref strErr); if (strErr == "") { var insertAddmissioninfosql = "INSERT INTO dbo_Admission(P_ID,Reference_Doc_ID,Under_Doc_ID,Admission_SL,UserID,UserPC,Hospital_Fee) VALUES(" + p_id + "," + refDocid + "," + underDocid + "," + dtAddmissionSl.Rows[0][0] + "," + Utility.userID + ",'" + Utility.PcName + "'," + hospitalFee + ")"; objData.ExecuteQuery(insertAddmissioninfosql, ref strErr); if (strErr == "") { var sqlSelectAdmissionId = "select max(Admission_id) from dbo_Admission"; var dtSelectAdmissionId = objData.RetriveData(sqlSelectAdmissionId, ref strErr); if (strErr == "") { intAdmissionId = dtSelectAdmissionId.Rows[0][0].ToString(); var insertAdmissionOtherinfosql = "INSERT INTO dbo_Admission_other_info(Admission_Id,Provisional_Diagnosis,ListOfDiagnosis) VALUES(" + dtSelectAdmissionId.Rows[0][0] + ",'" + txtprovisionsis.Text + "','" + txtlistofdocument.Text + "')"; objData.ExecuteQuery(insertAdmissionOtherinfosql, ref strErr); if (strErr == "") { var insertBedinfosql = "INSERT INTO Patient_Bed(BI_ID,Admission_id,Booked_On,isBooked,Note,UserID,UserPC) VALUES(" + selectedBed.Cells[0].Value + "," + dtSelectAdmissionId.Rows[0][0] + ",getdate(),1,'" + selectedBed.Cells[5].Value + "'," + Utility.userID + ",'" + Utility.PcName + "')"; objData.ExecuteQuery(insertBedinfosql, ref strErr); if (strErr == "") { if (!string.IsNullOrEmpty(advance)) { var insertDepositinfosql = "INSERT INTO Hospital_Deposit(Admission_id,Deposit_amount,Deposit_On,UserID,UserPC,Deposite_Type) VALUES(" + dtSelectAdmissionId.Rows[0][0] + ",'" + advance + "',getdate()," + Utility.userID + ",'" + Utility.PcName + "','A')"; objData.ExecuteQuery(insertDepositinfosql, ref strErr); if (strErr == "") { var sqlcashSl = "SELECT CASE WHEN MAX(CM_SL) IS NULL THEN 1001 ELSE MAX(CM_SL)+1 END FROM dbo_CashMemo WHERE CreatedOn>='" + new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1) .ToShortDateString() + "'"; var dtACashSl = objData.RetriveData(sqlcashSl, ref strErr); if (strErr == "") { var insertCashMemosql = "INSERT INTO dbo_CashMemo(Admission_ID,CM_SL,Pay_Amount,USERID,UserPC) VALUES(" + dtSelectAdmissionId.Rows[0][0] + "," + dtACashSl.Rows[0][0] + "," + advance + "," + userid + ",'" + Utility.PcName + "')"; objData.ExecuteQuery(insertCashMemosql, ref strErr); var selectCashMaxId = "SELECT MAX(CM_ID) FROM dbo_CashMemo;"; var arrMaxCashId = objData.RetriveData(selectCashMaxId, ref strErr); maxCashId = arrMaxCashId.Rows[0][0].ToString(); } } } } } } } } } } } var msg = ""; if (strErr != "") { objData.Rollback(ref strErr); msg = "An Error occured.\nTry again later."; } else { objData.CommitTransaction(ref strErr); msg = @"Successfully admitted"; } objData.CloseConnection(); if (strErr == "") { SetNewEnv(); } MessageBox.Show(msg); if (strErr == "") { ShowAdmissionReport(intAdmissionId); PrintMoneyReceipt(maxCashId); } btnpreview.Enabled = true; }
private void SaveData() { //throw new NotImplementedException(); string strSqlUpdateItems = ""; string strSqlInsertHistory = ""; string strIDs = ""; var strMsg = ""; hms.Include_Files.Utility.ComboboxItem LabData = lbPathlab.SelectedItem as hms.Include_Files.Utility.ComboboxItem; var ReportId = 2; if (LabData != null) { ReportId = Convert.ToInt16(LabData.Value.ToString()) + 1; } if (Convert.ToInt32(dgvPathLab.Rows.Count) - 1 > 0) { for (int i = 0; i < dgvPathLab.Rows.Count - 1; i++) { if ((bool)dgvPathLab.Rows[i].Cells[0].FormattedValue == true) { if (strIDs.ToString() == "") { strIDs = dgvPathLab.Rows[i].Cells[9].Value.ToString(); strSqlInsertHistory = " (" + dgvPathLab.Rows[i].Cells[9].Value.ToString() + ", " + ReportId + ", " + hms.Include_Files.Utility.userID + ",'" + Utility.PcName + "')"; } else { strIDs = strIDs + ", " + dgvPathLab.Rows[i].Cells[9].Value.ToString(); strSqlInsertHistory = strSqlInsertHistory + ", (" + dgvPathLab.Rows[i].Cells[9].Value.ToString() + ", " + ReportId + ", " + hms.Include_Files.Utility.userID + ",'" + Utility.PcName + "')"; } } } } if (strIDs.ToString() != "") { strSqlUpdateItems = "Update dbo_InvertigationServiceItem SET Status=" + ReportId + " where [ISI_ID] in (" + strIDs.ToString() + ")"; strSqlInsertHistory = "insert into Investigation_Serviceitem_History (ISI_ID, Status, UserID,userPC) values " + strSqlInsertHistory; objData = new C_Data_Batch(); objData.OpenConnection("AzharPC-Home", ref strErr); objData.BeginTransaction(ref strErr); if (strErr.ToString() == "") { objData.ExecuteQuery(strSqlUpdateItems, ref strErr); if (strErr.ToString() == "") { objData.ExecuteQuery(strSqlInsertHistory, ref strErr); if (strErr.ToString() == "") { //MessageBox.Show("sample collection saved succefully done."); hms.Include_Files.Utility.ComboboxItem LabDataMsg = lbPathlab.SelectedItem as hms.Include_Files.Utility.ComboboxItem; strMsg = "Test Complete"; if (LabDataMsg != null) { strMsg = LabDataMsg.Name; } strMsg = strMsg + " saved succefully done."; MessageBox.Show(strMsg); objData.CommitTransaction(ref strErr); frmLoad(); } else { objData.Rollback(ref strErr); MessageBox.Show("System cannot deal at this moment."); } } else { objData.Rollback(ref strErr); MessageBox.Show("System cannot deal at this moment."); } } } }
private void btnsave_Click(object sender, EventArgs e) { var addmissionId = txtAdmissionId.Text; var payAmount = 0; int.TryParse(txtdepositamount.Text, out payAmount); if (payAmount == 0) { MessageBox.Show(@"Please enter deposit amount."); txtdepositamount.Focus(); return; } if (!string.IsNullOrEmpty(txtdiscount.Text) || !string.IsNullOrEmpty(txtpersentance.Text)) { if (lstDiscountType.SelectedItems.Count == 0) { MessageBox.Show(@"Please select discount type."); return; } if (lstdiscountby.SelectedItems.Count == 0) { MessageBox.Show(@"Please select discount by."); return; } } var dueAmount = txtremainingdue.Text; var userId = Utility.userID; var cashMemoSl = ""; var cashId = ""; strErr = ""; var msg = ""; objData.OpenConnection("AatickPC-Office", ref strErr); var sqlCashMemoSl = "SELECT CASE WHEN MAX(CM_SL) IS NULL THEN 1001 ELSE MAX(CM_SL)+1 END FROM dbo_CashMemo WHERE CreatedOn>='" + new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToShortDateString() + "'"; var dtCashMemoSl = objData.RetriveData(sqlCashMemoSl, ref strErr); cashMemoSl = dtCashMemoSl.Rows[0][0].ToString(); if (txtReturnAmount.Visible && !string.IsNullOrEmpty(txtReturnAmount.Text)) { var insertReturnsql = "INSERT INTO dbo_CashMemo(CM_SL,Admission_ID,USERID,Return_Amount,UserPC) VALUES('" + cashMemoSl + "'," + addmissionId + "," + userId + ",'" + txtReturnAmount.Text + "','" + Utility.PcName + "')"; objData.ExecuteQuery(insertReturnsql, ref strErr); if (strErr == "") { var maxCashMemoSql = "SELECT MAX(CM_ID) FROM dbo_CashMemo;"; var arrCashId = objData.RetriveData(maxCashMemoSql, ref strErr); if (strErr == "") { cashId = arrCashId.Rows[0][0].ToString(); } } msg = strErr != "" ? "An error occured.\nPlease try again later." : "Successfully saved."; } else { objData.BeginTransaction(ref strErr); var insertDepositinfosql = "INSERT INTO Hospital_Deposit(Admission_id,Deposit_amount,Deposit_On,UserPC,Deposite_Type,UserID) VALUES(" + addmissionId + ",'" + payAmount + "',getdate(),'" + Utility.PcName + "','AD'," + Utility.userID + ")"; objData.ExecuteQuery(insertDepositinfosql, ref strErr); if (strErr == "") { var insertCashinfosql = "INSERT INTO dbo_CashMemo(CM_SL,Admission_ID,Pay_Amount,Due,USERID,Remarks,UserPC) VALUES('" + cashMemoSl + "'," + addmissionId + ",'" + payAmount + "','" + dueAmount + "'," + userId + ",'" + txtremarks.Text + "','" + Utility.PcName + "')"; objData.ExecuteQuery(insertCashinfosql, ref strErr); if (strErr == "") { var maxCashMemoSql = "SELECT MAX(CM_ID) FROM dbo_CashMemo;"; var arrCashId = objData.RetriveData(maxCashMemoSql, ref strErr); if (strErr == "") { cashId = arrCashId.Rows[0][0].ToString(); if (!string.IsNullOrEmpty(txtdiscount.Text) || !string.IsNullOrEmpty(txtpersentance.Text)) { var sql = "INSERT INTO dbo_Admission_Discount(Admission_Id,Discount_Amount,Discount_Percentage,Discount_Type,DiscountBy_Id,UserId,UserPc) VALUES(" + addmissionId + ",'" + GetDiscountAmount() + "','" + (string.IsNullOrEmpty(txtpersentance.Text) ? "0" : txtpersentance.Text) + "','" + lstDiscountType.SelectedValue + "','" + txtdiscountby.Text + "'," + Utility.userID + ",'" + Utility.PcName + "')"; objData.ExecuteQuery(sql, ref strErr); var updateAdmissioninfosql = "UPDATE dbo_Admission SET DiscountByID='" + txtdiscountby.Text + "', DiscountTK=ISNULL(DiscountTK,0)+" + GetDiscountAmount() + ",DiscountPercentage='0',UserId=" + Utility.userID + ",UserPc='" + Utility.PcName + "' WHERE Admission_Id=" + addmissionId; objData.ExecuteQuery(updateAdmissioninfosql, ref strErr); } } } } if (strErr != "") { objData.Rollback(ref strErr); msg = "An error occured.\nPlease try again later."; } else { objData.CommitTransaction(ref strErr); msg = "Successfully saved."; } } objData.CloseConnection(); MessageBox.Show(msg); if (strErr == "") { LoadAddmissionInfo(addmissionId); ShowMoneyReceipt(cashId); } }