/// <summary> /// Gets an instance of item. /// </summary> /// <param name="itemGuid"> itemGuid </param> private void GetItem(Guid itemGuid) { using (IDataReader reader = DBItems.GetOne(itemGuid)) { PopulateFromReader(reader); } }
/// <summary> /// Gets an instance of item. /// </summary> /// <param name="itemID"> itemID </param> private void GetItem(int itemID) { using (IDataReader reader = DBItems.GetOne(itemID)) { PopulateFromReader(reader); } }
protected void Page_Load(object sender, EventArgs e) { if (!App.loaded && !Server.MapPath(".").ToLower().Contains("loading")) { try { Response.Redirect("/Loading/", false); Context.ApplicationInstance.CompleteRequest(); } catch (System.Threading.ThreadAbortException) { } return; } this.Title = "LegacyPlayers | Loot"; if (Utility.GetQueryString(Request, "i", "") != "" && pmItem.Value == "") { pmItem.Value = Utility.GetQueryString(Request, "i", ""); } if (IsPostBack) { Utility.SetCookie(Response, Request, "Loot_Item", pmItem.Value); } else { if (pmItem.Value == "") { pmItem.Value = Utility.GetCookie(Request, "Loot_Item", ""); } } if (pmItem.Value == "") { return; } for (int i = 0; i < 2; ++i) { List <int> ItemIds = App.m_Items[i].Where(x => x.Value.Name.Contains(pmItem.Value)) .Select(x => x.Key).ToList(); if (ItemIds.Count == 0) { return; } SQLWrapper db = App.GetDB(i + 1); m_CurPage = int.Parse(Utility.GetQueryString(Request, "page", "0")); var imgType2 = Utility.GetImageType(Request); MySqlDataReader dr = db.Query("SELECT itemid FROM rs_loot WHERE itemid IN (" + string.Join(",", ItemIds) + ") GROUP BY itemid LIMIT " + m_CurPage * 10 + ", 10").ExecuteReaderRpll(); while (dr.Read()) { DBItems item = App.m_Items[i][dr.GetInt32(0)]; m_Table.Append( "<tr><td><div class=\"icon-26 bbdesign qe" + item.Quality + "\" style=\"background-image: url(\'/Assets/icons/" + item.IconName + "." + imgType2 + "\')\">" + "<div><a href=\"/Raids/Loot/Item/?item=" + dr.GetInt32(0) + "\" class=\"q" + item.Quality + "\" onmouseover=\"tt_show(this, 1," + dr.GetInt32(0) + ",[])\">[" + item.Name + "]</a></div></div></td></tr>"); } dr.CloseRpll(); } }
/// <summary> /// Persists a new instance of item. Returns true on success. /// </summary> /// <returns></returns> private bool Create() { int newID = 0; newID = DBItems.Create( siteGuid, featureGuid, moduleGuid, moduleID, definitionGuid, itemGuid, sortOrder, createdUtc, lastModUtc, viewRoles, editRoles); this.itemID = newID; bool result = (newID > 0); if (result) { ContentChangedEventArgs e = new ContentChangedEventArgs(); OnContentChanged(e); } return(result); }
/// <summary> /// Persists a new instance of item. Returns true on success. /// </summary> /// <returns></returns> private bool Create() { int newID = 0; newID = DBItems.Create( this.siteGuid, this.featureGuid, this.moduleGuid, this.moduleID, this.definitionGuid, this.itemGuid, this.sortOrder, this.createdUtc, this.lastModUtc); this.itemID = newID; bool result = (newID > 0); if (result) { ContentChangedEventArgs e = new ContentChangedEventArgs(); OnContentChanged(e); } return(result); }
/// <summary> /// Gets an IList with page of instances of item. /// </summary> /// <param name="pageNumber">The page number.</param> /// <param name="pageSize">Size of the page.</param> /// <param name="totalPages">total pages</param> public static List <Item> GetPage(int pageNumber, int pageSize, out int totalPages) { totalPages = 1; IDataReader reader = DBItems.GetPage(pageNumber, pageSize, out totalPages); return(LoadListFromReader(reader)); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Home/Error"); // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts. app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthentication(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllerRoute( name: "default", pattern: "{controller=Home}/{action=Index}/{id?}"); }); using (var scope = app.ApplicationServices.CreateScope()) { ApplicationContext context = scope.ServiceProvider.GetRequiredService <ApplicationContext>(); DBItems.Initial(context); } }
/// <summary> /// Gets an IList of all items, with values, for a single definition /// </summary> /// <param name="fieldDefinitionGuid"></param> /// <param name="siteGuid"></param> /// <param name="descending"></param> /// <returns></returns> public static List <ItemWithValues> GetForDefinitionWithValues(Guid fieldDefinitionGuid, Guid siteGuid, bool descending = false) { IDataReader reader = DBItems.GetForDefinitionWithValues(fieldDefinitionGuid, siteGuid, descending ? "DESC" : "ASC"); List <ItemWithValues> items = LoadListFromReaderWithValues(reader); return(items); }
/// <summary> /// /// </summary> /// <param name="moduleId"></param> /// <param name="descending"></param> /// <returns></returns> public static List <ItemWithValues> GetForModuleWithValues(int moduleId, bool descending = false) { IDataReader reader = DBItems.GetForModuleWithValues(moduleId, descending ? "DESC" : "ASC"); List <ItemWithValues> iwv = LoadListFromReaderWithValues(reader); return(iwv); }
/// <summary> /// Gets an IList with all items for a module instance /// </summary> /// <param name="moduleId"></param> /// <returns>IList</returns> public static List <Item> GetForModule(int moduleId, bool descending = false) { IDataReader reader = DBItems.GetForModule(moduleId, descending ? "DESC" : "ASC"); List <Item> items = LoadListFromReader(reader); return(items); }
/// <summary> /// The last date that a file(s) was submitted... /// </summary> private void SetUIItems() { DateTime lastDate = new DateTime(); lastDate = DBItems.ReturnLastActionDate(); this.ltlLastRunDate.Text = lastDate.ToShortDateString(); }
//Remove item from DBITEMS public void RemoveItem(int?id) { Item item = DBItems.FirstOrDefault(it => it.ID == id); if (item != null) { Remove(item); SaveChanges(); } }
/// <summary> /// Gets an IList with all items for a module instance /// </summary> /// <param name="moduleId"></param> /// <returns>IList</returns> public static List <Item> GetModuleItems(int moduleId, bool descending = false) { IDataReader reader = DBItems.GetModuleItems(moduleId); List <Item> items = LoadListFromReader(reader); if (descending) { Item_SortDescendingOrder descendingSort = new Item_SortDescendingOrder(); items.Sort(descendingSort); } return(items); }
/// <summary> /// Gets a DataTable with items on a specific page /// </summary> /// <param name="siteGuid"></param> /// <param name="pageId"></param> /// <returns>DataTable</returns> public static DataTable GetByCMSPage(Guid siteGuid, int pageId) { DataTable dataTable = new DataTable(); dataTable.Columns.Add("ModuleID", typeof(int)); dataTable.Columns.Add("ItemGuid", typeof(Guid)); dataTable.Columns.Add("ItemID", typeof(int)); dataTable.Columns.Add("SortOrder", typeof(int)); dataTable.Columns.Add("CreatedUtc", typeof(DateTime)); dataTable.Columns.Add("ModuleTitle", typeof(string)); dataTable.Columns.Add("ModuleViewRoles", typeof(string)); dataTable.Columns.Add("ItemViewRoles", typeof(string)); dataTable.Columns.Add("PublishBeginDate", typeof(DateTime)); dataTable.Columns.Add("PublishEndDate", typeof(DateTime)); using (IDataReader reader = DBItems.GetByCMSPage(siteGuid, pageId)) { while (reader.Read()) { DataRow row = dataTable.NewRow(); row["ModuleID"] = reader["moduleId"]; row["ItemGuid"] = Guid.Parse(reader["itemGuid"].ToString()); row["ItemID"] = reader["itemId"]; row["SortOrder"] = reader["sortOrder"]; row["CreatedUtc"] = Convert.ToDateTime(reader["createdUtc"]); row["ModuleTitle"] = reader["moduleTitle"]; row["ModuleViewRoles"] = reader["moduleViewRoles"]; row["ItemViewRoles"] = reader["itemViewRoles"]; if (reader["publishBeginDate"] != DBNull.Value) { row["PublishBeginDate"] = Convert.ToDateTime(reader["publishBeginDate"]); } if (reader["publishEndDate"] != DBNull.Value) { row["PublishEndDate"] = Convert.ToDateTime(reader["publishEndDate"]); } dataTable.Rows.Add(row); } } return(dataTable); }
/// <summary> /// Gets an IList with all items for a single definition /// </summary> /// <param name="fieldDefinitionGuid"></param> /// <param name="descending"></param> /// <returns></returns> public static List <Item> GetAllForDefinition(Guid fieldDefinitionGuid, bool descending = false) { IDataReader reader = DBItems.GetAllForDefinition(fieldDefinitionGuid); List <Item> items = LoadListFromReader(reader); if (descending) { return(items .OrderByDescending(i => i.GlobalViewSortOrder) .ThenByDescending(i => i.ModuleID) .ThenByDescending(i => i.SortOrder) .ThenByDescending(i => i.CreatedUtc).ToList()); //Item_SortDescendingOrder descendingSort = new Item_SortDescendingOrder(); //items.Sort(descendingSort); } return(items); }
/// <summary> /// Updates this instance of item. Returns true on success. /// </summary> /// <returns>bool</returns> private bool Update() { bool result = DBItems.Update( this.siteGuid, this.featureGuid, this.moduleGuid, this.moduleID, this.definitionGuid, this.itemGuid, this.sortOrder, this.createdUtc, this.lastModUtc); if (result) { ContentChangedEventArgs e = new ContentChangedEventArgs(); OnContentChanged(e); } return(result); }
/// <summary> /// Gets a list of Items within a "page" for a Definition /// </summary> /// <param name="moduleId"></param> /// <param name="pageNumber"></param> /// <param name="pageSize"></param> /// <param name="totalPages"></param> /// <param name="searchTerm"></param> /// <param name="searchField"></param> /// <param name="descending"></param> /// <returns></returns> public static List <Item> GetPageForDefinition( Guid defGuid, Guid siteGuid, int pageNumber, int pageSize, out int totalPages, out int totalRows, string searchTerm = "", string searchField = "", bool descending = false) { totalPages = 1; IDataReader reader = DBItems.GetPageForDefinition(defGuid, siteGuid, pageNumber, pageSize, searchTerm, searchField, descending); var items = LoadListFromReader(reader, true); totalRows = _totalRows; if (pageSize > 0) { totalPages = totalRows / pageSize; } if (totalRows <= pageSize) { totalPages = 1; } else { int remainder; Math.DivRem(totalRows, pageSize, out remainder); if (remainder > 0) { totalPages += 1; } } return(items); }
/// <summary> /// Gets a list of Items within a "page" /// </summary> /// <param name="moduleId"></param> /// <param name="pageNumber"></param> /// <param name="pageSize"></param> /// <param name="totalPages"></param> /// <param name="searchTerm"></param> /// <param name="searchField"></param> /// <param name="descending"></param> /// <returns></returns> public static List <ItemWithValues> GetForModuleWithValues_Paged( Guid moduleGuid, int pageNumber, int pageSize, out int totalPages, out int totalRows, string searchTerm = "", string searchField = "", bool descending = false) { totalPages = 1; IDataReader reader = DBItems.GetForModuleWithValues_Paged(moduleGuid, pageNumber, pageSize, searchTerm, searchField, descending ? "DESC" : "ASC"); var items = LoadListFromReaderWithValues(reader, true); totalRows = _totalRows; if (pageSize > 0) { totalPages = totalRows / pageSize; } if (totalRows <= pageSize) { totalPages = 1; } else { Math.DivRem(totalRows, pageSize, out int remainder); if (remainder > 0) { totalPages += 1; } } return(items); }
/// <summary> /// Updates this instance of item. Returns true on success. /// </summary> /// <returns>bool</returns> private bool Update() { bool result = DBItems.Update( siteGuid, featureGuid, moduleGuid, moduleID, definitionGuid, itemGuid, sortOrder, createdUtc, lastModUtc, viewRoles, editRoles); if (result) { ContentChangedEventArgs e = new ContentChangedEventArgs(); OnContentChanged(e); } return(result); }
public BaseModel <object> Item_Mutiple_Insert([FromBody] List <ItemsSavedImportModel> data) { BaseModel <object> _baseModel = new BaseModel <object>(); ErrorModel _error = new ErrorModel(); string Token = _account.GetHeader(Request); LoginData loginData = _account._GetInfoUser(Token); if (loginData == null) { return(_baseModel = new BaseModel <object> { data = null, status = 0, error = new ErrorModel { code = Constant.ERRORDATA, message = "Phiên đăng nhập hết hạn hoặc bạn chưa truyền Token" } }); } try { List <long> res = new List <long>(); using (var transactionCreate = _context.Database.BeginTransaction()) { foreach (var ele in data) { List <DBItems> l = new List <DBItems>(); DBItems element = new DBItems(); element.IdType = ele.IdType; element.Name = ele.Name; element.Money = ele.Money; element.Sales = ele.Sales; element.RateAvg = 0; element.IsDel = false; element.LinkImage = string.IsNullOrEmpty(ele.LinkImage) ? "" : ele.LinkImage.ToString().Trim(); _context.DBItems.Add(element); _context.SaveChanges(); } transactionCreate.Commit(); } _baseModel.status = 1; _baseModel.data = res; return(_baseModel); } catch (Exception ex) { _baseModel.status = 0; _error.message = "Thêm mới thất bại: " + ex; _error.code = Constant.ERRORCODE; _baseModel.error = _error; _baseModel.data = null; return(_baseModel); } }
/// <summary> /// Gets highest (largest) SortOrder for items for a module instance /// </summary> /// <param name="moduleId"></param> /// <returns>int</returns> public static int GetHighestSortOrder(int moduleId) { return(DBItems.GetHighestSortOrder(moduleId)); }
/// <summary> /// Gets an IList with all instances of item. /// </summary> public static List <Item> GetAll() { IDataReader reader = DBItems.GetAll(); return(LoadListFromReader(reader)); }
/// <summary> /// Gets a count of item. /// </summary> //public static int GetCount() //{ // return DBItems.GetCount(); //} /// <summary> /// Gets a count of all items for a module /// </summary> public static int GetCountForModule(int moduleId) { return(DBItems.GetCountForModule(moduleId)); }
/// <summary> /// Deletes Items and Values by Field Definition. Returns true on success. /// </summary> /// <param name="definitionGuid"> definitionGuid </param> /// <returns>bool</returns> public static bool DeleteByDefinition(Guid definitionGuid) { return(DBItems.DeleteByDefinition(definitionGuid)); }
/// <summary> /// Deletes Items by Module. Returns true on success. /// </summary> /// <param name="moduleGuid"> moduleGuid </param> /// <returns>bool</returns> public static bool DeleteByModule(Guid moduleGuid) { return(DBItems.DeleteByModule(moduleGuid)); }
/// <summary> /// Deletes Items by Site. Returns true on success. /// </summary> public static bool DeleteBySite(Guid siteGuid) { return(DBItems.DeleteBySite(siteGuid)); }
/// <summary> /// Deletes an instance of item. Returns true on success. /// </summary> /// <param name="itemID"> itemID </param> /// <returns>bool</returns> public static bool Delete(int itemID) { return(DBItems.Delete(itemID)); }
/// <summary> /// Gets a count of item. /// </summary> public static int GetCount() { return(DBItems.GetCount()); }
//Get item based on ID from DBITEMS public Item GetFromID(int?id) { return(DBItems.FirstOrDefault(it => it.ID == id)); }