protected void generateFirstDefaultersExcell(string reportingdatefrom, string reportingdateto) { ReportingResultsManager reportingLogic = new ReportingResultsManager(); DataTable dt = reportingLogic.getfirstdefaulters(Convert.ToDateTime(reportingdateto), 1, 30); //IQWebUtils theUtils = new IQWebUtils(); //theUtils.ExporttoExcel(dt, Response); using (XLWorkbook wb = new XLWorkbook()) { String timeStamp = GetTimestamp(DateTime.Now); var ws = wb.Worksheets.Add(dt, "1to30days"); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Buffer = true; HttpContext.Current.Response.Charset = ""; HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + "defaulters" + timeStamp + ".xlsx"); using (MemoryStream MyMemoryStream = new MemoryStream()) { wb.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(HttpContext.Current.Response.OutputStream); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); } } }
public int getNumberOfTxcurr(string reportingdate) { ReportingResultsManager reportingLogic = new ReportingResultsManager(); int txcurrcount = 0; DataTable theDT = reportingLogic.gettxcurr(Convert.ToDateTime(reportingdate)); txcurrcount = theDT.Rows.Count; return(txcurrcount); }
public int getFirstStageDefaulters(string reportingdate, int mindays, int maxdays) { ReportingResultsManager reportingLogic = new ReportingResultsManager(); int firstdefaulters = 0; DataTable theDT = reportingLogic.getfirstdefaulters(Convert.ToDateTime(reportingdate), mindays, maxdays); firstdefaulters = theDT.Rows.Count; return(firstdefaulters); }
public int getltfu(string fromdate, string todate) { ReportingResultsManager reportingLogic = new ReportingResultsManager(); int ltfu = 0; DataTable theDT = reportingLogic.getltfu(Convert.ToDateTime(fromdate), Convert.ToDateTime(todate)); ltfu = theDT.Rows.Count; return(ltfu); }
public string gettracingdata(string visitid) { var RRM = new ReportingResultsManager(); Tracing[] patientTracingData = RRM.getTracingData(Convert.ToInt32(visitid)).ToArray(); string jsonScreeningObject = "[]"; jsonScreeningObject = new JavaScriptSerializer().Serialize(patientTracingData); return(jsonScreeningObject); }
public ArrayList getltfull(string fromdate, string todate) { ReportingResultsManager reportingLogic = new ReportingResultsManager(); DataTable theDT = reportingLogic.getltfu(Convert.ToDateTime(fromdate), Convert.ToDateTime(todate)); ArrayList rows = new ArrayList(); int n = 0; foreach (DataRow items in theDT.Rows) { string[] i = new string[13] { n.ToString(), items["CCCNumber"].ToString(), items["FirstName"].ToString(), items["MiddleName"].ToString(), items["LastName"].ToString(), items["MobileNumber"].ToString(), Convert.ToDateTime(items["DispenseDate"]).ToString("dd-MMM-yyyy"), items["Drug"].ToString(), Convert.ToDateTime(items["ExpectedReturn"]).ToString("dd-MMM-yyyy"), items["DaysOverDue"].ToString(), items["Traced"].ToString(), items["PID"].ToString(), items["personid"].ToString() }; rows.Add(i); } return(rows); }
public ArrayList getseconddefaultersll(string reportingdate, int mindays, int maxdays) { ReportingResultsManager reportingLogic = new ReportingResultsManager(); DataTable theDT = reportingLogic.getseconddefaulters(Convert.ToDateTime(reportingdate), mindays, maxdays); ArrayList rows = new ArrayList(); int n = 0; foreach (DataRow items in theDT.Rows) { n = n + 1; string[] i = new string[13] { n.ToString(), items["CCCNumber"].ToString(), items["FirstName"].ToString(), items["MiddleName"].ToString(), items["LastName"].ToString(), items["MobileNumber"].ToString(), Convert.ToDateTime(items["DispenseDate"]).ToString("dd-MMM-yyyy"), items["Drug"].ToString(), Convert.ToDateTime(items["ExpectedReturn"]).ToString("dd-MMM-yyyy"), items["DaysOverDue"].ToString(), items["Traced"].ToString(), items["PID"].ToString(), items["personid"].ToString() }; rows.Add(i); } return(rows); }
public string saveTracingData(int PatientId, int PersonId, string tracingdate, int tracingmethod, int tracingoutcome, string othertracingoutcome, string tracingdateofdeath, string tracingdateoftransfer, string transferfacility, string tracingnotes, string tracingstatus, int?visitid) { ILookupManager mgr = (ILookupManager)ObjectFactory.CreateInstance("BusinessProcess.CCC.BLookupManager, BusinessProcess.CCC"); var tracing = new ReportingResultsManager(); int userId = Convert.ToInt32(Session["AppUserId"]); int patientmastervisitresult = 0; int EncounterResult = 0; string savestatus = ""; DateTime? deathTracingDate = new DateTime(); int CheckoutResult = 0; //save tracing data if (tracingdateofdeath == "") { deathTracingDate = null; } else { deathTracingDate = Convert.ToDateTime(tracingdateofdeath); } DateTime?transferTracingDate = new DateTime(); if (tracingdateoftransfer == "") { transferTracingDate = null; } else { transferTracingDate = Convert.ToDateTime(tracingdateoftransfer); } try { //create patient master visit id PatientMasterVisitManager patientMasterVisit = new PatientMasterVisitManager(); LookupLogic lookupLogic = new LookupLogic(); var currentfacility = lookupLogic.GetFacility(Session["AppPosID"].ToString()); if (currentfacility == null) { currentfacility = lookupLogic.GetFacility(); } if (visitid.HasValue && visitid.Value > 0) { Tracing[] patientTracingData = tracing.getTracingData(visitid.Value).ToArray(); if (patientTracingData.Length > 0) { patientTracingData[0].Mode = tracingmethod; patientTracingData[0].Outcome = tracingoutcome; patientTracingData[0].DateTracingDone = Convert.ToDateTime(tracingdate); patientTracingData[0].TracingDateOfDeath = deathTracingDate; patientTracingData[0].TracingTransferFacility = transferfacility; patientTracingData[0].TracingTransferDate = transferTracingDate; patientTracingData[0].Remarks = tracingnotes; tracing.UpdatePatientTracing(patientTracingData[0]); Session["PatientTrace"] = ""; } } else { patientmastervisitresult = patientMasterVisit.PatientMasterVisitCheckin(PatientId, userId, currentfacility.FacilityID); //create encounter PatientEncounterManager patientEncounterManager = new PatientEncounterManager(); EncounterResult = patientEncounterManager.AddpatientEncounterTracing(Convert.ToInt32(PatientId), Convert.ToInt32(patientmastervisitresult), patientEncounterManager.GetPatientEncounterId("EncounterType", "Patient-Tracing"), 203, userId, Convert.ToDateTime(tracingdate), Convert.ToDateTime(tracingdate)); int tracingType = Convert.ToInt32(mgr.GetLookupItemId("DefaulterTracing")); //save tracing data Tracing patientTracing = new Tracing() { PersonID = PersonId, TracingType = tracingType, PatientMasterVisitId = patientmastervisitresult, DateTracingDone = Convert.ToDateTime(tracingdate), Mode = tracingmethod, Outcome = tracingoutcome, TracingDateOfDeath = deathTracingDate, TracingTransferFacility = transferfacility, TracingTransferDate = transferTracingDate, Remarks = tracingnotes, CreateDate = DateTime.Now, CreatedBy = Convert.ToInt32(Session["AppUserId"]) }; Result = tracing.AddPatientTracing(patientTracing); //checkout patient master visit PatientMasterVisitManager patientMasterVisitcheckout = new PatientMasterVisitManager(); CheckoutResult = patientMasterVisit.PatientMasterVisitCheckout(patientmastervisitresult, PatientId, 0, 0, 0, Convert.ToDateTime(tracingdate)); Session["EncounterStatusId"] = 0; Session["PatientEditId"] = 0; Session["PatientPK"] = 0; Session["PatientTrace"] = ""; if (Result > 0 && CheckoutResult > 0) { Msg = "Patient appointment Added Successfully!"; } } } catch (Exception e) { Msg = e.Message; } return(savestatus); }