public ImportController(VERPSDBContext context, ILogger <ImportController> logger) { _logger = logger; _context = context; _dbHelper = new DBHelper(); _exactHelper = new ExactHelper(); }
public ConfigurationController(VERPSDBContext context, IHtmlLocalizer <ConfigurationController> loc) { _context = context; _exactHelper = new ExactHelper(); _dbHelper = new DBHelper(); _loc = loc; }
public ExactSupplier CreateOrGetSupplier(VERPSDBContext context, Account supplier, string exactUserId, ILogger logger) { var dbSupplier = context.ExactSuppliers .FirstOrDefault(x => x.ExactUser.ToString() == exactUserId && x.ExactId == supplier.ID); // Create new if (dbSupplier == null) { logger.LogInformation($"New supplier with GUID: {supplier.ID} created for User: {exactUserId}"); return(new ExactSupplier { Name = supplier.Name, Currency = supplier.Currency, Email = supplier.Email, Phone = supplier.Phone, VATNumber = supplier.VATNumber, ExactId = supplier.ID, Website = supplier.Website, Zipcode = supplier.Postcode, ExactUser = new Guid(exactUserId), }); } else { return(dbSupplier); } }
public ExternalLoginModel( SignInManager <User> signInManager, UserManager <User> userManager, ILogger <ExternalLoginModel> logger, VERPSDBContext context) { _signInManager = signInManager; _userManager = userManager; _logger = logger; _context = context; }
public ExactConfigurationVM GetExactConfig(VERPSDBContext context, int id) { return(context.ExactConfigurations .Where(x => x.Id == id) .Select(x => new ExactConfigurationVM { Id = x.Id, ItemGroupId = x.ItemGroupId, SupplierId = new Guid(x.SupplierId), PaymentConditionId = x.PaymentConditionId, UserId = x.BuyerId, ConfigType = x.ConfigType, }) .FirstOrDefault()); }
public UserVM GetUser(VERPSDBContext context, string userName) { return(context.Users .Where(x => x.UserName == userName) .Select(x => new UserVM { Id = x.Id, CompanyName = x.CompanyName, ConfigID = x.ExactConfiguration.Id, DivisionId = x.ExactConfiguration.DivsionId, CreatorId = x.UserID, UserName = x.UserName, ItemGroupId = x.ExactConfiguration.ItemGroupId.ToString(), SupplierId = x.ExactConfiguration.SupplierId.ToString(), Token = x.ExactToken.Token, }) .FirstOrDefault()); }
public DashboardController(VERPSDBContext context) { _context = context; _exactHelper = new ExactHelper(); _dbHelper = new DBHelper(); }
public OrderManagementController(VERPSDBContext context) { _context = context; _dbHelper = new DBHelper(); _exactHelper = new ExactHelper(); }
public ExactOrderVM GetExactOrderByIdToVM(VERPSDBContext context, int Id) { var order = context.ExactOrders //.Include(nameof(ExactOrder.Lines) + "." + nameof(ExactOrderLine.Item)) //.Include(nameof(ExactOrder.DBUser)) .Where(x => x.Id == Id) .Select(x => new { x.Id, x.Description, x.Created, x.Currency, x.Project, x.OrderNumber, x.YourRef, x.Document, x.OrderDate, x.PaymentCondition, UserGuid = x.User, supplierName = x.Supplier.Name, x.CreatorId, Lines = x.Lines .Select(y => new { Id = y.Id, Item = new { y.Item.Id, y.Item.ExactID, y.Item.Name, y.Item.Description, y.Item.Code, y.Item.IsComplete, y.Item.MessageSeen, }, Description = y.Description, Quantity = y.Quantity, Unit = y.Unit, NetPrice = y.NetPrice, ReceiptDate = y.ReceiptDate, VATCode = y.VATCode, VATPercentage = y.VATPercentage, AmountDC = y.AmountDC, VATAmount = y.VATAmount, Project = y.Project, }) .ToList(), x.IsStoredInExact, x.ItemsAreInExact, User = new { Id = x.DBUser.Id, Email = x.DBUser.Email }, x.TimeSend, }) .ToList(); var result = order.Select(x => new ExactOrderVM { Id = x.Id, Description = x.Description, Created = x.Created, Currency = x.Currency, Project = x.Project, OrderNumber = x.OrderNumber, YourRef = x.YourRef, Document = x.Document, OrderDate = x.OrderDate, PaymentConditionId = x.PaymentCondition, CreatorId = x.User.Id, SupplierName = x.supplierName, Lines = x.Lines .Select(y => new OrderLineVM { Id = y.Id, Item = new ItemVM { Id = y.Item.Id, ExactId = y.Item.ExactID, Code = y.Item.Code, Description = y.Item.Description, Name = y.Item.Name, MessageSeen = y.Item.MessageSeen, IsComplete = y.Item.IsComplete, }, Description = y.Description, Quantity = y.Quantity, Unit = y.Unit, NetPrice = y.NetPrice, ReceiptDate = y.ReceiptDate, VATCode = y.VATCode, VATPercentage = y.VATPercentage, AmountDC = y.AmountDC, VATAmount = y.VATAmount, Project = y.Project, }) .ToList(), IsStoredInExact = x.IsStoredInExact, ItemsAreInExact = x.ItemsAreInExact, DBUser = new DBUserVM { Id = x.User.Id, Email = x.User.Email, }, TimeSend = x.TimeSend, }) .FirstOrDefault(); return(result); }
public List <ExactSupplierConfig> GetExactSupplierConfigs(VERPSDBContext context, string userId) { return(context.ExactSupplierConfigurations .Where(x => x.User.Id == userId) .ToList()); }
public HomeController(IHtmlLocalizer <HomeController> loc, VERPSDBContext context) { _loc = loc; _context = context; }
public SupplierConfigController(VERPSDBContext context) { _context = context; _exactHelper = new ExactHelper(); _dbHelper = new DBHelper(); }