protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Id = int.Parse(Request["Id"]);
catParent = CatalogsManager.CreateInstant().SelectOne(Id);
if (catParent != null)
{
ParentId = catParent.ParentId;
IsLeaf = catParent.IsLeaf;
if (Request["t"] == "prev")
{
LoadData(catParent.ParentId);
}
else
{
LoadData(Id);
}
}
string html = Library.Tools.Util.RenderControl((Control)cats);
Response.Write(html);
Response.End();
}
}
public async Task <CatalogsEntity> CreateCatalogAsync(CatalogsEntity catalog)
{
var result = Mapping.Mapper.Map <Catalogs>(catalog);
await _context.AddAsync(result);
await _context.SaveChangesAsync();
return(Mapping.Mapper.Map <CatalogsEntity>(result));
}
public async Task <CatalogsEntity> EditCatalogAsync(int catalogId, CatalogsEntity catalog)
{
var oldmodel = await _context.Catalogs
.FirstOrDefaultAsync(e => e.CatalogId == catalogId);
var result = Mapping.Mapper.Map(catalog, oldmodel);
await _context.SaveChangesAsync();
return(Mapping.Mapper.Map <CatalogsEntity>(result));
}
void LoadData()
{
catParent = CatalogsManager.CreateInstant().SelectOne(Id);
if (catParent != null)
{
ParentId = catParent.ParentId;
IsLeaf = catParent.IsLeaf;
}
EntityCollection<CatalogsEntity> cats = CatalogsManager.CreateInstant().GetByParentId(Id, null);
repCatalog.DataSource = cats;
repCatalog.DataBind();
}
public async Task <IActionResult> CreateCatalogAsync(CatalogsEntity catalog)
{
if (!_catalogService.CheckIfCatalogExit(catalog))
{
var model = await _catalogService.CreateCatalogAsync(catalog);
var location = _linkGanarator.GetPathByAction("GetCatalogByIdAsync", "Catalogs", new { id = model.CatalogId });
return(Created(location, model));
}
else
{
return(BadRequest("catalog has already been created"));
}
}
public bool Delete(int Id)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
CatalogsEntity _CatalogsEntity = new CatalogsEntity(Id);
if (adapter.FetchEntity(_CatalogsEntity))
{
adapter.DeleteEntity(_CatalogsEntity);
toReturn = true;
}
}
return toReturn;
}
protected void Page_Load(object sender, EventArgs e)
{
_cat = new CatalogsEntity();
if (catId == 0)
trHeader.Visible = false;
else
{
_cat = CatalogsManager.CreateInstant().SelectOne(catId);
if (_cat == null)
{
trHeader.Visible = false;
}
else
{
lkAdd.CommandArgument = _cat.Id.ToString();
}
}
if (!IsPostBack)
{
//LoadCombo();
LoadData();
DataTable table = GetCatList();
repListCat.DataSource = table;
repListCat.DataBind();
}
}
public async Task <ActionResult <CatalogsEntity> > EditCatalogAsync(int catalogId, CatalogsEntity catalog)
{
if (!_catalogService.CheckIfCatalogExit(catalog))
{
var model = await _catalogService.EditCatalogAsync(catalogId, catalog);
//var result = _mapper.Map<CatalogsEntity>(catalogs);
var location = _linkGanarator.GetPathByAction("GetCatalogByIdAsync", "Catalogs", new { id = model.CatalogId });
return(model);
}
else
{
return(BadRequest("catalog has already been created"));
}
}
public bool Update(CatalogsEntity _CatalogsEntity)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(CatalogsFields.Id == _CatalogsEntity.Id);
filter.PredicateExpression.Add(_PredicateExpression);
adapter.UpdateEntitiesDirectly(_CatalogsEntity, filter);
toReturn = true;
}
return toReturn;
}
public bool CheckIfCatalogExit(CatalogsEntity catalog)
{
return(_context.Catalogs.FirstOrDefault(e => e.Name == catalog.Name) != null ? true : false);
}
void ItemCommand(object CommandArgument, string CommandName)
{
if (string.IsNullOrEmpty(CommandArgument.ToString()) || string.IsNullOrEmpty(CommandName))
return;
int Id = int.Parse(CommandArgument.ToString());
CatalogsEntity cat = new CatalogsEntity();
switch (CommandName)
{
case "selectfirst":
cat = CatalogsManager.CreateInstant().SelectOne(Id);
if (cat != null)
{
lblCatName.Text = cat.CatCode + " - " + cat.CatalogName;
hidCatId.Value = Id.ToString();
txt.Text = cat.Id.ToString();
catId = Id;
LoadHeader(Id);
GetCatList();
hidIsDirty.Value = "true";
}
break;
case "select":
cat = CatalogsManager.CreateInstant().SelectOne(Id);
if (cat != null)
{
lblCatName.Text = cat.CatCode + " - " + cat.CatalogName;
hidCatId.Value = Id.ToString();
txt.Text = cat.Id.ToString();
catId = Id;
LoadHeader(cat.ParentId);
GetCatList();
hidIsDirty.Value = "true";
}
break;
case "prev":
//hidCatId.Value = "";
catId = Id;
LoadData();
break;
case "next":
//hidCatId.Value = "";
catId = Id;
LoadData();
break;
}
}
public CatalogsEntity Insert(string CatalogName, string CatCode, string TextId, string ToolTip, int ParentId, bool IsLeaf, int ProductAmount, bool IsVisible, bool IsVisibleHome, int OrderIndex)
{
CatalogsEntity _CatalogsEntity = new CatalogsEntity();
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
_CatalogsEntity.CatalogName = CatalogName;
_CatalogsEntity.CatCode = CatCode;
_CatalogsEntity.TextId = TextId;
_CatalogsEntity.ToolTip = ToolTip;
_CatalogsEntity.ParentId = ParentId;
_CatalogsEntity.IsLeaf = IsLeaf;
_CatalogsEntity.ProductAmount = ProductAmount;
_CatalogsEntity.IsVisible = IsVisible;
_CatalogsEntity.IsVisibleHome = IsVisibleHome;
_CatalogsEntity.OrderIndex = OrderIndex;
adapter.SaveEntity(_CatalogsEntity, true);
}
return _CatalogsEntity;
}
public CatalogsEntity Insert(CatalogsEntity _CatalogsEntity)
{
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
adapter.SaveEntity(_CatalogsEntity, true);
}
return _CatalogsEntity;
}
public bool Update(int Id, string CatalogName, string CatCode, string TextId, string ToolTip, int ParentId, bool IsLeaf, int ProductAmount, bool IsVisible, bool IsVisibleHome, int OrderIndex)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
CatalogsEntity _CatalogsEntity = new CatalogsEntity(Id);
if (adapter.FetchEntity(_CatalogsEntity))
{
_CatalogsEntity.CatalogName = CatalogName;
_CatalogsEntity.CatCode = CatCode;
_CatalogsEntity.TextId = TextId;
_CatalogsEntity.ToolTip = ToolTip;
_CatalogsEntity.ParentId = ParentId;
_CatalogsEntity.IsLeaf = IsLeaf;
_CatalogsEntity.ProductAmount = ProductAmount;
_CatalogsEntity.IsVisible = IsVisible;
_CatalogsEntity.IsVisibleHome = IsVisibleHome;
_CatalogsEntity.OrderIndex = OrderIndex;
adapter.SaveEntity(_CatalogsEntity, true);
toReturn = true;
}
}
return toReturn;
}
public bool Update(CatalogsEntity _CatalogsEntity, RelationPredicateBucket filter)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
adapter.UpdateEntitiesDirectly(_CatalogsEntity, filter);
toReturn = true;
}
return toReturn;
}
CatalogsEntity getCat()
{
CatalogsEntity cat = new CatalogsEntity();
cat.CatalogName = getString(txtCatalogName.Text.Trim(), CatalogsFields.CatalogName.MaxLength);
cat.ParentId = int.Parse(ddlCatalog.SelectedValue);
cat.ToolTip = getString(txtToolTip.Text.Trim(), CatalogsFields.CatalogName.MaxLength);
cat.IsVisible = chkIsVisible.Checked;
cat.CatCode = getString(txtCatCode.Text.Trim(), CatalogsFields.CatCode.MaxLength);
return cat;
}
void ItemCommand(object CommandArgument, string CommandName)
{
int Id = int.Parse(CommandArgument.ToString());
CatalogsEntity cat = new CatalogsEntity();
switch (CommandName)
{
case "add":
cat = CatalogsManager.CreateInstant().SelectOne(Id);
if (cat != null)
{
divUpdate.Visible = true;
ddlCatalog.Items.Clear();
ddlCatalog.Items.Insert(0, new ListItem(cat.CatalogName, "-1"));
ddlCatalog.Enabled = false;
hidId.Value = cat.Id.ToString();
}
if (Id == 0)
{
divUpdate.Visible = true;
ddlCatalog.Items.Clear();
ddlCatalog.Items.Insert(0, new ListItem("Danh mục gốc", "-1"));
ddlCatalog.Enabled = false;
hidId.Value = "0";
}
break;
case "edit":
cat = CatalogsManager.CreateInstant().SelectOne(Id);
if (cat != null)
{
btnAdd.Visible = false;
btnUpdate.Visible = true;
hidId.Value = Id.ToString();
divUpdate.Visible = true;
txtCatalogName.Text = cat.CatalogName;
txtToolTip.Text = cat.ToolTip;
chkIsVisible.Checked = cat.IsVisible;
txtCatCode.Text = cat.CatCode;
LoadCombo(cat.Id, cat.ParentId);
ddlCatalog.Items.Insert(0, new ListItem("----------------------------------------------", "-1"));
}
break;
case "del":
cat = CatalogsManager.CreateInstant().SelectOne(Id);
if (cat != null)
{
validUpdate.IsValid = true;
if (cat.ProductAmount != 0 || !cat.IsLeaf)
{
validUpdate.IsValid = false;
validUpdate.ErrorMessage = "Không thể xóa danh mục đang chứa sản phẩm hoặc không phải là danh mục con";
}
if (validUpdate.IsValid)
{
CatalogsManager.CreateInstant().Delete(Id);
WebUtility.Refesh(Page);
}
}
break;
case "visible":
cat = CatalogsManager.CreateInstant().SelectOne(Id);
if (cat != null)
{
cat.IsVisible = !cat.IsVisible;
CatalogsManager.CreateInstant().Update(cat);
WebUtility.Refesh(Page);
}
break;
case "move-prev":
cat = CatalogsManager.CreateInstant().SelectOne(Id);
if (cat != null)
{
CatalogsEntity parent = CatalogsManager.CreateInstant().SelectOne(cat.ParentId);
if (parent != null)
{
cat.ParentId = parent.ParentId;
CatalogsManager.CreateInstant().Update(cat);
CatalogsManager.CreateInstant().UpdateIsLeaf(parent.Id);
WebUtility.Refesh(Page);
}
}
break;
}
}
public CatalogsEntity SelectOne(int Id)
{
CatalogsEntity toReturn = null;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
CatalogsEntity _CatalogsEntity = new CatalogsEntity(Id);
if (adapter.FetchEntity(_CatalogsEntity))
{
toReturn = _CatalogsEntity;
}
}
return toReturn;
}
