protected void LinkButton1_Click(object sender, EventArgs e) { DataSourceSelectArguments ee = new DataSourceSelectArguments(); DataView tmp = (DataView)this.SqlDataSource4.Select(ee); Response.Cookies["PapID"].Value = tmp[0][1].ToString(); //从sqldatasource获得列值 Response.Redirect("Paper.aspx"); }
/// <summary> /// Gets a list of data from the underlying data storage. /// </summary> /// <param name="arguments">A <see cref="T:System.Web.UI.DataSourceSelectArguments"/> that is used to request operations on the data beyond basic data retrieval.</param> /// <returns> /// An <see cref="T:System.Collections.IEnumerable"/> list of data from the underlying data storage. /// </returns> protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { Options.RecordsToRetrieve = arguments.MaximumRows; Options.StartingRecord = arguments.StartRowIndex; if (!String.IsNullOrEmpty(arguments.SortExpression)) { Parameters.OrderByClause = arguments.SortExpression; } if (DataMode == CatalogSearchDataMode.Objects) { Entries entries = CatalogContext.Current.FindItems(Parameters, Options, ResponseGroup); arguments.TotalRowCount = entries.TotalResults; return(entries.Entry); } else { int totalRecordsCount = 0; CatalogEntryDto entries = CatalogContext.Current.FindItemsDto(Parameters, Options, ref totalRecordsCount, ResponseGroup); if (totalRecordsCount > 0) { arguments.TotalRowCount = totalRecordsCount; return(entries.CatalogEntry.Rows); } else { arguments.TotalRowCount = 0; return(null); } } }
protected void FormView1_PageIndexChanging(object sender, FormViewPageEventArgs e) { DataSourceSelectArguments ee = new DataSourceSelectArguments(); DataView tmp = (DataView)this.SqlDataSource4.Select(ee); Response.Cookies["PapID"].Value = tmp[0][1].ToString(); //从sqldatasource获得列值 Response.Redirect("Paper.aspx"); }
/// <summary> /// Gets a list of data from the underlying data storage. /// </summary> /// <param name="arguments">A <see cref="T:System.Web.UI.DataSourceSelectArguments"/> that is used to request operations on the data beyond basic data retrieval.</param> /// <returns> /// An <see cref="T:System.Collections.IEnumerable"/> list of data from the underlying data storage. /// </returns> protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { Options.RecordsToRetrieve = arguments.MaximumRows; Options.StartingRecord = arguments.StartRowIndex; int totalRecordsCount = 0; LogDto dto = new LogDto(); if (this.DataMode == ApplicationLogDataMode.ApplicationLog) { dto = LogManager.GetAppLog(Parameters.SourceKey, Parameters.Operation, Parameters.ObjectType, Parameters.Created, Options.StartingRecord, Options.RecordsToRetrieve, ref totalRecordsCount); } else { dto = LogManager.GetSystemLog(Parameters.Operation, Parameters.ObjectType, Parameters.Created, Options.StartingRecord, Options.RecordsToRetrieve, ref totalRecordsCount); } if (totalRecordsCount > 0) { arguments.TotalRowCount = totalRecordsCount; return(dto.ApplicationLog.Rows); } else { arguments.TotalRowCount = 0; return(null); } }
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments selectArgs) { // only continue if a membership provider has been configured if (!Utils.IsProviderConfigured()) { return(null); } // get roles and build data table DataTable dataTable = new DataTable(); String[] roles = Utils.BaseRoleProvider().GetAllRoles(); dataTable.Columns.Add("Role"); dataTable.Columns.Add("UsersInRole"); // add users in role counts for (int i = 0; i < roles.Length; i++) { DataRow row = dataTable.NewRow(); row["Role"] = roles[i]; row["UsersInRole"] = Utils.BaseRoleProvider().GetUsersInRole(roles[i].ToString()).Length; dataTable.Rows.Add(row); } dataTable.AcceptChanges(); DataView dataView = new DataView(dataTable); // sort if a sort expression available if (selectArgs.SortExpression != String.Empty) { dataView.Sort = selectArgs.SortExpression; } // return as a DataList return((IEnumerable)dataView); }
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { DataTable queryTable = ((DataView)base.ExecuteSelect(arguments)).Table; DataTable sessionTable = (DataTable)session[owner.DataSourceSessionKey]; InitPrimaryKey(queryTable); if (owner.RevertToOriginalDataSource) { RaiseOnSelected(queryTable.DefaultView.Count); return(queryTable.DefaultView); } DataTable result; if (sessionTable == null) { sessionTable = queryTable.Copy(); InitPrimaryKey(sessionTable); session[owner.DataSourceSessionKey] = sessionTable; result = sessionTable; } else { result = SmartMerge(sessionTable, queryTable); } DataView view = result.DefaultView; view.Sort = arguments.SortExpression; RaiseOnSelected(view.Count); return(view); }
protected void OkBtn_Click(object sender, EventArgs e) { DataSourceSelectArguments pArguments = new DataSourceSelectArguments(); SqlDominio.Select(pArguments); DomainList.DataBind(); }
public void ListView_CreateDataSourceSelectArguments() { var lvp = new ListViewPoker(); DataSourceSelectArguments args = lvp.DoCreateDataSourceSelectArguments(); Assert.IsTrue(args != null, "#A1"); }
protected override DataSourceSelectArguments CreateDataSourceSelectArguments() { DataSourceSelectArguments dataSourceSelectArguments = base.CreateDataSourceSelectArguments(); //CHECK WHETHER A SORT EXPRESSION IS PRESENT if (string.IsNullOrEmpty(dataSourceSelectArguments.SortExpression)) { if (!string.IsNullOrEmpty(this.DefaultSortExpression) && (System.Web.HttpContext.Current != null)) { dataSourceSelectArguments.SortExpression = this.DefaultSortExpression; if (this.DefaultSortDirection == SortDirection.Descending) { dataSourceSelectArguments.SortExpression += " DESC"; } ActiveSortColumn = this.DefaultSortExpression; ActiveSortDirection = this.DefaultSortDirection; } } else { ActiveSortColumn = this.SortExpression; ActiveSortDirection = this.SortDirection; } return(dataSourceSelectArguments); }
protected void Button1_Click(object sender, EventArgs e) { DataSourceSelectArguments ee = new DataSourceSelectArguments(); DataView tmp = (DataView)this.SqlDataSource1.Select(ee); //TextBox1.Text= tmp[0][1].ToString(); name = TextBox1.Text; password = TextBox2.Text; int i = 0; for (; i < tmp.Count; i++) { if (tmp[i][1].ToString().Equals(name)) { break; } } if (i == tmp.Count) { Response.Write("<script>alert('该用户不存在')</script>"); } else if (tmp[i][2].ToString().Equals(password)) { Session["name"] = TextBox1.Text.Trim(); Session["headPhoto"] = tmp[i][6]; Response.Redirect("index.aspx", true); } else { Response.Write("<script>alert('密码错误请重新输入!')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (string.IsNullOrEmpty(Request.QueryString["c"])) Response.Redirect("Default.aspx"); DataSourceSelectArguments args =new DataSourceSelectArguments(); MapDataSource.SelectParameters.Add("Category", Request.QueryString["c"]); DataView dvMap = (DataView)MapDataSource.Select(args); DataView dvSubmission; string score; foreach (System.Data.DataRow row in dvMap.Table.Rows) { SubmissionSource.SelectParameters.Clear(); SubmissionSource.SelectParameters.Add("Question", row["Question"].ToString()); SubmissionSource.SelectParameters.Add("Username", Membership.GetUser().UserName); dvSubmission = (DataView)SubmissionSource.Select(args); string theme = "danger"; score = ""; int value=0; if (dvSubmission.Table.Rows.Count > 0) { score = "Score: "+dvSubmission.Table.Rows[0]["Score"].ToString()+"/100"; value = Convert.ToInt32(dvSubmission.Table.Rows[0]["Score"]); if (value == 100) theme = "success"; else if (value >= 50) theme = "info"; else theme = "warning"; } populate.InnerHtml += "<div class=\"col-lg-4\">" + "<div class=\"panel panel-"+theme+"\">" + "<div class=\"panel-heading\"><label>" + row["QuestionName"].ToString() + "</label></div>" + "<div class=\"panel-body\">" + "<div class=\"progress progress-striped active\">"+ "<div class=\"progress-bar progress-bar-" + theme + "\" role=\"progressbar\" aria-valuenow=\"" + value + "\" aria-valuemin=\"0\" aria-valuemax=\"100\" style=\"width:" + value + "%\">" + "<span class=\"sr-only\"><span>"+score+"</span>% Complete (success)</span>"+ "</div>"+ "</div>"+ "<button onclick=\"location.href=\'Challange.aspx?p=" + row["Question"].ToString() + "'\" type=\"button\" class=\"btn btn-" + theme + "\" style=\"float:right;\">Go to Question</button>" + "<h5 style=\"font-weight:bold\">" + score + "</h5>" + "</div>" + "<div class=\"panel-footer\" style=\"overflow:hidden;\">" + "<button onclick=\"location.href=\'Leaderboard.aspx?p=" + row["Question"].ToString() + "'\" type=\"button\" class=\"btn btn-outline btn-"+theme+"\">Leaderboard</button>" + "</div>" + "</div>" + "</div>"; /* * */ } } }
private static IOrderedDictionary MergeSelectParameters(DataSourceSelectArguments arguments) { bool shouldPage = arguments.StartRowIndex >= 0 && arguments.MaximumRows > 0; bool shouldSort = !String.IsNullOrEmpty(arguments.SortExpression); // Copy the parameters into a case insensitive dictionary IOrderedDictionary mergedParameters = new OrderedDictionary(StringComparer.OrdinalIgnoreCase); // Add the sort expression as a parameter if necessary if (shouldSort) { mergedParameters[SortParameterName] = arguments.SortExpression; } // Add the paging arguments as parameters if necessary if (shouldPage) { // Create a new dictionary with the paging information and merge it in (so we get type conversions) IDictionary pagingParameters = new OrderedDictionary(StringComparer.OrdinalIgnoreCase); pagingParameters[MaximumRowsParameterName] = arguments.MaximumRows; pagingParameters[StartRowIndexParameterName] = arguments.StartRowIndex; pagingParameters[TotalRowCountParameterName] = 0; MergeDictionaries(pagingParameters, mergedParameters); } return(mergedParameters); }
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { _arguments = arguments; LinqToSqlDataSourceEventArgs <TEntity> eventArgs = new LinqToSqlDataSourceEventArgs <TEntity> { Query = _owner.DataContext.GetTable <TEntity>() }; _owner.OnSelect(eventArgs); if (eventArgs.Query == null) { eventArgs.Query = _owner.DataContext.GetTable <TEntity>(); } IEnumerable <TEntity> result = (eventArgs.QueryExpr != null) ? eventArgs.Query.Where(eventArgs.QueryExpr) : eventArgs.Query; arguments.TotalRowCount = result.Count(); if (arguments.MaximumRows > 0 && arguments.StartRowIndex >= 0) { return(result.Skip(arguments.StartRowIndex).Take(arguments.MaximumRows)); } else { return(result); } }
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { IEnumerable dataSource = base.ExecuteSelect(arguments); // TODO: do your stuff here return(dataSource); }
public static IEnumerable <TRow> Select <TKey, TTable, TDataContext, TRow>( this BaseDataSourceView <TKey, TTable, TDataContext, TRow> view, StoreReadDataEventArgs e, BaseFilterControl <TKey, TTable, TDataContext> filter, GridFilters gridFilter, BaseGridColumns columns, bool sort) where TKey : struct where TTable : class where TDataContext : DataContext, new() where TRow : BaseRow, new() { var dataSourceSelectArguments = new DataSourceSelectArguments(e.Start, e.Limit); dataSourceSelectArguments.RetrieveTotalRowCount = true; if (sort && e.Sort != null && e.Sort.Length > 0) { dataSourceSelectArguments.SortExpression = GetSortExpression(columns, e.Sort); } IEnumerable result = null; view.Select(dataSourceSelectArguments, data => { result = data; }); e.Total = dataSourceSelectArguments.TotalRowCount; return(result.Cast <TRow>()); }
protected void btnUpdateShip_Click(object sender, EventArgs e) { LinkButton btn = sender as LinkButton; GridViewRow row = btn.NamingContainer as GridViewRow; string pk = GridViewSalesOrder.DataKeys[row.RowIndex].Values[0].ToString(); Session["Quotation_number"] = pk; SqlData.SelectCommand = "SELECT Quotes_ID From Quotes where ISNULL(Is_InventoryUpd,0) = 'false' and Quotes.Quotation_Number='" + pk + "'"; DataSourceSelectArguments dsArguments = new DataSourceSelectArguments(); DataView dvView = new DataView(); dvView = (DataView)SqlData.Select(dsArguments); int count = dvView.Count; if (count == 0) { SqlQuotationUpdate.UpdateParameters["Is_Shipped"].DefaultValue = "TRUE"; SqlQuotationUpdate.UpdateParameters["Shipment_Date"].DefaultValue = System.DateTime.Today.ToShortDateString(); SqlQuotationUpdate.UpdateParameters["Quotation_Number"].DefaultValue = pk; SqlQuotationUpdate.Update(); GridViewSalesOrder.DataBind(); } else { Response.Redirect("Ships.aspx"); } }
protected void btnMoveStockMovement_Click(object sender, EventArgs e) { string strBatchID = ProductRMDownList.SelectedValue; string strWarehouseID = FromWarehouseDropDownList.SelectedValue; string strLocationID = FromLocationDropDownList.SelectedValue; string strIsProduct = rbStockMovement.SelectedValue; SqlData.SelectCommand = "SELECT StockPile.Quantity, StockPile.Created_Date FROM StockPile INNER JOIN FinishedProduct ON FinishedProduct.Batch_ID = StockPile.Batch_ID AND StockPile.Batch_ID ='" + strBatchID + "' AND StockPile.Warehouse_ID ='" + strWarehouseID + "' AND StockPile.Location_ID ='" + strLocationID + "' INNER JOIN Product ON FinishedProduct.Product_ID = Product.Product_ID INNER JOIN Location ON StockPile.Location_ID = Location.Location_ID"; DataSourceSelectArguments dsArguments = new DataSourceSelectArguments(); DataView dvView = new DataView(); SqlStockPile.InsertParameters["Batch_ID"].DefaultValue = ProductRMDownList.SelectedValue; SqlStockPile.InsertParameters["Warehouse_ID"].DefaultValue = TowarehouseDropDownList.SelectedValue; SqlStockPile.InsertParameters["Location_ID"].DefaultValue = ToLocationDropDownList.SelectedValue; SqlStockPile.InsertParameters["Quantity"].DefaultValue = ToQuantityTextBox.Text.Trim(); SqlStockPile.InsertParameters["Created_Date"].DefaultValue = System.DateTime.Now.ToShortDateString(); SqlStockPile.InsertParameters["Is_Product"].DefaultValue = rbStockMovement.SelectedValue; SqlStockPile.Insert(); dvView = (DataView)SqlData.Select(dsArguments); string strQty = dvView[0].Row["Quantity"].ToString(); string strCreatedDate = dvView[0].Row["Created_Date"].ToString(); int intQty = Convert.ToInt32(strQty); int intToQty = Convert.ToInt32(ToQuantityTextBox.Text); if (intToQty != intQty) { dsArguments = new DataSourceSelectArguments(); dvView = new DataView(); SqlData.SelectCommand = "SELECT Entry_ID from StockPile where Batch_ID ='" + strBatchID + "' AND Warehouse_ID ='" + strWarehouseID + "' AND Location_ID ='" + strLocationID + "' AND Quantity ='" + strQty + "' and Is_Product ='" + strIsProduct + "'"; dvView = (DataView)SqlData.Select(dsArguments); string EntryID = dvView[0].Row["Entry_ID"].ToString(); SqlStockPile.UpdateParameters["Batch_ID"].DefaultValue = ProductRMDownList.SelectedValue; SqlStockPile.UpdateParameters["Warehouse_ID"].DefaultValue = FromWarehouseDropDownList.SelectedValue; SqlStockPile.UpdateParameters["Location_ID"].DefaultValue = FromLocationDropDownList.SelectedValue; SqlStockPile.UpdateParameters["Quantity"].DefaultValue = Convert.ToString(intQty - intToQty); SqlStockPile.UpdateParameters["Created_Date"].DefaultValue = strCreatedDate; SqlStockPile.UpdateParameters["Is_Product"].DefaultValue = rbStockMovement.SelectedValue; SqlStockPile.UpdateParameters["Entry_ID"].DefaultValue = EntryID; SqlStockPile.Update(); } else { SqlData.SelectCommand = "SELECT Entry_ID from StockPile where Batch_ID ='" + strBatchID + "' AND Warehouse_ID ='" + strWarehouseID + "' AND Location_ID ='" + strLocationID + "' AND Quantity ='" + strQty + "' and Is_Product ='" + strIsProduct + "'"; dvView = (DataView)SqlData.Select(dsArguments); string EntryID = dvView[0].Row["Quantity"].ToString(); SqlStockPile.SelectCommand = "DELETE FROM [StockPile] WHERE [Entry_ID] ='" + EntryID; SqlStockPile.Delete(); } gvStockMovement.DataBind(); PaneladdStockMovement.Visible = false; Panel1.Visible = false; PanelgvStockMovement.Visible = true; TowarehouseDropDownList.SelectedIndex = -1; ToQuantityTextBox.Text = String.Empty; ToLocationDropDownList.SelectedIndex = -1; }
public void GetSelectArguments() { PokerS p = new PokerS(); DataSourceSelectArguments arg = p.GetSelectArguments(); Assert.AreEqual("SortExp", arg.SortExpression, "GetSelectArguments"); }
public IQueryable <ClubCloud_Baansoort> SelectBaansoorten(string sortByExpression, int startRowIndex, int maximumRows, out int totalRowCount)//, bool retrieveTotalRowCount = true) { using (new SPMonitoredScope("Baansoorten SelectBaansoorten")) { if (SPContext.Current.Web.CurrentUser != null) { int bondsnummer; ClubCloud_Setting Settings = null; if (int.TryParse(SPContext.Current.Web.CurrentUser.UserId.NameId, out bondsnummer)) { Settings = Client.GetSettingById(bondsnummer); } if (Settings != null && Settings.VerenigingId != null) { List <Parameter> collection = new List <Parameter>(); foreach (Parameter where in WhereParameters) { if (collection.Any(w => w.Name == where.Name)) { int index = collection.FindIndex(p => p.Name == where.Name); if (index >= 0) { collection[index] = where; } } else { collection.Add(where); } } DataSourceSelectArguments selectArgs = new DataSourceSelectArguments { MaximumRows = maximumRows, StartRowIndex = startRowIndex, RetrieveTotalRowCount = true, SortExpression = sortByExpression }; ClubCloud_Baansoort_View queryresult = Client.GetBaansoortenByQuery(bondsnummer.ToString(), Settings.VerenigingId.Value, new DataSourceSelectArguments { MaximumRows = maximumRows, StartRowIndex = startRowIndex, RetrieveTotalRowCount = true, SortExpression = sortByExpression }, collection); totalRowCount = queryresult.TotalRowCount; if (totalRowCount > 0) { foreach (ClubCloud_Baansoort Baansoort in queryresult.ClubCloud_Baansoort) { Baansoort.ClubCloud_Baantype = Client.GetBaantypeForBaansoortById(Baansoort.Id, false, Settings); Baansoort.ClubCloud_Baanblok = new System.Collections.ObjectModel.ObservableCollection <ClubCloud_Baanblok>(Client.GetBaanblokkenForBaansoortById(Baansoort.Id, false, Settings)); } } return(queryresult.ClubCloud_Baansoort.AsQueryable <ClubCloud_Baansoort>()); } } } totalRowCount = 0; return(null); }
public void Equals() { DataSourceSelectArguments arg1 = new DataSourceSelectArguments(); DataSourceSelectArguments arg2 = DataSourceSelectArguments.Empty; Assert.IsTrue(arg1.Equals(arg2), "Equals#1"); Assert.IsTrue(arg1.GetHashCode() == arg2.GetHashCode(), "GetHashCode#1"); arg1.SortExpression = "sort"; arg1.MaximumRows = 10; arg1.StartRowIndex = 5; arg1.RetrieveTotalRowCount = true; arg1.TotalRowCount = 30; Assert.IsFalse(arg1.Equals(arg2), "Equals#2"); Assert.IsFalse(arg1.GetHashCode() == arg2.GetHashCode(), "GetHashCode#2"); arg2.SortExpression = "sort"; arg2.MaximumRows = 10; arg2.StartRowIndex = 5; Assert.IsFalse(arg1.Equals(arg2), "Equals#3"); Assert.IsFalse(arg1.GetHashCode() == arg2.GetHashCode(), "GetHashCode#3"); arg2.RetrieveTotalRowCount = true; arg2.TotalRowCount = 30; Assert.IsTrue(arg1.Equals(arg2), "Equals#4"); Assert.IsTrue(arg1.GetHashCode() == arg2.GetHashCode(), "GetHashCode#4"); }
protected IEnumerable <string> GetLogicalNames(DataSourceSelectArguments args, IDictionary parameters) { if (!string.IsNullOrEmpty(Owner.LogicalNames)) { var values = Owner.LogicalNames.Split(',').Where(s => !string.IsNullOrEmpty(s)).ToArray(); if (values.Any()) { return(values); } } var parameter = parameters["LogicalNames"]; if (parameter != null) { if (parameter is IEnumerable <string> ) { return((parameter as IEnumerable <string>).ToArray()); } var values = parameter.ToString().Split(',').Where(s => !string.IsNullOrEmpty(s)).ToArray(); if (values.Any()) { return(values); } } return(Enumerable.Empty <string>()); }
protected void btnAddCatManJob_Click(object sender, EventArgs e) { string vettedCreateJobText = Regex.Replace(txtCreateJob.Text.ToLower(), @"[\s]+", ""); try { if (vettedCreateJobText != null && vettedCreateJobText != "" && vettedCreateJobText.Length <= 50) { sds.ConnectionString = Resources.ConnectionStrings.ATHENA; sds.SelectCommand = Resources.CatalogManagerSQLQueries.VerifyRegexSelect; DataSourceSelectArguments dssa = new DataSourceSelectArguments(); dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount); dssa.RetrieveTotalRowCount = true; DataView dv = (DataView)sds.Select(dssa); if (dv.Count == 0) { sds.InsertCommand = Resources.CatalogManagerSQLQueries.InsertCleanValues; sds.Insert(); sds.UpdateCommand = Resources.CatalogManagerSQLQueries.UpdateJobs; sds.Update(); } } txtCreateJob.Text = String.Empty; } catch (InvalidCastException ex) { } }
protected internal override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { if (nodes == null) { DoXPathSelect(); } ArrayList list = new ArrayList(); int max = arguments.StartRowIndex + (arguments.MaximumRows > 0 ? arguments.MaximumRows : nodes.Count); if (max > nodes.Count) { max = nodes.Count; } for (int n = arguments.StartRowIndex; n < max; n++) { list.Add(new XmlDataSourceNodeDescriptor((XmlElement)nodes [n])); } if (arguments.RetrieveTotalRowCount) { arguments.TotalRowCount = nodes.Count; } return(list); }
protected void Page_Init(object sender, EventArgs e) { if (Session["AId"] == null) { Response.Redirect("~/default.aspx"); } cat_id = Request.QueryString.Get("cat_id").ToString(); if (string.IsNullOrEmpty(cat_id)) { Response.Redirect("category_add.aspx"); } SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = "SELECT [category_id], [category_name] FROM [Category] WHERE [category_id] = @cat_id"; SqlDataSource1.SelectParameters.Add("cat_id", cat_id); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView dv = SqlDataSource1.Select(args) as DataView; string name = dv.Table.Rows[0][1].ToString(); txtCateoryName.Text = name; dv.Dispose(); SqlDataSource1.Dispose(); }
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { // return a DataTable containing the queried fields from each business object DataTable table = new DataTable(); string tablename = metadata.Name.LocalName; string primaryKeyName = Caisis.BOL.BusinessObject.GetPrimaryKeyName(tablename); IEnumerable <string> foreignKeyNames = Caisis.BOL.BusinessObject.GetForeignKeyNames(tablename); // columns <- fieldnames from query // TraverseQueryFieldnames(metadata).Union(new string[] { primaryKeyName }.Concat(foreignKeyNames)).ForEach(s => table.Columns.Add(s)); /* * Caisis.BOL.BusinessObject.GetFieldNames(tablename).ForEach(s => table.Columns.Add(s)); * * // row <- queried path from each business object tree * businessObjects.ForEach(b => table.Rows.Add(CopyRowData(SubPath(b, metadata), table.NewRow()))); */ // get ordered field names string[] fields = BOL.BusinessObject.GetFieldNames(tablename).ToArray(); // add columns fields.ForEach(f => table.Columns.Add(f)); // each bizo -> add bizo data to new row businessObjects.ForEach(b => table.Rows.Add(fields.Select(f => b[f]).ToArray())); return(table.DefaultView); }
protected internal override IEnumerable ExecuteSelect ( DataSourceSelectArguments arguments) { oleCommand = new OleDbCommand (this.SelectCommand, oleConnection); SqlDataSourceSelectingEventArgs cmdEventArgs = new SqlDataSourceSelectingEventArgs (oleCommand, arguments); OnSelecting (cmdEventArgs); IEnumerable enums = null; Exception exception = null; OleDbDataReader reader = null; try { System.IO.File.OpenRead (dataSource.DataFile).Close (); oleConnection.Open (); reader = (OleDbDataReader)oleCommand.ExecuteReader (); //enums = reader.GetEnumerator (); throw new NotImplementedException("OleDbDataReader doesnt implements GetEnumerator method yet"); } catch (Exception e) { exception = e; } SqlDataSourceStatusEventArgs statusEventArgs = new SqlDataSourceStatusEventArgs (oleCommand, reader.RecordsAffected, exception); OnSelected (statusEventArgs); if (exception !=null) throw exception; return enums; }
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { IEnumerable result; if (null == this.source) { result = null; } else { DataTable table = new DataTable(); table.Columns.Add("Key"); table.Columns.Add("Name"); foreach (string user in this.source.ListUsers(this.role)) { table.Rows.Add(new object[] { user, user }); } result = table.Rows; } return(result); }
/// <summary> /// Gets a list of data from the underlying data storage. /// </summary> /// <param name="arguments">A <see cref="T:System.Web.UI.DataSourceSelectArguments"/> that is used to request operations on the data beyond basic data retrieval.</param> /// <returns> /// An <see cref="T:System.Collections.IEnumerable"/> list of data from the underlying data storage. /// </returns> protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { Options.RecordsToRetrieve = arguments.MaximumRows; Options.StartingRecord = arguments.StartRowIndex; if (!String.IsNullOrEmpty(arguments.SortExpression)) { Parameters.OrderByClause = arguments.SortExpression; } int totalRecords = 0; OrderGroup[] orders = null; if (base.Name == CartsViewName) { orders = OrderContext.Current.FindCarts(this.Parameters, this.Options, out totalRecords); } else if (base.Name == PaymentPlansViewName) { orders = OrderContext.Current.FindPaymentPlans(this.Parameters, this.Options, out totalRecords); } else { orders = OrderContext.Current.FindPurchaseOrders(this.Parameters, this.Options, out totalRecords); } arguments.TotalRowCount = totalRecords; return(orders); }
private static void GuardStartRowIndexNotNegative(DataSourceSelectArguments arguments) { if (arguments.StartRowIndex < 0) { throw new ArgumentException(String.Format(CultureInfo.CurrentCulture, Resources.InvalidStartRowIndex, arguments.StartRowIndex)); } }
private void SortDataForSelectIfNeeded(DataSourceSelectArguments arguments) { if (!(UsingServerSorting || String.IsNullOrEmpty(arguments.SortExpression))) { Data.Sort(new ObjectComparer(arguments.SortExpression, GetDataObjectType())); } }
public virtual void Select(DataSourceSelectArguments args) { if (null != this._dataSource) { this.DataSourceView.Select(args, new DataSourceViewSelectCallback(this.DataSourceSelectCallback)); } }
protected internal override IEnumerable ExecuteSelect( DataSourceSelectArguments arguments) { oleCommand = new OleDbCommand(this.SelectCommand, oleConnection); SqlDataSourceSelectingEventArgs cmdEventArgs = new SqlDataSourceSelectingEventArgs(oleCommand, arguments); OnSelecting(cmdEventArgs); IEnumerable enums = null; Exception exception = null; OleDbDataReader reader = null; try { System.IO.File.OpenRead(dataSource.DataFile).Close(); oleConnection.Open(); reader = (OleDbDataReader)oleCommand.ExecuteReader(); //enums = reader.GetEnumerator (); throw new NotImplementedException("OleDbDataReader doesnt implements GetEnumerator method yet"); } catch (Exception e) { exception = e; } SqlDataSourceStatusEventArgs statusEventArgs = new SqlDataSourceStatusEventArgs(oleCommand, reader.RecordsAffected, exception); OnSelected(statusEventArgs); if (exception != null) { throw exception; } return(enums); }
/*private void GetUserInfo1() * { * SqlDataSource SqlDataSource1 = new SqlDataSource(); * SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; * * SqlDataSource1.SelectCommand = @"SELECT [user_fname], [user_lname], [user_email], [user_ph_num], [user_addr1], [user_addr2], [user_city], [user_state], [user_country], [user_zip] FROM [UserInfo] WHERE [user_id] = @user_id"; * * SqlDataSource1.SelectParameters.Add("user_id", Session["Id"].ToString()); * * * DataSourceSelectArguments args = new DataSourceSelectArguments(); * DataView dv = SqlDataSource1.Select(args) as DataView; * string fname = dv.Table.Rows[0]["user_fname"].ToString(); * string lname = dv.Table.Rows[0]["user_lname"].ToString(); * customerName = fname + " " + lname; * Session["fullname"] = customerName; * dv.Dispose(); * * * FormView1.DataSource = SqlDataSource1; * FormView1.DataBind(); * * SqlDataSource1.Dispose(); * * }*/ private void GetUserInfo2() { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = @"SELECT [user_fname], [user_lname], [user_email], [user_ph_num], [user_addr1], [user_addr2], [user_city], [user_state], [user_country], [user_zip] FROM [UserInfo] WHERE [user_id] = @user_id"; SqlDataSource1.SelectParameters.Add("user_id", Session["Id"].ToString()); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView dv = SqlDataSource1.Select(args) as DataView; string fname = dv.Table.Rows[0]["user_fname"].ToString(); string lname = dv.Table.Rows[0]["user_lname"].ToString(); customerName = fname + " " + lname; Session["fullname"] = customerName; dv.Dispose(); FormView2.DataSource = SqlDataSource1; FormView2.DataBind(); SqlDataSource1.Dispose(); }
public void Empty() { DataSourceSelectArguments arg1 = DataSourceSelectArguments.Empty; DataSourceSelectArguments arg2 = DataSourceSelectArguments.Empty; Assert.IsFalse(Object.ReferenceEquals(arg1, arg2), "Not Cached instance"); }
private void GetProductList() { DataSourceSelectArguments arg = new DataSourceSelectArguments(); pds.DataSource = (DataView)isNew.Select(arg); pds.AllowPaging = true; pds.PageSize = 12; for (int i = 0; i < pds.PageCount; i++) { listPage1.Items.Add((i + 1).ToString()); } if (Request.QueryString["page"] == null) { currentIndex = 1; } else { currentIndex = Convert.ToInt16(Request.QueryString["page"].ToString()); } foreach (ListItem l in listPage1.Items) { if (l.ToString() == currentIndex.ToString().Trim()) { listPage1.SelectedValue = currentIndex.ToString().Trim(); } } pds.CurrentPageIndex = currentIndex - 1; if (!pds.IsFirstPage) { if (Request.Url.ToString().IndexOf("?") > 0) { btnFirst1.NavigateUrl = string.Format(Request.Url.ToString().Replace("page", "nothing") + "&page={0}", 1); btnUp1.NavigateUrl = string.Format(Request.Url.ToString().Replace("page", "nothing") + "&page={0}", currentIndex - 1); } else { btnFirst1.NavigateUrl = string.Format(Request.Url.ToString() + "?page={0}", 1); btnUp1.NavigateUrl = string.Format(Request.Url.ToString() + "?page={0}", currentIndex - 1); } } if (!pds.IsLastPage) { if (Request.Url.ToString().IndexOf("?") > 0) { btnDown1.NavigateUrl = string.Format(Request.Url.ToString().Replace("page", "nothing") + "&page={0}", currentIndex + 1); btnLast1.NavigateUrl = string.Format(Request.Url.ToString().Replace("page", "nothing") + "&page={0}", pds.PageCount); } else { btnDown1.NavigateUrl = string.Format(Request.Url.ToString() + "?page={0}", currentIndex + 1); btnLast1.NavigateUrl = string.Format(Request.Url.ToString() + "?page={0}", pds.PageCount); } } this.yeci1.InnerHtml = currentIndex.ToString() + "/" + pds.PageCount.ToString(); DataList1.DataSource = pds; DataList1.DataBind(); }
internal EntityDataSourceSelectedEventArgs(ObjectContext context, IEnumerable results, int totalRowCount, DataSourceSelectArguments selectArgs) { _context = context; _results = results; _totalRowCount = totalRowCount; _selectArguments = selectArgs; }
public LinqDataSourceSelectEventArgs(DataSourceSelectArguments arguments, IDictionary<string, object> whereParameters, IOrderedDictionary orderByParameters, IDictionary<string, object> groupByParameters, IDictionary<string, object> orderGroupsByParameters, IDictionary<string, object> selectParameters) { _arguments = arguments; _groupByParameters = groupByParameters; _orderByParameters = orderByParameters; _orderGroupsByParameters = orderGroupsByParameters; _selectParameters = selectParameters; _whereParameters = whereParameters; }
protected void btnHae_Click(object sender, EventArgs e) { DataSourceSelectArguments args = new DataSourceSelectArguments("asioid, lastname, firstname, date"); DataView dv = (DataView)srcIlmot.Select(args); dv.RowFilter = "lastname LIKE '" + txtName.Text + "%'"; Gridview1.DataSourceID = ""; Gridview1.DataSource = dv; Gridview1.DataBind(); }
protected internal override IEnumerable ExecuteSelect (DataSourceSelectArguments arguments) { ArrayList list = new ArrayList (); int max = arguments.StartRowIndex + (arguments.MaximumRows > 0 ? arguments.MaximumRows : nodes.Count); if (max > nodes.Count) max = nodes.Count; for (int n = arguments.StartRowIndex; n < max; n++) list.Add (new XmlDataSourceNodeDescriptor ((XmlElement) nodes [n])); if (arguments.RetrieveTotalRowCount) arguments.TotalRowCount = nodes.Count; return list; }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { try { DataTable dt = new DataTable(); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView view = (DataView)SqlDataSource2.Select(args); dt = view.ToTable(); dt.DefaultView.RowFilter = "maa = '" + DropDownList1.SelectedItem.ToString() + "'"; GridView1.DataSource = dt; GridView1.DataSourceID = null; GridView1.DataBind(); } catch (Exception es) { txtError.Text = es.Message; } }
protected void Button1_Click(object sender, EventArgs e) { try { DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView view = (DataView)SqlDataSource1.Select(args); DataTable dt = view.ToTable(); int columnNumber = 0; //Currency Column for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][columnNumber].ToString() == ListBox1.SelectedValue) { decimal dollars = Convert.ToDecimal(TextBox1.Text); decimal rate = Convert.ToDecimal(dt.Rows[i][1]); decimal amount = dollars * rate; Label1.Text = amount.ToString("f2"); Label1.Visible = true; Label2.Text = ""; Label3.Text = ""; TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; break; } } } catch (FormatException) { Label1.Text = "Error"; Label1.Visible = true; Label2.Text = ""; Label3.Text = ""; TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; } }
protected void ddl_College_FiscalYear_SelectedIndexChanged(object sender, EventArgs e) { if (ddl_fiscalyear.SelectedIndex > 0 && ddl_College.SelectedIndex > 0) { pan_Acc.Visible = true; DataSourceSelectArguments dssa = new DataSourceSelectArguments(); dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount); dssa.RetrieveTotalRowCount = true; DataView dv = (DataView)SQLDS_Accountablity.Select(dssa); Label1.Text = dv.Table.Rows[0][0].ToString(); hf_Accountability_Id.Value = dv.Table.Rows[0][0].ToString(); lbl_Acc_Id.Text = dv.Table.Rows[0][0].ToString(); txt_Note.Text = dv.Table.Rows[0][4].ToString(); //ds_Level.DataBind(); dv = (DataView)ds_Level.Select(dssa); lbl_Level.Text = dv.Table.Rows[0][1].ToString(); hf_Level_Id.Value = dv.Table.Rows[0][0].ToString(); ddl_Acct_Next_Level.DataBind(); //ds_Acc_Narr.DataBind(); //SqlDS_Gender.DataBind(); //SqlDS_Race.DataBind(); //ds_2p1_Spec_Pop.DataBind(); //ds_3p1_Spec_Pop.DataBind(); //ds_4p1_Spec_Pop.DataBind(); //ds_5p1_Spec_Pop.DataBind(); //ds_5p2_Spec_Pop.DataBind(); //ds_Enrollment.DataBind(); rg_Narratives.DataBind(); rg_Enrollment.DataBind(); } else pan_Acc.Visible = false; }
protected void btnSearch_Click(object sender, EventArgs e) { try { String haku = txtSearch.Text; DataTable dt = new DataTable(); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView view = (DataView)SqlDataSource1.Select(args); dt = view.ToTable(); dt.DefaultView.RowFilter = "asnimi like '%" + haku + "%' OR yhteyshlo like '%" + haku + "%'"; GridView1.DataSource = dt; GridView1.DataSourceID = null; GridView1.DataBind(); } catch (Exception es) { txtError.Text = es.Message; } }
public virtual void Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) {}
protected internal override IEnumerable ExecuteSelect (DataSourceSelectArguments arguments) { arguments.RaiseUnsupportedCapabilitiesError (this); IOrderedDictionary paramValues = MergeParameterValues (SelectParameters, null, null); ObjectDataSourceSelectingEventArgs args = new ObjectDataSourceSelectingEventArgs (paramValues, arguments, false); object result = null; if (owner.EnableCaching) result = owner.Cache.GetCachedObject (SelectMethod, SelectParameters); if (result == null) { OnSelecting (args); if (args.Cancel) return new ArrayList (); if (CanPage) { if (StartRowIndexParameterName.Length == 0) throw new InvalidOperationException ("Paging is enabled, but the StartRowIndexParameterName property is not set."); if (MaximumRowsParameterName.Length == 0) throw new InvalidOperationException ("Paging is enabled, but the MaximumRowsParameterName property is not set."); paramValues [StartRowIndexParameterName] = arguments.StartRowIndex; paramValues [MaximumRowsParameterName] = arguments.MaximumRows; } if (SortParameterName.Length > 0) paramValues [SortParameterName] = arguments.SortExpression; result = InvokeSelect (SelectMethod, paramValues); if (CanRetrieveTotalRowCount && arguments.RetrieveTotalRowCount) arguments.TotalRowCount = QueryTotalRowCount (MergeParameterValues (SelectParameters, null, null), arguments); if (owner.EnableCaching) owner.Cache.SetCachedObject (SelectMethod, SelectParameters, result); } if (FilterExpression.Length > 0 && !(result is DataGrid || result is DataView || result is DataTable)) throw new NotSupportedException ("The FilterExpression property was set and the Select method does not return a DataSet, DataTable, or DataView."); if (owner.EnableCaching && result is IDataReader) throw new NotSupportedException ("Data source does not support caching objects that implement IDataReader"); if (result is DataSet) { DataSet dset = (DataSet) result; if (dset.Tables.Count == 0) throw new InvalidOperationException ("The select method returnet a DataSet which doesn't contain any table."); result = dset.Tables [0]; } if (result is DataTable) { DataView dview = new DataView ((DataTable)result); if (arguments.SortExpression != null && arguments.SortExpression.Length > 0) { dview.Sort = arguments.SortExpression; } if (FilterExpression.Length > 0) { IOrderedDictionary fparams = FilterParameters.GetValues (context, owner); ObjectDataSourceFilteringEventArgs fargs = new ObjectDataSourceFilteringEventArgs (fparams); OnFiltering (fargs); if (!fargs.Cancel) { object[] formatValues = new object [fparams.Count]; for (int n=0; n<formatValues.Length; n++) { formatValues [n] = fparams [n]; if (formatValues [n] == null) return dview; } dview.RowFilter = string.Format (FilterExpression, formatValues); } } return dview; } if (result is IEnumerable) return (IEnumerable) result; else return new object[] {result}; }
protected void ReloadData() { DataView dv1 = (DataView)sqlds_accountablityCheck.Select(DataSourceSelectArguments.Empty); DataSet rowcountds = dv1.Table.DataSet.Copy(); if (rowcountds.Tables[0].Rows[0][0].ToString() == "0") { btnCreate.Visible = true; lbl_Acc_Id.Text = ""; lbl_Acc_Id.Visible = false; txt_Note.Visible = false; lbl_Level.Visible = false; hf_Level_Id.Visible = false; ddl_Acct_Next_Level.Visible = false; btn_Save.Visible = false; Label3.Visible = false; Label4.Visible = false; Label5.Visible = false; Label6.Visible = false; HL_Errors.Visible = false; HL_RPLIST.Visible = false; lnkSubmit.Visible = false; if (Session[Session.SessionID + "roleid"].ToString() != "101") { btnCreate.Visible = false; } else { btnCreate.Visible = true; } lbl_error.Visible = true; } else { btnCreate.Visible = false; lbl_error.Visible = false; if (ddl_fiscalyear.SelectedIndex > 0) { SQLDS_Accountablity.SelectParameters.Clear(); SQLDS_Accountablity.SelectParameters.Add("p_key_college_id", ddl_College.SelectedValue); SQLDS_Accountablity.SelectParameters.Add("p_nbr_fiscal_year", ddl_fiscalyear.SelectedValue); SQLDS_Accountablity.SelectParameters.Add("p_txt_created_by", HttpContext.Current.User.Identity.Name.ToString()); SQLDS_Accountablity.Select(DataSourceSelectArguments.Empty); DataSourceSelectArguments dssa = new DataSourceSelectArguments(); dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount); dssa.RetrieveTotalRowCount = true; DataView dv = (DataView)SQLDS_Accountablity.Select(dssa); hf_Accountability_Id.Value = dv.Table.Rows[0][0].ToString(); lbl_Acc_Id.Text = dv.Table.Rows[0][0].ToString(); txt_Note.Text = dv.Table.Rows[0][4].ToString(); dv = (DataView)ds_Level.Select(dssa); lbl_Level.Text = dv.Table.Rows[0][1].ToString(); Session.Add(HttpContext.Current.User.Identity.Name + Session.SessionID + "LevelTitle", lbl_Level.Text); hf_Level_Id.Value = dv.Table.Rows[0][0].ToString(); ddl_Acct_Next_Level.DataBind(); lbl_Acc_Id.Visible = true; txt_Note.Visible = true; lbl_Level.Visible = true; hf_Level_Id.Visible = true; ddl_Acct_Next_Level.Visible = true; btn_Save.Visible = true; Label3.Visible = true; Label4.Visible = true; Label5.Visible = true; Label6.Visible = true; HL_RPLIST.Visible = true; lnkSubmit.Visible = true; } else { lbl_Acc_Id.Text = ""; txt_Note.Text = ""; lbl_Level.Text = ""; hf_Level_Id.Value = ""; //ds_Acct_Next_Level.DataBind(); ddl_Acct_Next_Level.Items.Clear(); HL_Errors.Visible = false; HL_RPLIST.Visible = false; lnkSubmit.Visible = false; } } }
protected void btnCreate_Click(object sender, EventArgs e) { // Create an Accountability Report if (ddl_fiscalyear.SelectedIndex > 0) { SQLDS_Accountablity.InsertParameters.Clear(); SQLDS_Accountablity.InsertParameters.Add("p_key_college_id", ddl_College.SelectedValue); SQLDS_Accountablity.InsertParameters.Add("p_nbr_fiscal_year", ddl_fiscalyear.SelectedValue); SQLDS_Accountablity.InsertParameters.Add("p_txt_created_by", HttpContext.Current.User.Identity.Name.ToString()); SQLDS_Accountablity.Insert(); SQLDS_Accountablity.SelectParameters.Clear(); SQLDS_Accountablity.SelectParameters.Add("p_key_college_id", ddl_College.SelectedValue); SQLDS_Accountablity.SelectParameters.Add("p_nbr_fiscal_year", ddl_fiscalyear.SelectedValue); SQLDS_Accountablity.SelectParameters.Add("p_txt_created_by",HttpContext.Current.User.Identity.Name.ToString()); SQLDS_Accountablity.Select(DataSourceSelectArguments.Empty); DataSourceSelectArguments dssa = new DataSourceSelectArguments(); dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount); dssa.RetrieveTotalRowCount = true; DataView dv = (DataView)SQLDS_Accountablity.Select(dssa); hf_Accountability_Id.Value = dv.Table.Rows[0][0].ToString(); lbl_Acc_Id.Text = dv.Table.Rows[0][0].ToString(); txt_Note.Text = dv.Table.Rows[0][4].ToString(); dv = (DataView)ds_Level.Select(dssa); lbl_Level.Text = dv.Table.Rows[0][1].ToString(); hf_Level_Id.Value = dv.Table.Rows[0][0].ToString(); ddl_Acct_Next_Level.DataBind(); lbl_Acc_Id.Visible = true; txt_Note.Visible = true; lbl_Level.Visible = true; hf_Level_Id.Visible = true; ddl_Acct_Next_Level.Visible = true; btn_Save.Visible = true; Label3.Visible = true; Label4.Visible = true; Label5.Visible = true; Label6.Visible = true; HL_RPLIST.Visible = true; lnkSubmit.Visible = true; } else { lbl_Acc_Id.Text = ""; txt_Note.Text = ""; lbl_Level.Text = ""; hf_Level_Id.Value = ""; //ds_Acct_Next_Level.DataBind(); ddl_Acct_Next_Level.Items.Clear(); HL_Errors.Visible = false; HL_RPLIST.Visible = false; lnkSubmit.Visible = false; btn_Save.Visible = false; } LoadSession(); ReloadData(); }
int QueryTotalRowCount (IOrderedDictionary mergedParameters, DataSourceSelectArguments arguments) { ObjectDataSourceSelectingEventArgs countArgs = new ObjectDataSourceSelectingEventArgs (mergedParameters, arguments, true); OnSelecting (countArgs); if (countArgs.Cancel) return 0; object count = InvokeSelect (SelectCountMethod, mergedParameters); return (int) Convert.ChangeType (count, typeof(int)); }
protected void preencherGaleria() { DataSourceSelectArguments arg = new DataSourceSelectArguments(); IEnumerable ft = allFotos.Select(arg); IEnumerator ft2 = ft.GetEnumerator(); string fotos = ""; int numFotos = 0; while (ft2.MoveNext()) { numFotos++; DataRowView row = (DataRowView)ft2.Current; string legenda = row.Row[4].ToString() + " na cidade de(o) " + row.Row[3].ToString() + " (" + Convert.ToDateTime(row.Row[5].ToString()).ToShortDateString() + ")"; fotos = fotos + "<figure class=\"cap-left\">" + "<a href=\"" + row.Row[2].ToString() + "\" class=\"top_up\" toptions=\"group = imagens\"><p style=\"float: left; width: 200px; font-size: 9pt; margin-right: 5px; padding-bottom: 0px;\"><img width=\"200px\" height=\"200px\" src=\"" + row.Row[2].ToString() + "\" alt=\"\"></a>"+legenda+"</p><br/>" + "<figcaption>" + row.Row[1].ToString() + " <a href=\"Fotos.aspx?remFoto=" + row.Row[0].ToString() + "\" onClick=\"if(confirm('Deseja eliminar a foto seleccionada?')); else return false;\"><img src=\"Icons/remFoto.png\" heigth=\"20px\" width=\"20px\" title=\"Remover Foto\"/></a></figcaption>" + "</figure>"; } Label1.Visible = true; if (numFotos == 0) { Label1.Text = "<center>Não existem fotos da cidade seleccionada</center>"; } else { Label1.Text = fotos + "<br/>"; } }
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments) { throw new Exception("The method or operation is not implemented."); }
string SavePostedFiles(UploadedFile uploadedFile) { if (!uploadedFile.IsValid) return string.Empty; DataSourceSelectArguments dsSA = new DataSourceSelectArguments(); DataView returnedDataView = (DataView)dsInfo.Select(dsSA); string strMaSo = ""; if (Session["UserID"].ToString() != null) strMaSo = Session["UserID"].ToString() + "_" + DateTime.Now.ToString("ddMMyyyyhhmmss"); else strMaSo = DateTime.Now.ToString("ddMMyyyyhhmmss"); FileInfo fileInfo = new FileInfo(uploadedFile.FileName); string strExp = fileInfo.Name; int Index = strExp.LastIndexOf('.'); strExp = strExp.Substring(Index, strExp.Length - Index); if (strExp.Length <= 0) strExp = ""; string uploadFolder = Server.MapPath("~/img/UserAvata"); uploadedFile.SaveAs(uploadFolder + "/" + strMaSo + strExp); //CutImage150("~/img/UserAvata", 150, fileInfo.Name); return strMaSo + strExp; }
protected void ButtonCompile_Click(object sender, EventArgs e) { var jss = new JavaScriptSerializer(); string url = "http://2d73b8c2.problems.sphere-engine.com/api/v3/compilers?access_token=" + token; if (languageId.Count == 0) { response = client.DownloadString(url); var langObj = jss.Deserialize<Dictionary<string, dynamic>>(response); for (int i = 0; i < langObj["items"].Count; i++) languageId.Add(langObj["items"][i]["id"].ToString()); } url = "http://2d73b8c2.problems.sphere-engine.com/api/v3/submissions?access_token=" + token; string code = TextBoxCode.Text; var json = jss.Serialize(code); string jsonData = "{\"compilerId\":" + languageId[DropDownLanguage.SelectedIndex] + ",\"source\":" + json + ",\"problemCode\":\"" + Request.QueryString["p"] + "\"}"; client.Headers.Add("Content-Type", "application/json"); response = client.UploadString(url, "POST", jsonData); var idObj = jss.Deserialize<Dictionary<string, string>>(response); string id = idObj["id"]; bool finished = false; while (!finished) { url = "http://2d73b8c2.problems.sphere-engine.com/api/v3/submissions/"+id+"?access_token="+token; response = client.DownloadString(url); var resultObj = jss.Deserialize<Dictionary<string, dynamic>>(response); if (resultObj["status"] > 10) { finished = true; testCases=""; for (int i = 0; i < resultObj["result_array"].Count; i++) { string passed = "check"; if (resultObj["result_array"][i]["statusDescription"] != "accepted") passed = "close"; string color = passed == "check" ? "green;" : "red;"; testCases += "<h5><a href=\"#\"><label><i style=\"color:"+color +"\" class=\"fa fa-"+passed+" fa-fw\"></i> Testcase " + (i + 1).ToString() + "</label></a></h5><div class=\"no-padding\" style=\"border:0;\">"; testCases += "<table aria-describedby=\"dataTables-example_info\" role=\"grid\"" + "class=\"table table-responsive table-striped table-bordered table-hover dataTable no-footer dtr-inline\""+ "width=\"100%\"><tbody>"; if (i==0 && resultObj["result_stdout"].Contains("DATASET NUMBER: 0")) testCases += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Output</label></td><td>" + resultObj["result_stdout"].Split('\n')[2] + "</td></tr>"; testCases += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Time</label></td><td>" + resultObj["result_array"][i]["time"] + "</td></tr>"; testCases += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Memory</label></td><td>" + resultObj["result_array"][i]["memory"] + "</td></tr>"; testCases += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Status</label></td><td>" + resultObj["result_array"][i]["statusDescription"] + "</td></tr>"; testCases += "</tbody></table></div>"; } compInfo.InnerHtml = "<table aria-describedby=\"dataTables-example_info\" role=\"grid\""+ "class=\"table table-responsive table-striped table-bordered table-hover dataTable no-footer dtr-inline\""+ "width=\"100%\"><tbody>"; compInfo.InnerHtml += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Score</label></td><td>" + resultObj["result_score"] + "</td></tr>"; compInfo.InnerHtml += "<tr role=\"row\" class=\"gradeA odd\"><td><label>LangName</label></td><td>" + resultObj["compiler"]["name"] + "</td></tr>"; compInfo.InnerHtml += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Time</label></td><td>" + resultObj["result_time"] + "</td></tr>"; compInfo.InnerHtml += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Memory</label></td><td>" + resultObj["result_memory"] + "</td></tr>"; compInfo.InnerHtml += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Signal</label></td><td>" + resultObj["result_signal"] + "</td></tr>"; if (resultObj["result_cmperr"] != "") compInfo.InnerHtml += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Compile Error</label></td><td>" + resultObj["result_cmperr"] + "</td></td>"; compInfo.InnerHtml += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Status</label></td><td>" + resultObj["statusDescription"] + "</td></tr>"; compInfo.InnerHtml += "<tr role=\"row\" class=\"gradeA odd\"><td><label>Result</label></td><td>"; if (resultObj["status"] == 11) compInfo.InnerHtml += "Compilation Error"; if (resultObj["status"] == 12) compInfo.InnerHtml += "Runtime Error"; if (resultObj["status"] == 13) compInfo.InnerHtml += "Time Limit Exceeded"; if (resultObj["status"] == 14) compInfo.InnerHtml += "Wrong Answer"; if (resultObj["status"] == 15) compInfo.InnerHtml += "Success"; if (resultObj["status"] == 17) compInfo.InnerHtml += "Memory Limit Exceeded"; if (resultObj["status"] == 19) compInfo.InnerHtml += "Illegal System Call"; if (resultObj["status"] == 20 || resultObj["status"] == 21) compInfo.InnerHtml += "Internal Error"; compInfo.InnerHtml += "</td></tr></tbody></table>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "init", "g1.refresh(" + resultObj["result_score"] + ")", true); SubmissionDataSource.SelectParameters.Clear(); //Select SubmissionDataSource.SelectParameters.Add("Question", Request.QueryString["p"]); SubmissionDataSource.SelectParameters.Add("Username", Membership.GetUser().UserName); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView dv = (DataView)SubmissionDataSource.Select(args); if (dv.Table.Rows.Count == 1) //Update if exist { SubmissionDataSource.UpdateParameters.Clear(); SubmissionDataSource.UpdateParameters.Add("Score", Convert.ToInt32(resultObj["result_score"]).ToString()); SubmissionDataSource.UpdateParameters.Add("SubmissionId", id); SubmissionDataSource.UpdateParameters.Add("Question", Request.QueryString["p"]); SubmissionDataSource.UpdateParameters.Add("Username", Membership.GetUser().UserName); SubmissionDataSource.UpdateParameters.Add("Date", DateTime.Now.ToString("MM/dd/yyyy HH:mm")); SubmissionDataSource.UpdateParameters.Add("Language", DropDownLanguage.SelectedItem.Text); SubmissionDataSource.Update(); } else //Insert { SubmissionDataSource.InsertParameters.Clear(); SubmissionDataSource.InsertParameters.Add("Score", Convert.ToInt32(resultObj["result_score"]).ToString()); SubmissionDataSource.InsertParameters.Add("SubmissionId", id); SubmissionDataSource.InsertParameters.Add("Question", Request.QueryString["p"]); SubmissionDataSource.InsertParameters.Add("Username", Membership.GetUser().UserName); SubmissionDataSource.InsertParameters.Add("Date", DateTime.Now.ToString("MM/dd/yyyy HH:mm")); SubmissionDataSource.InsertParameters.Add("Language", DropDownLanguage.SelectedItem.Text); SubmissionDataSource.Insert(); } } } }
protected void Page_Load(object sender, EventArgs e) { int postback = 1; if (!Page.IsPostBack) { if (string.IsNullOrEmpty(Request.QueryString["p"])) Response.Redirect("Default.aspx"); DropDownLanguage.Attributes.Add("onchange", "fillSampleCode();"); languageId.Clear(); var jss = new JavaScriptSerializer(); string url = "http://2d73b8c2.problems.sphere-engine.com/api/v3/compilers?access_token=" + token; response = client.DownloadString(url); var langObj = jss.Deserialize<Dictionary<string, dynamic>>(response); for (int i = 0; i < langObj["items"].Count; i++) { DropDownLanguage.Items.Add(langObj["items"][i]["name"] +" ("+ langObj["items"][i]["ver"]+")"); languageId.Add(langObj["items"][i]["id"].ToString()); } url = "http://2d73b8c2.problems.sphere-engine.com/api/v3/problems/" + Request.QueryString["p"] +"?access_token=" + token; response = client.DownloadString(url); var problemObj = jss.Deserialize<Dictionary<string, dynamic>>(response); problem.InnerHtml = "<h3><strong>"+problemObj["name"]+"</strong></h3>" + problemObj["body"]; SubmissionDataSource.SelectParameters.Clear(); //Select SubmissionDataSource.SelectParameters.Add("Question", Request.QueryString["p"]); SubmissionDataSource.SelectParameters.Add("Username", Membership.GetUser().UserName); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView dv = (DataView)SubmissionDataSource.Select(args); if (dv.Table.Rows.Count == 1) { string submissionId = dv.Table.Rows[0]["SubmissionId"].ToString(); url = "http://2d73b8c2.problems.sphere-engine.com/api/v3/submissions/" + submissionId + "?access_token=" + token; response = client.DownloadString(url); var oldSubmission = jss.Deserialize<Dictionary<string, dynamic>>(response); TextBoxCode.Text = oldSubmission["source"]; DropDownLanguage.SelectedIndex = languageId.IndexOf(oldSubmission["language"].ToString()); } else { postback = 0; DropDownLanguage.SelectedIndex = 10; } } Page.ClientScript.RegisterStartupScript(this.GetType(), "init", "init(" + postback.ToString() + ")", true); }
protected internal override IEnumerable ExecuteSelect (DataSourceSelectArguments arguments) { if (SortParameterName.Length > 0 && SelectCommandType == SqlDataSourceCommandType.Text) throw new NotSupportedException ("The SortParameterName property is only supported with stored procedure commands in SqlDataSource"); if (arguments.SortExpression.Length > 0 && owner.DataSourceMode == SqlDataSourceMode.DataReader) throw new NotSupportedException ("SqlDataSource cannot sort. Set DataSourceMode to DataSet to enable sorting."); if (arguments.StartRowIndex > 0 || arguments.MaximumRows > 0) throw new NotSupportedException ("SqlDataSource does not have paging enabled. Set the DataSourceMode to DataSet to enable paging."); if (FilterExpression.Length > 0 && owner.DataSourceMode == SqlDataSourceMode.DataReader) throw new NotSupportedException ("SqlDataSource only supports filtering when the data source's DataSourceMode is set to DataSet."); InitConnection (); DbCommand command = factory.CreateCommand (); command.CommandText = SelectCommand; command.Connection = connection; if (SelectCommandType == SqlDataSourceCommandType.Text) command.CommandType = CommandType.Text; else { command.CommandType = CommandType.StoredProcedure; if (SortParameterName.Length > 0 && arguments.SortExpression.Length > 0) command.Parameters.Add (CreateDbParameter (SortParameterName, arguments.SortExpression)); } if (SelectParameters.Count > 0) InitializeParameters (command, SelectParameters, null, null, false); Exception exception = null; if (owner.DataSourceMode == SqlDataSourceMode.DataSet) { DataView dataView = null; if (owner.EnableCaching) dataView = (DataView) owner.Cache.GetCachedObject (SelectCommand, SelectParameters); if (dataView == null) { SqlDataSourceSelectingEventArgs selectingArgs = new SqlDataSourceSelectingEventArgs (command, arguments); OnSelecting (selectingArgs); if (selectingArgs.Cancel || !PrepareNullParameters (command, CancelSelectOnNullParameter)) { return null; } try { DbDataAdapter adapter = factory.CreateDataAdapter (); DataSet dataset = new DataSet (); adapter.SelectCommand = command; adapter.Fill (dataset, name); dataView = dataset.Tables [0].DefaultView; if (dataView == null) throw new InvalidOperationException (); } catch (Exception e) { exception = e; } int rowsAffected = (dataView == null) ? 0 : dataView.Count; SqlDataSourceStatusEventArgs selectedArgs = new SqlDataSourceStatusEventArgs (command, rowsAffected, exception); OnSelected (selectedArgs); if (exception != null && !selectedArgs.ExceptionHandled) throw exception; if (owner.EnableCaching) owner.Cache.SetCachedObject (SelectCommand, selectParameters, dataView); } if (SortParameterName.Length == 0 || SelectCommandType == SqlDataSourceCommandType.Text) dataView.Sort = arguments.SortExpression; if (FilterExpression.Length > 0) { IOrderedDictionary fparams = FilterParameters.GetValues (context, owner); SqlDataSourceFilteringEventArgs fargs = new SqlDataSourceFilteringEventArgs (fparams); OnFiltering (fargs); if (!fargs.Cancel) { object [] formatValues = new object [fparams.Count]; for (int n = 0; n < formatValues.Length; n++) { formatValues [n] = fparams [n]; if (formatValues [n] == null) return dataView; } dataView.RowFilter = string.Format (FilterExpression, formatValues); } } return dataView; } else { SqlDataSourceSelectingEventArgs selectingArgs = new SqlDataSourceSelectingEventArgs (command, arguments); OnSelecting (selectingArgs); if (selectingArgs.Cancel || !PrepareNullParameters (command, CancelSelectOnNullParameter)) { return null; } DbDataReader reader = null; bool closed = connection.State == ConnectionState.Closed; if (closed) connection.Open (); try { reader = command.ExecuteReader (closed ? CommandBehavior.CloseConnection : CommandBehavior.Default); } catch (Exception e) { exception = e; } SqlDataSourceStatusEventArgs selectedArgs = new SqlDataSourceStatusEventArgs (command, reader.RecordsAffected, exception); OnSelected (selectedArgs); if (exception != null && !selectedArgs.ExceptionHandled) throw exception; return reader; } }
public IEnumerable Select (DataSourceSelectArguments args) { return View.Select (args); }
protected override DataSourceSelectArguments CreateDataSourceSelectArguments() { DataSourceSelectArguments arguments = new DataSourceSelectArguments(); DataSourceView view = GetData(); _useServerPaging = AllowPaging && view.CanPage; // decide if we should use server-side paging if (_useServerPaging) { arguments.StartRowIndex = PageIndex; if (view.CanRetrieveTotalRowCount) { arguments.RetrieveTotalRowCount = true; arguments.MaximumRows = 1; } else { arguments.MaximumRows = -1; } } return arguments; }
protected override DataSourceSelectArguments CreateDataSourceSelectArguments() { DataSourceSelectArguments arguments = new DataSourceSelectArguments(); DataSourceView view = GetData(); bool useServerPaging = view.CanPage; string sortExpression = SortExpressionInternal; if (SortDirectionInternal == SortDirection.Descending && !String.IsNullOrEmpty(sortExpression)) { sortExpression += " DESC"; } arguments.SortExpression = sortExpression; // decide if we should use server-side paging if (useServerPaging) { if (view.CanRetrieveTotalRowCount) { arguments.RetrieveTotalRowCount = true; arguments.MaximumRows = _maximumRows; } else { arguments.MaximumRows = -1; } arguments.StartRowIndex = _startRowIndex; } return arguments; }
public IEnumerable Select (DataSourceSelectArguments arguments) { return ExecuteSelect (arguments); }
public ObjectDataSourceSelectingEventArgs (IOrderedDictionary inputParameters, DataSourceSelectArguments arguments, bool executeSelectCount) : base (inputParameters) { this.executeSelectCount = executeSelectCount; this.arguments = arguments; }
protected internal override IEnumerable ExecuteSelect (DataSourceSelectArguments arguments) { return collection; }