public virtual ActionResult Index(int id)
{
var model = new CategoryIndex();
using (var dbContext = new AllureContext())
{
var current = dbContext.Set <SubCategory>().SingleOrDefault(c => c.Id == id);
if (current == null)
{
throw new HttpException(404, string.Format("category {0} doesn't exist", id.ToString()));
}
model.Current = new SubCategoryOutput(current, this.LanguageCode);
model.SubCategories = dbContext.Set <SubCategory>()
.Include(c => c.Localized)
.Where(c => c.ParentId == current.ParentId)
.ToArray()
.Select(c => new SubCategoryOutput(c, this.LanguageCode))
.ToArray();
model.Products = dbContext.Set <Product>()
.Include(p => p.Locale)
.Include(p => p.Localized)
.Where(p => p.SubCategoryId == current.Id)
.ToArray()
.Select(p => new ProductOutput(p, this.LanguageCode))
.ToArray();
}
return(View(CreateViewModel(model)));
}
void context_BeginRequest(object sender, EventArgs e)
{
var dbContext = new AllureContext();
var application = (HttpApplication)sender;
string[] supported = dbContext.Set <Language>().Where(lang => lang.Enabled).Select(lang => lang.Code).ToArray();
string querySpecified = application.Request.QueryString[SpecifiedLanguageQueryString];
if (!querySpecified.IsNullOrEmpty() && supported.Contains(querySpecified))
{
SetCulture(application.Response, querySpecified);
return;
}
string headerSpecified = application.Request.Headers[SpecifiedLanguageHeader];
if (!headerSpecified.IsNullOrEmpty() && supported.Contains(headerSpecified))
{
SetCulture(application.Response, headerSpecified);
return;
}
var cookieSpecified = application.Request.Cookies[SpecifiedLanguageCookieName];
if (cookieSpecified != null && supported.Contains(cookieSpecified.Value))
{
SetCulture(application.Response, cookieSpecified.Value);
return;
}
string browserSpecified = application.Request.UserLanguages.FirstOrDefault(l => supported.Contains(l));
SetCulture(application.Response, browserSpecified ?? dbContext.Set <Language>().Single(lang => lang.IsDefault).Code);
}
public OrderOutput Update(OrderInput input)
{
using (var dbContext = new AllureContext())
{
var order = dbContext.Set <Order>().SingleOrDefault(o => o.Id == input.Id);
if (order == null)
{
throw new HttpException(404, string.Format("order {0} doesn't exist", input.Id.ToString()));
}
order.Status = input.Status;
order.WillCheck = input.WillCheck;
order.CheckAddress = input.CheckAddress;
order.CheckTime = input.CheckTime;
order.CheckContact = input.CheckContact;
order.LogisticCode = input.LogisticCode;
order.LogisticOrderNumber = input.LogisticOrderNumber;
order.Deposit = input.Deposit;
order.DepositReceipt = input.DepositReceipt;
order.Remaining = input.Remaining;
order.RemainingReceipt = input.RemainingReceipt;
order.UpdateTime = DateTime.Now;
if (order.Deposit.HasValue)
{
order.RealCharge = order.OriginalRealCharge - order.Deposit.Value;
}
dbContext.SaveChanges();
return(Id(order.Id));
}
}
public void Delete(int id)
{
using (var dbContext = new AllureContext())
{
var order = dbContext.Set <Order>().SingleOrDefault(o => o.Id == id);
if (order == null)
{
throw new HttpException(404, string.Format("order {0} doesn't exist", id.ToString()));
}
dbContext.Set <OrderDetail>().RemoveRange(order.Details);
dbContext.Entry(order).State = EntityState.Deleted;
dbContext.SaveChanges();
}
}
public virtual ActionResult Register(UserRegister reg)
{
var user = new User
{
Email = reg.Email,
FirstName = reg.FirstName,
LastName = reg.LastName,
Address = reg.Address,
Company = reg.Company,
Gender = reg.Gender,
Mobile = reg.Mobile,
Password = reg.PlainTextPassword,
PostCode = reg.PostCode,
Telephone = reg.Telephone,
Status = UserStatus.Unactivated,
Roles = new[] { new UserRole {
Role = Role.Customer
} },
Deliveries = new[] { new Delivery {
Address = reg.Address, Phone = reg.Mobile, PostCode = reg.PostCode, Receiver = reg.FirstName + " " + reg.LastName
} }
};
using (var context = new AllureContext())
{
context.Set <User>().Add(user);
context.SaveChanges();
}
ViewBag.ActivateUrl = "/user/activate?token=" + Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(prefix + user.Email));
return(View(MVC.User.Views.RegisterSuccess, CreateViewModel()));
}
public Warehouse[] List()
{
using (var dbContext = new AllureContext())
{
return(dbContext.Set <Warehouse>().ToArray());
}
}
public Brand[] List()
{
using (var dbContext = new AllureContext())
{
return(dbContext.Set <Brand>().ToArray());
}
}
public Logistic[] List()
{
using (var dbContext = new AllureContext())
{
return(dbContext.Set <Logistic>().ToArray());
}
}
public UserOutput Create(CreateUserInput input)
{
var user = new User
{
Email = input.Email,
Gender = input.Gender,
FirstName = input.FirstName,
LastName = input.LastName,
Telephone = input.Telephone,
Mobile = input.Mobile,
Company = input.Company,
Roles = input.Roles.Select(r => new UserRole {
Role = r
}).ToList(),
Deliveries = input.Deliveries.Select(d => new Delivery {
Address = d.Address, PostCode = d.PostCode, Receiver = d.Receiver, Phone = d.Phone
}).ToList(),
Status = UserStatus.Unactivated
};
using (var dbContext = new AllureContext())
{
dbContext.Set <User>().Add(user);
dbContext.SaveChanges();
}
return(Id(user.Id));
}
public void Create(Logistic input)
{
using (var dbContext = new AllureContext())
{
dbContext.Set <Logistic>().Add(input);
dbContext.SaveChanges();
}
}
public void Create(Warehouse input)
{
using (var dbContext = new AllureContext())
{
dbContext.Set <Warehouse>().Add(input);
dbContext.SaveChanges();
}
}
public void Delete(int id)
{
using (var dbContext = new AllureContext())
{
var user = dbContext.Set <User>().SingleOrDefault(u => u.Id == id);
if (user == null)
{
throw new HttpException(404, string.Format("user {0} doesn't exist", id.ToString()));
}
dbContext.Set <UserRole>().RemoveRange(user.Roles);
dbContext.Set <Delivery>().RemoveRange(user.Deliveries);
dbContext.Entry(user).State = EntityState.Deleted;
dbContext.SaveChanges();
}
}
public LocaleOutput Create(Locale locale)
{
using (var dbContext = new AllureContext())
{
dbContext.Set <Locale>().Add(locale);
dbContext.SaveChanges();
}
return(new LocaleOutput(locale));
}
public Brand Create(Brand brand)
{
using (var dbContext = new AllureContext())
{
dbContext.Set <Brand>().Add(brand);
dbContext.SaveChanges();
}
return(Id(brand.Id));
}
public void Delete(string id)
{
using (var dbContext = new AllureContext())
{
var image = dbContext
.Set <HomePageImage>()
.Include(i => i.Localized)
.SingleOrDefault(i => i.Id == id);
if (image == null)
{
throw new HttpException(404, string.Format("image {0} doesn't exist", id.ToString()));
}
dbContext.Set <LocalizedHomePageImage>().RemoveRange(image.Localized);
dbContext.Entry(image).State = EntityState.Deleted;
dbContext.SaveChanges();
}
}
public void DeleteSub(int id)
{
using (var dbContext = new AllureContext())
{
var subCategory = dbContext
.Set <SubCategory>()
.Include(c => c.Localized)
.SingleOrDefault(c => c.Id == id);
if (subCategory == null)
{
throw new Exception(string.Format("subcategory {0} doesn't exist", id.ToString()));
}
dbContext.Set <LocalizedSubCategory>().RemoveRange(subCategory.Localized);
dbContext.Entry(subCategory).State = EntityState.Deleted;
dbContext.SaveChanges();
}
}
private void BuildLanguagesInModel(MainViewModel model)
{
using (var dbContext = new AllureContext())
{
model.Languages = dbContext
.Set <Language>()
.Where(lang => lang.Enabled)
.ToArray();
}
}
public virtual ActionResult Save(OrderInput input)
{
using (var context = new AllureContext())
{
var order = context.Set <Order>()
.Include(o => o.Details)
.AsNoTracking()
.SingleOrDefault(o => o.Id == input.Id);
if (order == null)
{
throw new Exception(string.Format("order {0} doesn't exist", input.Id.ToString()));
}
var ids = input.Details.Select(d => d.ProductId).ToArray();
var products = context.Set <Product>().Where(p => ids.Contains(p.Id)).ToDictionary(p => p.Id);
var details = input.Details.Where(d => d.Count > 0).Select(d => new OrderDetail
{
ProductId = d.ProductId,
Count = d.Count,
Discount = 0m
});
order.WillCheck = input.WillCheck;
order.CheckTime = input.WillCheck ? input.CheckTime : null;
order.CheckContact = input.CheckContact;
order.CheckAddress = input.CheckAddress;
order.ReceiverName = input.ReceiverName;
order.ReceiverAddress = input.ReceiverAddress;
order.ReceiverPostCode = input.ReceiverPostCode;
order.ReceiverContact = input.ReceiverContact;
order.Details = details.ToList();
order.OriginalRealCharge = order.Details.Sum(d => d.RealCharge);
order.RealCharge = order.OriginalRealCharge;
order.UpdateTime = DateTime.Now;
context.UpdateGraph(order, o => o.OwnedCollection(oo => oo.Details));
context.SaveChanges();
return(Json("ok"));
}
}
public void SetDefault(string id)
{
using (var dbContext = new AllureContext())
{
var defaultLang = dbContext.Set <Language>().Single(l => l.IsDefault);
if (!defaultLang.Code.Equals(id))
{
var lang = dbContext.Set <Language>().SingleOrDefault(l => l.Code == id);
if (lang == null)
{
throw new Exception(string.Format("the language {0} isn't active yet.", id));
}
lang.IsDefault = true;
defaultLang.IsDefault = false;
dbContext.SaveChanges();
}
}
}
public LocaleOutput[] List()
{
using (var dbContext = new AllureContext())
{
return(dbContext
.Set <Locale>()
.Include(l => l.Localized)
.ToArray()
.Select(l => new LocaleOutput(l))
.ToArray());
}
}
private void BuildCategoryInModel(MainViewModel model)
{
using (var dbContext = new AllureContext())
{
model.Categories = dbContext
.Set <Category>()
.Include(c => c.Localized)
.Include(c => c.Children)
.ToList()
.Select(c => new CategoryOutput(c, this.LanguageCode))
.ToArray();
}
}
public void Delete(string id)
{
using (var dbContext = new AllureContext())
{
var lang = dbContext.Set <Language>().SingleOrDefault(l => l.Code == id);
if (lang != null)
{
lang.Enabled = false;
dbContext.SaveChanges();
}
}
}
public virtual ActionResult EmailExists(string email)
{
var valid = false;
if (!string.IsNullOrEmpty(email))
{
using (var context = new AllureContext())
{
valid = !context.Set <User>().Any(u => u.Email == email);
}
}
return(Content(valid.ToString().ToLowerInvariant()));
}
public OrderOutput Id(int id)
{
using (var dbContext = new AllureContext())
{
var order = dbContext.Set <Order>().SingleOrDefault(o => o.Id == id);
if (order == null)
{
throw new HttpException(404, string.Format("order {0} doesn't exist", id.ToString()));
}
return(new OrderOutput(order));
}
}
public LanguageOutput[] Current()
{
using (var dbContext = new AllureContext())
{
var languages = dbContext
.Set <Language>()
.Where(l => l.Enabled)
.ToList()
.Select(lang => new LanguageOutput(lang))
.ToArray();
return(languages);
}
}
public Brand Id(int id)
{
using (var dbContext = new AllureContext())
{
var brand = dbContext.Set <Brand>().SingleOrDefault(b => b.Id == id);
if (brand == null)
{
throw new HttpException(404, string.Format("brand {0} doesn't exist", id.ToString()));
}
return(brand);
}
}
public virtual ActionResult Submit(OrderInput input)
{
using (var context = new AllureContext())
{
var ids = input.Details.Select(d => d.ProductId).ToArray();
var products = context.Set <Product>().Where(p => ids.Contains(p.Id)).ToDictionary(p => p.Id);
var details = input.Details.Where(d => d.Count > 0).Select(d => new OrderDetail
{
ProductId = d.ProductId,
Count = d.Count,
Discount = 0m
});
var order = new Order
{
WillCheck = input.WillCheck,
CheckTime = input.WillCheck ? input.CheckTime : null,
CheckContact = input.CheckContact,
CheckAddress = input.CheckAddress,
ReceiverName = input.ReceiverName,
ReceiverAddress = input.ReceiverAddress,
ReceiverPostCode = input.ReceiverPostCode,
ReceiverContact = input.ReceiverContact,
Details = details.ToArray(),
Status = OrderStatus.New,
CustomerId = this.Identity.User.Id,
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now
};
context.Set <Order>().Add(order);
context.SaveChanges();
return(Json("ok"));
}
}
public void Delete(int id)
{
using (var dbContext = new AllureContext())
{
var brand = dbContext.Set <Brand>().SingleOrDefault(b => b.Id == id);
if (brand == null)
{
throw new Exception(string.Format("brand {0} doesn't exist", id.ToString()));
}
brand.Status = DataStatus.Deleted;
dbContext.SaveChanges();
}
}
public virtual ActionResult Products(int id)
{
using (var dbContext = new AllureContext())
{
var products = dbContext.Set <Product>()
.Include(p => p.Locale)
.Include(p => p.Localized)
.Where(p => p.SubCategoryId == id)
.ToArray()
.Select(p => new ProductOutput(p, this.LanguageCode))
.ToArray();
return(Json(products, JsonRequestBehavior.AllowGet));
}
}
public void Delete(string id)
{
using (var dbContext = new AllureContext())
{
var warehouse = dbContext.Set <Warehouse>().SingleOrDefault(l => l.Code == id);
if (warehouse == null)
{
throw new HttpException(404, string.Format("Warehouse {0} doesn't exist", id.ToString()));
}
warehouse.Status = DataStatus.Deleted;
dbContext.SaveChanges();
}
}