private DataTable getselectMultiselectvalues(string BindSource, string CodeID)
{
DataSet theDSXML = new DataSet();
theDSXML.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
DataView theDV = new DataView(theDSXML.Tables[BindSource]);
if (BindSource.ToUpper() == "MST_SYMPTOM" || BindSource.ToUpper() == "MST_REASON")
{
theDV.RowFilter = "DeleteFlag=0 and SystemID IN(0," + GblIQCare.SystemId.ToString() + ") and CategoryID=" + CodeID + "";
}
else if (BindSource.ToUpper() == "MST_HIVDISEASE")
{
theDV.RowFilter = "DeleteFlag=0 and SystemID IN(0," + GblIQCare.SystemId.ToString() + ") and SectionID=" + CodeID + "";
}
else if (BindSource.ToUpper() == "MST_STOPPEDREASON")
{
theDV.RowFilter = "DeleteFlag=0 and SystemID IN(0," + GblIQCare.SystemId.ToString() + ")";
}
else if (BindSource.ToUpper() == "MST_DECODE" || BindSource.ToUpper() == "MST_PMTCTDECODE" || BindSource.ToUpper() == "MST_MODDECODE")
{
theDV.RowFilter = "DeleteFlag=0 and SystemID IN(0," + GblIQCare.SystemId.ToString() + ") and CodeID=" + CodeID + "";
}
else
{
theDV.RowFilter = "DeleteFlag=0";
}
IQCareUtils theUtils = new IQCareUtils();
BindFunctions BindManager = new BindFunctions();
DataTable theDT = (DataTable)theUtils.CreateTableFromDataView(theDV);
return(theDT);
}
private void BindCombo()
{
DataSet XMLDS = new DataSet();
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
BindFunctions theBindManager = new BindFunctions();
DataView theDV = new DataView(XMLDS.Tables["Mst_Store"]);
theDV.RowFilter = "(DeleteFlag =0 or DeleteFlag is null)";
theDV.Sort = "Name ASC";
DataTable theStoreDT = theDV.ToTable();
theBindManager.Win_BindCombo(ddlStoreName, theStoreDT, "Name", "Id");
theDV = new DataView(XMLDS.Tables["Mst_Employee"]);
theDV.RowFilter = "(DeleteFlag =0 or DeleteFlag is null)";
DataTable theEMPPrepDT = theDV.ToTable();
DataTable theEMPAuthDT = theDV.ToTable();
theBindManager.Win_BindCombo(ddlPreparedBy, theEMPPrepDT, "Name", "Id");
theBindManager.Win_BindCombo(ddlAuthoriseBy, theEMPAuthDT, "Name", "Id");
theBindManager.Win_BindCombo(ddlAuthoriseBy, theEMPAuthDT, "Name", "Id");
theDV = new DataView(XMLDS.Tables["Mst_Decode"]);
theDV.RowFilter = "CodeID=205 and (DeleteFlag =0 or DeleteFlag is null)";
DataTable theAdjustmentReason = theDV.ToTable();
theBindManager.Win_BindCombo(ddlAdjustmentReason, theAdjustmentReason, "Name", "Id");
}
private void Init_Form()
{
string XmlFile = GblIQCare.GetXMLPath() + "Currency.xml";
DataSet theDSCurrencyXML = new DataSet();
theDSCurrencyXML.ReadXml(XmlFile);
IBudgetConfigDetail objProgramlistByDonor = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
dsProgramListByDonor = objProgramlistByDonor.GetProgramListByDonor(Convert.ToInt32(GblIQCare.objHashtbl["DonorID"]));
//if (dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "'").SingleOrDefault() != null)
if (dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "'").Length > 0)
{
//DataRow []dr=dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "'");
//foreach(DataRow drdt in dr)
//{
//}
FundEndDt = Convert.ToDateTime(dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "' and FundingEndDate=max(FundingEndDate)").SingleOrDefault().ItemArray[10]);
FundEndDt = Convert.ToDateTime(FundEndDt.Month + "-" + System.DateTime.DaysInMonth(FundEndDt.Year, FundEndDt.Month) + "-" + FundEndDt.Year);
int month = Convert.ToInt32(dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "' and FundingStartDate=min(FundingStartDate)").SingleOrDefault().ItemArray[4]);
ProgramStartDt = Convert.ToDateTime(month + "-" + System.DateTime.DaysInMonth(Convert.ToInt32(GblIQCare.objHashtbl["ProgramYear"]), month) + "-" + GblIQCare.objHashtbl["ProgramYear"]);
}
string CurrencyCode = theDSCurrencyXML.Tables[0].Select("Id = '" + GblIQCare.AppCountryId + "'").SingleOrDefault().ItemArray[1].ToString().Split('(').LastOrDefault().Replace(")", "");
lblCurrency.Text = "Currency: " + CurrencyCode;
txtDonor.Text = GblIQCare.objHashtbl["DonorName"].ToString();
txtProgram.Text = GblIQCare.objHashtbl["ProgramName"].ToString();
txtProgramYear.Text = GblIQCare.objHashtbl["ProgramYear"].ToString();
LoadGrid(LoadGridData().Tables[1]);
}
private void frmPharmacynotes_Load(object sender, EventArgs e)
{
patientDetails();
rptDocument = new ReportDocument();
IQCareUtils theUtil = new IQCareUtils();
IDrug ReportDetails = (IDrug)ObjectFactory.CreateInstance("BusinessProcess.Pharmacy.BDrug,BusinessProcess.Pharmacy");
DataSet theDS = (DataSet)ReportDetails.GetPharmacyNotes(GblIQCare.patientID);
theDS.WriteXmlSchema(GblIQCare.GetXMLPath() + "\\PharmacyNotes.xml");
rptPharmacyNotes rep = new rptPharmacyNotes();
rep.SetDataSource(theDS);
//frmPharmacyNotes theRepViewer = new frmPharmacyNotes();
frmReportViewer theRepViewer = new frmReportViewer();
theRepViewer.MdiParent = this.MdiParent;
theRepViewer.Location = new Point(0, 0);
theRepViewer.crViewer.ReportSource = rep;
theRepViewer.crViewer.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
theRepViewer.Width = 902;
theRepViewer.Height = 650;
theRepViewer.crViewer.Width = 880;
theRepViewer.crViewer.Height = 600;
theRepViewer.crViewer.Location = new Point(11, 11);
theRepViewer.btnExit_position(451, 615);
theRepViewer.Show();
this.Close();
}
private void btnPrint_Click(object sender, EventArgs e)
{
ReportDocument objRptDoc = new ReportDocument();
DataSet dsPrintPOItemsDetail = new DataSet();
//IMasterList objStockLedger = (IMasterList)ObjectFactory.CreateInstance("BusinessProcess.SCM.BMasterList,BusinessProcess.SCM");
IPurchase objPOItem = (IPurchase)ObjectFactory.CreateInstance("BusinessProcess.SCM.BPurchase,BusinessProcess.SCM");
dsPrintPOItemsDetail = objPOItem.GetPurchaseOrderDetailsByPoid(GblIQCare.PurchaseOrderID);
dsPrintPOItemsDetail.WriteXmlSchema(GblIQCare.GetXMLPath() + "\\IntStorePO.xml");
rptIntStorePOReport rep = new rptIntStorePOReport();
rep.SetDataSource(dsPrintPOItemsDetail);
// rep.ParameterFields["FormDate","1"];
rep.SetParameterValue("ModePurchaseOrder", GblIQCare.ModePurchaseOrder);
rep.SetParameterValue("facilityname", GblIQCare.AppLocation);
// , Convert.ToString(dtpFrom.Text)];
frmReportViewer theRepViewer = new frmReportViewer();
theRepViewer.MdiParent = this.MdiParent;
theRepViewer.Location = new Point(0, 0);
theRepViewer.crViewer.ReportSource = rep;
theRepViewer.Show();
this.Close();
}
private void BindStoreName()
{
StoreID = GblIQCare.intStoreId;
//ddlSourceStore.Enabled = true;
BindFunctions theBind = new BindFunctions();
DataSet XMLDS = new DataSet();
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
DataView theDV;
DataTable theStoreDT;
IMasterList objItemCommonlist = (IMasterList)ObjectFactory.CreateInstance("BusinessProcess.SCM.BMasterList,BusinessProcess.SCM");
IQCareUtils theUtils = new IQCareUtils();
DataSet theDS = objItemCommonlist.GetStoreDetail();
ddlSourceStore.Enabled = true;
theDV = new DataView(theDS.Tables[2]);
theDV.RowFilter = "Id <>" + StoreID;
theStoreDT = theDV.ToTable();
theBind.Win_BindCombo(ddlSourceStore, theStoreDT, "Name", "Id");
theDV = new DataView(XMLDS.Tables["Mst_Store"]);
theDV.RowFilter = "(DeleteFlag =0 or DeleteFlag is null) and ( Id =" + StoreID + ")";
theStoreDT = theDV.ToTable();
//theBind.Win_BindCombo(ddlDestinationStore, theStoreDT, "Name", "Id");
ddlDestinationStore.DataSource = theStoreDT;
ddlDestinationStore.DisplayMember = "Name";
ddlDestinationStore.ValueMember = "Id";
}
private void BindDropdown()
{
string XmlFile = GblIQCare.GetXMLPath() + "Currency.xml";
DataSet theDSCurrencyXML = new DataSet();
theDSCurrencyXML.ReadXml(XmlFile);
string CurrencyCode = theDSCurrencyXML.Tables[0].Select("Id = '" + GblIQCare.AppCountryId + "'").SingleOrDefault().ItemArray[1].ToString().Split('(').LastOrDefault().Replace(")", "");
lblCurrency.Text = "Currency: " + CurrencyCode;
BindFunctions objBindControls = new BindFunctions();
DataTable theDT = new DataTable();
theDT = objBindControls.GetYears(DateTime.Now.AddYears(1).Year, "Name", "Id");
ddlProgramYear.Items.Clear();
objBindControls.Win_BindCombo(ddlProgramYear, theDT, "Name", "Id");
ddlDonorPayer.DataSource = null;
ddlDonorPayer.Items.Clear();
objBindControls.Win_BindCombo(ddlDonorPayer, dsDonorList.Tables[0], "DonorName", "Id");
ddlProgram.DataSource = null;
ddlProgram.Items.Clear();
objBindControls.Win_BindCombo(ddlProgram, dsProgramList.Tables[0], "ProgramName", "Id");
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (rdoStockLedger.Checked)
{
ReportDocument objRptDoc = new ReportDocument();
//IMasterList objStockLedger = (IMasterList)ObjectFactory.CreateInstance("BusinessProcess.SCM.BMasterList,BusinessProcess.SCM");
ISCMReport objStockLedger = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport,BusinessProcess.SCM");
DataSet theDS = objStockLedger.GetStockLedgerData(Convert.ToInt32(ddlStore.SelectedValue), Convert.ToDateTime(dtpFrom.Text), Convert.ToDateTime(dtpTo.Text));
theDS.WriteXmlSchema(GblIQCare.GetXMLPath() + "\\StockLedger.xml");
rptStockLedger rep = new rptStockLedger();
rep.SetDataSource(theDS);
// rep.ParameterFields["FormDate","1"];
rep.SetParameterValue("FromDate", dtpFrom.Text);
rep.SetParameterValue("ToDate", dtpTo.Text);
rep.SetParameterValue("ToClosingDate", (Convert.ToString(dtpTo.Text)).Replace('-', ' '));
rep.SetParameterValue("facilityname", GblIQCare.AppLocation);
// , Convert.ToString(dtpFrom.Text)];
frmReportViewer theRepViewer = new frmReportViewer();
theRepViewer.MdiParent = this.MdiParent;
theRepViewer.Location = new Point(0, 0);
theRepViewer.crViewer.ReportSource = rep;
theRepViewer.Show();
this.Close();
}
}
private void Init_Form()
{
string XmlFile = GblIQCare.GetXMLPath() + "Currency.xml";
DataSet theDSCurrencyXML = new DataSet();
theDSCurrencyXML.ReadXml(XmlFile);
string CurrencyCode = theDSCurrencyXML.Tables[0].Select("Id = '" + GblIQCare.AppCountryId + "'").SingleOrDefault().ItemArray[1].ToString().Split('(').LastOrDefault().Replace(")", "");
labelCurrency.Text = "Currency: " + CurrencyCode;
}
private void BindGrid()
{
//string filePath = "C:/AidsRelief Ver3.2/SourceBase/IQCare Management/XMLFiles/Masterlist.xml";
//dsMasterList.ReadXml(filePath);
DataSet dsMasterList = new DataSet();
dsMasterList.ReadXml(GblIQCare.GetXMLPath() + "\\Masterlist.xml");
if (dsMasterList.Tables[0].Rows.Count > 0)
{
ShowGrid(dsMasterList.Tables[0]);
}
}
private void frmPatientClinicalSummary_Load(object sender, EventArgs e)
{
//rptDocument = new ReportDocument();
//IQCareUtils theUtil = new IQCareUtils();
//IPatientHome ReportDetails = (IPatientHome)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPatientHome,BusinessProcess.Clinical");
//DataSet theDS = (DataSet)ReportDetails.GetPatientSummaryInformation(GblIQCare.patientID, GblIQCare.ModuleId);
//string filename = GblIQCare.GetXMLPath() + "PatientClinicalSummary.xml";
//System.IO.FileStream myFileStream = new System.IO.FileStream(filename, System.IO.FileMode.Create);
//System.Xml.XmlTextWriter MyXmlTextWriter = new System.Xml.XmlTextWriter(myFileStream, System.Text.Encoding.Unicode);
//theDS.WriteXmlSchema(MyXmlTextWriter);
//MyXmlTextWriter.Close();
//ReportDetails = null;
//theReportSource = GblIQCare.GetReportPath() + "rptPatientClinicalSummary.rpt";
//rptDocument.Load(theReportSource);
//rptDocument.SetDataSource(theDS);
//crViewer.ReportSource = rptDocument;
//crViewer.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
rptDocument = new ReportDocument();
IQCareUtils theUtil = new IQCareUtils();
IPatientHome ReportDetails = (IPatientHome)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPatientHome,BusinessProcess.Clinical");
DataSet theDS = (DataSet)ReportDetails.GetPatientSummaryInformation(GblIQCare.patientID, GblIQCare.ModuleId);
theDS.WriteXmlSchema(GblIQCare.GetXMLPath() + "\\PatientClinicalSummary.xml");
rptPatientClinicalSummary rep = new rptPatientClinicalSummary();
rep.SetDataSource(theDS);
frmReportViewer theRepViewer = new frmReportViewer();
theRepViewer.MdiParent = this.MdiParent;
theRepViewer.Location = new Point(0, 0);
theRepViewer.crViewer.ReportSource = rep;
theRepViewer.crViewer.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
theRepViewer.Width = 902;
theRepViewer.Height = 650;
theRepViewer.crViewer.Width = 880;
theRepViewer.crViewer.Height = 600;
theRepViewer.crViewer.Location = new Point(11, 11);
theRepViewer.btnExit_position(451, 615);
theRepViewer.Show();
this.Close();
}
/// <summary>
/// Generates the cache.
/// </summary>
/// <param name="StateInfo">The state information.</param>
public static void GenerateCache(object StateInfo)
{
try
{
string xmlPath = GblIQCare.GetXMLPath();
IIQCareSystem DateManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security");
DateTime theDTime = DateManager.SystemDate();
System.IO.FileInfo theFileInfo1 = new System.IO.FileInfo(xmlPath + "\\AllMasters.con");
System.IO.FileInfo theFileInfo2 = new System.IO.FileInfo(xmlPath + "\\DrugMasters.con");
System.IO.FileInfo theFileInfo3 = new System.IO.FileInfo(xmlPath + "\\LabMasters.con");
if (theFileInfo1.LastWriteTime.Date != theDTime.Date || theFileInfo2.LastWriteTime.Date != theDTime.Date || theFileInfo3.LastWriteTime.Date != theDTime.Date)
{
IIQCareSystem theCacheManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem,BusinessProcess.Security");
DataSet theMainDS = theCacheManager.GetSystemCache();
IQCareUtils.WriteCache(ref theMainDS, theDTime);
}
}
catch { }
}
private void BindCombo()
{
try
{
DataSet XMLDS = new DataSet();
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
BindFunctions theBindManager = new BindFunctions();
DataView theDV = new DataView(XMLDS.Tables["Mst_Store"]);
theDV.RowFilter = "(DeleteFlag =0 or DeleteFlag is null)";
DataTable theStoreDT = theDV.ToTable();
theBindManager.Win_BindCombo(ddlStore, theStoreDT, "Name", "Id");
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareWindowMsgBox.ShowWindowConfirm("#C1", theBuilder, this);
}
}
private void BindCombo()
{
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
BindFunctions theBindManager = new BindFunctions();
DataView mainDV = new DataView(XMLDS.Tables["Mst_Decode"]);
DataView theDV = new DataView(XMLDS.Tables["Mst_Decode"]);
theDV.RowFilter = "CodeId = 4 and (DeleteFlag =0 or DeleteFlag is null)";
DataTable theGender = theDV.ToTable();
theBindManager.Win_BindCombo(cmbGender, theGender, "Name", "Id");
theDV = new DataView(XMLDS.Tables["Mst_Code"]);
theDV.RowFilter = "Name = 'ServiceRegisteredForAtPharmacy' and (DeleteFlag =0 or DeleteFlag is null)";
string codeID = "-999";
try
{
codeID = theDV[0]["CodeId"].ToString();
//theDV = new DataView(XMLDS.Tables["Mst_Decode"]);
//mainDV.RowFilter = "CodeId = " + codeID + " and (DeleteFlag =0 or DeleteFlag is null)";
}
catch { }
mainDV.RowFilter = "CodeId = " + codeID + " and (DeleteFlag =0 or DeleteFlag is null)";
DataTable theService = mainDV.ToTable();
DataRow theDR = theService.NewRow();
theDR["Name"] = "Select";
theDR["Id"] = "0";
theDR["DeleteFlag"] = "0";
theDR["CodeId"] = "4";
theService.Rows.InsertAt(theDR, 0);
theBindManager.Win_BindCombo(cmbService, theService, "Name", "Id");
}
public void formInit()
{
try
{
//IMasterList objPOItem = (IMasterList)ObjectFactory.CreateInstance("BusinessProcess.SCM.BMasterList,BusinessProcess.SCM");
IPurchase objPOItem = (IPurchase)ObjectFactory.CreateInstance("BusinessProcess.SCM.BPurchase,BusinessProcess.SCM");
dsPOItemsDetail = objPOItem.GetPurchaseOrderDetailsByPoid(GblIQCare.PurchaseOrderID);
if (dsPOItemsDetail.Tables.Count > 0)
{
if (dsPOItemsDetail.Tables[0].Rows.Count > 0)
{
//if (Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["SupplierID"]) > 0 && Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["SourceStoreID"]) == 0)
//{
// // set IsPurchaseOrder = 1;
// rdoPurchaseOrder.Checked = true;
// rdoInterStoreTransfer.Enabled = false;
//}
//else if (Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["SupplierID"]) == 0 && Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["SourceStoreID"]) > 0)
//{
// //set IsPurchaseOrder = 0;
// rdoInterStoreTransfer.Checked = true;
// rdoPurchaseOrder.Enabled = false;
//}
dtpOrderDate.Text = dsPOItemsDetail.Tables[0].Rows[0]["OrderDate"].ToString();
dtpOrderDate.CustomFormat = "dd-MMM-yyyy";
dtpOrderDate.Enabled = false;
txtOrderNumber.Text = dsPOItemsDetail.Tables[0].Rows[0]["OrderNo"].ToString();
txtOrderNumber.Enabled = false;
// ddlSourceStore.SelectedValue = Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["SourceStoreID"].ToString());
ddlDestinationStore.DataSource = null;
DataSet XMLDS = new DataSet();
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
BindFunctions theBindManager = new BindFunctions();
// Id <>" + StoreID + " or
DataView theDV = new DataView(XMLDS.Tables["Mst_Store"]);
//DataView theDV = new DataView(dsPOItemsDetail.Tables[3]);
theDV.RowFilter = "(DeleteFlag =0 or DeleteFlag is null )and (Id =" + Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["DestinStoreID"].ToString()) + ") ";
DataTable theStoreDT = theDV.ToTable();
theBindManager.Win_BindCombo(ddlDestinationStore, theStoreDT, "Name", "Id");
// ddlDestinationStore.SelectedValue = Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["DestinStoreID"].ToString());
ddlSourceStore.SelectedValue = Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["SourceStoreID"].ToString());
ddlSourceStore.Enabled = false;
ddlDestinationStore.SelectedValue = Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["DestinStoreID"].ToString());
ddlPreparedBy.SelectedValue = Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["PreparedBy"].ToString());
//john start
ddlPreparedBy.Visible = false;
lblPreparedByLabel.Text = dsPOItemsDetail.Tables[0].Rows[0]["PreparedName"].ToString();
//lblPreparedByLabel.Location = new Point(lblPreparedByLabel.Location.X, lblPreparedByLabel.Location.Y-25);
lblPreparedByLabel.Visible = true;
//john end
if (dsPOItemsDetail.Tables[0].Rows[0]["Status"].ToString() == "1")
{
chkRejectedStatus.Visible = true;
Btndelete.Enabled = true;
btnSave.Enabled = true;
IsPOUpdated = true;
btnPrint.Enabled = false;
}
else if (dsPOItemsDetail.Tables[0].Rows[0]["Status"].ToString() == "5")
{
btnSave.Enabled = false;
Btndelete.Enabled = false;
IsPOUpdated = false;
chkRejectedStatus.Visible = true;
chkRejectedStatus.Checked = true;
chkRejectedStatus.Enabled = false;
btnPrint.Enabled = true;
}
else
{
ddlAuthorisedBy.SelectedValue = Convert.ToInt32(dsPOItemsDetail.Tables[0].Rows[0]["AuthorizedBy"].ToString());
//john start
ddlAuthorisedBy.Visible = false;
lblAuthorisedLabel.Text = dsPOItemsDetail.Tables[0].Rows[0]["AuthorizeName"].ToString();
//lblAuthorisedLabel.Location = new Point(lblAuthorisedLabel.Location.X, lblAuthorisedLabel.Location.Y - 25);
lblAuthorisedLabel.Visible = true;
//john end
btnSave.Enabled = false;
Btndelete.Enabled = false;
chkRejectedStatus.Visible = false;
btnPrint.Enabled = true;
}
lblTotalAmount.Text = dsPOItemsDetail.Tables[1].Rows[0]["TotalAmount"].ToString();
BindGrid(dsPOItems);
dgwItemSubitemDetails.AllowUserToAddRows = true;
dgwItemSubitemDetails.DataSource = dsPOItemsDetail.Tables[1];
}
}
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareWindowMsgBox.ShowWindow("#C1", theBuilder, this);
return;
}
}
/// <summary>
/// Generates the cache.
/// </summary>
/// <param name="StateInfo">The state information.</param>
public static void GenerateCache(object StateInfo)
{
string xmlPath = GblIQCare.GetXMLPath();
IIQCareSystem DateManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security");
DateTime theDTime = DateManager.SystemDate();
try
{
IIQCareSystem theCacheManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem,BusinessProcess.Security");
DataSet theMainDS = theCacheManager.GetSystemCache();
DataSet WriteXMLDS = new DataSet();
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_CouncellingType"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_CouncellingTopic"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Provider"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Division"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Ward"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_District"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Reason"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Education"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Designation"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Employee"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Occupation"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Province"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Village"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Code"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_HIVAIDSCareTypes"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ARTSponsor"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_HivDisease"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Assessment"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Symptom"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Decode"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Feature"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Function"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_HivDisclosure"].Copy());
//WriteXMLDS.Tables.Add(theMainDS.Tables["mst_Satellite"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_LPTF"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["mst_StoppedReason"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["mst_facility"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_HIVCareStatus"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_RelationshipType"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_TBStatus"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ARVStatus"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_LostFollowreason"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Regimen"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Store"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Supplier"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["mst_Donor"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Program"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Batch"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["VWDiseaseSymptom"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["mst_RegimenLine"].Copy());
if (theMainDS.Tables.Contains("Users"))
{
WriteXMLDS.Tables.Add(theMainDS.Tables["Users"].Copy());
}
WriteXMLDS.WriteXml(xmlPath + "\\AllMasters.con", XmlWriteMode.WriteSchema);
WriteXMLDS.Tables.Clear();
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Strength"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_FrequencyUnits"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Drug"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Generic"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_DrugType"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Frequency"].Copy());
WriteXMLDS.WriteXml(xmlPath + "\\DrugMasters.con", XmlWriteMode.WriteSchema);
WriteXMLDS.Tables.Clear();
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_LabTest"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Lnk_TestParameter"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Lnk_LabValue"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Lnk_ParameterResult"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["LabTestOrder"].Copy());
WriteXMLDS.WriteXml(xmlPath + "\\LabMasters.con", XmlWriteMode.WriteSchema);
// IQCareUtils.WriteCache(ref theMainDS, theDTime.AddDays(-1));
}
catch { }
}
private void ShowGrid(DataTable theDT)
{
try
{
dgwStockLevelDetails.Columns.Clear();
dgwStockLevelDetails.AutoGenerateColumns = false;
dgwStockLevelDetails.DataSource = null;
DataGridViewTextBoxColumn Itemcode = new DataGridViewTextBoxColumn();
Itemcode.HeaderText = "ItemId";
Itemcode.DataPropertyName = "ItemId";
Itemcode.Width = 30;
Itemcode.ReadOnly = true;
Itemcode.Visible = false;
DataGridViewTextBoxColumn ItemName = new DataGridViewTextBoxColumn();
ItemName.HeaderText = "Item Name";
ItemName.DataPropertyName = "DrugName";
ItemName.Width = 305;
ItemName.ReadOnly = true;
DataGridViewTextBoxColumn DispensingUnit = new DataGridViewTextBoxColumn();
DispensingUnit.HeaderText = "Dispensing Unit";
DispensingUnit.DataPropertyName = "DispensingUnit";
DispensingUnit.Width = 80;
DispensingUnit.ReadOnly = true;
DataGridViewTextBoxColumn BatchId = new DataGridViewTextBoxColumn();
BatchId.HeaderText = "Batch Id";
BatchId.DataPropertyName = "BatchId";
BatchId.Width = 100;
BatchId.ReadOnly = false;
BatchId.Visible = false;
DataGridViewTextBoxColumn BatchNo = new DataGridViewTextBoxColumn();
BatchNo.HeaderText = "Batch No.";
BatchNo.DataPropertyName = "Batch";
BatchNo.Width = 100;
BatchNo.ReadOnly = false;
DataGridViewTextBoxColumn ExpiryDate = new DataGridViewTextBoxColumn();
ExpiryDate.HeaderText = "Expiry Date";
ExpiryDate.DataPropertyName = "ExpiryDate";
ExpiryDate.Width = 100;
ExpiryDate.ReadOnly = true;
ExpiryDate.Visible = true;
DataGridViewTextBoxColumn CurrentQuantity = new DataGridViewTextBoxColumn();
CurrentQuantity.HeaderText = "Current Quantity";
CurrentQuantity.DataPropertyName = "AvailableQTY";
CurrentQuantity.Width = 80;
CurrentQuantity.ReadOnly = true;
DataGridViewTextBoxColumn AdjustedQuantity = new DataGridViewTextBoxColumn();
AdjustedQuantity.HeaderText = "Adjusted Quantity";
AdjustedQuantity.DataPropertyName = "AdjQty";
AdjustedQuantity.Width = 80;
AdjustedQuantity.ReadOnly = false;
DataGridViewComboBoxColumn AdjustedReason = new DataGridViewComboBoxColumn();
AdjustedReason.HeaderText = "Adjusted Reason";
AdjustedReason.DataPropertyName = "AdjustReasonId";
AdjustedReason.Width = 200;
DataSet XMLDS = new DataSet();
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
DataRow theDRReasoon = XMLDS.Tables["Mst_Decode"].NewRow();
theDRReasoon["Id"] = 0;
theDRReasoon["Name"] = "Select";
theDRReasoon["CodeId"] = 205;
theDRReasoon["DeleteFlag"] = 0;
XMLDS.Tables["Mst_Decode"].Rows.Add(theDRReasoon);
DataView theDV = new DataView(XMLDS.Tables["Mst_Decode"]);
theDV.RowFilter = "CodeID=205 and (DeleteFlag =0 or DeleteFlag is null)";
theDV.Sort = "Id ASC";
//AdjustedReason
AdjustedReason.DataSource = theDV.ToTable();
AdjustedReason.DisplayMember = "Name";
AdjustedReason.ValueMember = "Id";
AdjustedReason.ReadOnly = false;
dgwStockLevelDetails.Columns.Add(Itemcode);
dgwStockLevelDetails.Columns.Add(ItemName);
dgwStockLevelDetails.Columns.Add(DispensingUnit);
dgwStockLevelDetails.Columns.Add(BatchNo);
dgwStockLevelDetails.Columns.Add(BatchId);
dgwStockLevelDetails.Columns.Add(ExpiryDate);
dgwStockLevelDetails.Columns.Add(CurrentQuantity);
dgwStockLevelDetails.Columns.Add(AdjustedQuantity);
dgwStockLevelDetails.Columns.Add(AdjustedReason);
dgwStockLevelDetails.DataSource = theDT;
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareWindowMsgBox.ShowWindowConfirm("#C1", theBuilder, this);
}
}
private void dgwStockSummary_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == dgwStockSummary.Columns["BinCard"].Index)
{
int storeid = Convert.ToInt32(ddlStore.SelectedValue.ToString());
int itemid = Convert.ToInt32(dgwStockSummary.Rows[e.RowIndex].Cells["ItemId"].Value.ToString());
DateTime dateFrom = Convert.ToDateTime(dtpFrom.Value.ToString("yyyy-MM-dd"));
DateTime dateTo = Convert.ToDateTime(dtpTo.Value.ToString("yyyy-MM-dd"));
ReportDocument objRptDoc = new ReportDocument();
DataSet theDS = GetBINCard(storeid, itemid, dateFrom, dateTo);
////////////////////////////////////////////////////////////////
//Image Streaming
DataTable dtFacility = new DataTable();
// object of data row
DataRow drow = null;
// add the column in table to store the image of Byte array type
dtFacility.Columns.Add("FacilityImage", System.Type.GetType("System.Byte[]"));
drow = dtFacility.NewRow();
// define the filestream object to read the image
FileStream fs = default(FileStream);
// define te binary reader to read the bytes of image
BinaryReader br = default(BinaryReader);
int ImageFlag = 0;
// check the existance of image
if (File.Exists(GblIQCare.PresentationImagePath() + theDS.Tables[3].Rows[0]["FacilityLogo"].ToString()))
{
// open image in file stream
fs = new FileStream(GblIQCare.PresentationImagePath() + theDS.Tables[3].Rows[0]["FacilityLogo"].ToString(), FileMode.Open);
// initialise the binary reader from file streamobject
br = new BinaryReader(fs);
// define the byte array of filelength
byte[] imgbyte = new byte[fs.Length + 1];
// read the bytes from the binary reader
imgbyte = br.ReadBytes(Convert.ToInt32((fs.Length)));
drow[0] = imgbyte;
// add the image in bytearray
dtFacility.Rows.Add(drow);
ImageFlag = 1;
// add row into the datatable
br.Close();
// close the binary reader
fs.Close();
// close the file stream
}
theDS.Tables.Add(dtFacility);
////////////////////////////////////////
theDS.WriteXmlSchema(GblIQCare.GetXMLPath() + "\\BinCard.xml");
rptBinCard rep = new rptBinCard();
rep.SetDataSource(theDS);
// rep.ParameterFields["FormDate","1"];
rep.SetParameterValue("facilityname", GblIQCare.AppLocation);
frmReportViewer theRepViewer = new frmReportViewer();
theRepViewer.MdiParent = this.MdiParent;
theRepViewer.Location = new Point(0, 0);
theRepViewer.crViewer.ReportSource = rep;
theRepViewer.Show();
this.Close();
}
}
private void frmSelectList_Load(object sender, EventArgs e)
{
btnconditionalfield.Enabled = true;
if (GblIQCare.strgblPredefined.ToString() == "P")
{
pnlselectlist.Enabled = false;
}
else
{
pnlselectlist.Enabled = true;
}
if (GblIQCare.strControlReferenceId == "SELECTLIST_TEXTBOX")
{
btnconditionalfield.Enabled = false;
}
//if (GblIQCare.strYesNo == "Yes No")
//{
// lstSelectList.Items.Add("Yes");
// lstSelectList.Items.Add("No");
// pnlselectlist.Enabled = false;
//}
//else
//{
// pnlselectlist.Enabled = true;
// lstSelectList.Items.Clear();
//}
//disable all controls on form when form mode is 1 i.e. readonly
if (GblIQCare.iFormMode.ToString() == "1")
{
pnlselectlist.Enabled = false;
}
if (GblIQCare.iConditionalbtn.ToString() == "1")
{
btnconditionalfield.Enabled = false;
}
else
{
btnconditionalfield.Enabled = true;
GblIQCare.iConditionalbtn = 0;
}
//set css begin
clsCssStyle theStyle = new clsCssStyle();
theStyle.setStyle(this);
//set css end
if (GblIQCare.strSelectList == "frmFieldDetails")
{
if (GblIQCare.objhashSelectList.Contains(GblIQCare.gblRowIndex))
{
char[] splitter1 = { ';' };
if (GblIQCare.objhashSelectList[GblIQCare.gblRowIndex].ToString() != "")
{
string strselect = GblIQCare.objhashSelectList[GblIQCare.gblRowIndex].ToString();
string[] arrListValue1 = strselect.Split(splitter1);
for (int i = 0; i < arrListValue1.Length; i++)
{
lstSelectList.Items.Add(arrListValue1[i].ToString().Trim());
}
}
}
}
else
{
if (GblIQCare.objhashSelectList.Contains(GblIQCare.gblRowIndex))
{
char[] splitter1 = { ';' };
if (GblIQCare.objhashSelectList[GblIQCare.gblRowIndex].ToString() != "")
{
string strselect = GblIQCare.objhashSelectList[GblIQCare.gblRowIndex].ToString();
string[] arrListValue1 = strselect.Split(splitter1);
for (int i = 0; i < arrListValue1.Length; i++)
{
lstSelectList.Items.Add(arrListValue1[i].ToString().Trim());
}
}
}
}
/////Written by Rajketu//////////////
if (GblIQCare.strYesNo == "Yes No" || GblIQCare.strYesNo == "6")
{
lstSelectList.Items.Clear();
lstSelectList.Items.Add("Yes");
lstSelectList.Items.Add("No");
pnlselectlist.Enabled = false;
}
/////Written by Rajketu//////////////
else if (GblIQCare.strYesNo == "Disease/Symptoms" || GblIQCare.strYesNo == "15")
{
DataSet XMLDS = new DataSet();
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
BindFunctions theBindManager = new BindFunctions();
DataView theDV = new DataView(XMLDS.Tables["VWDiseaseSymptom"]);
theDV.RowFilter = "(DeleteFlag =0 or DeleteFlag is null)";
theDV.Sort = "Name1 ASC";
DataTable theDT = theDV.ToTable();
theBindManager.Win_BindListBox(lstSelectList, theDT, "Name1", "Id");
btnconditionalfield.Enabled = false;
btnDelete.Enabled = false;
btnSubmit.Enabled = false;
btnAdd.Enabled = false;
txtEnterValue.Enabled = false;
}
}
private void frmSelectList_Load(object sender, EventArgs e)
{
if (GblIQCare.strgblPredefined.ToString() == "P")
{
pnlselectlist.Enabled = false;
}
else
{
pnlselectlist.Enabled = true;
}
//if (GblIQCare.strYesNo == "Yes No")
//{
// lstSelectList.Items.Add("Yes");
// lstSelectList.Items.Add("No");
// pnlselectlist.Enabled = false;
//}
//else
//{
// pnlselectlist.Enabled = true;
// lstSelectList.Items.Clear();
//}
//disable all controls on form when form mode is 1 i.e. readonly
if (GblIQCare.iFormMode.ToString() == "1")
{
pnlselectlist.Enabled = false;
}
if (GblIQCare.iConditionalbtn.ToString() == "1")
{
btnconditionalfield.Enabled = false;
}
else
{
btnconditionalfield.Enabled = true;
GblIQCare.iConditionalbtn = 0;
}
//set css begin
clsCssStyle theStyle = new clsCssStyle();
theStyle.setStyle(this);
//set css end
if (GblIQCare.strMainGrdFldName.ToLower() == "userlist")
{
lstSelectList.HorizontalScrollbar = true;
lstSelectList.ScrollAlwaysVisible = true;
}
else
{
lstSelectList.HorizontalScrollbar = false;
lstSelectList.ScrollAlwaysVisible = false;
}
if (GblIQCare.strSelectList == "frmFieldDetails")
{
if (GblIQCare.objhashSelectList.Contains(GblIQCare.gblRowIndex))
{
char[] splitter1 = { ';' };
if (GblIQCare.objhashSelectList[GblIQCare.gblRowIndex].ToString() != "")
{
string strselect = GblIQCare.objhashSelectList[GblIQCare.gblRowIndex].ToString();
string[] arrListValue1 = strselect.Split(splitter1);
//Jayant-12/06/2104 Exit Reason for PASDP
if (GblIQCare.strMainGrdFldName == "Exit Reason" && GblIQCare.SystemId == 3)
{
DataSet XMLDS = new DataSet();
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
BindFunctions theBindManager = new BindFunctions();
DataView theDV = new DataView(XMLDS.Tables["Mst_Decode"]);
theDV.RowFilter = "((DeleteFlag =0 or DeleteFlag is null) and CodeId=23 and ModuleId=205)";
theDV.Sort = "Name ASC";
DataTable theDT = theDV.ToTable();
foreach (DataRow theDR in theDT.Rows)
{
lstSelectList.Items.Add(theDR["Name"].ToString().Trim());
}
}
//Jayant-12/06/2104 Exit Reason for IQCare
else if (GblIQCare.strMainGrdFldName == "Exit Reason" && GblIQCare.SystemId == 1)
{
DataSet XMLDS = new DataSet();
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
BindFunctions theBindManager = new BindFunctions();
DataView theDV = new DataView(XMLDS.Tables["Mst_Decode"]);
theDV.RowFilter = "((DeleteFlag =0 or DeleteFlag is null) and CodeId=23 and SystemId IN(0,1))";
theDV.Sort = "Name ASC";
DataTable theDT = theDV.ToTable();
foreach (DataRow theDR in theDT.Rows)
{
lstSelectList.Items.Add(theDR["Name"].ToString().Trim());
}
}
else
{
for (int i = 0; i < arrListValue1.Length; i++)
{
lstSelectList.Items.Add(arrListValue1[i].ToString().Trim());
}
}
}
}
}
else
{
if (GblIQCare.objhashSelectList.Contains(GblIQCare.gblRowIndex))
{
char[] splitter1 = { ';' };
if (GblIQCare.objhashSelectList[GblIQCare.gblRowIndex].ToString() != "")
{
string strselect = GblIQCare.objhashSelectList[GblIQCare.gblRowIndex].ToString();
string[] arrListValue1 = strselect.Split(splitter1);
for (int i = 0; i < arrListValue1.Length; i++)
{
lstSelectList.Items.Add(arrListValue1[i].ToString().Trim());
}
}
}
}
/////Written by Rajketu//////////////
if (GblIQCare.strYesNo == "Yes No" || GblIQCare.strYesNo == "6")
{
lstSelectList.Items.Clear();
lstSelectList.Items.Add("Yes");
lstSelectList.Items.Add("No");
pnlselectlist.Enabled = false;
}
/////Written by Rajketu//////////////
else if (GblIQCare.strYesNo == "Disease/Symptoms" || GblIQCare.strYesNo == "15")
{
DataSet XMLDS = new DataSet();
XMLDS.ReadXml(GblIQCare.GetXMLPath() + "\\AllMasters.con");
BindFunctions theBindManager = new BindFunctions();
DataView theDV = new DataView(XMLDS.Tables["VWDiseaseSymptom"]);
theDV.RowFilter = "(DeleteFlag =0 or DeleteFlag is null)";
theDV.Sort = "Name1 ASC";
DataTable theDT = theDV.ToTable();
theBindManager.Win_BindListBox(lstSelectList, theDT, "Name1", "Id");
btnconditionalfield.Enabled = false;
btnDelete.Enabled = false;
btnSubmit.Enabled = false;
btnAdd.Enabled = false;
txtEnterValue.Enabled = false;
}
}
private void mnuRefereshSystemCache_Click(object sender, EventArgs e)
{
string strGetXMLPath = GblIQCare.GetXMLPath();
System.IO.FileInfo theFileInfo1 = new System.IO.FileInfo(strGetXMLPath + "\\AllMasters.con");
System.IO.FileInfo theFileInfo2 = new System.IO.FileInfo(strGetXMLPath + "\\DrugMasters.con");
System.IO.FileInfo theFileInfo3 = new System.IO.FileInfo(strGetXMLPath + "\\LabMasters.con");
theFileInfo1.Delete();
theFileInfo2.Delete();
theFileInfo3.Delete();
IIQCareSystem theCacheManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem,BusinessProcess.Security");
DataSet theMainDS = theCacheManager.GetSystemCache();
DataSet WriteXMLDS = new DataSet();
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_CouncellingType"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_CouncellingTopic"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Provider"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Division"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Ward"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_District"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Reason"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Education"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Designation"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Employee"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Occupation"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Province"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Village"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Code"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_HIVAIDSCareTypes"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ARTSponsor"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_HivDisease"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Assessment"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Symptom"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Decode"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Feature"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Function"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_HivDisclosure"].Copy());
//WriteXMLDS.Tables.Add(theMainDS.Tables["mst_Satellite"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_LPTF"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["mst_StoppedReason"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["mst_facility"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_HIVCareStatus"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_RelationshipType"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_TBStatus"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ARVStatus"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_LostFollowreason"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Regimen"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Store"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Supplier"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["mst_Donor"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Program"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Batch"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["VWDiseaseSymptom"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["mst_RegimenLine"].Copy());
WriteXMLDS.WriteXml(strGetXMLPath + "\\AllMasters.con", XmlWriteMode.WriteSchema);
WriteXMLDS.Tables.Clear();
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Strength"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_FrequencyUnits"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Drug"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Generic"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_DrugType"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Frequency"].Copy());
WriteXMLDS.WriteXml(strGetXMLPath + "\\DrugMasters.con", XmlWriteMode.WriteSchema);
WriteXMLDS.Tables.Clear();
WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_LabTest"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Lnk_TestParameter"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Lnk_LabValue"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["Lnk_ParameterResult"].Copy());
WriteXMLDS.Tables.Add(theMainDS.Tables["LabTestOrder"].Copy());
WriteXMLDS.WriteXml(strGetXMLPath + "\\LabMasters.con", XmlWriteMode.WriteSchema);
IQCareWindowMsgBox.ShowWindow("SysCacheRefresh", this);
}
