public ActionResult Index(ReportMenuViewModel vmodel)
{
if (ModelState.IsValid)
{
int language = LanguageBL.CheckLanguageSession();
switch (vmodel.TypeReportId)
{
case "1":
vmodel.ReportTotalSales = ReportBL.FindReportTotalSales(vmodel, language);
ViewBag.report = true;
ViewBag.TypeReportId = vmodel.TypeReportId;
return(PartialView("_PartialReportTotalSales", vmodel.ReportTotalSales));
case "2":
vmodel.ReportTotalSalesByProduct = ReportBL.FindReportTotalSalesByProduct(vmodel, language);
ViewBag.report = true;
ViewBag.TypeReportId = vmodel.TypeReportId;
return(PartialView("_PartialReportTotalSalesByProduct", vmodel.ReportTotalSalesByProduct));
default:
break;
}
}
vmodel.TypesReport = ReportBL.FindAllTypesReport();
return(View(vmodel));
}
// GET: Messages
//[Authorize(Roles = "admin")]
//[Authorize(Roles = "manager")]
public ActionResult Index(string sortOrder, string searchString)
{
string nameSetting = "MessageGen";
string messageG = SettingBL.FindSettingValueByName(nameSetting);
ViewBag.messageG = int.Parse(messageG);
int lang = LanguageBL.CheckLanguageSession();
var messagesT = db.SPP_MessageTransDistinct(lang).ToList();
ViewBag.NameSortParam = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
if (!String.IsNullOrEmpty((searchString)))
{
messagesT = messagesT.Where(s => s.title.ToLower().StartsWith(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "name_desc":
messagesT = messagesT.OrderByDescending(d => d.title).ToList();
break;
default:
messagesT = messagesT.OrderBy(d => d.title).ToList();
break;
}
return(View(messagesT));
}
public ActionResult Edit(ProductViewModel vmodel)
{
if (ModelState.IsValid)
{
db.Entry(vmodel.Product).State = EntityState.Modified;
//db.SaveChanges();
IList <PRODUCT_TRANSLATION> productsT = TranslationBL.VerifyIsUniversal(vmodel.ProductsTrans, vmodel.IdProduct);
foreach (var item in vmodel.ProductsTrans)
{
db.Entry(item).State = EntityState.Modified;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
bool isUniversal = false;
if (vmodel.ProductsTrans.Count() == 1)
{
isUniversal = true;
}
ViewBag.isUniversal = isUniversal;
int lang = LanguageBL.CheckLanguageSession();
int ULang = LanguageBL.FindUniversalId();
vmodel.ListLang = LanguageBL.FindLanguageListWithoutUniversal();
vmodel.CategoriesTrans = db.CATEGORY_TRANSLATIONs.Where(c => c.languageId == lang || c.languageId == ULang).ToList();
vmodel.Ages = db.AGEs.ToList();
vmodel.Brands = db.BRANDs.ToList();
vmodel.HeroesTrans = db.HERO_TRANSLATIONs.Where(c => c.languageId == lang || c.languageId == ULang).ToList();
vmodel.Vats = db.VATs.ToList();
return(View(vmodel));
}
// GET: Terminals/Create
//[Authorize(Roles = "admin")]
//[Authorize(Roles = "manager")]
public ActionResult Create()
{
int lang = LanguageBL.CheckLanguageSession();
int universal = db.LANGUAGESs.Where(l => l.shortForm == "all").Select(s => s.idLanguage).Single();
ViewBag.shopId = new SelectList(db.SHOP_TRANSLATIONs.Include(t => t.SHOP).Where(s => s.languageId == lang || s.languageId == universal), "shopId", "nameShop");
return(View());
}
// GET: Categories
//[Authorize(Roles = "admin")]
//[Authorize(Roles = "manager")]
public ActionResult Index(string sortOrder, string searchString)
{
CategoryViewModel vm = new CategoryViewModel();
//Find all cat by language
int lang = LanguageBL.CheckLanguageSession();
var categoriesT = db.SPP_CategoryTransDistinct(lang).ToList();
//Find relation for all cat
IList <int> parentOnly = db.SPP_ParentCategoriesSubTransDistinct(lang).Select(p => p.idCategory).ToList();
IList <int> childOnly = db.SPP_ChildCategoriesTransDistinct(lang).Select(p => p.idCategory).ToList();
IList <CategoryViewModel> list = new List <CategoryViewModel>();
string rel;
foreach (var item in categoriesT)
{
if (childOnly.Contains(item.idCategory) && parentOnly.Contains(item.idCategory))
{
rel = "parent/sous-catégorie";
}
else if (childOnly.Contains(item.idCategory))
{
rel = "sous-catégorie";
}
else
{
rel = "catégorie parent";
}
CategoryViewModel cat = new CategoryViewModel
{
IdCat = item.idCategory,
NameCat = item.nameCategory,
Image = item.imageCat,
Relation = rel
};
list.Add(cat);
}
ViewBag.NameSortParam = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
if (!String.IsNullOrEmpty((searchString)))
{
list = list.Where(s => s.NameCat.ToLower().StartsWith(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "name_desc":
list = list.OrderByDescending(d => d.NameCat).ToList();
break;
default:
list = list.OrderBy(d => d.NameCat).ToList();
break;
}
return(View(list));
}
// GET: Categories/Create
//[Authorize(Roles = "admin")]
//[Authorize(Roles = "manager")]
public ActionResult Create()
{
int lang = LanguageBL.CheckLanguageSession();
CategoryViewModel vm = new CategoryViewModel
{
ListLang = LanguageBL.FindLanguageListWithoutUniversal(),
Categories = db.SPP_CategoryTransDistinct(lang).ToList()
};
return(View(vm));
}
// GET: Messages/Delete/5
//[Authorize(Roles = "admin")]
//[Authorize(Roles = "manager")]
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
int lang = LanguageBL.CheckLanguageSession();
SPP_MessageTransDistinct_Result messages = db.SPP_MessageTransDistinct(lang).Where(m => m.idMessage == id).Single();
return(View(messages));
}
public ActionResult Create(CategoryViewModel vmodel)
{
if (ModelState.IsValid)
{
//Check if nameHero have min 1 value
IList <CATEGORY_TRANSLATION> catsT = vmodel.CategoriesTrans;
bool nameCatIsValid = TranslationBL.CheckIfMinOneValued(catsT);
if (nameCatIsValid)
{
//Check if Cat exist by nameCategory before create
bool nameExist = TranslationBL.CheckIfNameExist(catsT);
if (!nameExist)
{
CATEGORY cat = new CATEGORY
{
imageCat = vmodel.Image
};
db.CATEGORYs.Add(cat);
db.SaveChanges();
//Add Translation
int id = cat.idCategory;
IList <CATEGORY_TRANSLATION> newcatsT = TranslationBL.VerifyIsUniversal(catsT, id);
db.CATEGORY_TRANSLATIONs.AddRange(newcatsT);
db.SaveChanges();
if (vmodel.Parent != null)
{
SUBCATEGORY subCat = new SUBCATEGORY {
parentCategory = vmodel.Parent.Value,
childCategory = cat.idCategory
};
db.SUBCATEGORYs.Add(subCat);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
//to do --> match the error with the name that causes the error
ViewBag.nameIsNotValid = "Le nom existe déjà, veuillez saisir un autre nom!";
}
}
else
{
ViewBag.nameIsNotValid = "Veuillez saisir un nom!";
}
}
int lang = LanguageBL.CheckLanguageSession();
vmodel.ListLang = LanguageBL.FindLanguageListWithoutUniversal();
vmodel.Categories = db.SPP_CategoryTransDistinct(lang).ToList();
return(View(vmodel));
}
public ActionResult Create([Bind(Include = "idTerminal,nameTerminal,shopId")] TERMINAL terminal)
{
if (ModelState.IsValid)
{
db.TERMINALs.Add(terminal);
db.SaveChanges();
return(RedirectToAction("Index"));
}
int lang = LanguageBL.CheckLanguageSession();
int universal = db.LANGUAGESs.Where(l => l.shortForm == "all").Select(s => s.idLanguage).Single();
ViewBag.shopId = new SelectList(db.SHOP_TRANSLATIONs.Include(t => t.SHOP).Where(s => s.languageId == lang || s.languageId == universal), "shopId", "nameShop");
return(View(terminal));
}
// GET: Products/Edit/5
//[Authorize(Roles = "admin")]
//[Authorize(Roles = "manager")]
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PRODUCT pRODUCT = db.PRODUCTs.Find(id);
if (pRODUCT == null)
{
return(HttpNotFound());
}
var translation = db.PRODUCT_TRANSLATIONs.Where(pt => pt.productId == id).ToList();
ProductViewModel vm = new ProductViewModel();
bool isUniversal = false;
if (translation.Count() == 1)
{
isUniversal = true;
}
ViewBag.isUniversal = isUniversal;
vm.Product = pRODUCT;
vm.IdProduct = pRODUCT.idProduct;
vm.Barcode = pRODUCT.barcode;
vm.Price = pRODUCT.salesPrice;
vm.Discount = pRODUCT.discountRate;
vm.ImageProduct = pRODUCT.imageProduct;
vm.Category = pRODUCT.categoryId.ToString();
vm.Age = pRODUCT.ageId.ToString();
vm.Brand = pRODUCT.brandId.ToString();
vm.Hero = pRODUCT.heroId.ToString();
vm.ProductsTrans = translation;
int lang = LanguageBL.CheckLanguageSession();
int ULang = LanguageBL.FindUniversalId();
vm.ListLang = LanguageBL.FindLanguageListWithoutUniversal();
vm.CategoriesTrans = db.CATEGORY_TRANSLATIONs.Where(c => c.languageId == lang || c.languageId == ULang).ToList();
vm.Ages = db.AGEs.ToList();
vm.Brands = db.BRANDs.ToList();
vm.HeroesTrans = db.HERO_TRANSLATIONs.Where(c => c.languageId == lang || c.languageId == ULang).ToList();
vm.Vats = db.VATs.ToList();
return(View(vm));
}
// GET: Products/Create
//[Authorize(Roles = "admin")]
//[Authorize(Roles = "manager")]
public ActionResult Create()
{
int lang = LanguageBL.CheckLanguageSession();
int ULang = LanguageBL.FindUniversalId();
ProductViewModel vm = new ProductViewModel
{
ListLang = LanguageBL.FindLanguageListWithoutUniversal(),
CategoriesTrans = db.CATEGORY_TRANSLATIONs.Where(c => c.languageId == lang || c.languageId == ULang).ToList(),
Ages = db.AGEs.ToList(),
Brands = db.BRANDs.ToList(),
HeroesTrans = db.HERO_TRANSLATIONs.Where(c => c.languageId == lang || c.languageId == ULang).ToList(),
Vats = db.VATs.ToList()
};
return(View(vm));
}
// GET: Terminals/Edit/5
//[Authorize(Roles = "admin")]
//[Authorize(Roles = "manager")]
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TERMINAL terminal = db.TERMINALs.Find(id);
if (terminal == null)
{
return(HttpNotFound());
}
int lang = LanguageBL.CheckLanguageSession();
int universal = db.LANGUAGESs.Where(l => l.shortForm == "all").Select(s => s.idLanguage).Single();
ViewBag.shopId = new SelectList(db.SHOP_TRANSLATIONs.Include(t => t.SHOP).Where(s => s.languageId == lang || s.languageId == universal), "shopId", "nameShop", terminal.shopId);
return(View(terminal));
}
// GET: Shops
//[Authorize(Roles = "admin")]
//[Authorize(Roles = "manager")]
public ActionResult Index(string sortOrder, string searchString)
{
int lang = LanguageBL.CheckLanguageSession();
var shopsT = db.SPP_ShopTransDistinct(lang).ToList();
ViewBag.NameSortParam = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
if (!String.IsNullOrEmpty((searchString)))
{
shopsT = shopsT.Where(s => s.nameShop.ToLower().StartsWith(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "name_desc":
shopsT = shopsT.OrderByDescending(d => d.nameShop).ToList();
break;
default:
shopsT = shopsT.OrderBy(d => d.nameShop).ToList();
break;
}
return(View(shopsT));
}
public ActionResult Create(ProductViewModel vmodel)
{
if (ModelState.IsValid)
{
try
{
//if no image, assign default image
string img = vmodel.ImageProduct;
if (img == null)
{
img = "~/Content/image/logo_noImage.png";
}
// check if hero is null
int?hero = null;
if (vmodel.Hero != null)
{
hero = int.Parse(vmodel.Hero);
}
PRODUCT product = new PRODUCT
{
barcode = vmodel.Barcode,
salesPrice = vmodel.Price,
discountRate = vmodel.Discount,
imageProduct = img,
categoryId = int.Parse(vmodel.Category),
ageId = int.Parse(vmodel.Age),
brandId = int.Parse(vmodel.Brand),
heroId = hero,
vatId = int.Parse(vmodel.Vat)
};
db.PRODUCTs.Add(product);
db.SaveChanges();
//Add Translation
int id = product.idProduct;
IList <PRODUCT_TRANSLATION> productsT = TranslationBL.VerifyIsUniversal(vmodel.ProductsTrans, id);
db.PRODUCT_TRANSLATIONs.AddRange(productsT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
//to do insert to log file
var e1 = ex.GetBaseException(); // --> log
var e4 = ex.Message; // --> log
var e5 = ex.Source; // --> log
var e8 = ex.GetType(); // --> log
var e9 = ex.GetType().Name; // --> log
return(View("Error"));
}
}
int lang = LanguageBL.CheckLanguageSession();
int ULang = LanguageBL.FindUniversalId();
vmodel.ListLang = LanguageBL.FindLanguageListWithoutUniversal();
vmodel.CategoriesTrans = db.CATEGORY_TRANSLATIONs.Where(c => c.languageId == lang || c.languageId == ULang).ToList();
vmodel.Ages = db.AGEs.ToList();
vmodel.Brands = db.BRANDs.ToList();
vmodel.HeroesTrans = db.HERO_TRANSLATIONs.Where(c => c.languageId == lang || c.languageId == ULang).ToList();
vmodel.Vats = db.VATs.ToList();
return(View(vmodel));
}
