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