public ActionResult Index() { using (var context = dataContextFactory.CreateByUser()) { var viewModel = new HomeViewModel(context.GetUser(HttpContext.User.Identity)); return(View(viewModel)); } }
/// <summary> /// Show a list of CustomerAppIssues by CustomerApp /// </summary> /// <param name="customerAppId">CustomerApp to show Issues for</param> /// <returns></returns> public ActionResult Index(Guid customerAppId) { using (var context = dataContextFactory.CreateByUser()) { var customerAppIssues = (from x in context.CustomerAppIssues where x.CustomerAppId == customerAppId select x); var viewModel = new CustomerAppIssueIndexViewModel(customerAppIssues); return(View(viewModel)); } }
/// <summary> /// Get list of SKUs /// </summary> /// <returns>SKU index list view</returns> public ActionResult Index() { using (var context = dataContextFactory.CreateByUser()) { //Eager loading SKU var SKUQuery = (from x in context.SKUs select x).Include(x => x.PrivateKey) .Include(x => x.SkuFeatures.Select(f => f.Feature)) .OrderBy(x => x.SkuCode); SKUIndexViewModel viewModel = new SKUIndexViewModel(SKUQuery.ToList()); return(View(viewModel)); } }
public ActionResult IndexPartial(int userId) { using (var context = dataContextFactory.CreateByUser()) { var objectRightsQuery = (from x in context.UserVendorRights where x.UserId == userId select x as UserObjectRight) .Union(from x in context.UserCustomerRights where x.UserId == userId select x as UserObjectRight) .Union(from x in context.UserLicenseRights where x.UserId == userId select x as UserObjectRight) .Include(x => x.Right); var viewModel = new UserObjectRightIndexViewModel(context.GetUser(HttpContext.User.Identity), userId, objectRightsQuery.ToList()); return(PartialView(viewModel)); } }
/// <summary> /// Get list of Customers /// </summary> /// <returns>Customer index list view</returns> public ActionResult Index() { using (var context = dataContextFactory.CreateByUser()) { //Eager loading Customer var customerQuery = (from x in context.Customers select x) .Include(x => x.Country) .OrderBy(x => x.Name); var viewModel = new CustomerIndexViewModel(context.GetUser(HttpContext.User.Identity), customerQuery.ToList()); return(View(viewModel)); } }
/// <summary> /// Get list of transactions /// </summary> /// <returns>Transaction index list view</returns> public ActionResult Index() { using (var context = dataContextFactory.CreateByUser()) { //Eager loading Transaction var transactionQuery = (from x in context.Transactions orderby x.CreatedDateTime select x) .Include(x => x.TransactionItems.Select(s => s.Sku)) .Include(x => x.TransactionItems.Select(s => s.License)); var viewModel = new TransactionIndexViewModel(transactionQuery.OrderByDescending(x => x.CreatedDateTime).ToList()); return(View(viewModel)); } }
/// <summary> /// Start a new basket /// </summary> /// <param name="dataContextFactory">Data context factory</param> /// <returns>An instance of a basketwrapper serving a new transaction</returns> public static BasketWrapper CreateNewByIdentity(IDataContextFactory dataContextFactory) { var basket = new BasketWrapper(dataContextFactory.CreateByUser()); basket.Transaction = new Transaction {CreatedDateTime = DateTime.Now}; return basket; }
/// <summary> /// Get list of features /// </summary> /// <returns>Feature index list view</returns> public ActionResult Index() { using (var context = dataContextFactory.CreateByUser()) { //Authorized vendors var vendorGuids = (from v in context.Vendors select v).Select(x => x.ObjectId).ToList(); //Eager loading feature var featureQuery = (from f in context.Features where vendorGuids.Contains(f.VendorId) orderby f.FeatureCode select f) .Include(x => x.Vendor) .OrderBy(x => x.FeatureName); FeatureIndexViewModel viewModel = new FeatureIndexViewModel(featureQuery.ToList()); return(View(viewModel)); } }
/// <summary> /// Start a new basket /// </summary> /// <param name="dataContextFactory">Data context factory</param> /// <returns>An instance of a basketwrapper serving a new transaction</returns> public static BasketWrapper CreateNewByIdentity(IDataContextFactory dataContextFactory) { var basket = new BasketWrapper(dataContextFactory.CreateByUser()); basket.Transaction = new Transaction { CreatedDateTime = DateTime.Now }; return(basket); }
public ActionResult IndexPartial(Guid parentVendor) { using (var context = dataContextFactory.CreateByUser()) { var privateKeyQuery = (from x in context.PrivateKeys where x.VendorId == parentVendor orderby x.DisplayName select x); var vendorQuery = (from v in context.Vendors where v.ObjectId == parentVendor select v); PrivateKeyIndexViewModel viewModel = new PrivateKeyIndexViewModel(privateKeyQuery.ToList(), vendorQuery.FirstOrDefault()); return(PartialView(viewModel)); } }
public ActionResult IndexPartial(Guid parentLicense) { using (var context = dataContextFactory.CreateByUser()) { var domainLicenseQuery = (from x in context.DomainLicenses where x.LicenseId == parentLicense orderby x.DomainName select x) .Include(x => x.License.Sku); var viewModel = new DomainLicenseIndexViewModel(parentLicense, domainLicenseQuery.ToList()); return(PartialView(viewModel)); } }
public static VendorCredentialModel ForCreate(IDataContextFactory contextFactory, Guid vendorId) { VendorCredentialModel result; using (var context = contextFactory.CreateByUser()) { var vendor = (from x in context.Vendors where x.ObjectId == vendorId select x).FirstOrDefault(); result = new VendorCredentialModel() { VendorId = vendor.ObjectId, VendorName = vendor.Name, }; } return result; }
public static VendorCredentialModel ForCreate(IDataContextFactory contextFactory, Guid vendorId) { VendorCredentialModel result; using (var context = contextFactory.CreateByUser()) { var vendor = (from x in context.Vendors where x.ObjectId == vendorId select x).FirstOrDefault(); result = new VendorCredentialModel() { VendorId = vendor.ObjectId, VendorName = vendor.Name, }; } return(result); }
/// <summary> /// Get list of CustomerApps /// </summary> /// <returns>CustomerApp index list view</returns> public ActionResult Index() { using (var context = dataContextFactory.CreateByUser()) { //Eager loading CustomerApp, includes Licenses and from License the SKUs var customerAppQuery = (from x in context.CustomerApps select x).Include(x => x.LicenseCustomerApps) .Include(x => x.LicenseCustomerApps.Select(s => s.License)) .Include(x => x.CustomerAppIssues) .OrderBy(x => x.ApplicationName); var viewModel = new CustomerAppIndexViewModel(customerAppQuery.ToList()); return(View(viewModel)); } }
/// <summary> /// Get list of vendors /// </summary> /// <returns>Vendor index list view</returns> public ActionResult Index() { using (var context = dataContextFactory.CreateByUser()) { //Eager loading Vendor var vendorQuery = (from v in context.Vendors select v).Include(x => x.Country);//.FilterByUser(UserEntity); var viewModel = new VendorIndexViewModel(context.GetUser(HttpContext.User.Identity), vendorQuery.ToList()); return(View(viewModel)); } }
public static VendorCredentialModel ForEdit(IDataContextFactory dataContextFactory, Guid key) { VendorCredentialModel result; using (var dataContext = dataContextFactory.CreateByUser()) { var vendorCredential = dataContext.VendorCredentials.Where(vs => vs.VendorCredentialId == key).Include(x => x.Vendor).Single(); result = new VendorCredentialModel() { VendorId = vendorCredential.Vendor.ObjectId, VendorName = vendorCredential.Vendor.Name, VendorCredentialId = vendorCredential.VendorCredentialId, CredentialName = vendorCredential.CredentialName, CredentialValue = Encoding.UTF8.GetString(SymmetricEncryption.DecryptForDatabase(vendorCredential.CredentialValue)) }; } return(result); }
public static VendorCredentialModel ForEdit(IDataContextFactory dataContextFactory, Guid key) { VendorCredentialModel result; using (var dataContext = dataContextFactory.CreateByUser()) { var vendorCredential = dataContext.VendorCredentials.Where(vs => vs.VendorCredentialId == key).Include(x => x.Vendor).Single(); result = new VendorCredentialModel() { VendorId = vendorCredential.Vendor.ObjectId, VendorName = vendorCredential.Vendor.Name, VendorCredentialId = vendorCredential.VendorCredentialId, CredentialName = vendorCredential.CredentialName, CredentialValue = Encoding.UTF8.GetString(SymmetricEncryption.DecryptForDatabase(vendorCredential.CredentialValue)) }; } return result; }
/// <summary> /// Get list of Licenses /// </summary> /// <returns>License index list view</returns> public ActionResult Index() { using (var context = dataContextFactory.CreateByUser()) { //Eager loading License var licenseQuery = (from x in context.Licenses select x).Include(x => x.PurchasingCustomer) .Include(x => x.OwningCustomer) .Include(x => x.Sku) .OrderBy(x => x.OwningCustomer.Name); LicenseIndexViewModel viewModel = new LicenseIndexViewModel(context.GetUser(HttpContext.User.Identity), licenseQuery.ToList()); return(View(viewModel)); } }