public override CommonResponse <CategoryVM> SaveData(CategoryVM data, string transactionId) { CommonResponse <CategoryVM> response = ValidateParameter(data); if (response != null) { return(response); } string lastId = DbContext.Categories.Select(u => u.Id).OrderByDescending(u => u).FirstOrDefault(); Category categoryData = new Category { Id = CreateNewCategoryId(lastId), Name = data?.Name, }; DbContext.Add(categoryData); CategoryHistory categoryDataHistory = new CategoryHistory(); categoryDataHistory.FillFromCategory( categoryData, transactionId, 1, TableTransactionOperation.Insert ); DbContext.Add(categoryDataHistory); if (DbContext.SaveChanges() > 0) { data.Id = categoryData.Id; return(new CommonResponse <CategoryVM> { Status = true, Code = "S", Message = "Save Data is Success!", Data = new CategoryVM[] { data }, }); } else { return(new CommonResponse <CategoryVM> { Status = false, Code = "E-003", Message = "Save Data Failed! Please Contact an Web Administrator!", Data = new CategoryVM[] { data }, }); } }
public string InsertCategoryHistory(CategoryHistory ch) { try { db.CategoryHistories.Add(ch); db.SaveChanges(); return(""); } catch (Exception ex) { return(ex.ToString()); } }
public ActionResult Edit(int id, CategoryHistory collection) { try { // TODO: Add update logic here dao.UpdateCategoryHistory(id, collection); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(CategoryHistory collection) { try { // TODO: Add insert logic here dao.InsertCategoryHistory(collection); return(RedirectToAction("Index")); } catch { return(View()); } }
public string DeleteCategoryHistory(int ID, CategoryHistory ch) { try { ch = db.CategoryHistories.Find(ID); db.CategoryHistories.Remove(ch); db.SaveChanges(); return(""); } catch (Exception ex) { return(ex.ToString()); } }
public string UpdateCategoryHistory(int ID, CategoryHistory ch) { try { var res = db.CategoryHistories.Find(ID); res.Name = ch.Name; db.SaveChanges(); return(""); } catch (Exception ex) { return(ex.ToString()); } }
public ActionResult Delete(int id, CategoryHistory collection) { try { // TODO: Add delete logic here var res = dao.DeleteCategoryHistory(id, collection); if (res == "") { return(RedirectToAction("Index")); } else { return(View()); } } catch { return(View()); } }
public IList <CategoryHistoryData> GetAllHistory(int id) { return(CategoryHistory.ToJavaScriptCategoryHistory(_eventStoreRepository.All(id))); }
public override CommonResponse <CategoryVM> DeleteData(CategoryVM data, string transactionId) { IQueryable <Category> lastDataContext = DbContext.Categories.AsQueryable(); if (string.IsNullOrEmpty(data?.Id)) { return(new CommonResponse <CategoryVM> { Status = false, Code = "E-001", Message = "Please fill the ID!", Data = new CategoryVM[] { data }, }); } lastDataContext = lastDataContext.Where(u => u.Id.Equals(data.Id) ); Category lastData = lastDataContext.FirstOrDefault(); if (lastData == null) { return(new CommonResponse <CategoryVM> { Status = false, Code = "E-002", Message = string.Format("Data not found for ID {0}, please fill the right ID!", data?.Id), Data = new CategoryVM[] { data }, }); } int historySequence = lastData?.CategoryHistories? .Select(u => u.Seq) .OrderByDescending(u => u) .FirstOrDefault() ?? 0; lastData.IsDeleted = true; CategoryHistory categoryDataHistory = new CategoryHistory(); categoryDataHistory.FillFromCategory( lastData, transactionId, historySequence + 1, TableTransactionOperation.Delete ); DbContext.Add(categoryDataHistory); if (DbContext.SaveChanges() > 0) { return(new CommonResponse <CategoryVM> { Status = true, Code = "S", Message = "Delete Data is Success!", Data = new CategoryVM[] { data }, }); } else { return(new CommonResponse <CategoryVM> { Status = false, Code = "E-003", Message = "Delete Data Failed! Please Contact an Web Administrator!", Data = new CategoryVM[] { data }, }); } }