/// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        public ActionResult Index(string day = "")
        {
            List <TopProduct> data = ReportBLL.TopProduct(day);
            var model = new Models.ReportTopProduct()
            {
                Data = data
            };

            return(View(model));
        }
        public ActionResult Testxml(string id)
        {
            ReportBLL reportBll = new ReportBLL();
            string    Message   = string.Empty;

            reportBll.Testxml(id, out Message);

            ViewBag.IsSuccess = Message;
            return(View());
        }
Beispiel #3
0
        protected void btnReport_Click(object sender, ImageClickEventArgs e)
        {
            Int32 period_id = Convert.ToInt32(cboPeriod.SelectedValue);

            if (validate())
            {
                List <Entities.AcademicOffer> pListAcademicOffer = ReportBLL.getInstance().reportTeacher(period_id);
                printReport(pListAcademicOffer);
            }
        }
Beispiel #4
0
        public void start(SCApplication _app)
        {
            scApp     = _app;
            reportBLL = _app.ReportBLL;
            lineBLL   = _app.LineBLL;
            line      = scApp.getEQObjCacheManager().getLine();


            //initPublish(line);
        }
        protected void btnReport_Click(object sender, ImageClickEventArgs e)
        {
            Int32 period_id = Convert.ToInt32(cboPeriod.SelectedValue);

            if (validate())
            {
                List <Entities.ClassRoom> listClassRoom = ReportBLL.getInstance().reportClassRoom(period_id);
                getReport(listClassRoom);
            }
        }
Beispiel #6
0
        public void start(SCApplication _app)
        {
            scApp     = _app;
            reportBLL = _app.ReportBLL;
            lineBLL   = _app.LineBLL;
            line      = scApp.getEQObjCacheManager().getLine();

            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.Host_Control_State), PublishLineInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.SCStats), PublishLineInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.Secs_Link_Stat), PublishLineInfo);

            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.CurrentPortStateChecked), PublishOnlineCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.CurrentStateChecked), PublishOnlineCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.EnhancedVehiclesChecked), PublishOnlineCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.TSCStateChecked), PublishOnlineCheckInfo);
            //line.addEventHandler(nameof(ConnectionInfoService), nameof(line.UnitAlarmStateListChecked), PublishOnlineCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.EnhancedTransfersChecked), PublishOnlineCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.EnhancedCarriersChecked), PublishOnlineCheckInfo);
            //line.addEventHandler(nameof(ConnectionInfoService), nameof(line.LaneCutListChecked), PublishOnlineCheckInfo);

            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.MCSConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.RouterConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV1ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV2ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV3ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV4ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV5ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV6ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV7ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV8ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV9ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV10ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV11ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV12ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV13ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV14ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ChargePLCConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM1ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM2ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM3ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM4ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM5ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP1ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP2ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP3ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP4ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP5ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP6ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP7ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP8ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP9ConnectionSuccess), PublishPingCheckInfo);
            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP10ConnectionSuccess), PublishPingCheckInfo);

            initPublish(line);
        }
Beispiel #7
0
        private void PopulatePort(Int32 Vessel, Int32 Voyage, Int32 Line)
        {
            ReportBLL objBLL = new ReportBLL();
            DataSet   ds     = objBLL.GetPOD(Vessel, Voyage, Line);

            ddlPOD.DataValueField = "fk_PortID";
            ddlPOD.DataTextField  = "PortName";
            ddlPOD.DataSource     = ds;
            ddlPOD.DataBind();
            ddlPOD.Items.Insert(0, new ListItem("All", "0"));
        }
Beispiel #8
0
        protected void SubreportEventHandler(object sender, SubreportProcessingEventArgs e)
        {
            var BlNo = e.Parameters["EXPBLID"].Values[0].ToString();
            var main = ReportBLL.GetRptFrieghtManifest(BlNo);
            var TFS  = ReportBLL.GetRptFrieghtManifest_TFS(BlNo);
            var CTRS = ReportBLL.GetRptFrieghtManifest_CTRS(BlNo);

            e.DataSources.Add(new ReportDataSource("dsLin", main.Tables[0]));
            e.DataSources.Add(new ReportDataSource("dsTFS", TFS.Tables[0]));
            e.DataSources.Add(new ReportDataSource("dsCTRS", CTRS.Tables[0]));
        }
