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
{
}
}
