private void frmDerpartmentSetup_Load(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
frmLoad();
objData.CloseConnection();
}
private void button3_Click(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
frmLoad();
objData.CloseConnection();
}
private void lsttestname_SelectedIndexChanged(object sender, EventArgs e)
{
if (isFirstTime != "0")
{
return;
}
var sql = "select Amount from Dbo_Services where service_id = " + lsttestname.SelectedValue;
//C_Data_Batch objData;
strErr = "";
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Office", ref strErr);
var arrServicePrice = objData.RetriveData(sql, ref strErr);
if (strErr == "")
{
if (arrServicePrice.Rows.Count > 0)
{
lblServicePrice.Text = arrServicePrice.Rows[0][0].ToString();
}
else
{
lblServicePrice.Text = "";
}
}
else
{
lblServicePrice.Text = "";
}
objData.CloseConnection();
}
private void 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 cmbInvestigation_SelectedIndexChanged(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
loadall();
objData.CloseConnection();
}
private void addService()
{
if (lsttestname.SelectedIndex > -1)
{
var isVal = false;
for (int i = 0; i < dgvInvestigation.Rows.Count; i++)
{
if (dgvInvestigation.Rows[i].Cells[1].Value.ToString() == lsttestname.SelectedValue.ToString())
{
isVal = true;
break;
}
}
if (!isVal)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
string strSQL = "";
strSQL = "Select s.Service_ID, s.Service_Name, s.Amount ,(case when Duraion_Type = 1 then dateadd(hh, Dutaion, getdate()) else dateadd(day,Dutaion, getdate() ) end ) 'Delivery Date' , '' Remarks from Dbo_Services S where service_id in (" + lsttestname.SelectedValue + ")";
DataTable arrservice = objData.RetriveData(strSQL, ref strErr);
dgvInvestigation.Rows.Add(false, arrservice.Rows[0][0].ToString(), arrservice.Rows[0][1].ToString(), arrservice.Rows[0][2].ToString(), arrservice.Rows[0][3].ToString(), arrservice.Rows[0][4].ToString());
dgvInvestigation.AutoResizeColumn(0, DataGridViewAutoSizeColumnMode.ColumnHeader);
getTotalCalculation();
objData.CloseConnection();
}
}
}
private void txtinvestigationid_KeyUp(object sender, KeyEventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
fillGridView();
objData.CloseConnection();
}
private void btnpreview_Click(object sender, EventArgs e)
{
objData = new C_Data_Batch();
string strErr = "";
objData.OpenConnection("PolinPC-Office", ref strErr);
//txtCategoryID
string strSQL = "";
strSQL = "select Category_ID, Category_Name from Dbo_Service_Category where Category_ID = 2 order by Category_ID Desc";
DataTable arrCatList = objData.RetriveData(strSQL, ref strErr);
objData.CloseConnection();
DataSet ds = new DataSet();
ds.Tables.Add(arrCatList);
frmReport reportviewer = new frmReport();
var rptpath = Utility.ReportPath + "rptCategory.rpt";
reportviewer.ReportPath = rptpath;
reportviewer.Reportds = ds;
reportviewer.Show(this);
}
private void getcategorid()
{
objData = new C_Data_Batch();
string strErr = "";
objData.OpenConnection("PolinPC-Office", ref strErr);
//txtCategoryID
string strSQL = "";
strSQL = "select max(Category_ID) from Dbo_Service_Category";
DataTable arrCatID = objData.RetriveData(strSQL, ref strErr);
objData.CloseConnection();
int CatId = 0;
if (arrCatID.Rows.Count > 0)
{
if (arrCatID.Rows[0][0].ToString() == "")
{
CatId = 1;
}
else
{
CatId = Convert.ToInt32(arrCatID.Rows[0][0].ToString()) + 1;
}
}
else
{
CatId = 1;
}
txtCategoryID.Text = CatId.ToString();
}
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 getServiceID()
{
//throw new NotImplementedException();
objData = new C_Data_Batch();
string strErr = "";
objData.OpenConnection("PolinPC-Office", ref strErr);
//txtCategoryID
string strSQL = "";
strSQL = "select max(Service_ID) from Dbo_Services";
DataTable arrID = objData.RetriveData(strSQL, ref strErr);
objData.CloseConnection();
int Id = 0;
if (arrID.Rows.Count > 0)
{
if (arrID.Rows[0][0].ToString() == "")
{
Id = 1;
}
else
{
Id = Convert.ToInt32(arrID.Rows[0][0].ToString()) + 1;
}
}
else
{
Id = 1;
}
txtServiceID.Text = Id.ToString();
}
private void btnpreview_Click(object sender, EventArgs e)
{
objData = new C_Data_Batch();
string strErr = "";
objData.OpenConnection("PolinPC-Office", ref strErr);
//txtCategoryID
string strSQL = "";
strSQL = "SELECT [Service_ID],cat.Category_Name,[Service_Name],[Amount],[Commission],case when [Commision_Type] = 1 then '%' else 'Tk' end 'Commision Type',[Dutaion] ,case when [Duraion_Type] = 1 then 'Hour' else 'day' end 'Duraion Type' ,[CC_PC],[Sample_Type],[isSample] FROM [Dbo_Services] S Inner Join dbo_Service_category Cat On S.Category_ID = CAt.Category_ID order by Service_id Desc";
DataTable arrCatList = objData.RetriveData(strSQL, ref strErr);
objData.CloseConnection();
DataSet ds = new DataSet();
ds.Tables.Add(arrCatList);
frmReport reportviewer = new frmReport();
var rptpath = Utility.ReportPath + "rptServices.rpt";
reportviewer.ReportPath = rptpath;
reportviewer.Reportds = ds;
reportviewer.Show(this);
}
private void selectDoctorInfo()
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
loadDoctorInformation();
objData.CloseConnection();
}
private void frmPathologylab_Load(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
frmLoad();
objData.CloseConnection();
}
private void loaddoctor()
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
getDocList(txtdoctorinformation.Text.Trim());
objData.CloseConnection();
}
private void btnsave_Click(object sender, EventArgs e)
{
//MessageBox.Show(dgvRetrurn.Rows[0].Cells[0].Value.ToString());
//MessageBox.Show(dgvRetrurn.Rows[1].Cells[17].Value.ToString());
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
string strSQL = "";
objData.BeginTransaction(ref strErr);
for (int i = 0; i < dgvRetrurn.Rows.Count - 1; i++)
{
if (Convert.ToInt16(dgvRetrurn.Rows[i].Cells[3].Value.ToString()) > 0)
{
strSQL = "update dbo_InvertigationServiceItem set isreturn =1, return_on = getdate(), Return_Amount = " + dgvRetrurn.Rows[i].Cells[3].Value + ", ReturnUserID =" + Utility.userID + " , ReturnUserPC='" + Utility.PcName + "' where ISI_ID=" + dgvRetrurn.Rows[i].Cells[17].Value;
objData.ExecuteQuery(strSQL, ref strErr);
}
}
if (strErr == "")
{
string strSqlSpotCommission = "USP_Inv_Calculate_SpotCommission " + txtInvestigationID.Text.Split('/')[0] + "," + txtInvestigationID.Text.Split('/')[1] + "," + txtInvestigationID.Text.Split('/')[2];
objData.ExecuteQuery(strSqlSpotCommission, ref strErr);
MessageBox.Show("Investigation return succefully done.");
objData.CommitTransaction(ref strErr);
}
else
{
MessageBox.Show("Investigation not return.");
objData.Rollback(ref strErr);
}
}
private void btnDocRefresh_Click(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
getDocList();
objData.CloseConnection();
}
private void getEmployeeID()
{
//throw new NotImplementedException();
string strErr = "";
objetdata = new C_Data_Batch();
string strSQL = "";
strSQL = "select max(EmpID) from dbo_Employee_Profiles";
objetdata.OpenConnection("PolinPC-Office", ref strErr);
Int32 EmpID = 0;
DataTable arrEmpID = objetdata.RetriveData(strSQL, ref strErr);
if (arrEmpID.Rows.Count > 0)
{
if (arrEmpID.Rows[0][0].ToString() != "")
{
EmpID = Convert.ToInt32(arrEmpID.Rows[0][0].ToString()) + 1;
}
else
{
EmpID = 1;
}
}
else
{
EmpID = 1;
}
txtEmpployeeID.Text = EmpID.ToString();
}
private void lbPathlab_SelectedIndexChanged(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
fillGridView();
objData.CloseConnection();
}
private void btnpreview_Click(object sender, EventArgs e)
{
objData = new C_Data_Batch();
string strErr = "";
objData.OpenConnection("PolinPC-Office", ref strErr);
//txtCategoryID
string strSQL = "";
strSQL = "SELECT st.[SIT_ID],s.[Service_Name],st.[OGroup],st.[Entity],st.[Unit],st.[RefRenge],st.[Result_B] FROM [Dbo_service_Itemwise_Test] ST inner Join Dbo_Services S On St.Service_ID=s.Service_ID order by st.[SIT_ID] desc";
DataTable arrCatList = objData.RetriveData(strSQL, ref strErr);
objData.CloseConnection();
DataSet ds = new DataSet();
ds.Tables.Add(arrCatList);
frmReport reportviewer = new frmReport();
var rptpath = Utility.ReportPath + "rptServicesWiseTest.rpt";
reportviewer.ReportPath = rptpath;
reportviewer.Reportds = ds;
reportviewer.Show(this);
}
private void 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 btnedit_Click(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
DataEdit();
objData.CloseConnection();
}
private void frmServiceWiseList_Load(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
frmload();
objData.CloseConnection();
}
private void btnnew_Click(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("PolinPC-Office", ref strErr);
frmload();
objData.CloseConnection();
}
public int getDoctorId()
{
int doctorid = 0;
string strErr = "";
string strSQL = "select max(DocID) from dbo_Doctor_list";
objData = new C_Data_Batch();
objData.OpenConnection("PolinPC-Office", ref strErr);
DataTable dtMaxDictorID = objData.RetriveData(strSQL, ref strErr);
//string[,] arrMaxDictorID = objData.RetriveDataArray(strSQL, ref strErr);
objData.CloseConnection();
if (dtMaxDictorID.Rows.Count > 0)
{
if (dtMaxDictorID.Rows[0][0].ToString() != "")
{
doctorid = Convert.ToInt32(dtMaxDictorID.Rows[0][0].ToString()) + 1;
}
else
{
doctorid = 1;
}
}
else
{
doctorid = 1;
}
return(doctorid);
}
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 frmInvestigationDueCollection_Load(object sender, EventArgs e)
{
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
frmlod();
objData.CloseConnection();
}
private void btnsave_Click(object sender, EventArgs e)
{
strErr = "";
objData = new C_Data_Batch();
objData.OpenConnection("AzharPC-Home", ref strErr);
SaveData();
objData.CloseConnection();
}