Beispiel #9
0
        private void BindBuyerProvince()
        {
            string    startDate = datePicker.Value.Trim();
            string    endDate   = datePickerEnd.Value.Trim();
            DataTable tb        = ReportBLL.GetBuyerProviceReport(Users.Nick, startDate, endDate);

            if (tb != null)
            {
                Chart2.Series["buyerProvince"].Points.DataBindXY(tb.DefaultView, "province", tb.DefaultView, "areacount");
            }
        }
        /// <summary>
        /// Khởi tạo
        /// </summary>
        public static void Initialize()
        {
            string connectionString =
                ConfigurationManager.ConnectionStrings["LiteCommerce"].ConnectionString;

            CatalogBLL.Initialize(connectionString);
            HumanResourceBLL.Initialize(connectionString);
            AccountBLL.Initialize(connectionString);
            ReportBLL.Initialize(connectionString);
            //TODO: Bổ sung khởi tạo các BLL khác khi cần sử dụng
        }
Beispiel #11
0
        protected void btnReport_Click(object sender, ImageClickEventArgs e)
        {
            Int32 period_id = Convert.ToInt32(cboPeriod.SelectedValue);
            Int32 isContact = Convert.ToInt32(cboOptions.SelectedValue);

            if (validate())
            {
                List <Entities.WaitingList> listWaitingList = ReportBLL.getInstance().reportWaitingList(period_id, isContact);
                getReport(listWaitingList);
            }
        }
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            var startTime = DateTime.Parse(hidStartTime.Value);
            var endTime   = DateTime.Parse(hidEndTime.Value);

            if (!base.CheckDateInput(startTime, endTime, ltCheckInfo))
            {
                ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
                return;
            }
            // 车架号VIN
            string vin = string.Empty;

            if (!string.IsNullOrEmpty(this.hidVIN.Value))
            {
                vin = hidVIN.Value;
            }
            var rptName = base.CurrentRptName;

            try
            {
                ACCONStatisticSearchModel model = new ACCONStatisticSearchModel();
                model.SartTime = startTime;
                model.EndTime  = endTime;
                model.VIN      = vin;
                model.PlateNum = this.hidPlateNum.Value;
                List <ACCONStatisticDataModel> list;

                // 默认模式
                if (base.VehicleViewMode)
                {
                    list = ReportBLL.GetDefaultACCONStatisticData(model, base.CurrentStrucID);
                }
                // 自由模式
                else
                {
                    list = ReportBLL.GetACCONStatisticData(model, base.CurrentUserID);
                }

                if (!base.CheckResult <ACCONStatisticDataModel>(list, ltCheckInfo))
                {
                    ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
                    return;
                }
                this.ShowReport(list);
                ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
                base.DoReportLog(ex.Message, ltCheckInfo);
            }
        }
Beispiel #13
0
        protected void btnReport_Click(object sender, ImageClickEventArgs e)
        {
            Int32  period_id   = Convert.ToInt32(cboPeriod.SelectedValue);
            String period_name = cboPeriod.SelectedItem.Text;

            if (validate())
            {
                List <Entities.AcademicOffer> listAcademicOffer = ReportBLL.getInstance().reportOffer(period_id);
                lblMessage.Text = "";
                printReport(listAcademicOffer, period_name);
            }
        }
