private void RemoveCategory()
{
try
{
using (var context = new DatabaseContext())
{
//get the category element to remove
var data = context.Categories.FirstOrDefault(x => x.CategoryName == RemoveCategoryText);
if (data != null)
{
context.Categories.Remove(data);
context.VnUserCategoryTitles.RemoveRange(context.VnUserCategoryTitles.Where(x => x.Title == RemoveCategoryText));
context.SaveChanges();
//reload category list
CategoriesCollection.Clear();
LoadCategoryList();
}
}
}
catch (Exception ex)
{
Globals.Logger.Error(ex);
throw;
}
}
private void LoadDDLCategory()
{
try
{
Data objdata = new Data(Global.ConnectionSql);
Categories obj = new Categories();
obj.DataObject = objdata;
ddlCategory.Items.Clear();
CategoriesCollection col = obj.GetAll(string.Empty, -1);
if (col == null)
{
return;
}
ddlCategory.DataSource = col;
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataValueField = "CategoryID";
ddlCategory.DataBind();
}
catch (Exception ex)
{
Global.WriteLogError("LoadDDLCategory () " + ex);
lblmessage.Text = "Lỗi xảy ra trong quá trình lưu dữ liệu. Liên hệ với người quản trị để khắc phục";
mdPopup.Show();
}
}
private void BindingData()
{
try
{
CategoriesCollection col = null;
col = this.LoadCategory(string.Empty, -1);
if (col == null)
{
col = new CategoriesCollection();
lblCount.Text = "Có 0" + " record";
rptData.DataSource = col;
rptData.DataBind();
}
else
{
lblCount.Text = "Có " + col.Count.ToString() + " record";
lblCount.ForeColor = System.Drawing.Color.Blue;
anpPager.RecordCount = col.Count;
anpPager.PageSize = Convert.ToInt32(ddlPageSize.SelectedValue);
anpPager.ShowFirstLast = false;
col = this.GetSubData(col, anpPager.StartRecordIndex - 1, anpPager.EndRecordIndex);
rptData.DataSource = col;
rptData.DataBind();
}
}
catch (Exception ex)
{
Global.WriteLogError("BindingCategory()" + ex);
}
}
public CategoriesCollection Categories_LoadAll()
{
CategoriesCollection coll = new CategoriesCollection();
coll.es.IsLazyLoadDisabled = true;
coll.LoadAll();
return(coll);
}
public CreateViewModel()
{
_locations = new LocationCollection();
LoadResources();
_category = CategoriesCollection.Instance;
AddCommand = new RelayCommand(ToAddUds);
}
public CategoriesCollection Categories_LoadByDynamic(string serializedQuery)
{
CategoriesQuery query = CategoriesQuery.SerializeHelper.FromXml(
serializedQuery, typeof(CategoriesQuery), AllKnownTypes) as CategoriesQuery;
CategoriesCollection coll = new CategoriesCollection();
coll.es.IsLazyLoadDisabled = true;
coll.Load(query);
return(coll);
}
public CategoriesCollectionProxyStub Categories_SaveCollection(CategoriesCollectionProxyStub collection)
{
if (collection != null)
{
CategoriesCollection c = collection.GetCollection();
c.Save();
return(c);
}
return(null);
}
public CategoriesCollection.CategoriesCollectionWCFPacket Categories_LoadAll()
{
CategoriesCollection coll = new CategoriesCollection();
if (coll.LoadAll())
{
return(coll);
}
return(null);
}
public CategoriesCollectionProxyStub Categories_LoadAll()
{
CategoriesCollection coll = new CategoriesCollection();
if (coll.LoadAll())
{
return(coll);
}
return(null);
}
private void LoadCategoryList()
{
using (var context = new DatabaseContext())
{
List <string> categories = context.Categories.Where(x => x.CategoryName != "All").Select(x => x.CategoryName)
.ToList();
if (categories.Count > 0)
{
CategoriesCollection.InsertRange(categories);
}
}
}
public override sealed void OnNavigatedTo(
object parameter,
NavigationMode mode,
IDictionary <string, object> state)
{
var country = Country.PR;
CategoriesCollection = new CategoriesCollection(new GetCategoriesRequest(country),
FindierService);
HotPostsCollection = new PostsCollection(new GetPostsRequest(country).Sort(PostSort.Hot), FindierService);
NewPostsCollection = new PostsCollection(new GetPostsRequest(country).Sort(PostSort.New), FindierService);
TopPostsCollection = new PostsCollection(new GetPostsRequest(country).Sort(PostSort.Top), FindierService);
}
public EditViewModel()
{
_locationCollection = new LocationCollection();
_categories = CategoriesCollection.Instance;
_udstillingsGenstande = UdsCollection.Instance;
Loadcollections();
SaveCommand = new RelayCommand(toSaveCommand);
DeleteCommand = new RelayCommand(toDeleteCommand);
}
/// <summary>
/// GET : api/shopsigns/{shopsignid}/categories
/// </summary>
/// <param name="shopsignId">shop sign id to extract</param>
/// <returns></returns>
public async Task <IEnumerable <Category> > GetCategoriesAsync([FromRoute] string shopsignId)
{
var categories = await GetArticleCategoriesAsync();
var stockGroups = GetStockGroupsFromShopSign(shopsignId);
ShopSign shop = new ShopSign()
{
Id = shopsignId
};
var r = categories.Where(c => string.Join(',', stockGroups) == c.StockGroupId);
return(CategoriesCollection.BuildTree(r));
}
public CategoriesCollectionProxyStub Categories_QueryForCollection(string serializedQuery)
{
CategoriesQuery query = CategoriesQuery.SerializeHelper.FromXml(
serializedQuery, typeof(CategoriesQuery), AllKnownTypes) as CategoriesQuery;
CategoriesCollection coll = new CategoriesCollection();
if (coll.Load(query))
{
return(coll);
}
return(null);
}
private CategoriesCollection GetSubData(CategoriesCollection Source, int start, int end)
{
int iTotalRecord = Source.Count;
CategoriesCollection subSource = new CategoriesCollection();
if (Source != null)
{
for (int i = start; i < end; i++)
{
subSource.Add(Source[i]);
}
}
return(subSource);
}
private async void DeleteCategory_Click(object sender, RoutedEventArgs e)
{
var item = (sender as AppBarButton).DataContext;
ContentDialogResult result = await deleteItemDialog.ShowAsync();
if (result == ContentDialogResult.Primary)
{
var vm = (TravelDetailsViewModel)this.DataContext;
bool res = await vm.RemoveCategoryAsync(Travel, (Category)item);
if (res)
{
Travel.Categories.Remove((Category)item);
CategoriesCollection.Remove((Category)item);
}
}
}
public async Task <PaginationInfo <Category> > ListAllAsync(int pageSize, int pageNumber)
{
using (var conn = DataContext.CreateConnection())
{
conn.Open();
string spName = "faldone.ArticleCategoryList";
var results = await conn.QueryMultipleAsync(spName
, new { PageSize = pageSize, PageNumber = pageNumber }
, commandType : CommandType.StoredProcedure);
var res = await results.ReadAsync <CategoriesCollection.ResultSet>();
var recordCount = results.Read <int>().First();
IEnumerable <Category> coll = CategoriesCollection.BuildTree(res);
return(PaginationInfo <Category>(pageSize, pageNumber, recordCount, coll));
}
}
private CategoriesCollection LoadCategory(string stextsearch, int TypeID)
{
CategoriesCollection col = null;
try
{
Data objdata = new Data(Global.ConnectionSql);
Categories obj = new Categories();
obj.DataObject = objdata;
col = obj.GetAll(stextsearch, TypeID);
}
catch (Exception ex)
{
Global.WriteLogError("LoadCategory()" + ex);
}
return(col);
}
/// <summary>
/// GET : api/shopsigns
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <ShopSign> > GetShopSignsAsync()
{
var categories = await GetArticleCategoriesAsync();
List <ShopSign> list = new List <ShopSign>();
var signs = new string[] { "KASANOVA", "KASANOVA+", "COIMPORT", "L'Outlet", "Casa sulla'albero", "Le Kikke", "E-Commerce" };
foreach (string sign in signs)
{
var stockGroups = GetStockGroupsFromShopSign(sign);
ShopSign shop = new ShopSign()
{
Id = sign
};
var r = categories.Where(c => string.Join(',', stockGroups) == c.StockGroupId);
shop.Categories.AddRange(CategoriesCollection.BuildTree(r));
list.Add(shop);
}
return(list);
}
public void Arrange()
{
categoriesCollection = CategoriesCollection.Instance;
}
/// <summary>
/// Initializes a new instance of the <see cref="Workspace"/> class.
/// </summary>
/// <param name="context">The context.</param>
public Workspace(KbContext context)
{
Keywords = new KeywordCollection(context);
UserFiles = new UserFileCollection(KbContext.CurrentUserId, context);
Categories = new CategoriesCollection(context);
}
