public async Task <ActionResult <Cataloges> > PostCataloges(Cataloges cataloges) { var user = HttpContext.Session.GetObjectFromJson <Users>("user"); _catalogesRepository.CreateCataloges(cataloges); return(NoContent()); }
public ActionResult DeleteConfirm(int id) { Cataloges clauses = session.Query <Cataloges>().Where(c => c.Id == id).FirstOrDefault(); CascadeDelete(clauses); session.Delete(clauses); session.FlushAsync(); if (clauses.Children.Count > 0) { session.Delete(clauses.Children.Last()); session.FlushAsync(); } try { if (clauses.Clauses.Count > 0) { session.Delete(clauses.Clauses.Last()); session.FlushAsync(); } } catch { } return(PartialView("~/Views/Clauses/ClausesShow.cshtml")); }
public CatalogesItems(Cataloges cataloge) { this.cataloge = cataloge; var childrenCataloges = cataloge.Children.Select(ch => new CatalogesItems(ch) as IMenyItem).ToList(); var childrenClauses = cataloge.Clauses.Select(ch => new ClausesItems(ch) as IMenyItem).ToList(); children = childrenClauses.Concat(childrenCataloges).ToList(); }
void Start() { Catalog = new Cataloges(); TableOfTiles = new Tile[AreaSize, AreaSize]; GenerateTiles(); GenerateBoxesAndCrosses(); GeneratePlayer(); GenerateWalls(); }
public PartialViewResult CreateConfirm([Bind(Include = "Id,Name")] Cataloges cataloges, string idParent) { if (ModelState.IsValid) { cataloges.Parent = session.Query <Cataloges>().Where(c => c.Id == int.Parse(idParent)).FirstOrDefault(); session.Save(cataloges); } return(PartialView("~/Views/Clauses/ClausesShow.cshtml")); }
public async Task <IActionResult> PutCataloges(int id, Cataloges cataloges) { if (id != cataloges.id) { return(BadRequest()); } var user = HttpContext.Session.GetObjectFromJson <Users>("user"); _catalogesRepository.UpdateCataloges(id, cataloges); return(NoContent()); }
public IActionResult PostCataloge(Cataloges cataloges) { result = _catalogesRepository.AddCataloges(cataloges); if (result != null && result.ms == "found") { return(Content("{\"message\":\"Danh mục này đã có, hãy nhập tên khác\"}")); } else { return(NoContent()); } }
public dynamic AddCataloges(Cataloges cataloges) { sql = "AddCataloges"; var query = SQLUtils.ExecuteCommand(SQLUtils._connStr, conn => conn.Query(sql, new { cataloges.name, cataloges.created_by }, commandType: CommandType.StoredProcedure)).FirstOrDefault(); return(query); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Cataloges clauses = session.Query <Cataloges>().Where(c => c.Id == id).FirstOrDefault(); if (clauses == null) { return(HttpNotFound()); } return(View(clauses)); }
public ActionResult EditConfirm([Bind(Include = "Id,Name")] Cataloges cataloges, string idParent) { if (ModelState.IsValid) { if (idParent != null && int.Parse(idParent) != -1) { cataloges.Parent = session.Query <Cataloges>().Where(c => c.Id == int.Parse(idParent)).FirstOrDefault(); } session.Update(cataloges, cataloges.Id); session.Flush(); } return(PartialView("~/Views/Clauses/ClausesShow.cshtml")); }
public dynamic EditCataloges(int id, Cataloges cataloges) { sql = "EditCataloges"; var query = SQLUtils.ExecuteCommand(SQLUtils._connStr, conn => conn.Query(sql, new { cataloges.name, cataloges.updated_by, id }, commandType: CommandType.StoredProcedure)).FirstOrDefault(); return(query); }
public void UpdateCataloges(int id, Cataloges Cataloges) { update_Cataloges = "UPDATE [Cataloges] SET [name] = @name, [permalink] = @permalink,[updated_at] = GETDATE(), " + "[updated_by] = @updated_by WHERE [id] = @id AND [isDeleted] = 0"; SQLUtils.ExecuteCommand(SQLUtils._connStr, conn => { var query = conn.Query <Cataloges>(update_Cataloges, new { Cataloges.name, Cataloges.permalink, Cataloges.updated_by, id }); }); }
public void CreateCataloges(Cataloges Cataloges) { create_Cataloges = "INSERT INTO [Cataloges] ([name], [permalink], [isDeleted], " + "[created_at], [created_by]) " + "VALUES(@name, @permalink, 0, GETDATE(), @created_by)"; SQLUtils.ExecuteCommand(SQLUtils._connStr, conn => { var query = conn.Query <Cataloges>(create_Cataloges, new { Cataloges.name, Cataloges.permalink, Cataloges.created_by }); }); }
public IActionResult PutCataloge(int id, Cataloges cataloges) { if (id != cataloges.id) { return(BadRequest()); } result = _catalogesRepository.EditCataloges(id, cataloges); if (result != null && result.ms == "found") { return(Content("{\"message\":\"Danh mục này đã có, hãy nhập tên khác\"}")); } else { return(NoContent()); } }
public async Task <ActionResult <Cataloges> > PostCataloge() { var cataloge = new Cataloges(); cataloge.name = HttpContext.Request.Form["name"]; cataloge.permalink = HttpContext.Request.Form["permalink"]; cataloge.ShopsId = int.Parse(HttpContext.Request.Form["shopId"]); _context.Cataloges.Add(cataloge); await _context.SaveChangesAsync(); var catalogeImg = _context.Cataloges.Find(cataloge.id); catalogeImg.created_by = "Đan"; _context.Entry(catalogeImg).State = EntityState.Modified; await _context.SaveChangesAsync(); return(CreatedAtAction("GetCity", new { id = cataloge.id }, new { cataloge.id })); }
private void CascadeDelete(Cataloges cat) { cat.Clauses.DefaultIfEmpty(); cat.Children.DefaultIfEmpty(); foreach (var child in cat.Children) { CascadeDelete(child); session.Delete(child); session.FlushAsync(); } try{ foreach (var child in cat.Clauses) { session.Delete(child); session.FlushAsync(); } } catch { } }