/// <summary>
/// Gets the hash code
/// </summary>
/// <returns>Hash code</returns>
public override int GetHashCode()
{
unchecked // Overflow is fine, just wrap
{
var hashCode = 41;
// Suitable nullity checks etc, of course :)
if (CategoryId != null)
{
hashCode = hashCode * 59 + CategoryId.GetHashCode();
}
if (Name != null)
{
hashCode = hashCode * 59 + Name.GetHashCode();
}
if (Info != null)
{
hashCode = hashCode * 59 + Info.GetHashCode();
}
if (CategoryItems != null)
{
hashCode = hashCode * 59 + CategoryItems.GetHashCode();
}
if (Buy != null)
{
hashCode = hashCode * 59 + Buy.GetHashCode();
}
if (Sell != null)
{
hashCode = hashCode * 59 + Sell.GetHashCode();
}
return(hashCode);
}
}
public async Task <CategoryItems> UpdateCategories(CategoryItems category)
{
_context.Update(category);
await _context.SaveChangesAsync();
return(category);
}
public void checker(string searchTxt, string category, int amount, int len)
{
if (String.IsNullOrEmpty(searchTxt) && String.IsNullOrEmpty(category))
{
return;
}
if (!String.IsNullOrEmpty(searchTxt) && !String.IsNullOrEmpty(category))//both not empty
{
CategoryIndex = CategoryItems.IndexOf(category);
//GetSearch(searchTxt, category, amount, len,false);
}
else if (!String.IsNullOrEmpty(searchTxt) && String.IsNullOrEmpty(category))//category empty
{
CategoryIndex = 0;
//GetSearch(searchTxt, category, amount, len);
}
else if (String.IsNullOrEmpty(searchTxt) && !String.IsNullOrEmpty(category))//search text empty
{
isRandom = true;
if (category == CategoryItems[0])
{
GetRandomProducts(0, 10, false);
}
else
{
CategoryIndex = CategoryItems.IndexOf(category);
}
//GetCategoryItems(category, len, amount);
}
}
private void UpdateCategoryItems()
{
var oldSelectedCategoryItem = _selectedCategoryItem;
CategoryItems.Clear();
var allCategoryItem = new Item {
ID = "-1", Name = "All"
};
CategoryItems.Add(new ItemVM {
Model = allCategoryItem
});
using (var context = new ERPContext())
{
var categoryItemsFromDatabase = _selectedCategory.Name.Equals("All")
? context.Inventory.Include("Suppliers").OrderBy(item => item.Name)
: context.Inventory.Include("Suppliers")
.Where(item => item.ItemCategory.ID.Equals(_selectedCategory.ID))
.OrderBy(item => item.Name);
foreach (var item in categoryItemsFromDatabase)
{
CategoryItems.Add(new ItemVM {
Model = item
});
}
}
UpdateSelectedCategoryItem(oldSelectedCategoryItem);
}
protected void Load_Category(int catid)
{
SqlProduct.SelectCommand = "SELECT * FROM [dbo].[vw_nthing_CatProducts] where CategoryId = " + catid;
SqlProduct.DataBind();
CategoryItems.DataSource = SqlProduct;
CategoryItems.DataBind();
}
public ActionResult Index()
{
var dataModel = new CategoryViewModel();
try
{
var categories = Db.Categories
.Where(x => !x.IsDelete && x.IsActive)
.OrderBy(x => x.CategoryId);
var list = new List <CategoryItems>();
foreach (var items in categories)
{
var data = new CategoryItems
{
DateAdded = items.DateAdded.GetValueOrDefault(),
CategoryId = items.CategoryId,
Name = items.CategoryName,
ImagePath = items.ImagePath
};
list.Add(data);
}
dataModel.Title = Globals.Category.Women_Ethnic_Wear.DisplayName();
dataModel.CategoryItems = list;
}
catch (Exception e)
{
Log.Debug(e);
}
return(View(dataModel));
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
public List <CategoryItems> GetList()
{
string sql = "select * from CategoryItems";
db.PrepareSql(sql);
DataTable dt = new DataTable();
dt = db.ExecQuery();
if (dt.Rows.Count == 0)
{
return(null);
}
List <CategoryItems> GetList = new List <CategoryItems>();
foreach (DataRow item in dt.Rows)
{
CategoryItems entity = new CategoryItems();
entity.CID = int.Parse(item["CID"].ToString());
entity.C_Category = item["C_Category"].ToString();
entity.CI_ID = int.Parse(item["CI_ID"].ToString());
entity.CI_Name = item["CI_Name"].ToString();
GetList.Add(entity);
}
return(GetList);
}
public bool Add(CategoryItems entity)
{
//拼接SQL语句
string cmd = entity.GetInsertSql();
//读取属性名
Dictionary <string, object> properties = entity.GetAllPorpertiesNameAndValues();
List <SqlParameter> ps = new List <SqlParameter>();
foreach (KeyValuePair <string, object> item in properties)
{
string paramName = "@" + item.Key;
string field = "{" + item.Key + "}";
if (cmd.Contains(field))
{
cmd = cmd.Replace(field, paramName);
//获取参数的数据类型
SqlParameter p = new SqlParameter(paramName, item.Value == null?DBNull.Value:item.Value);
ps.Add(p);
}
}
SqlCmdHelper helper = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(helper.ExcuteNoQuery(cmd, ps.ToArray()) > 0);
}
public ActionResult CreateTask(AnalyzeTaskView task)
{
if (ModelState.IsValid)
{
ToDoCreateTask toDoCreateTask = new ToDoCreateTask();
toDoCreateTask.Record(Request, ref task);
return(RedirectToAction("ToDo"));
}
else
{
PriorityItems priorityItems = new PriorityItems();
CategoryItems categoryItems = new CategoryItems();
SelectList listPriorityItems = new SelectList(priorityItems.Priorities(), "Id", "Name");
SelectList listCategoryItems = new SelectList(categoryItems.Categories(), "Id", "Name");
return(View(new AccountTask
{
Name = task.Name,
Objective = task.Objective,
EndDate = task.EndDate,
StartDate = task.StartDate,
selectCategoryItems = listCategoryItems,
selectPriorityItems = listPriorityItems
}));
}
}
IEnumerator GetJson(string url)
{
UnityWebRequest www = UnityWebRequest.Get(url);
yield return(www.SendWebRequest());
if (www.isNetworkError)
{
Debug.Log(www.error);
}
else
{
string json = www.downloadHandler.text;
Debug.Log("JSON: " + json);
categoryItems = JsonUtility.FromJson <CategoryItems>(json);
for (int i = 0; i < categoryItems.Categories.Length; i++)
{
if (categoryItems.Categories[i].augmented)
{
VideosARItem arItem = new VideosARItem(categoryItems.Categories[i].id, categoryItems.Categories[i].urlvideo, categoryItems.Categories[i].name, categoryItems.Categories[i].relatedProduct);
//GameObject.Find("Scripts").GetComponent<ApplicationController>().videosArItemList.Add(arItem);
}
}
StartCoroutine(LoadJsonProducts("http://squaar.com/ofertaya/products.json"));
}
}
public CategoryItems createCategoryItems(string categoryName)
{
CategoryItems newCat = new CategoryItems();
newCat.name = categoryName;
GroupOfItems.Add(newCat);
return(newCat);
}
private void UpdateSelectedCategoryItem(ItemVM oldSelectedCategoryItem)
{
if (oldSelectedCategoryItem == null)
{
return;
}
SelectedCategoryItem = CategoryItems.FirstOrDefault(item => item.ID.Equals(oldSelectedCategoryItem.ID));
}
public IList <CategoryItems> QueryAll()
{
List <CategoryItems> datas = new List <CategoryItems>();
CategoryItems model = new CategoryItems();
string sql = model.QueryAllDataOfSql();
return(CommonRepository.QueryModelList <CategoryItems>(sql, null, SqlConnString, 0, int.MaxValue));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
CategoryItems categoryItems = await db.CategoryItems.FindAsync(id);
db.CategoryItems.Remove(categoryItems);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public void LoadData()
{
CategoryItems = System.Threading.Tasks.Task.Run(() => GetCategoryItems()).Result;
CategoryTasks = System.Threading.Tasks.Task.Run(() => GetCategoryTasks()).Result;
ItemList = System.Threading.Tasks.Task.Run(() => GetItems()).Result;
ItemList = new ObservableCollection <Item>(ItemList.Where(e => !CategoryItems.Contains(e)).ToList());
TaskList = System.Threading.Tasks.Task.Run(() => GetTasks()).Result;
TaskList = new ObservableCollection <Model.Task>(TaskList.Where(e => !CategoryTasks.Contains(e)).ToList());
}
public ActionResult TaskCategory()
{
CategoryItems categoryItems = new CategoryItems();
SelectList listItems = new SelectList(categoryItems.Categories(), "Id", "Name");
return(PartialView("_TasksCategory", new AccountTask {
selectCategoryItems = listItems
}));
}
/// <summary>
/// 添加
/// </summary>
/// <returns></returns>
public int Add(CategoryItems entity)
{
string sql = "insert into CategoryItems(C_Category,CI_ID,CI_Name)values(@C_Category,@CI_ID,@CI_Name)";
db.PrepareSql(sql);
db.SetParameter("C_Category", entity.C_Category);
db.SetParameter("CI_ID", entity.CI_ID);
db.SetParameter("CI_Name", entity.CI_Name);
return(db.ExecNonQuery());
}
public bool Edit(CategoryItems entity)
{
string sql = entity.GetUpdateSql();
SqlCmdHelper helper = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(helper.GenerateNoQuerySqlAndExcute(sql, entity) > 0);
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public int Update(CategoryItems entity)
{
string sql = "update CategoryItems set C_Category=@C_Category,CI_ID=@CI_ID,CI_Name=@CI_Name where CID=@CID";
db.PrepareSql(sql);
db.SetParameter("CID", entity.CID);
db.SetParameter("C_Category", entity.C_Category);
db.SetParameter("CI_ID", entity.CI_ID);
db.SetParameter("CI_Name", entity.CI_Name);
return(db.ExecNonQuery());
}
public void SetCategoryItems(IEnumerable <Category> categories)
{
foreach (var c in categories)
{
CategoryItems.Add(new SelectListItem()
{
Value = c.CategoryId.ToString(),
Text = c.Description
});
}
}
public void SetCategories(List <Category> category)
{
category = category.OrderBy(c => c.CategoryName).ToList();
foreach (var c in category)
{
CategoryItems.Add(new SelectListItem()
{
Value = c.CategoryId.ToString(),
Text = c.CategoryName
});
}
}
private async void GetCategoryItems()
{
var Categories = await conn_api.GetBlogCategories();
CategoryItems.Add(new CategoriesForBlog {
Id = 0, Name = "Reset"
});
foreach (var item in Categories)
{
CategoryItems.Add(item);
}
}
public async Task <ActionResult> Edit([Bind(Include = "CategoryItemID,CategoryID,CategoryItemName,CategoryItemPhoto")] CategoryItems categoryItems)
{
if (ModelState.IsValid)
{
db.Entry(categoryItems).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", categoryItems.CategoryID);
return(View(categoryItems));
}
public async Task <IActionResult> UpdateCategories([FromBody] CategoryItems category)
{
_logger.LogInformation($"CategoryController ->");
var categories = await _services.UpdateCategories(category);
if (categories == null)
{
_logger.LogInformation("Category Not Updated");
return(NotFound());
}
return(Ok(categories));
}
public List <CategoryItems> QueryNodesByIndex(string keySpell)
{
CategoryItems item = new CategoryItems()
{
IndexSpell = "%" + keySpell + "%"
};
DataSet ds = new SqlCmdHelper()
{
SqlConnString = SqlConnString
}.GenerateQuerySqlAndExcute(item.GetQueryByIndexSpell(), item);
return(DataHelp.DataReflection.DataSetConvert <CategoryItems>(ds));
}
public int ValideExists(string key)
{
string sql = CategoryItems.BuilderValideSql();
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "@code", Value = key
}
};
return(CommonRepository.ExecuteCount(sql, param, SqlConnString));
}
internal async void RemoveItem(Item item)
{
//Add item to ItemList, remove item from CategoryItem and remove item from Category.Item on the backend
var result = await Client.HttpClient.DeleteAsync("http://localhost:65177/api/Category/" + Category.Id.ToString() + "/Item/" + item.Id.ToString());
if (result.IsSuccessStatusCode)
{
ItemList.Add((Item)item);
CategoryItems.Remove((Item)item);
}
}
public bool ChangeSpell(int id, string spell)
{
CategoryItems item = new CategoryItems()
{
Id = id, IndexSpell = spell
};
string sql = item.GetChangeSpellWord();
SqlCmdHelper helper = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(helper.GenerateNoQuerySqlAndExcute(sql, item) > 0);
}
// GET: CategoryItems/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CategoryItems categoryItems = await db.CategoryItems.FindAsync(id);
if (categoryItems == null)
{
return(HttpNotFound());
}
return(View(categoryItems));
}
public List <CategoryItems> GetNodeListByParent(string parentNodeCode)
{
List <CategoryItems> datas = new List <CategoryItems>();
CategoryItems model = new CategoryItems();
string sql = model.BuilderSqlParam();
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "@code", Value = parentNodeCode
}
};
return(CommonRepository.QueryModelList <CategoryItems>(sql, param, SqlConnString, 0, int.MaxValue));
}
