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 fillDesignation()
{
//throw new NotImplementedException();
objetdata = new C_Data_Batch();
string strErr = "";
objetdata.OpenConnection("PolinPC-Office", ref strErr);
string strSQL = "";
hms.Include_Files.Utility.ComboboxItem itms = cmbDepartment.SelectedItem as hms.Include_Files.Utility.ComboboxItem;
var DeptID = 0;
if (itms != null)
{
DeptID = itms.Value;
strSQL = "select DegId, Designation from dbo_Designation where DeptID= " + DeptID + " order by DeptID Desc ";
DataTable arrDept = objetdata.RetriveData(strSQL, ref strErr);
objetdata.CloseConnection();
//DataSet ds = new DataSet();
//ds.Tables.Add(arrDept);
//dgvEmpprofile.DataSource = ds.Tables["Table1"];
cmbDesignation.Items.Clear();
if (arrDept.Rows.Count > 0)
{
for (int i = 0; i < arrDept.Rows.Count; i++)
{
cmbDesignation.Items.Add(new hms.Include_Files.Utility.ComboboxItem(arrDept.Rows[i][1].ToString(), Convert.ToInt32(arrDept.Rows[i][0].ToString())));
}
}
}
else
{
MessageBox.Show("Please select the Department");
}
}
private void dgvServcieInformation_Click(object sender, EventArgs e)
{
txtServiceID.Text = dgvServcieInformation.CurrentRow.Cells[0].Value.ToString();
cmbCategory.SelectedIndex = cmbCategory.FindStringExact(dgvServcieInformation.CurrentRow.Cells[1].Value.ToString());
hms.Include_Files.Utility.ComboboxItem valCategory = cmbCategory.SelectedItem as hms.Include_Files.Utility.ComboboxItem;
if (valCategory != null)
{
txtcatagory.Text = valCategory.Value.ToString();
}
//txtcatagory.Text = "";
cmbCommission.SelectedIndex = cmbCommission.FindStringExact(dgvServcieInformation.CurrentRow.Cells[5].Value.ToString());
cmbDurationType.SelectedIndex = cmbDurationType.FindStringExact(dgvServcieInformation.CurrentRow.Cells[7].Value.ToString());
txtcommistion.Text = dgvServcieInformation.CurrentRow.Cells[4].Value.ToString();
txtpc.Text = dgvServcieInformation.CurrentRow.Cells[6].Value.ToString();
txtservicecharge.Text = dgvServcieInformation.CurrentRow.Cells[3].Value.ToString();
txtservicename.Text = dgvServcieInformation.CurrentRow.Cells[2].Value.ToString();
txtDuration.Text = dgvServcieInformation.CurrentRow.Cells[6].Value.ToString();
if (dgvServcieInformation.CurrentRow.Cells[10].Value.ToString() == "True")
{
chkSample.Checked = true;
}
else
{
chkSample.Checked = false;
}
//chkSample.Checked = false;
txtSample.Text = dgvServcieInformation.CurrentRow.Cells[9].Value.ToString();
}
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();
}
private void cmbServices_SelectedIndexChanged(object sender, EventArgs e)
{
hms.Include_Files.Utility.ComboboxItem itms = cmbServices.SelectedItem as hms.Include_Files.Utility.ComboboxItem;
if (itms != null)
{
txtServiceID.Text = itms.Value.ToString();
}
}
private void cmbMarktingOfficer_SelectedIndexChanged(object sender, EventArgs e)
{
hms.Include_Files.Utility.ComboboxItem itms = cmbMarktingOfficer.SelectedItem as hms.Include_Files.Utility.ComboboxItem;
if (itms != null)
{
txtMarketingBy.Text = itms.Name.ToString();
}
}
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 dgvServiceWiseSetup_CellClick(object sender, DataGridViewCellEventArgs e)
{
txtSIT_ID.Text = dgvServiceWiseSetup.CurrentRow.Cells[0].Value.ToString();
cmbServices.SelectedIndex = cmbServices.FindStringExact(dgvServiceWiseSetup.CurrentRow.Cells[1].Value.ToString());
hms.Include_Files.Utility.ComboboxItem valService = cmbServices.SelectedItem as hms.Include_Files.Utility.ComboboxItem;
if (valService != null)
{
txtServiceID.Text = valService.Value.ToString();
}
else
{
txtServiceID.Text = "";
}
txtOGroup.Text = dgvServiceWiseSetup.CurrentRow.Cells[2].Value.ToString();
txtEntity.Text = dgvServiceWiseSetup.CurrentRow.Cells[3].Value.ToString();
txtUnit.Text = dgvServiceWiseSetup.CurrentRow.Cells[4].Value.ToString();
txtRefRenge.Text = dgvServiceWiseSetup.CurrentRow.Cells[5].Value.ToString();
txtResultB.Text = dgvServiceWiseSetup.CurrentRow.Cells[6].Value.ToString();
}
private void dgvPathLab_DoubleClick(object sender, EventArgs e)
{
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());
}
if (ReportId == 3)
{
frmPathologyLabProcess f = new frmPathologyLabProcess(dgvPathLab.CurrentRow.Cells[8].Value.ToString());
f.Show();
}
//new frmPathologyLabProcess() { Owner = this }.ShowDialog();
//new frmAdmitedPatientList() { Owner = this }.ShowDialog();
//var val =
//MessageBox.Show(loadInvestigationID());
}
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 fillGridView()
{
//throw new NotImplementedException();
hms.Include_Files.Utility.ComboboxItem LabData = lbPathlab.SelectedItem as hms.Include_Files.Utility.ComboboxItem;
var ReportId = 1;
if (LabData != null)
{
ReportId = LabData.Value;
}
var ids = "";
for (var i = 0; i < gbtestcatagory.Controls.Count; i++)
{
if (gbtestcatagory.Controls[i] is CheckBox)
{
if (((CheckBox)gbtestcatagory.Controls[i]).Checked)
{
if (ids == "")
{
ids = ((CheckBox)gbtestcatagory.Controls[i]).Tag.ToString();
}
else
{
ids += "," + ((CheckBox)gbtestcatagory.Controls[i]).Tag.ToString();
}
}
}
}
string strSQL = "";
strSQL = "select cast(inv.Invetigation_SL as varchar(6))+'/'+cast( MONTH(inv.CreatedON) as varchar(2))+'/'+cast(year(inv.CreatedON) as varchar(4)) investigation ";
strSQL = strSQL + ", inv.CreatedON 'Date', s.Service_Name 'Test Name', s.Sample_Type 'Sample Type'";
strSQL = strSQL + ", p.Name+'('+cast(datediff(year, p.BirthDate, getdate()) as varchar(3))+'Y)' 'Tatient' ";
strSQL = strSQL + ",d.Name 'Doctor', s.Amount 'Charge' ,inv.InvestigationID, items.ISI_ID ";
strSQL = strSQL + "From dbo_Investigation Inv inner join dbo_Patient_info P On inv.P_ID = p.P_ID ";
strSQL = strSQL + "inner join dbo_Doctor_List D on inv.DocID=d.DocID ";
strSQL = strSQL + "inner Join dbo_InvertigationServiceItem items on inv.InvestigationID=items.Investigationid ";
strSQL = strSQL + "Inner join Dbo_Services S on s.Service_ID = items.Service_ID ";
if (ReportId == 3)
{
strSQL = strSQL + "where items.Status >= " + ReportId;
}
else
{
strSQL = strSQL + "where items.Status = " + ReportId;
}
if (ids != "")
{
strSQL = strSQL + " And S.Category_ID in (" + ids + ")";
}
string strVal = "";
strVal = txtinvestigationid.Text;
string[] arrinv = strVal.Split(new string[] { "/" }, StringSplitOptions.None);
if (arrinv.Length.ToString() == "3")
{
if (arrinv[0].ToString() == "")
{
//MessageBox.Show("please enter valid investifgation no.");
}
else
{
if (arrinv[1].ToString() == "")
{
//MessageBox.Show("please enter valid Month no.");
}
else
{
if (arrinv[2].ToString() == "")
{
//MessageBox.Show("please enter valid year no.");
}
else
{
strSQL = strSQL + " and inv.Invetigation_SL= " + arrinv[0].Trim();
strSQL = strSQL + " and MONTH(inv.CreatedON)= " + arrinv[1].Trim();
strSQL = strSQL + " and year(inv.CreatedON)= " + arrinv[2].Trim();
}
}
}
}
//objData = new C_Data_Batch();
//objData.OpenConnection("AzharPC-Home", ref strErr);
DataTable arrSample = objData.RetriveData(strSQL, ref strErr);
DataSet ds = new DataSet();
ds.Tables.Add(arrSample);
dgvPathLab.DataSource = ds.Tables["Table1"];
dgvPathLab.Columns["InvestigationID"].Visible = false;
dgvPathLab.Columns["ISI_ID"].Visible = false;
}
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.");
}
}
}
}
