public async Task <MaterialCategory> Update(MaterialCategory elem)
{
_dbContext.MaterialCategorys.Update(elem);
await _dbContext.SaveChangesAsync();
return(Get(elem.Id));
}
public MaterialCategory Get(String MaterialCategoryCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MatCategory", MaterialCategoryCode)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MaterialCategoryByID", paramList);
MaterialCategory objMatCat = new MaterialCategory();
for (int i = 0; i < dt.Rows.Count; i++)
{
objMatCat.MatCatID = Convert.ToString(dt.Rows[0]["MatCatID"]);
objMatCat.MaterialCategoryName = Convert.ToString(dt.Rows[0]["MaterialCategory"]);
}
return(objMatCat);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public void UpdateInformation()
{
materialList = QuerryMaterials.GetAllMaterial();
dgrListMaterial.ItemsSource = materialList;
searchState = MaterialCategory.All;
GeneralLayout();
}
public async Task <IActionResult> Edit([FromRoute] Guid Id, [FromBody] MaterialCategory obj)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Id != obj.Id)
{
return(BadRequest());
}
_context.Entry(obj).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Exists(Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult Edit(MaterialCategory article)
{
var old = _material.Get(article.MaterialCategoryId);
old.MaterialName = article.MaterialName;
_material.Update(old);
return(JumpUrl("List", "系统设置-材料类别-编辑成功！"));
}
public ActionResult DeleteConfirmed(int id)
{
MaterialCategory materialcategory = db.MaterialCategories.Find(id);
db.MaterialCategories.Remove(materialcategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private IList <Material> GetMaterialsByCategory(MaterialCategory category)
{
var materialsByCategory = from material in materialsStore
where material.MaterialCategory == category
select material;
return(materialsByCategory.ToList());
}
public MaterialCategoryDto MaterialCategorytoDto(MaterialCategory mCatDal)
{
return(new MaterialCategoryDto()
{
Id = mCatDal.Id,
Name = mCatDal.Name,
});
}
/// <summary>
/// Get Materials List By Locations
/// </summary>
/// <param name="Location"></param>
/// <returns></returns>
//public List<Material> GetMaterialsBylocation(Location Location)
//{
// var query = from m in db.Materials
// where m.Location.Id == Location.Id
// select m;
// return query.ToList<Material>();
//}
/// <summary>
/// Get Materials List By Material Category
/// </summary>
/// <param name="MaterialCategory"></param>
/// <returns></returns>
public List <Material> GetMaterialsByMaterialCategory(MaterialCategory MaterialCategory)
{
var query = from m in db.Materials
where m.Materialcategory.Id == MaterialCategory.Id
select m;
return(query.ToList <Material>());
}
//
// GET: /MaterialCategory/Edit/5
public ActionResult Edit(int id)
{
MaterialCategory materialcategory = db.MaterialCategories.Find(id);
ViewBag.ParentMaterialCategoryID = new SelectList(db.MaterialCategories, "MaterialCategoryID", "Description", materialcategory.ParentMaterialCategoryID);
ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", materialcategory.ValidationStateID);
return(View(materialcategory));
}
public async Task Remove(int id)
{
MaterialCategory ev = Get(id);
if (ev != null)
{
_dbContext.MaterialCategorys.Remove(ev);
await _dbContext.SaveChangesAsync();
}
}
public JsonResult GetDetailEdit(int id)
{
MaterialCategory materialCategory = materialCategoryService.GetSingleByID(id);
return(Json(new
{
materialCategory = materialCategory,
status = true
}, JsonRequestBehavior.AllowGet));
}
public void UpdateMaterialCategory(MaterialCategoryDto mCat)
{
MaterialCategory Ezer = db.MaterialCategorys.FirstOrDefault(x => x.Id == mCat.Id);
if (Ezer != null)
{
Ezer.Name = mCat.Name;
db.SaveChanges();
}
}
public async Task <IActionResult> CreateMaterialCategory([FromBody] MaterialCategory category)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.MaterialCategories.Add(category);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMaterialCategory", new { id = category.Id }, category));
}
public async Task <IActionResult> Add([FromBody] MaterialCategory obj)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.MaterialCategories.Add(obj);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetById", new { Id = obj.Id }, obj));
}
public async Task <MaterialCategory> Create(MaterialCategory elem)
{
if (elem == null)
{
throw new ArgumentNullException("Element on create cannot be null!");
}
_dbContext.MaterialCategorys.Add(elem);
await _dbContext.SaveChangesAsync();
return(elem);
}
public ActionResult Edit(MaterialCategory materialcategory)
{
if (ModelState.IsValid)
{
db.Entry(materialcategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ParentMaterialCategoryID = new SelectList(db.MaterialCategories, "MaterialCategoryID", "Description", materialcategory.ParentMaterialCategoryID);
ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", materialcategory.ValidationStateID);
return(View(materialcategory));
}
public ActionResult Add(string materialName)
{
if (string.IsNullOrEmpty(materialName))
{
return(JumpUrl("List", "材料类别不能为空!"));
}
var mn = new MaterialCategory();
mn.MaterialName = materialName;
_material.Add(mn);
return(JumpUrl("List", "系统设置-材料类别-创建成功！"));
}
public List <MaterialDto> GetMaterialsByCategoryName(string name)
{
MaterialCategory mCat = db.MaterialCategorys.FirstOrDefault(x => x.Name.Equals(name));
List <MaterialDto> MaterialL = new List <MaterialDto>();
db.Materials.ToList().ForEach(x =>
{
if (x.MaterialCategoryId == mCat.Id)
{
MaterialL.Add(MaterialToDto(x));
}
});
return(MaterialL);
}
public async Task<IActionResult> OnGetAsync(int? id)
{
if (id == null)
{
return NotFound();
}
MaterialCategory = await _context.MaterialCategories.FirstOrDefaultAsync(m => m.Id == id);
if (MaterialCategory == null)
{
return NotFound();
}
return Page();
}
public int Add(MaterialCategory obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MatCatID", obj.MatCatID),
new SqlParameter("@MaterialCategory", obj.MaterialCategoryName)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_MaterialCategory", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
MaterialCategory = await _context.MaterialCategories.FindAsync(id);
if (MaterialCategory != null)
{
_context.MaterialCategories.Remove(MaterialCategory);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
private void gvCategory_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
try
{
SelectedCode = gvCategory.Rows[e.RowIndex].Cells["colCode"].Value.ToString();
MaterialCategory obj = objMatCatDL.Get(SelectedCode);
txtCategoryName.Text = obj.MaterialCategoryName;
txtID.Text = obj.MatCatID;
IsSelect = true;
btnDelete.Enabled = true;
}
catch (Exception ex)
{
}
}
}
public int Update(MaterialCategory obj, String OriginalCatID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MatCatID", obj.MatCatID),
new SqlParameter("@MaterialCategory", obj.MaterialCategoryName),
new SqlParameter("@Original_MatCatID", OriginalCatID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MaterialCategory", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
//Action được ajax gọi khi click submid trên popup
public JsonResult SubmitForm(string strMaterial)
{
//Lấy material được truyền qua
JavaScriptSerializer serializer = new JavaScriptSerializer();
MaterialCategory materialCategory = serializer.Deserialize <MaterialCategory>(strMaterial);
bool status = false;
string message = string.Empty;
bool action;
//action là thêm khi có id = 0
if (materialCategory.ID == 0)
{
//material.CreatedDate = DateTime.Now;
materialCategory.IsDelete = false;
materialCategoryService.Add(materialCategory);
action = true;
}
else //action là sửa khi có id cụ thể
{
materialCategory.IsDelete = false;
materialCategoryService.Update(materialCategory);
action = false;
}
//update xuống database
try
{
materialCategoryService.Save();
status = true;
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
return(Json(new
{
status = status,
message = message,
action = action
}));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtID.Text.Equals(""))
{
MessageBox.Show(this, "Please enter Category Code", "Empty Fields", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
MaterialCategory obj = new MaterialCategory();
obj.MatCatID = txtID.Text;
obj.MaterialCategoryName = txtCategoryName.Text;
int res = objMatCatDL.Add(obj);
if (res > 0)
{
gvCategory.DataSource = objMatCatDL.GetDataView();
ClearForm();
}
}
catch (SqlException sqlex)
{
if (sqlex.Number == 2627)
{
MessageBox.Show(this, "Category code already in the database, Please enter another one", "Duplicate Data", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show(this, "Database Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Error occured while saving", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
public MaterialCategoryCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MaterialCategory");
MaterialCategoryCollec obj = new MaterialCategoryCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
MaterialCategory objMatCat = new MaterialCategory();
objMatCat.MatCatID = Convert.ToString(dt.Rows[0]["MatCatID"]);
objMatCat.MaterialCategoryName = Convert.ToString(dt.Rows[0]["MaterialCategory"]);
obj.Add(objMatCat);
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public static List<Material> SearchMaterialByCategory(List<Material> list, MaterialCategory category)
{
switch (category)
{
case MaterialCategory.DVD:
return GetDVDList(list);
case MaterialCategory.AudioBook:
return GetAudioBookList(list);
case MaterialCategory.BoardGame:
return GetBoardGameList(list);
case MaterialCategory.Dictionary:
return GetDictionaryList(list);
case MaterialCategory.Magazine:
return GetMagazineList(list);
case MaterialCategory.LectureBook:
return GetReadingBookList(list);
case MaterialCategory.LearningBook:
return GetLearningBookList(list);
case MaterialCategory.Movie:
return GetMovieList(list);
default:
return null;
}
}
/// <summary>
/// Name constructor
/// </summary>
/// <param name="name"></param>
public IsoMaterial(string name, MaterialCategory category = MaterialCategory.Undefined) : base(name, category)
{
}
static MaterialID GetRandomMaterial(MaterialCategory category)
{
var materials = Materials.GetMaterials(category).Select(mi => mi.ID).ToArray();
return materials[Helpers.GetRandomInt(materials.Length)];
}
public static IEnumerable<MaterialInfo> GetMaterials(MaterialCategory materialClass)
{
return s_materials.Where(m => m != null && m.Category == materialClass);
}
private void UpdatePaintMaterialsBrowser(float width)
{
var removeCategory = default(string);
foreach (var materialCategory in materialCategories.Values)
{
materialCategory.PaintMaterials.Clear();
}
for (var i = P3dPaintMaterial.CachedInstances.Count - 1; i >= 0; i--)
{
var paintMaterial = P3dPaintMaterial.CachedInstances[i];
if (paintMaterial != null)
{
var category = paintMaterial.Category ?? "";
var materialCategory = default(MaterialCategory);
if (materialCategories.TryGetValue(category, out materialCategory) == false)
{
materialCategory = new MaterialCategory();
materialCategories.Add(category, materialCategory);
}
materialCategory.PaintMaterials.Add(paintMaterial);
}
else
{
P3dPaintMaterial.CachedInstances.RemoveAt(i);
}
}
foreach (var pair in materialCategories)
{
var category = pair.Key;
var materialCategory = pair.Value;
if (materialCategory.PaintMaterials.Count > 0)
{
materialCategory.Expand = EditorGUILayout.Foldout(materialCategory.Expand, category);
if (materialCategory.Expand == true)
{
materialCategory.PaintMaterials.Sort(MaterialCategory.Compare);
DrawMaterials(materialCategory.PaintMaterials, width);
}
}
else
{
removeCategory = category;
}
}
if (removeCategory != null)
{
materialCategories.Remove(removeCategory);
}
if (currentPaintMaterial == null)
{
EditorGUILayout.HelpBox("You must select a paint material before you can paint.", MessageType.Info);
}
}
public ItemFilter(ItemID itemID, MaterialCategory materialCategory)
{
m_itemIDMask = new EnumBitMask<ItemID>(itemID);
m_itemCategoryMask = new EnumBitMask32<ItemCategory>();
m_materialIDMask = new EnumBitMask64<MaterialID>();
m_materialCategoryMask = new EnumBitMask32<MaterialCategory>(materialCategory);
}
public bool Match(ItemID itemID, ItemCategory itemCategory, MaterialID materialID, MaterialCategory materialCategory)
{
return m_itemIDMask.Get(itemID) &&
m_itemCategoryMask.Get(itemCategory) &&
m_materialIDMask.Get(materialID) &&
m_materialCategoryMask.Get(materialCategory);
}
public bool Match(ItemID itemID, ItemCategory itemCategory, MaterialID materialID, MaterialCategory materialCategory)
{
return (m_itemIDMask == null || m_itemIDMask.Get(itemID)) &&
(m_itemCategoryMask == null || m_itemCategoryMask.Get(itemCategory)) &&
(m_materialIDMask == null || m_materialIDMask.Get(materialID)) &&
(m_materialCategoryMask == null || m_materialCategoryMask.Get(materialCategory));
}
public async Task<MaterialCategory> AddAsync(MaterialCategory entity)
{
var addedEntity = await _context.MaterialCategories.AddAsync(entity);
return addedEntity.Entity;
}
private static void UpdateNewsCategory()
{
Console.WriteLine("Start UpdateNewsCategory");
using (FileStream fs = new FileStream(Path + "nw_nw.txt", FileMode.Open))
{
byte[] data = new byte[fs.Length];
fs.Read(data, 0, Convert.ToInt32(fs.Length));
char[] chars = Encoding.UTF8.GetString(data).ToCharArray();
var limit = chars.Length;
if (UseLimit && MaxChars < chars.Length)
{
limit = MaxChars;
}
for (int i = 0; i < limit; i++)
{
MaterialCategory newsCategory = new MaterialCategory()
{
MaterialType = MaterialType.News
};
// id
string id = string.Empty;
while (chars[i] != '|')
{
id += chars[i];
i++;
}
i++;
newsCategory.OldId = int.Parse(id);
// position
string position = string.Empty;
while (chars[i] != '|')
{
position += chars[i];
i++;
}
i++;
// newsCategory.Position = int.Parse(position);
// count
string count = string.Empty;
while (chars[i] != '|')
{
count += chars[i];
i++;
}
i++;
// newsCategory.ItemsCount = int.Parse(count);
// name
while (chars[i] != '|')
{
newsCategory.Name += chars[i];
i++;
}
i++;
// url
var urlPath = "";
if (chars[i] == '|')
{
i++;
while (chars[i] != '|')
{
urlPath += chars[i];
i++;
}
i++;
}
MaterialCategoryRepository.AddAsync(newsCategory);
}
}
}
public ItemFilter(ItemID itemID, MaterialCategory materialCategory)
{
m_itemIDMask = new ItemIDMask(itemID);
m_materialCategoryMask = new MaterialCategoryMask(materialCategory);
}
public Task DeleteAsync(MaterialCategory entity)
{
_context.MaterialCategories.Remove(entity);
return Task.CompletedTask;
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
MaterialCategory = e.Parameter as MaterialCategory;
base.OnNavigatedTo(e);
}
public SearchEventArgs(MaterialCategory _materialType, Material _actualMaterial)
{
this._materialType = _materialType;
this._actualMaterial = _actualMaterial;
}
public static void Name_is_not_empty(MaterialCategory actual) => Assert.NotEmpty(actual.Name);
private void cboMaterialType_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
switch ((int)cboMaterialType.SelectedValue)
{
case 1:
materialType = MaterialCategory.DVD;
break;
case 2:
materialType = MaterialCategory.LectureBook;
break;
case 3:
materialType = MaterialCategory.LearningBook;
break;
case 4:
materialType = MaterialCategory.Dictionary;
break;
case 5:
materialType = MaterialCategory.Magazine;
break;
case 6:
materialType = MaterialCategory.AudioBook;
break;
case 7:
materialType = MaterialCategory.Movie;
break;
case 8:
materialType = MaterialCategory.BoardGame;
break;
}
UpdateComponentsLayout();
}
public void Update(MaterialCategory entity)
{
_context.MaterialCategories.Attach(entity);
_context.Entry(entity).State = EntityState.Modified;
}
private void cboTypeMaterial_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
switch ((int)cboTypeMaterial.SelectedValue)
{
case -1:
searchState = MaterialCategory.All;
break;
case 1:
searchState = MaterialCategory.DVD;
break;
case 2:
searchState = MaterialCategory.LectureBook;
break;
case 3:
searchState = MaterialCategory.LearningBook;
break;
case 4:
searchState = MaterialCategory.Dictionary;
break;
case 5:
searchState = MaterialCategory.Magazine;
break;
case 6:
searchState = MaterialCategory.AudioBook;
break;
case 7:
searchState = MaterialCategory.Movie;
break;
case 8:
searchState = MaterialCategory.BoardGame;
break;
}
ConfigureLayout();
SetComboBoxInitialValue();
SetCategoryData();
SetDataGridActualValue();
}
