private void Window_Loaded(object sender, RoutedEventArgs e) { Reports.XtraReport1 rep = new Reports.XtraReport1(); //rep = bla; preview.DocumentSource = rep; rep.CreateDocument(); }
public ActionResult rptWinningBetAgent(ReportItems model) { var operatorID = _user.OperatorID; var operatorName = _user.OperatorName; var AgentID = model.AgentID; var DateReceived = DateRecToDateRecieved(model.DateRec); var DrawResult = model.DrawResult; var ForDraw = model.ForDraw; //Time List <rptWinningBetAgent> rptData = null; var strQuery = "SELECT [DateReceived],[StrBet],[RamBet],[TotalAmt],[OperatorMobile],[ForDraw],[AgentName],[DrawResult],[MobileNo]" + ",[OperatorName],[AgentCode],[WonCnt],[WonStr],[WonRam] FROM [dbo].[rptWinningBetAgent]" + " WHERE OperatorName = @OperatorName" + " AND [DateReceived] = @DateReceived " + " AND [DrawResult] = @DrawResult " + " AND [ForDraw] = @ForDraw" + " AND [TotalAmt] > 0 "; if (AgentID != null) { var agentCode = getAgentCode(AgentID); //Agent Name strQuery = strQuery + " AND [AgentName] = @AgentName "; //Agent Code Filter rptData = dbContext.Database.SqlQuery <rptWinningBetAgent>(strQuery, new SqlParameter("OperatorName", operatorName), new SqlParameter("DateReceived", DateReceived), new SqlParameter("AgentName", agentCode), new SqlParameter("DrawResult", DrawResult), new SqlParameter("ForDraw", ForDraw)) .ToList(); } else { rptData = dbContext.Database.SqlQuery <rptWinningBetAgent>(strQuery, new SqlParameter("OperatorName", operatorName), new SqlParameter("DateReceived", DateReceived), new SqlParameter("DrawResult", DrawResult), new SqlParameter("ForDraw", ForDraw)) .ToList(); } rptData.ForEach(x => x.PersonViewed = operatorName); rptData.OrderBy(x => x.OperatorName).OrderBy(x => x.AgentName).OrderBy(x => x.AgentCode); //Sorting Reports.XtraReport1 r_rptWinningAgentBet = new Reports.XtraReport1(); r_rptWinningAgentBet.DataSource = rptData as IEnumerable <rptWinningBetAgent>; Session[s_rptWinningBetAgent] = r_rptWinningAgentBet; return(PartialView()); }
public ActionResult Index() { ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application."; Reports.XtraReport1 report = new Reports.XtraReport1(); string constr = ConfigurationManager.ConnectionStrings["dropdownconn"].ToString(); SqlConnection _con = new SqlConnection(constr); SqlDataAdapter _da = new SqlDataAdapter("SELECT * FROM [SETS].[dbo].[view_FullExamineeResultsWithQuestions] ORDER BY LastFirstMiddle ASC", _con);//where actualtestid in(" + Session["selected"] + ") ORDER BY LastFirstMiddle ASC", _con); DataSet ds = new DataSet(); _da.Fill(ds); report.DataMember = ds.Tables[0].TableName; report.DataSource = ds; // return PartialView("_DocumentViewer1Partial", report); //return PartialView(new Reports.XtraReport1()); return(PartialView(report)); //return View(); //return PartialView(); }