Beispiel #14
0
        private void BtnPrint_Click(object sender, EventArgs e)
        {
            if (this.gridView3.RowCount == 0)
            {
                return;
            }

            DataTable dt       = ReportBLL.GetInstance().GetPurchaseReportData(purchaseSaveModel.PurchaseId);
            FrmPrint  frmPrint = new FrmPrint(new PurchaseXtraReport(base.CurrentUserOrgName + "采购单报表"), dt);

            frmPrint.ShowDialog();
        }
        public void start(SCApplication _app)
        {
            scApp     = _app;
            reportBLL = _app.ReportBLL;
            lineBLL   = _app.LineBLL;
            line      = scApp.getEQObjCacheManager().getLine();

            line.addEventHandler(nameof(ConnectionInfoService), nameof(line.MCSCommandAutoAssign), PublishTransferInfo);


            initPublish(line);
        }
    protected void btnGoxxx_Click(object sender, EventArgs e)
    {
        //string where = "";
        string        fields = "ID,OwnerID,tbName,tbKey,tbBalance,tbMobile,tbIdentityNo,PatchID";
        string        key    = this.RadioButtonList1.SelectedItem.Value;
        StringBuilder sb     = new StringBuilder();

        string KeyValue = ViewState["Key_" + key].ToString();
        string template = " select {0} from companycase_{1} where {2} ='{3}'";



        CompanyDS = BLL.CompanyBLL.GetCompanyList();
        int count = CompanyDS.Tables[0].Rows.Count;

        for (int i = 0; i < count; i++)
        {
            DataRow dr = CompanyDS.Tables[0].Rows[i];
            string  id = dr["ID"].ToString();

            if (HasCaseTable(id) && id != CompanyID)
            {
                string fieldsAddCompanyID = id + "  as CompanyID," + fields;
                string tempsql            = string.Format(template, fieldsAddCompanyID, id, key, KeyValue);
                sb.AppendLine(tempsql);
                sb.AppendLine("Union All");
            }
        }

        string sql = sb.ToString();

        if (sql == "")
        {
            return;
        }
        else
        {
            sql = sql.Substring(0, sql.Length - "Union All".Length - 2);

            DataSet ds = ReportBLL.GetDataSet(sql);



            if (ds.Tables[0].Rows.Count > 0)
            {
                ALLPatchsDS = BLL.PatchBLL.GetPatchList();
            }

            this.GridView2.DataSource = ds;
            this.GridView2.DataBind();
        }
    }
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            var startTime = DateTime.Parse(hidStartTime.Value);
            var endTime   = DateTime.Parse(hidEndTime.Value);

            if (!base.CheckInput(startTime, endTime, ltCheckInfo))
            {
                ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
                return;
            }

            // 车辆ID
            long vehiclesID = 0;

            if (!string.IsNullOrWhiteSpace(this.hidVehicleID.Value))
            {
                vehiclesID = Convert.ToInt64(hidVehicleID.Value);
            }
            try
            {
                ExceptionSearchModel model = new ExceptionSearchModel();
                model.UserID     = base.CurrentUserID;
                model.SartTime   = startTime;
                model.EndTime    = endTime;
                model.VehiclesID = vehiclesID;
                List <MGJHExpForIllegalDischargModel> list;
                // 默认模式
                if (base.VehicleViewMode)
                {
                    list = ReportBLL.GetMGJHExpForIllegalDischarg(model, base.CurrentStrucID);
                }
                // 自由模式
                else
                {
                    list = ReportBLL.GetMGJHExpForIllegalDischarg(model);
                }

                if (!base.CheckResult <MGJHExpForIllegalDischargModel>(list, ltCheckInfo))
                {
                    ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
                    return;
                }

                this.ShowReport(list);
                ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
                base.DoReportLog(ex.Message, ltCheckInfo);
            }
        }
