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();
}
