public IEnumerable <Sku> ListSkuByCategory(StaticCategory cat)
{
var ids = session.QueryOver <Category>().Where(i => i.staticcat == cat).List().Select(i => i.skuId).ToArray();
var retval = session.QueryOver <Sku>().Where(s => s.id.IsIn(ids)).List();
return(retval);
}
public bool AddOrUpdateStaticCategory(StaticCategory category)
{
bool result = false;
try
{
dbService.Run(db =>
{
var categoryDB = db.GetRepository <StaticCategory>().TryOne(category.id);
if (categoryDB == null)
{
db.GetRepository <StaticCategory>().Add(category);
}
else
{
categoryDB.name = category.name;
db.GetRepository <StaticCategory>().Update(categoryDB);
}
});
result = true;
}
catch (Exception err)
{
result = false;
logger.Error(err.Message);
}
return(result);
}
// GET: Admin/StaticCategory
public ActionResult Index(int?id)
{
int categoryId = (id.HasValue) ? Convert.ToInt32(id) : 0;
ViewBag.StaticCategory = StaticCategory.DropDown(categoryId);
return(View());
}
/// <summary>
///
/// </summary>
private static void ImportCategories(ApplicationDbContext db)
{
var sortIndex = 0;
var dirInfo = new DirectoryInfo(HttpContext.Current.Server.MapPath(staticListDirectory));
foreach (var dir in dirInfo.GetDirectories())
{
StaticCategory staticCategory = new StaticCategory()
{
Name = dir.Name,
SortOrder = sortIndex++
};
db.StaticCategories.Add(staticCategory);
db.SaveChanges();
var soIndex = 0;
var fileNames = dir.GetFiles();
foreach (var fileInfo in fileNames)
{
string filePath = string.Concat(dir.Name, "/", fileInfo.Name);
string key = string.Concat(dir.Name.Replace(" ", "_"), ".", Path.GetFileNameWithoutExtension(fileInfo.Name));
StaticCategoryList staticCategoryList = new StaticCategoryList()
{
Name = Path.GetFileNameWithoutExtension(fileInfo.Name),
StaticCategory = staticCategory,
SortOrder = soIndex++
};
db.StaticCategoryLists.Add(staticCategoryList);
db.SaveChanges();
ImportCategoryList(db, staticCategoryList, key, filePath);
}
}
}
public ActionResult DeleteConfirmed(int id)
{
StaticCategory staticCategory = db.StaticCategories.Find(id);
db.StaticCategories.Remove(staticCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name,Description,SortOrder,IsPublished")] StaticCategory staticCategory)
{
if (ModelState.IsValid)
{
db.Entry(staticCategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(staticCategory));
}
// GET: Admin/StaticCategoryListItem
public ActionResult Index(int?id)
{
int categoryListId = (id.HasValue) ? Convert.ToInt32(id) : 0;
int categoryId = (categoryListId > 0) ? db.StaticCategoryLists.Find(categoryListId).StaticCategory.Id : 0;
ViewBag.StaticCategory = StaticCategory.DropDown(categoryId);
ViewBag.StaticCategoryList = StaticCategoryList.DropDown(categoryId, categoryListId);
return(View());
}
public ActionResult Create([Bind(Include = "Id,Name,Description,SortOrder,IsPublished")] StaticCategory staticCategory)
{
if (ModelState.IsValid)
{
db.StaticCategories.Add(staticCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(staticCategory));
}
// GET: Admin/StaticCategory/Create
public ActionResult Create(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
int categoryId = Convert.ToInt32(id);
return(View(new StaticCategoryList()
{
StaticCategory = StaticCategory.Get(categoryId)
}));
}
// GET: Admin/StaticCategory/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StaticCategory staticCategory = db.StaticCategories.Find(id);
if (staticCategory == null)
{
return(HttpNotFound());
}
return(View(staticCategory));
}
public StaticCategory GetStaticCategoryById(long idCat)
{
var result = new StaticCategory();
try
{
dbService.Run(db =>
{
result = db.GetRepository <StaticCategory>().TryOne(idCat);
});
}
catch (Exception err)
{
logger.Error(err.Message);
}
return(result);
}
public List <Sku> ListSkuByCategory(StaticCategory cat)
{
var result = new List <Sku>();
try
{
dbService.Run(db =>
{
result = ((SkuRepository)db.GetRepository <Sku>()).ListSkuByCategory(cat).ToList();
});
}
catch (Exception err)
{
logger.Error(err.Message);
}
return(result);
}
private IEnumerable <ShortSKUModel> ListSkuByCategory(StaticCategory cat)
{
var u = AccountAdminModelBuilder.BuildOneUser(WebSecurity.CurrentUserName);
if (u != null && u.Discount > 0)
{
return(dataService.ListSkuByCategory(cat).Select(sku => new ShortSKUModel()
{
id = sku.id,
brandId = sku.brand.id,
brandName = sku.brand.name,
categotyId = cat.id,
categotyName = cat.name,
description = sku.description,
name = sku.name,
price = sku.price,
priceAct = sku.priceAct - ((sku.priceAct / 100) * u.Discount),
smalPhotoPath = string.Format("{0}/{1}", imagesPath.GetImagesPath(), (sku.smalPhoto ?? new Photo()
{
path = "box.png"
}).path)
}));
}
return(dataService.ListSkuByCategory(cat).Select(sku => new ShortSKUModel()
{
id = sku.id,
brandId = sku.brand.id,
brandName = sku.brand.name,
categotyId = cat.id,
categotyName = cat.name,
description = sku.description,
name = sku.name,
price = sku.price,
priceAct = sku.priceAct,
smalPhotoPath = string.Format("{0}/{1}", imagesPath.GetImagesPath(), (sku.smalPhoto ?? new Photo()
{
path = "box.png"
}).path)
}));
}
public ActionResult AddOrUpdateStaticCategory(StaticCategory category)
{
var message = string.Empty;
try
{
if (ModelState.IsValid)
{
if (dataService.AddOrUpdateStaticCategory(category))
{
return(Content("Категория сохранена", "text/html"));
}
}
}
catch (Exception err)
{
message = err.Message;
}
return(Content("Категория НЕ сохранена " + message, "text/html"));
}
public Event Create(Event culturalEvent, StaticCategory staticCategory)
{
using (var transaction = _context.Database.BeginTransaction())
{
_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Categories ON;");
transaction.Commit();
}
using (var transaction = _context.Database.BeginTransaction())
{
var list = _context.Categories.FromSql("SELECT * FROM dbo.Categories").ToList();
transaction.Commit();
}
_context.Events.Add(culturalEvent);
_context.SaveChanges();
using (var transaction = _context.Database.BeginTransaction())
{
_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Categories OFF;");
transaction.Commit();
}
return(culturalEvent);
}
public List<Sku> ListSkuByCategory(StaticCategory cat)
{
var result = new List<Sku>();
try
{
dbService.Run(db =>
{
result = ((SkuRepository)db.GetRepository<Sku>()).ListSkuByCategory(cat).ToList();
});
}
catch (Exception err)
{
logger.Error(err.Message);
}
return result;
}
public StaticCategory GetStaticCategoryById(long idCat)
{
var result = new StaticCategory();
try
{
dbService.Run(db =>
{
result = db.GetRepository<StaticCategory>().TryOne(idCat);
});
}
catch (Exception err)
{
logger.Error(err.Message);
}
return result;
}
public bool AddOrUpdateStaticCategory(StaticCategory category)
{
bool result = false;
try
{
dbService.Run(db =>
{
var categoryDB = db.GetRepository<StaticCategory>().TryOne(category.id);
if (categoryDB == null)
{
db.GetRepository<StaticCategory>().Add(category);
}
else
{
categoryDB.name = category.name;
db.GetRepository<StaticCategory>().Update(categoryDB);
}
});
result = true;
}
catch (Exception err)
{
result = false;
logger.Error(err.Message);
}
return result;
}
public ActionResult AddOrUpdateStaticCategory(StaticCategory category)
{
var message = string.Empty;
try
{
if (ModelState.IsValid)
{
if (dataService.AddOrUpdateStaticCategory(category))
{
return Content("Категория сохранена", "text/html");
}
}
}
catch (Exception err)
{
message = err.Message;
}
return Content("Категория НЕ сохранена " + message, "text/html");
}
private IEnumerable<ShortSKUModel> ListSkuByCategory(StaticCategory cat)
{
var u = AccountAdminModelBuilder.BuildOneUser(WebSecurity.CurrentUserName);
if (u!=null&&u.Discount>0)
{
return dataService.ListSkuByCategory(cat).Select(sku => new ShortSKUModel()
{
id = sku.id,
brandId = sku.brand.id,
brandName = sku.brand.name,
categotyId = cat.id,
categotyName = cat.name,
description = sku.description,
name = sku.name,
price = sku.price,
priceAct = sku.priceAct-((sku.priceAct / 100) * u.Discount),
smalPhotoPath = string.Format("{0}/{1}", imagesPath.GetImagesPath(), (sku.smalPhoto ?? new Photo() { path = "box.png" }).path)
});
}
return dataService.ListSkuByCategory(cat).Select(sku => new ShortSKUModel()
{
id = sku.id,
brandId = sku.brand.id,
brandName = sku.brand.name,
categotyId = cat.id,
categotyName = cat.name,
description = sku.description,
name = sku.name,
price = sku.price,
priceAct = sku.priceAct,
smalPhotoPath = string.Format("{0}/{1}", imagesPath.GetImagesPath(), (sku.smalPhoto ?? new Photo() { path = "box.png" }).path)
});
}
public IActionResult New([FromForm] IFormCollection form, [FromForm] IFormFile picFile) //string name, string surname, string email, string telephone, string password)
{
int creatorId = int.Parse(Request.Cookies["user"]);
var title = form["title"];
DateTime dateStart = DateTime.Parse(form["dateStart"]);
DateTime dateEnd = DateTime.Parse(form["dateEnd"]);
var city = form["city"];
var street = form["street"];
var houseNumber = int.Parse(form["houseNumber"]);
var apartmentNumber = int.Parse(form["apartmentNumber"]);
var postalCode = form["postalCode"];
var description = form["description"];
byte[] picture = null;
BinaryReader reader = new BinaryReader(picFile.OpenReadStream());
picture = reader.ReadBytes((int)picFile.Length);
int staticCategoryId = int.Parse(Request.Form["category"]);
StaticCategory staticCategory = new StaticCategory();
staticCategory.Id = staticCategoryId;
Event culturalEvent = new Event
{
Title = title,
DateStart = dateStart,
DateEnd = dateEnd,
City = city,
Street = street,
HouseNumber = houseNumber,
ApartmentNumber = apartmentNumber,
PostalCode = postalCode,
Description = description,
Picture = picture,
StaticCategory = staticCategory,
CreatorId = creatorId
};
try
{
//save
_events.Create(culturalEvent, staticCategory);
return(Redirect("/Events/Created"));
}
catch (Exception ex)
{
//return error if there was an exception
return(BadRequest(new { message = ex.Message }));
}
/*
* using (var transaction = _context.Database.BeginTransaction())
* {
*
* var list = _context.Categories.FromSql("SELECT * FROM dbo.Categories").ToList();
* transaction.Commit();
* }
*/
}
