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