protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["AppLocation"] == null || Session.Count == 0 || Session["AppUserID"].ToString() == "")
        {
            IQCareMsgBox.Show("SessionExpired", this);
            Response.Redirect("~/frmlogin.aspx", true);
        }
        SetEnrollmentCombo();
        Ajax.Utility.RegisterTypeForAjax(typeof(frmFindAddPatient));
        if (!IsPostBack)
        {
            Session["HIVPatientStatus"]   = 0;
            Session["PMTCTPatientStatus"] = 0;
            //SetEnrollmentCombo();
            Session["PatientId"] = 0;
            //(Master.FindControl("lblheaderfacility") as Label).Visible = false;
            //(Master.FindControl("lblheader") as Label).Text = "Find Add Patient";
            (Master.FindControl("levelOneNavigationUserControl1").FindControl("lblheader") as Label).Text  = "Find Add Patient";
            (Master.FindControl("levelOneNavigationUserControl1").FindControl("lblRoot") as Label).Visible = false;

            txtDOB.Attributes.Add("onblur", "DateFormat(this,this.value,event,true,'3'); isCheckValidDate('" + Application["AppCurrentDate"] + "', '" + txtDOB.ClientID + "', '" + txtDOB.ClientID + "');");
            txtDOB.Attributes.Add("onkeyup", "DateFormat(this,this.value,event,false,'3')");
            //      txtDOB.Attributes.Add("OnBlur", "DateFormat(this,this.value,event,true,'3')");
            //txtpatientenrolno.Attributes.Add("onkeyup", "chkInteger('" + txtpatientenrolno.ClientID + "')");

            if (Request.QueryString["loc"] != null)
            {
                if (Request.QueryString["loc"] == "w")
                {
                    Utility theUtil = new Utility();
                    txtidentificationno.Text = theUtil.DecodeFrom64(Request.QueryString["iqnum"].ToString());

                    /*
                     * Calling generate cache from common location
                     * Update By: Gaurav
                     * Update Date: 8 July 2014
                     */
                    IQCareUtils.GenerateCache(false);

                    windowlogin(theUtil.DecodeFrom64(Request.QueryString["AppName"]), Convert.ToInt32(theUtil.DecodeFrom64(Request.QueryString["apploc"].ToString())), Convert.ToInt32(theUtil.DecodeFrom64(Request.QueryString["sysid"].ToString())));
                }
            }
            if (Request.QueryString["ReportName"] != null)
            {
                theReportName      = Request.QueryString["ReportName"];
                tHeading.InnerText = "Find Patient";
                btnAdd.Visible     = false;
            }
            else
            {
                theReportName = null;
            }
            if (Request.QueryString["mnuClicked"] != null)
            {
                if (Request.QueryString["mnuClicked"] == "DeletePatient")
                {
                    //add.Visible = false;
                    //RTyagi..19Feb 07..
                    /***************** Check For User Rights ****************/
                    AuthenticationManager Authentiaction = new AuthenticationManager();
                    //if (Request.QueryString["name"] == "Delete")
                    //{
                    if (Authentiaction.HasFunctionRight(ApplicationAccess.DeletePatient, FunctionAccess.Delete, (DataTable)Session["UserRight"]) == false)
                    {
                        string theUrl = "./frmFacilityHome.aspx";
                        Response.Redirect(theUrl);
                    }
                    //}

                    tHeading.InnerText = "Delete Patient";
                    //(Master.FindControl("lblheader") as Label).Text = "Delete Patient";
                    (Master.FindControl("levelOneNavigationUserControl1").FindControl("lblheader") as Label).Text = "Delete Patient";

                    btnAdd.Visible = false;
                    tdPatientOtherDetails.Visible = false;
                }
            }

            Session.Remove("GrdData");
            Session.Remove("SortDirection");
            if (Request.QueryString["FormName"] != null)
            {
                if (Request.QueryString["FormName"].ToString() == "AppointmentMain")
                {
                    //add.Visible = false;
                    btnAdd.Visible = false;
                }
            }
            if (Request.QueryString["FormName"] != null)
            {
                if (Request.QueryString["FormName"].ToString() == "FamilyInfo")
                {
                    btnAdd.Visible = false;
                }
            }
            Init_Page();
        }
    }
