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