Beispiel #18
0
 public ResponseLRGet LRGet([FromBody] RequestLRGet request)
 {
     try
     {
         ReportBLL bll = new ReportBLL();
         return(bll.LRGet(request));
     }
     catch (Exception ex)
     {
         throw new HttpResponseException(
                   Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
     }
 }
Beispiel #19
0
        public void ManagerController_DistributionCentreLosses()
        {
            //Arrange
            var mc        = new ManagerController();
            var reportBLL = new ReportBLL();

            //Act
            var result   = mc.CentreList() as ViewResult;
            var packages = (List <DistributionCentre>)result.ViewData.Model;

            //Asert
            Assert.IsNotNull(packages);
        }
Beispiel #20
0
 /// <summary>
 /// Get report periods
 /// </summary>
 /// <returns>List of report periods</returns>
 public List <ReportPeriod> GetReportPeriods()
 {
     try
     {
         return(ReportBLL.GetReportPeriods());
     }
     catch (Exception ex)
     {
         Log.Exception(ex.StackTrace);
         Log.Exception(ex.Message);
         throw ex;
     }
 }
        private void GenerateReport()

        {
            ReportBLL cls = new ReportBLL();

            try
            {
                DateTime dt1 = DateTime.Today;
                DateTime dt2 = DateTime.Today;

                DataTable dtExcel = new DataTable();
                string    vord    = "D";
                if (ddlType.SelectedIndex == 0)
                {
                    dt1  = Convert.ToDateTime(txtFromDt.Text.Trim());
                    dt2  = Convert.ToDateTime(txtToDt.Text.Trim());
                    vord = "D";
                }
                else
                {
                    vord = "V";
                }
                dtExcel = cls.GetDetentionReport(vord, dt1, dt2, ddlVoyage.SelectedValue, ddlVessel.SelectedValue, ddlLine.SelectedValue, ddlLoc.SelectedValue);
                ExporttoExcel(dtExcel);
            }
            catch (Exception ex)
            {
            }

            //ReportBLL cls = new ReportBLL();
            //DateTime dtFrom = Convert.ToDateTime(txtFromDt.Text, _culture);
            //DateTime dtTo = Convert.ToDateTime(txtToDt.Text, _culture);
            //List<ImpInvRegisterEntity> lstReg = ReportBLL.GetImportInvoiceRegister(Convert.ToInt32(ddlLine.SelectedValue), Convert.ToInt32(ddlLoc.SelectedValue), Convert.ToInt32(ddlType.SelectedValue), dtFrom, dtTo);

            //LocalReportManager reportManager = new LocalReportManager(rptViewer, "ImportInvRegister", ConfigurationManager.AppSettings["ReportNamespace"].ToString(), ConfigurationManager.AppSettings["ReportPath"].ToString());
            //string rptName = "ImportInvRegister.rdlc";

            //rptViewer.Reset();
            //rptViewer.LocalReport.Dispose();
            //rptViewer.LocalReport.DataSources.Clear();
            //rptViewer.LocalReport.ReportPath = this.Server.MapPath(this.Request.ApplicationPath) + ConfigurationManager.AppSettings["ReportPath"].ToString() + "/" + rptName;

            //rptViewer.LocalReport.DataSources.Add(new ReportDataSource("RptDataSet", lstReg));
            //rptViewer.LocalReport.SetParameters(new ReportParameter("CompanyName", Convert.ToString(ConfigurationManager.AppSettings["CompanyName"])));
            //rptViewer.LocalReport.SetParameters(new ReportParameter("Location", ddlLoc.SelectedItem.Text));
            //rptViewer.LocalReport.SetParameters(new ReportParameter("Line", ddlLine.SelectedItem.Text));
            //rptViewer.LocalReport.SetParameters(new ReportParameter("BillType", ddlType.SelectedItem.Text));
            //rptViewer.LocalReport.SetParameters(new ReportParameter("FromDate", txtFromDt.Text));
            //rptViewer.LocalReport.SetParameters(new ReportParameter("ToDate", txtToDt.Text));
            //rptViewer.LocalReport.Refresh();
        }
Beispiel #22
0
 /// <summary>
 /// Update report periods
 /// </summary>
 /// <param name="reportPeriods">List of report repiods</param>
 /// <returns>True or false</returns>
 public bool UpdateReportPeriods(List <ReportPeriod> reportPeriods)
 {
     try
     {
         ReportBLL.UpdateReportPeriods(reportPeriods);
         return(true);
     }
     catch (Exception ex)
     {
         Log.Exception(ex.StackTrace);
         Log.Exception(ex.Message);
         throw ex;
     }
 }
Beispiel #23
0
        // GET api/userreport
        /// <summary>
        ///
        /// </summary>
        /// <param name="userID"></param>
        /// <param name="model">0-仅本用户菜单,1-全部菜单</param>
        /// <returns></returns>
        public IEnumerable <UserReport> Get(decimal userID, short model)
        {
            switch (model)
            {
            case 0:
                return(ReportBLL.ListUserReport(userID));

            case 1:
                return(ReportBLL.ListAllUserReport(userID));

            default:
                return(null);
            }
        }
Beispiel #24
0
        private void BindData()
        {
            ReportBLL ReportBL = new ReportBLL(connectionString);
            List <ReportViewModel> incident_reports = ReportBL.GetIncidentReportInventory();

            foreach (ReportViewModel model in incident_reports)
            {
                model.Name = GetCarNameFromCarID(model.CarID);
                string[] date_element = model.DateOfIncident.Split(' ');
                model.DateOfIncident = date_element[0];
            }
            ReportList.DataSource = incident_reports;
            ReportList.DataBind();
        }
        private void LoadCounters()
        {
            DataSet   ds = new ReportBLL().GetAllItemGroup();
            DataTable dt = ds.Tables[0];
            DataRow   dr = dt.NewRow();

            dr["ItemGroupID"] = "0";
            dr["Descr"]       = "All Counters";
            dt.Rows.InsertAt(dr, 0);
            ddlCounters.DataValueField = "ItemGroupID";
            ddlCounters.DataTextField  = "Descr";
            ddlCounters.DataSource     = dt;
            ddlCounters.DataBind();
        }
Beispiel #26
0
 protected void ReportEditButtonClick(object sender, EventArgs e)
 {
     if (Page.IsValid)
     {
         ReportBLL       bll    = new ReportBLL(connectionString);
         ReportViewModel report = new ReportViewModel();
         report.ReportID          = Convert.ToInt32(Request.QueryString["ReportID"]);
         report.ReportName        = ReportName.Text;
         report.ReportDescription = ReportDescription.Text;
         report.DateOfIncident    = Convert.ToDateTime(DateOfIncident.Text);
         bll.EditReport(report);
         Response.Redirect("~/Reports.aspx");
     }
 }
Beispiel #27
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ReportBLL       bll    = new ReportBLL(connectionString);
                ReportViewModel report = bll.GetReportById(Convert.ToInt32(Request.QueryString["ReportID"]));

                ReportID.Text          = report.ReportID.ToString();
                DateOfIncident.Text    = report.DateOfIncident.ToString();
                CarID.Text             = report.CarID.ToString();
                ReportName.Text        = report.ReportName;
                ReportDescription.Text = report.ReportDescription;
            }
        }
        protected void btnExcel_Click(object sender, EventArgs e)
        {
            ReportBLL cls = new ReportBLL();

            try
            {
                DataTable dtExcel = new DataTable();
                dtExcel = cls.GetGroundRentLOLOStatement(ddlLine.SelectedValue, ddlLoc.SelectedValue, ddlStatus.SelectedValue, txtStartDate.Text.Trim(), txtdtStock.Text.Trim(), ddlEmptyYard.SelectedValue.ToInt());
                ExporttoExcel(dtExcel);
            }
            catch (Exception ex)
            {
            }
        }
Beispiel #29
0
        public void ManagerController_GlobalStock()
        {
            //Arrange
            var mc        = new ManagerController();
            var reportBLL = new ReportBLL();

            //Act
            var result      = mc.GlobalStock() as ViewResult;
            var packages    = (List <MedicationTypeViewData>)result.ViewData.Model;
            var allpackages = reportBLL.GlobalStock();

            //Asert
            Assert.IsNotNull(packages);
            Assert.AreEqual(packages.Count, allpackages.Count);
        }
        protected void btnPrint_Click(object sender, EventArgs e)
        {
            ReportBLL cls = new ReportBLL();

            try
            {
                DateTime  dt      = Convert.ToDateTime(txtdtStock.Text.Trim());
                DataTable dtExcel = new DataTable();
                dtExcel = cls.GetTypeWiseStockSummary(ddlLine.SelectedValue, ddlLoc.SelectedValue, dt);
                ExporttoExcel(dtExcel);
            }
            catch (Exception ex)
            {
            }
        }