Exemple #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["AppLocation"] == null || Session.Count == 0 || Session["AppUserID"].ToString() == "")
        {
            IQCareMsgBox.Show("SessionExpired", this);
            Response.Redirect("~/frmlogin.aspx", true);
        }
        #region Commented Old Code for GenerateCache
        //System.IO.FileInfo theFileInfo1 = new System.IO.FileInfo(Server.MapPath(".\\XMLFiles\\AllMasters.con").ToString());
        //System.IO.FileInfo theFileInfo2 = new System.IO.FileInfo(Server.MapPath(".\\XMLFiles\\DrugMasters.con").ToString());
        //System.IO.FileInfo theFileInfo3 = new System.IO.FileInfo(Server.MapPath(".\\XMLFiles\\LabMasters.con").ToString());
        //System.IO.FileInfo theFileInfo4 = new System.IO.FileInfo(Server.MapPath(".\\XMLFiles\\Frequency.xml").ToString());
        //theFileInfo1.Delete();
        //theFileInfo2.Delete();
        //theFileInfo3.Delete();
        //theFileInfo4.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_pmtctDeCode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Module"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ModDecode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ARVSideEffects"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ModCode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Country"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Town"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["VWDiseaseSymptom"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["VW_ICDList"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["mst_RegimenLine"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["mst_Store"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["mst_BlueCode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["mst_BlueDecode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_FormBuilderTab"].Copy());
        //WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "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.Tables.Add(theMainDS.Tables["Mst_DrugSchedule"].Copy());
        //WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "DrugMasters.con",XmlWriteMode.WriteSchema);

        //WriteXMLDS.Tables.Clear();
        //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.Tables.Add(theMainDS.Tables["mst_PatientLabPeriod"].Copy());
        //WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "LabMasters.con",XmlWriteMode.WriteSchema);

        //WriteXMLDS.Tables.Clear();
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Frequency"].Copy());
        //WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "Frequency.xml", XmlWriteMode.WriteSchema);
        #endregion

        /*
         * Calling generate cache from common location
         * Update By: Gaurav
         * Update Date: 8 July 2014
         */
        string code = Request.QueryString["Code"].ToString();
        try
        {
            if ((string.IsNullOrEmpty(code)) || (code == "1"))
            {
                IQCareUtils.GenerateCache(true);
            }
            else if (code == "2")
            {
                try
                {
                    IReportIQTools IQToolsReport = (IReportIQTools)ObjectFactory.CreateInstance("BusinessProcess.Reports.IQToolsReport,BusinessProcess.Reports");
                    IQToolsReport.IQToolsRefresh();
                }
                catch (Exception exp)
                {
                    MsgBuilder theBuilder = new MsgBuilder();
                    theBuilder.DataElements["MessageText"] = exp.Message.ToString();
                    IQCareMsgBox.Show("#C1", theBuilder, this);
                }
            }
            DataSet theDS = new DataSet();
            theDS.ReadXml(MapPath("XMLFiles\\ALLMasters.con"));
            BindFunctions BindManager = new BindFunctions();
            IQCareUtils   theUtils    = new IQCareUtils();
            if (theDS.Tables["Mst_Facility"] != null)
            {
                DataView theDV = new DataView(theDS.Tables["Mst_Facility"]);
                theDV.RowFilter = "DeleteFlag=0 and FacilityId=" + Convert.ToInt32(Session["AppLocationId"]);
                if (theDV.Table != null)
                {
                    DataTable theDT = (DataTable)theUtils.CreateTableFromDataView(theDV);
                    HttpContext.Current.Session["Billing"] = theDT.Rows[0]["Billing"].ToString();
                    HttpContext.Current.Session["Wards"]   = theDT.Rows[0]["Wards"].ToString();
                    if (theDT.Rows[0]["PMSCM"].ToString() == "1")
                    {
                        Session["SCMModule"] = "PMSCM";
                    }
                    else
                    {
                        Session["SCMModule"] = null;
                    }
                }
            }
        }
        catch (Exception err)
        {
            MsgBuilder theBuilder = new MsgBuilder();
            theBuilder.DataElements["MessageText"] = err.Message.ToString();
            IQCareMsgBox.Show("#C1", theBuilder, this);
        }
        finally
        {
            Response.Redirect("frmFacilityHome.aspx");
        }
    }
Exemple #3
0
        private void mnuRefereshSystemCache_Click(object sender, EventArgs e)
        {
            #region Commented Old Code for GenerateCache
            //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);
            #endregion

            try
            {
                /*
                 * Calling generate cache from common location
                 * Update By: Gaurav
                 * Update Date: 8 July 2014
                 */
                IQCareUtils.GenerateCache(true);
                IQCareWindowMsgBox.ShowWindow("SysCacheRefresh", this);
            }
            catch (System.UnauthorizedAccessException uex)
            {
                IQCareWindowMsgBox.ShowWindow("Error - Access to the path is denied.", "", "", this);
            }
            catch (Exception ex)
            {
                IQCareWindowMsgBox.ShowWindow("Error - unable to refresh cache.", "", "", this);
            }
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        #region Commented Old Code for GenerateCache
        //System.IO.FileInfo theFileInfo1 = new System.IO.FileInfo(Server.MapPath(".\\XMLFiles\\AllMasters.con").ToString());
        //System.IO.FileInfo theFileInfo2 = new System.IO.FileInfo(Server.MapPath(".\\XMLFiles\\DrugMasters.con").ToString());
        //System.IO.FileInfo theFileInfo3 = new System.IO.FileInfo(Server.MapPath(".\\XMLFiles\\LabMasters.con").ToString());
        //System.IO.FileInfo theFileInfo4 = new System.IO.FileInfo(Server.MapPath(".\\XMLFiles\\Frequency.xml").ToString());
        //theFileInfo1.Delete();
        //theFileInfo2.Delete();
        //theFileInfo3.Delete();
        //theFileInfo4.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_pmtctDeCode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Module"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ModDecode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ARVSideEffects"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ModCode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Country"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Town"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["VWDiseaseSymptom"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["VW_ICDList"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["mst_RegimenLine"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["mst_Store"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["mst_BlueCode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["mst_BlueDecode"].Copy());
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_FormBuilderTab"].Copy());
        //WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "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.Tables.Add(theMainDS.Tables["Mst_DrugSchedule"].Copy());
        //WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "DrugMasters.con",XmlWriteMode.WriteSchema);

        //WriteXMLDS.Tables.Clear();
        //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.Tables.Add(theMainDS.Tables["mst_PatientLabPeriod"].Copy());
        //WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "LabMasters.con",XmlWriteMode.WriteSchema);

        //WriteXMLDS.Tables.Clear();
        //WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Frequency"].Copy());
        //WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "Frequency.xml", XmlWriteMode.WriteSchema);
        #endregion

        /*
         * Calling generate cache from common location
         * Update By: Gaurav
         * Update Date: 8 July 2014
         */
        IQCareUtils.GenerateCache(true);
        Response.Redirect("frmFacilityHome.aspx");
    }