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(); } }
protected void Page_Load(object sender, EventArgs e) { (Master.FindControl("pnlExtruder") as Panel).Visible = false; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("lblformname") as Label).Text = "Pharmacy Dashboard"; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("patientLevelMenu") as Menu).Visible = false; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("PharmacyDispensingMenu") as Menu).Visible = true; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("UserControl_Alerts1") as UserControl).Visible = false; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("PanelPatiInfo") as Panel).Visible = false; if (!IsPostBack) { BindCombo(); } ISCMReport objPODetails = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport, BusinessProcess.SCM"); DataSet theDTPODetails = objPODetails.PharmacyDashBoard(Convert.ToInt32(ddlStore.SelectedValue)); RadHtmlChart1.DataSource = theDTPODetails.Tables[0]; RadHtmlChart1.DataBind(); RadHtmlChart2.DataSource = theDTPODetails.Tables[1]; RadHtmlChart2.DataBind(); grdDrugsRunningOut.DataSource = theDTPODetails.Tables[2]; grdDrugsRunningOut.DataBind(); }
private void GetStockSummaryItems() { ISCMReport objOpenStock = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport,BusinessProcess.SCM"); DataTable dt = objOpenStock.GetStockSummaryLineList(); ShowGrid(dt); }
private void btnSubmit_Click(object sender, EventArgs e) { if (Validation_Form() != true) { return; } //IMasterList objItemCommonlist = (IMasterList)ObjectFactory.CreateInstance("BusinessProcess.SCM.BMasterList,BusinessProcess.SCM"); ISCMReport objItemCommonlist = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport,BusinessProcess.SCM"); DataTable theDT = new DataTable(); //System.DateTime answer = Convert.ToDateTime(dtpReportDate.Text); System.DateTime answer = Convert.ToDateTime(GblIQCare.CurrentDate); System.DateTime expdate = answer.AddDays(Convert.ToInt32(cmbdays.Text)); theDT = objItemCommonlist.GetExperyReport(Convert.ToInt32(cmbStore.SelectedValue.ToString()), expdate, Convert.ToDateTime(GblIQCare.CurrentDate)); IQCareUtils theUtils = new IQCareUtils(); DataView theDV = new DataView(theDT); theDV.RowFilter = "Quantityno > 0"; theDT = theUtils.CreateTableFromDataView(theDV); if (theDT.Rows.Count > 0) { ShowGrid(theDT); } }
/// <summary> /// Gets the items. /// </summary> /// <param name="StoreId">The store identifier.</param> /// <param name="ItemsId">The items identifier.</param> /// <param name="FromDate">From date.</param> /// <param name="ToDate">To date.</param> /// <returns></returns> private DataSet GetItems(int StoreId, int ItemsId, DateTime FromDate, DateTime ToDate) { BindFunctions theBindManager = new BindFunctions(); //IMasterList objOpenStock = (IMasterList)ObjectFactory.CreateInstance("BusinessProcess.SCM.BMasterList,BusinessProcess.SCM"); ISCMReport objOpenStock = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport,BusinessProcess.SCM"); return(objOpenStock.GetBatchSummary(StoreId, ItemsId, FromDate, ToDate)); }
protected void Page_Load(object sender, EventArgs e) { try { Session["PatientId"] = 0; Session["TechnicalAreaId"] = 206; ViewState["Facility"] = null; if (!IsPostBack) { BindCombo(); } ISCMReport objPODetails = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport, BusinessProcess.SCM"); DataSet theDTPODetails = objPODetails.PharmacyDashBoard(Convert.ToInt32(ddlStore.SelectedValue)); //RadHtmlChart1.DataSource = theDTPODetails.Tables[0]; //RadHtmlChart1.DataBind(); RadHtmlChart2.DataSource = theDTPODetails.Tables[1]; RadHtmlChart2.DataBind(); //grdDrugsRunningOut.DataSource = theDTPODetails.Tables[2]; //grdDrugsRunningOut.DataBind(); resizeScreen(); (Master.FindControl("pnlExtruder") as Panel).Visible = false; (Master.FindControl("level2Navigation") as Control).Visible = true; //(Master.FindControl("levelTwoNavigationUserControl1").FindControl("lblformname") as Label).Text = "Pharmacy Dashboard"; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("patientLevelMenu") as Menu).Visible = false; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("PharmacyDispensingMenu") as Menu).Visible = true; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("UserControl_Alerts1") as UserControl).Visible = false; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("PanelPatiInfo") as Panel).Visible = false; //(Master.FindControl("facilityBanner") as Control).Visible = false; //(Master.FindControl("patientBanner") as Control).Visible = false; //(Master.FindControl("username1") as Control).Visible = false; //(Master.FindControl("currentdate1") as Control).Visible = false; //(Master.FindControl("facilityName") as Control).Visible = false; //(Master.FindControl("imageFlipLevel2") as Control).Visible = false; } catch (Exception ex) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = ex.Message.ToString(); IQCareMsgBox.Show("#C1", theBuilder, this); } }
private DataSet GetItems(int StoreId, int ItemsId, DateTime FromDate, DateTime ToDate) { ISCMReport objOpenStock = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport,BusinessProcess.SCM"); return(objOpenStock.GetStockSummary(StoreId, ItemsId, FromDate, ToDate)); }
private DataSet GetBINCard(int StoreId, int ItemsId, DateTime FromDate, DateTime ToDate) { ISCMReport binCard = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport,BusinessProcess.SCM"); return(binCard.GetBINCard(StoreId, ItemsId, FromDate, ToDate, GblIQCare.AppLocationId)); }
protected void Page_Load(object sender, EventArgs e) { try { Session["PatientId"] = 0; Session["TechnicalAreaId"] = 201; // 206; ViewState["Facility"] = null; if (!IsPostBack) { BindCombo(); } ISCMReport objPODetails = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport, BusinessProcess.SCM"); DataSet theDTPODetails = objPODetails.PharmacyDashBoard(Convert.ToInt32(ddlStore.SelectedValue)); BarSeries barSeries = new BarSeries(); barSeries.DataFieldY = "Quantity"; barSeries.Name = "Quantity"; barSeries.TooltipsAppearance.Visible = false; RadHtmlChart RadHtmlChart1 = new RadHtmlChart(); RadHtmlChart1.ChartTitle.Text = "Drugs expiring in a months time"; RadHtmlChart1.Legend.Appearance.Visible = false; RadHtmlChart1.PlotArea.Series.Add(barSeries); RadHtmlChart1.PlotArea.XAxis.DataLabelsField = "DrugName"; RadHtmlChart1.PlotArea.XAxis.MajorGridLines.Visible = false; RadHtmlChart1.PlotArea.XAxis.MinorGridLines.Visible = false; RadHtmlChart1.PlotArea.YAxis.TitleAppearance.Text = "Quantity"; RadHtmlChart1.PlotArea.YAxis.MinorGridLines.Visible = false; RadHtmlChart1.Skin = "Silk"; RadHtmlChart1.Width = 1150; RadHtmlChart1.Height = 350; RadHtmlChart1.DataSource = theDTPODetails.Tables[0]; RadHtmlChart1.DataBind(); chart1.Controls.Add(RadHtmlChart1); ColumnSeries colseries1 = new ColumnSeries(); colseries1.Name = "Appointments"; colseries1.DataFieldY = "NoOfAppointments"; colseries1.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Orange; colseries1.TooltipsAppearance.Color = System.Drawing.Color.White; ColumnSeries colseries2 = new ColumnSeries(); colseries2.Name = "Visits"; colseries2.DataFieldY = "NoOfVisits"; colseries2.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Blue; colseries2.TooltipsAppearance.Color = System.Drawing.Color.White; RadHtmlChart RadHtmlChart2 = new RadHtmlChart(); //RadHtmlChart2.Width = 500; RadHtmlChart2.Height = 321; RadHtmlChart2.Skin = "Silk"; RadHtmlChart2.PlotArea.Series.Add(colseries1); RadHtmlChart2.PlotArea.Series.Add(colseries2); RadHtmlChart2.PlotArea.XAxis.DataLabelsField = "Day"; RadHtmlChart2.PlotArea.XAxis.Color = System.Drawing.Color.SlateGray; RadHtmlChart2.PlotArea.XAxis.MinorGridLines.Visible = false; RadHtmlChart2.PlotArea.XAxis.MajorGridLines.Visible = false; RadHtmlChart2.PlotArea.XAxis.LabelsAppearance.TextStyle.Color = System.Drawing.Color.DarkGray; RadHtmlChart2.PlotArea.YAxis.Color = System.Drawing.Color.SlateGray; RadHtmlChart2.PlotArea.YAxis.MinorGridLines.Visible = false; RadHtmlChart2.PlotArea.YAxis.LabelsAppearance.TextStyle.Color = System.Drawing.Color.DarkGray; RadHtmlChart2.PlotArea.YAxis.TitleAppearance.Text = "No. of appointments/visits"; RadHtmlChart2.PlotArea.YAxis.TitleAppearance.TextStyle.Color = System.Drawing.Color.DarkGray; RadHtmlChart2.ChartTitle.Text = "Patient Appointments vs Visits"; RadHtmlChart2.DataSource = theDTPODetails.Tables[1]; RadHtmlChart2.DataBind(); chart2.Controls.Add(RadHtmlChart2); grdDrugsRunningOut.DataSource = theDTPODetails.Tables[2]; grdDrugsRunningOut.DataBind(); resizeScreen(); //(Master.FindControl("pnlExtruder") as Panel).Visible = false; //(Master.FindControl("level2Navigation") as Control).Visible = true; ////(Master.FindControl("levelTwoNavigationUserControl1").FindControl("lblformname") as Label).Text = "Pharmacy Dashboard"; //(Master.FindControl("levelTwoNavigationUserControl1").FindControl("patientLevelMenu") as Menu).Visible = false; (Master.FindControl("levelOneNavigationUserControl1").FindControl("PharmacyDispensingMenu") as Menu).Visible = true; (Master.FindControl("levelTwoNavigationUserControl1").FindControl("thePnlIdent") as Panel).Visible = false; //(Master.FindControl("levelTwoNavigationUserControl1").FindControl("UserControl_Alerts1") as UserControl).Visible = false; //(Master.FindControl("levelTwoNavigationUserControl1").FindControl("PanelPatiInfo") as Panel).Visible = false; //(Master.FindControl("facilityBanner") as Control).Visible = false; //(Master.FindControl("patientBanner") as Control).Visible = false; //(Master.FindControl("username1") as Control).Visible = false; //(Master.FindControl("currentdate1") as Control).Visible = false; //(Master.FindControl("facilityName") as Control).Visible = false; //(Master.FindControl("imageFlipLevel2") as Control).Visible = false; } catch (Exception ex) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = ex.Message.ToString(); IQCareMsgBox.Show("#C1", theBuilder, this); } }
private DataTable GetItems(int StoreId) { ISCMReport objOpenStock = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport,BusinessProcess.SCM"); return(objOpenStock.GetStocksPerStore(StoreId)); }
private DataTable GetItems(int StoreId, int SupplierFlag)//If Supplier then SupplerFlag=1 else 0 { ISCMReport objOpenStock = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport,BusinessProcess.SCM"); return(objOpenStock.GetStocksPerStore(StoreId, SupplierFlag)); }
protected DataSet GetBINCard(int StoreId, int ItemsId, DateTime FromDate, DateTime ToDate) { ISCMReport binCard = (ISCMReport)ObjectFactory.CreateInstance("BusinessProcess.SCM.BSCMReport,BusinessProcess.SCM"); return(binCard.GetBINCard(StoreId, ItemsId, FromDate, ToDate, Convert.ToInt32(Session["AppLocationId"]))); }