public async static Task category(TempDataDictionary TempData, long categoryId)
{
// remove from database
using (FM_Datastore_Entities_EF db_manager = new FM_Datastore_Entities_EF())
{
Category category = db_manager.Categories.FirstOrDefault(m => m.Id == categoryId);
if (category != null)
{
db_manager.Categories.Remove(category);
await db_manager.SaveChangesAsync();
}
}
// remove from session
List <Category> categories;
Load.categories(TempData, out categories);
Category tmpCategory = categories.FirstOrDefault(m => m.Id == categoryId);
if (tmpCategory != null)
{
categories.Remove(tmpCategory);
}
// remove from session combobox
List <SelectListItem> comboboxItems;
Load.categoriesCombobox(TempData, out comboboxItems);
SelectListItem tmpCBI = comboboxItems.FirstOrDefault(m => m.Value == categoryId.ToString());
if (tmpCBI != null)
{
categories.Remove(tmpCategory);
}
}
public async static Task product(TempDataDictionary TempData, long productId)
{
// remove from database
using (FM_Datastore_Entities_EF db_manager = new FM_Datastore_Entities_EF())
{
Product product = db_manager.Products.Include(AppSettings.Includes.Category).FirstOrDefault(m => m.Id == productId);
if (product != null)
{
db_manager.Products.Remove(product);
await db_manager.SaveChangesAsync();
}
}
// remove from session
List <Product> products;
Load.products(TempData, out products);
Product tmpProd = products.FirstOrDefault(m => m.Id == productId);
if (tmpProd != null)
{
products.Remove(tmpProd);
}
// remove from session combobox
List <SelectListItem> comboboxItems;
Load.productsCombobox(TempData, out comboboxItems);
SelectListItem tmpCBI = comboboxItems.FirstOrDefault(m => m.Value == productId.ToString());
if (tmpCBI != null)
{
products.Remove(tmpProd);
}
}
public async static Task <Category> category(TempDataDictionary TempData, Category category)
{
// add to database
using (FM_Datastore_Entities_EF db_manager = new FM_Datastore_Entities_EF())
{
category = db_manager.Categories.Add(category);
await db_manager.SaveChangesAsync();
}
// add to session
List <Category> categories;
if (!Load.categories(TempData, out categories))
{
categories.Add(category);
}
// add to session combobox
List <SelectListItem> comboboxItems;
if (!Load.categoriesCombobox(TempData, out comboboxItems))
{
comboboxItems.Add(new SelectListItem()
{
Text = category.name,
Value = category.Id.ToString()
});
}
return(category);
}
public async static Task <bool> category(TempDataDictionary TempData, long categoryId, long[] productLinkCatId)
{
// remove from database
using (FM_Datastore_Entities_EF db_manager = new FM_Datastore_Entities_EF())
{
Category category = db_manager.Categories.FirstOrDefault(m => m.Id == categoryId);
if (category != null)
{
List <Product> prod = category.Products.ToList();
Category categoryDef;
long tmpCat;
// remove products from categories
for (int i = 0; i < prod.Count; i++)
{
tmpCat = productLinkCatId[i];
categoryDef = db_manager.Categories.FirstOrDefault(m => m.Id == tmpCat);
prod[i].categoryId = (long)productLinkCatId[i];
prod[i].Category = categoryDef;
Update.product(TempData, prod[i]);
}
db_manager.Categories.Remove(category);
await db_manager.SaveChangesAsync();
}
}
// remove from session
List <Category> categories;
Load.categories(TempData, out categories);
Category tmpCategory = categories.FirstOrDefault(m => m.Id == categoryId);
if (tmpCategory != null)
{
categories.Remove(tmpCategory);
}
// remove from session combobox
List <SelectListItem> comboboxItems;
Load.categoriesCombobox(TempData, out comboboxItems);
SelectListItem tmpCBI = comboboxItems.FirstOrDefault(m => m.Value == categoryId.ToString());
if (tmpCBI != null)
{
categories.Remove(tmpCategory);
}
return(true);
}
public async static Task product(TempDataDictionary TempData, HttpSessionStateBase Session, long productId, long[] transactionLinkProdId)
{
// remove from database
using (FM_Datastore_Entities_EF db_manager = new FM_Datastore_Entities_EF())
{
Product product = db_manager.Products.FirstOrDefault(m => m.Id == productId);
if (product != null)
{
// remove transactions from products
List <Transaction> trans = product.Transactions.ToList();
Product productDef;
long tmp;
// remove transactions from products
for (int i = 0; i < trans.Count; i++)
{
tmp = transactionLinkProdId[i];
productDef = db_manager.Products.FirstOrDefault(m => m.Id == tmp);
trans[i].productId = transactionLinkProdId[i];
trans[i].Product = productDef;
Update.transaction(Session, trans[i]);
}
db_manager.Products.Remove(product);
await db_manager.SaveChangesAsync();
}
}
// remove from session
List <Product> products;
Load.products(TempData, out products);
Product tmpProd = products.FirstOrDefault(m => m.Id == productId);
if (tmpProd != null)
{
products.Remove(tmpProd);
}
// remove from session combobox
List <SelectListItem> comboboxItems;
Load.productsCombobox(TempData, out comboboxItems);
SelectListItem tmpCBI = comboboxItems.FirstOrDefault(m => m.Value == productId.ToString());
if (tmpCBI != null)
{
products.Remove(tmpProd);
}
}
public async static Task <Product> product(TempDataDictionary TempData, Product product)
{
// add to database
using (FM_Datastore_Entities_EF db_manager = new FM_Datastore_Entities_EF())
{
if (product.Category == null)
{
product.Category = db_manager.Categories.FirstOrDefault(m => m.Id == product.categoryId);
}
product = db_manager.Products.Add(product);
await db_manager.SaveChangesAsync();
}
// add to session
List <Product> products;
if (!Load.products(TempData, out products))
{
products.Add(product);
}
// add to session combobox
List <SelectListItem> comboboxItems;
if (!Load.productsCombobox(TempData, out comboboxItems))
{
comboboxItems.Add(new SelectListItem()
{
Text = product.name,
Value = product.Id.ToString()
});
}
return(product);
}
