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