public static DateTime SystemDate() { IIQCareSystem SystemManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); DateTime theCurrentDate = SystemManager.SystemDate(); SystemManager = null; return(theCurrentDate); }
private void FillSystemDropdown() { BindFunctions theBindManager = new BindFunctions(); IIQCareSystem SystemManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); DataTable theDT = SystemManager.GetIQCareSystems(0); theBindManager.BindCombo(cmbSystem, theDT, "SystemName", "SystemId"); }
public PatientRegistrationForm() { // // Required for telerik Reporting designer support // InitializeComponent(); // // TODO: Add any constructor code after InitializeComponent call // IIQCareSystem appManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); PatientInfo.ConnectionString = appManager.GetEMRConnectionString(); pbLogo.Value = "logo.png"; }
protected void Page_Load(object sender, EventArgs e) { try { IIQCareSystem ReportingTables = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem,BusinessProcess.Security"); ReportingTables.RefreshReportingTables(1); Response.Redirect("frmFacilityHome.aspx"); } catch (Exception err) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = err.Message.ToString(); IQCareMsgBox.Show("#C1", theBuilder, this); } }
/// <summary> /// Fields the validation. /// </summary> /// <param name="labtobedone">The labtobedone.</param> /// <param name="orderbydate">The orderbydate.</param> /// <param name="orderby">The orderby.</param> /// <param name="appcurrentdate">The appcurrentdate.</param> /// <returns></returns> private Boolean FieldValidation(string labtobedone, string orderbydate, string orderby, string appcurrentdate) { IIQCareSystem _iqcareSecurity = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); DateTime _theCurrentDate = (DateTime)_iqcareSecurity.SystemDate(); IQCareUtils theUtils = new IQCareUtils(); Page page = HttpContext.Current.Handler as Page; if (orderby == "0") { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["Control"] = "Ordered By"; IQCareMsgBox.Show("BlankDropDown", theMsg, page); return(false); } else if (orderbydate == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Ordered By Date"; IQCareMsgBox.Show("BlankTextBox", theBuilder, page); return(false); } else if (Convert.ToDateTime(orderbydate) > Convert.ToDateTime(appcurrentdate)) { IQCareMsgBox.Show("OrderedToDate", page); return(false); } //---------- if (labtobedone != "") { DateTime _theVisitDate = Convert.ToDateTime(theUtils.MakeDate(labtobedone)); if (HttpContext.Current.Session["IEVisitDate"] != null) //ViewState["IEVisitDate"] != null) { DateTime _theIEVisitDate = Convert.ToDateTime(HttpContext.Current.Session["IEVisitDate"].ToString()); //Convert.ToDateTime(ViewState["IEVisitDate"].ToString()); if (_theIEVisitDate > _theVisitDate) { IQCareMsgBox.Show("CompareLabTobeDoneDate", page); return(false); } } } return(true); }
protected void Page_Load(object sender, EventArgs e) { IIQCareSystem appManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor(); System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable(); TypeReportSource reportSource = new TypeReportSource(); reportSource.TypeName = typeof(PatientSummary).AssemblyQualifiedName; ReportSource myrep = reportSource; myrep.Parameters.Add(new Telerik.Reporting.Parameter("patientpk", Session["PatientId"].ToString())); myrep.Parameters.Add(new Telerik.Reporting.Parameter("logopath", "\\logo.png")); reportViewer1.ReportSource = reportSource; reportViewer1.ParametersAreaVisible = false; this.reportViewer1.RefreshReport(); }
/// <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 { } }
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); } try { IIQCareSystem ReportingTables = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem,BusinessProcess.Security"); ReportingTables.RefreshReportingTables(1); Response.Redirect("frmFacilityHome.aspx"); } catch (Exception err) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = err.Message.ToString(); IQCareMsgBox.Show("#C1", theBuilder, this); } }
public PatientSummary() { // // Required for telerik Reporting designer support // InitializeComponent(); // // TODO: Add any constructor code after InitializeComponent call // IIQCareSystem appManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); string sconstring = appManager.GetEMRConnectionString().ToLower().Replace("initial catalog = iqcare", "initial catalog = iqtools"); VLs.ConnectionString = sconstring; ARTInfo.ConnectionString = sconstring; CD4.ConnectionString = sconstring; ClinicalNotes.ConnectionString = sconstring; PatientDetails.ConnectionString = sconstring; pbLogo.Value = "logo.png"; }
protected void btnSystemSave_Click(object sender, EventArgs e) { try { Session["SystemId"] = ConfigurationManager.AppSettings["SystemId"].ToString(); IIQCareSystem SystemManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); if (cmbSystem.SelectedValue == "2") { DataTable theDT = SystemManager.GetIQCareSystems(1); } tblSystem.Visible = false; btnAdd.Enabled = true; Init_Form(); } catch (Exception err) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = err.Message.ToString(); IQCareMsgBox.Show("#C1", theBuilder, this); return; } }
private static void GenerateCacheImpl(string path) { string allMaster = path + "AllMasters.con"; string drugMaster = path + "DrugMasters.con"; string labMaster = path + "LabMasters.con"; string frequency = path + "Frequency.xml"; System.IO.FileInfo theFileInfo1 = new System.IO.FileInfo(allMaster); System.IO.FileInfo theFileInfo2 = new System.IO.FileInfo(drugMaster); System.IO.FileInfo theFileInfo3 = new System.IO.FileInfo(labMaster); System.IO.FileInfo theFileInfo4 = new System.IO.FileInfo(frequency); 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_Provider"].Copy()); WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Ward"].Copy()); WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Division"].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_CouncellingType"].Copy()); WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_CouncellingTopic"].Copy()); WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ReferredFrom"].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.Tables.Add(theMainDS.Tables["VW_UserDesignationTransaction"].Copy()); WriteXMLDS.WriteXml(allMaster, 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(drugMaster, 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.Tables.Add(theMainDS.Tables["mst_PatientLabPeriod"].Copy()); WriteXMLDS.WriteXml(labMaster, XmlWriteMode.WriteSchema); WriteXMLDS.Tables.Clear(); WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Frequency"].Copy()); WriteXMLDS.WriteXml(frequency, XmlWriteMode.WriteSchema); }
private Boolean FieldValidation() { IIQCareSystem IQCareSecurity = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); DateTime theCurrentDate = (DateTime)IQCareSecurity.SystemDate(); IQCareUtils theUtils = new IQCareUtils(); if (TxtFirstName.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "First Name"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtFirstName.Focus(); return(false); } if (TxtLastName.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Last Name"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtLastName.Focus(); return(false); } if (TxtAdmissionNo.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Last Name"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); return(false); } if (TxtRegistrationDate.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Registration Date"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtRegistrationDate.Focus(); return(false); } DateTime theEnrolDate = Convert.ToDateTime(theUtils.MakeDate(TxtRegistrationDate.Text)); if (theEnrolDate > theCurrentDate) { IQCareMsgBox.Show("EnrolDate", this); TxtRegistrationDate.Focus(); return(false); } if (DDGender.SelectedValue == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Sex"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); DDGender.Focus(); return(false); } if (TxtDOB.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "DOB"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtDOB.Focus(); return(false); } DateTime theDOBDate = Convert.ToDateTime(theUtils.MakeDate(TxtDOB.Text)); if (theDOBDate > theCurrentDate) { IQCareMsgBox.Show("DOBDate", this); TxtDOB.Focus(); return(false); } if (theDOBDate > theEnrolDate) { IQCareMsgBox.Show("DOB_EnrolDate", this); return(false); } return(true); }
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); }
private Boolean FieldValidation() { IIQCareSystem IQCareSecurity = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); DateTime theCurrentDate = (DateTime)IQCareSecurity.SystemDate(); IQCareUtils theUtils = new IQCareUtils(); if (DDFinalResult.SelectedItem.Value == "9") { spDeath.Visible = true; } if (TxtFirstName.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "First Name"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtFirstName.Focus(); return(false); } if (TxtLastName.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Last Name"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtLastName.Focus(); return(false); } if (TxtInfantId.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Infant ID"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtInfantId.Focus(); return(false); } try { int i = Convert.ToInt32(TxtInfantId.Text); } catch { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Infant ID"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtDateOfBirth.Focus(); return(false); } if (TxtDateOfBirth.Value.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "DOB"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtDateOfBirth.Focus(); return(false); } DateTime theDOBDate = Convert.ToDateTime(theUtils.MakeDate(TxtDateOfBirth.Value)); if (theDOBDate > theCurrentDate) { IQCareMsgBox.Show("DOBDate", this); TxtDateOfBirth.Focus(); return(false); } if (TxtDeathDate.Text != "") { spDeath.Visible = true; DateTime theDeathDate = Convert.ToDateTime(theUtils.MakeDate(TxtDeathDate.Text)); if (theDeathDate > theCurrentDate) { IQCareMsgBox.Show("DeathDateCheck", this); TxtDeathDate.Focus(); return(false); } if (theDeathDate < theDOBDate) { IQCareMsgBox.Show("DeathDOBDate", this); TxtDeathDate.Focus(); return(false); } } //if (DDInfantFeedingPractice.SelectedItem.Value.Trim() == "0") //{ // IQCareMsgBox.Show("InfantFeed", this); // DDInfantFeedingPractice.Focus(); // return false; //} //if (DDHIVTestType.SelectedItem.Value.Trim() == "0") //{ // IQCareMsgBox.Show("InfantHivTestType", this); // DDHIVTestType.Focus(); // return false; //} //if (DDResult.SelectedItem.Value.Trim() == "0") //{ // IQCareMsgBox.Show("InfantResult", this); // DDResult.Focus(); // return false; //} //if (DDFinalResult.SelectedItem.Value.Trim() == "0") //{ // IQCareMsgBox.Show("InfantFinalResult", this); // DDFinalResult.Focus(); // return false; //} return(true); }
/// <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 Boolean FieldValidation() { IIQCareSystem IQCareSecurity = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); DateTime theCurrentDate = (DateTime)IQCareSecurity.SystemDate(); IQCareUtils theUtils = new IQCareUtils(); if (TxtFirstName.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "First Name"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtFirstName.Focus(); return(false); } if (TxtLastName.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Last Name"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtLastName.Focus(); return(false); } if (TxtRegistrationDate.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Registration Date"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtRegistrationDate.Focus(); return(false); } DateTime theEnrolDate = Convert.ToDateTime(theUtils.MakeDate(TxtRegistrationDate.Text)); if (theEnrolDate > theCurrentDate) { IQCareMsgBox.Show("EnrolDate", this); TxtRegistrationDate.Focus(); return(false); } if (DDGender.SelectedValue == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Sex"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); DDGender.Focus(); return(false); } if (TxtDOB.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "DOB"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtDOB.Focus(); return(false); } DateTime theDOBDate = Convert.ToDateTime(theUtils.MakeDate(TxtDOB.Text)); if (theDOBDate > theCurrentDate) { IQCareMsgBox.Show("DOBDate", this); TxtDOB.Focus(); return(false); } if (theDOBDate > theEnrolDate) { IQCareMsgBox.Show("DOB_EnrolDate", this); return(false); } /////17-09-09 //if (chkTransferIn.Checked == true && ddReferredFrom.SelectedIndex != 0) //{ // // //MsgBuilder theBuilder = new MsgBuilder(); // // theBuilder.DataElements["Control"] = "RefFrom"; // //// IQCareMsgBox.Show("BlankDropDown", theBuilder, this); // return false; // } ////17-09-09 if (chkTransferIn.Checked == false && ddReferredFrom.SelectedIndex != 0) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Either Tranfer in/Referred From"; IQCareMsgBox.Show("BlankDropDown", theBuilder, this); return(false); } if (chkTransferIn.Checked == true && ddReferredFrom.SelectedIndex == 0) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Either Tranfer in/Referred From"; IQCareMsgBox.Show("BlankDropDown", theBuilder, this); return(false); } if (TxtANCNumber.Text == "" && TxtPMTCTNumber.Text == "" && TxtAdmissionNumber.Text == "" && TxtOutPatientNumber.Text == "") { IQCareMsgBox.Show("PMTCTEnrol_ANC", this); return(false); } IPatientRegistration ValMgrPMTCT = (IPatientRegistration)ObjectFactory.CreateInstance(ObjFactoryParameter); string msg = ""; if (TxtANCNumber.Text != "") { DataTable theDT = ValMgrPMTCT.Validate(TxtANCNumber.Text, "ANC"); if (theDT.Rows.Count > 0) { //if (Request.QueryString["Name"] == "Edit") if (Convert.ToInt32(Session["PatientId"]) > 0) //i.e. update mode { if (theDT.Rows[0]["IDNumber"].ToString() != Convert.ToString(ViewState["ANC"])) { msg = "ANC" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this); MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = msg; IQCareMsgBox.Show("#C1", theBuilder, this); return(false); } } else { msg = "ANC" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this); MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = msg; IQCareMsgBox.Show("#C1", theBuilder, this); return(false); } } } if (TxtPMTCTNumber.Text != "") { DataTable theDT = ValMgrPMTCT.Validate(TxtPMTCTNumber.Text, "PMTCT"); if (theDT.Rows.Count > 0) { //if (Request.QueryString["Name"] == "Edit") //if (Request.QueryString["Name"] != "Add") //i.e. edit mode if (Convert.ToInt32(Session["PatientId"]) > 0) { if (theDT.Rows[0]["IDNumber"].ToString() != ViewState["PMTCT"].ToString()) { msg = "PMTCT" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this); MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = msg; IQCareMsgBox.Show("#C1", theBuilder, this); return(false); } } else { msg = "PMTCT" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this); MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = msg; IQCareMsgBox.Show("#C1", theBuilder, this); return(false); } } } if (TxtAdmissionNumber.Text != "") { DataTable theDT = ValMgrPMTCT.Validate(TxtAdmissionNumber.Text, "Admission"); if (theDT.Rows.Count > 0) { //if (Request.QueryString["Name"] == "Edit") //if (Request.QueryString["Name"] != "Add") //i.e. edit mode if (Convert.ToInt32(Session["PatientId"]) > 0) { if (theDT.Rows[0]["IDNumber"].ToString() != ViewState["Admission"].ToString()) { msg = "Admission" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this); MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = msg; IQCareMsgBox.Show("#C1", theBuilder, this); return(false); } } else { msg = "Admission" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this); MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = msg; IQCareMsgBox.Show("#C1", theBuilder, this); return(false); } } } if (TxtOutPatientNumber.Text != "") { DataTable theDT = ValMgrPMTCT.Validate(TxtOutPatientNumber.Text, "Outpatient"); if (theDT.Rows.Count > 0) { //if (Request.QueryString["Name"] == "Edit") //if (Request.QueryString["Name"] != "Add") //i.e. edit mode if (Convert.ToInt32(Session["PatientId"]) > 0) { if (theDT.Rows[0]["IDNumber"].ToString() != ViewState["Outpatient"].ToString()) { msg = "OutpatientNumber" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this); MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = msg; IQCareMsgBox.Show("#C1", theBuilder, this); return(false); } } else { msg = "OutpatientNumber" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this); MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = msg; IQCareMsgBox.Show("#C1", theBuilder, this); return(false); } } } return(true); }
private void GetApplicationParameters() { try { //CLogger.WriteLog(ELogLevel.INFO, "Form: frmLogin, Method: GetApplicationParameters() begin!"); IUser ApplicationManager; ApplicationManager = (IUser)ObjectFactory.CreateInstance("BusinessProcess.Security.BUser, BusinessProcess.Security"); DataSet theDS = ApplicationManager.GetFacilitySettings(1); DataTable theDT = theDS.Tables[0]; if (theDT.Rows.Count < 1) { string theUrl = string.Format("{0}", "./AdminForms/frmAdmin_FacilityList.aspx?BS=true"); Response.Redirect(theUrl); } if (!string.IsNullOrEmpty(theDT.Rows[0]["Image"].ToString())) { imgLogin.ImageUrl = string.Format("images/{0}", theDT.Rows[0]["Image"].ToString()); } else { imgLogin.ImageUrl = "~/Images/Login.jpg"; } Session["SystemId"] = Convert.ToInt32(theDT.Rows[0]["SystemId"]); #region "Version Control" //Run upgrade scripts here //-------------------------------------------------------------------------------------------------------------------- if (theDS.Tables[1].Rows[0]["AppVer"].ToString() != AuthenticationManager.AppVersion || ((DateTime)theDS.Tables[1].Rows[0]["RelDate"]).ToString("dd-MMM-yyyy") != AuthenticationManager.ReleaseDate) { IIQCareSystem appManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); string scriptDirectory = @"C:\inetpub\wwwroot\IQCare\scripts\"; string dbversion = theDS.Tables[1].Rows[0]["AppVer"].ToString(); int iDBVersion = Convert.ToInt16(dbversion.Replace(".", "")); int iAppversion = Convert.ToInt16(AuthenticationManager.AppVersion.Replace(".", "")); DirectoryInfo di = new DirectoryInfo(scriptDirectory); FileInfo[] rgFiles = di.GetFiles("*.sql"); foreach (FileInfo fi in rgFiles) { int iScriptVersion = Convert.ToInt16(fi.Name.Replace(".sql", "").Replace(".", "")); if (iScriptVersion > iDBVersion) { FileInfo fileInfo = new FileInfo(fi.FullName); string script = fileInfo.OpenText().ReadToEnd(); appManager.ExecuteBatchNonQuery(script); } } theDS = ApplicationManager.GetFacilitySettings(1); } //-------------------------------------------------------------------------------------------------------------------- //Check if DB has been upgraded to latest version if (theDS.Tables[1].Rows[0]["AppVer"].ToString() != AuthenticationManager.AppVersion || ((DateTime)theDS.Tables[1].Rows[0]["RelDate"]).ToString("dd-MMM-yyyy") != AuthenticationManager.ReleaseDate) { string script = "<script language = 'javascript' defer ='defer' id = 'confirm'>\n"; script += "var ans=true;\n"; script += "alert('You are using a Wrong Version of Application. Please contact Support staff.');\n"; script += "if (ans==true)\n"; script += "{\n"; script += "window.close() - y;\n"; script += "}\n"; script += "</script>\n"; RegisterStartupScript("confirm", script); btnLogin.Enabled = false; } #endregion ApplicationManager = null; IIQCareSystem DateManager; DateManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); DateTime theDTime = DateManager.SystemDate(); ViewState["theCurrentDate"] = theDTime; lblDate.Text = theDTime.ToString("dd-MMM-yyyy"); Application["AppCurrentDate"] = theDTime.ToString("dd-MMM-yyyy"); Session["AppCurrentDateClass"] = theDTime.ToString("dd-MMM-yyyy"); //CLogger.WriteLog(ELogLevel.INFO, "Form: frmLogin, Method: GetApplicationParameters() end!"); } catch (Exception ex) { CLogger.WriteLog(ELogLevel.ERROR, "Form: frmLogin, Method: GetApplicationParameters() ", ex); } }
private void GenerateCache() { IIQCareSystem DateManager; DateManager = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); DateTime theDTime = DateManager.SystemDate(); 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()); if (theFileInfo1.LastWriteTime.Date != theDTime.Date || theFileInfo2.LastWriteTime.Date != theDTime.Date || theFileInfo3.LastWriteTime.Date != theDTime.Date) { 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_Provider"].Copy()); WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Ward"].Copy()); WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Division"].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_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_CouncellingType"].Copy()); WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_CouncellingTopic"].Copy()); WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_ReferredFrom"].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.WriteXml(Server.MapPath(@"~\XMLFiles\AllMasters.con").ToString(), 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\DrugMasters.con").ToString(), 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.Tables.Add(theMainDS.Tables["mst_PatientLabPeriod"].Copy()); WriteXMLDS.WriteXml(Server.MapPath(@"~\XMLFiles\LabMasters.con").ToString(), XmlWriteMode.WriteSchema); } }
protected void btnRefresh_Click(object sender, EventArgs e) { IIQCareSystem theRptTables = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem,BusinessProcess.Security"); theRptTables.RefreshReportingTables(1); }
private Boolean FieldValidation() { IIQCareSystem IQCareSecurity = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security"); DateTime theCurrentDate = (DateTime)IQCareSecurity.SystemDate(); IQCareUtils theUtils = new IQCareUtils(); if (DDFinalResult.SelectedItem.Value == "9") { spDeath.Visible = true; } if (TxtFirstName.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "First Name"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtFirstName.Focus(); return(false); } if (TxtLastName.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Last Name"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtLastName.Focus(); return(false); } if (TxtInfantId.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Infant ID"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtInfantId.Focus(); return(false); } try { Int64 i = Convert.ToInt64(TxtInfantId.Text); } catch { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "Infant ID"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtDateOfBirth.Focus(); return(false); } if (TxtDateOfBirth.Value.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["Control"] = "DOB"; IQCareMsgBox.Show("BlankTextBox", theBuilder, this); TxtDateOfBirth.Focus(); return(false); } DateTime theDOBDate = Convert.ToDateTime(theUtils.MakeDate(TxtDateOfBirth.Value)); if (theDOBDate > theCurrentDate) { IQCareMsgBox.Show("DOBDate", this); TxtDateOfBirth.Focus(); return(false); } int Age = GetAge(theDOBDate); if (TxtDateOfBirth.Value != "") { Decimal AgeinYear = Math.Round(Convert.ToDecimal(Session["PatientAge"]), 0); if (Convert.ToDecimal(Age) >= AgeinYear) { //ScriptManager.RegisterStartupScript(this, GetType(), "PatientAge", "alert('Infant Age cannot be more than Parent Age');", true); MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["Control"] = "Infant Age cannot be more than Parent Age"; IQCareMsgBox.Show("PatientAge", theMsg, this); TxtDateOfBirth.Focus(); return(false); } } if (TxtDeathDate.Value != "") { spDeath.Visible = true; DateTime theDeathDate = Convert.ToDateTime(theUtils.MakeDate(TxtDeathDate.Value)); if (theDeathDate > theCurrentDate) { IQCareMsgBox.Show("DeathDateCheck", this); TxtDeathDate.Focus(); return(false); } if (theDeathDate < theDOBDate) { IQCareMsgBox.Show("DeathDOBDate", this); TxtDeathDate.Focus(); return(false); } } //if (DDInfantFeedingPractice.SelectedItem.Value.Trim() == "0") //{ // IQCareMsgBox.Show("InfantFeed", this); // DDInfantFeedingPractice.Focus(); // return false; //} //if (DDHIVTestType.SelectedItem.Value.Trim() == "0") //{ // IQCareMsgBox.Show("InfantHivTestType", this); // DDHIVTestType.Focus(); // return false; //} //if (DDResult.SelectedItem.Value.Trim() == "0") //{ // IQCareMsgBox.Show("InfantResult", this); // DDResult.Focus(); // return false; //} //if (DDFinalResult.SelectedItem.Value.Trim() == "0") //{ // IQCareMsgBox.Show("InfantFinalResult", this); // DDFinalResult.Focus(); // return false; //} return(true); }
protected void Page_Load(object sender, EventArgs e) { try { 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()); theFileInfo1.Delete(); theFileInfo2.Delete(); theFileInfo3.Delete(); } catch { } 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()); if (theMainDS.Tables.Contains("Users")) { WriteXMLDS.Tables.Add(theMainDS.Tables["Users"].Copy()); } WriteXMLDS.Tables.Add(theMainDS.Tables["Mst_Store"].Copy()); try { WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "AllMasters.con", XmlWriteMode.WriteSchema); } catch { } 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()); try { WriteXMLDS.WriteXml(Server.MapPath(".\\XMLFiles\\").ToString() + "LabMasters.con", XmlWriteMode.WriteSchema); } catch { } try { WriteXMLDS.Tables.Clear(); WriteXMLDS = new DataSet("QBReportList"); WriteXMLDS.Tables.Add(theMainDS.Tables["QueryBuilderReports"].Copy()); WriteXMLDS.WriteXml(Server.MapPath("~\\XMLFiles\\QueryBuilderReports.con"), XmlWriteMode.WriteSchema); } catch { } Response.Redirect("frmFacilityHome.aspx"); }
private int ImportExportDBUpdates(DataSet dsCollectDataToSave, bool isUpdate, bool isVersionUpdate, IImportExportForms objImportFormDetails) { if (dsCollectDataToSave.Tables.Count < 0) { return(-1); } IIQCareSystem objIIQCareSystem = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem,BusinessProcess.Security"); int iRes = 0; decimal vernumber = Convert.ToDecimal(dsCollectDataToSave.Tables[15].Rows[0]["VersionName"]); DataSet DSFormVerTables = new DataSet(); dtmstformversion = clsCommon.CreateMstVersionTable(); DataRow drfrmver = dtmstformversion.NewRow(); String dtchng; if (dsCollectDataToSave.Tables[15].Rows[0]["VersionDate"] != null) { dtchng = DateTime.Parse(dsCollectDataToSave.Tables[15].Rows[0]["VersionDate"].ToString()).ToString("dd-MMM-yyyy"); } else { dtchng = objIIQCareSystem.SystemDate().ToString("dd-MMM-yyyy"); } drfrmver["VerId"] = 0; drfrmver["VersionDate"] = dtchng.ToString(); drfrmver["UserId"] = GblIQCare.AppUserId; //version will not update if same form is imported if (isUpdate && !isVersionUpdate) { drfrmver["VersionName"] = vernumber.ToString(); } else if (!isUpdate && isVersionUpdate) { //increment version if any changes found on form vernumber = vernumber + Convert.ToDecimal(0.1); dtchng = DateTime.Parse(dsCollectDataToSave.Tables[15].Rows[0]["VersionDate"].ToString()).ToString("dd-MMM-yyyy"); drfrmver["VersionName"] = vernumber.ToString(); dtmstformversion = clsCommon.CreateMstVersionTable(); dtTabchanges = clsCommon.ManageVersionTab(); dtSectionchanges = clsCommon.ManageVersionSection(); dtFieldChanges = clsCommon.ManageVersionField(); dtConFieldchanges = clsCommon.ManageVersionConField(); } else { //dtchng = objIIQCareSystem.SystemDate(); drfrmver["VersionDate"] = dtchng.ToString(); drfrmver["VersionName"] = vernumber.ToString(); dtTabchanges = clsCommon.ManageVersionTab(); dtSectionchanges = clsCommon.ManageVersionSection(); dtFieldChanges = clsCommon.ManageVersionField(); dtConFieldchanges = clsCommon.ManageVersionConField(); } dtmstformversion.Rows.Add(drfrmver); DSFormVerTables.Tables.Add(dtmstformversion); DSFormVerTables.Tables.Add(dtTabchanges); DSFormVerTables.Tables.Add(dtSectionchanges); DSFormVerTables.Tables.Add(dtFieldChanges); DSFormVerTables.Tables.Add(dtConFieldchanges); iRes = objImportFormDetails.ImportForms(dsCollectDataToSave, GblIQCare.AppUserId, System.Convert.ToInt32(GblIQCare.AppCountryId), DSFormVerTables, GblIQCare.AppLocationId); return(iRes); }