public SalesDocService(IServiceProvider serviceProvider, PosDbContext dbContext) { DbContext = dbContext; ServiceProvider = serviceProvider; DbSet = dbContext.Set <SalesDoc>(); IdentityService = serviceProvider.GetService <IIdentityService>(); }
public PosUnitOfWork(PosDbContext context) { _context = context; AlmacenesRepository = new AlmacenesRepository(_context); CatalogoSatRepository = new CatalogoSatRepository(_context); ComprasRepository = new ComprasRepository(_context); CortesRepository = new CortesRepository(_context); DepartamentosRepository = new DepartamentosRepository(_context); ImpuestoProductosRepository = new ImpuestoProductosRepository(_context); ImpuestosRepository = new ImpuestosRepository(_context); MarcaRepository = new MarcaRepository(_context); OrdenesRepository = new OrdenesRepository(_context); PantallasRepository = new PantallasRepository(_context); PantallasUsuarioRepository = new PantallasUsuarioRepository(_context); PLUProductoRepository = new PLUProductosRepository(_context); ProductoAlmacenRepository = new ProductoAlmacenRepository(_context); ProductosCompraRepository = new ProductosCompraRepository(_context); ProductosOrdenRepository = new ProductosOrdenRepository(_context); ProductosPromocionRepository = new ProductosPromocionRepository(_context); ProductosProveedorRepository = new ProductosProveedorRepository(_context); ProductosRepository = new ProductosRepository(_context); ProductosVentaRepository = new ProductosVentaRepository(_context); PromocionesRepository = new PromocionesRepository(_context); ProveedoresRepository = new ProveedoresRepository(_context); RetirosRepository = new RetirosRepository(_context); TipoPagoRepository = new TipoPagoRepository(_context); TipoUsuarioRepository = new TipoUsuarioRepository(_context); TurnosRepository = new TurnosRepository(_context); UnidadesRepository = new UnidadesRepository(_context); UnidadSatRepository = new UnidadSatRepository(_context); UsuariosRepository = new UsuariosRepository(_context); VentaImpuestosRepository = new VentaImpuestosRepository(_context); VentaPagosRepository = new VentaPagosRepository(_context); VentasRepository = new VentasRepository(_context); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env, PosDbContext dbContext) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Home/Error"); // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts. app.UseHsts(); } dbContext.Database.EnsureCreated(); app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthorization(); app.UseSession(); app.UseEndpoints(endpoints => { endpoints.MapControllerRoute( name: "default", pattern: "{controller=Login}/{action=Login}/{id?}"); }); }
public bool IsPartyUpdated(Party party) { PosDbContext db = new PosDbContext(); db.Parties.Attach(party); db.Entry(party).State = EntityState.Modified; return(db.SaveChanges() > 0); }
public DiscountService(IServiceProvider serviceProvider, PosDbContext dbContext) { DbContext = dbContext; ServiceProvider = serviceProvider; DbSet = dbContext.Set <Discount>(); DbSetDiscountStore = dbContext.Set <DiscountStore>(); IdentityService = serviceProvider.GetService <IIdentityService>(); }
public bool Update(Employee employee) { PosDbContext db = new PosDbContext(); db.Employees.Attach(employee); db.Entry(employee).State = EntityState.Modified; return(db.SaveChanges() > 0); }
public bool Update(ExpenseCategory category) { PosDbContext db = new PosDbContext(); db.ExpenseCategories.Attach(category); db.Entry(category).State = EntityState.Modified; return(db.SaveChanges() > 0); }
public bool Update(Organization organization) { PosDbContext db = new PosDbContext(); db.Organizations.Attach(organization); db.Entry(organization).State = EntityState.Modified; return(db.SaveChanges() > 0); }
public BaseRepository(PosDbContext dbContext) { if (dbContext == null) { throw new ArgumentNullException("dbContext"); } Db = dbContext; DbSet = dbContext.Set <T>(); }
public Documentos Get(Guid id) { using PosDbContext context = new PosDbContext(); var Documento = context.Documentos //Indicamos la tabla .Where(x => x.IdDocumento == id) .First(); //Seleccionamos el primero return(Documento); }
public SalesDocReturnService(IServiceProvider serviceProvider, PosDbContext dbContext, ISalesDocService salesDocService) { DbContext = dbContext; ServiceProvider = serviceProvider; DbSet = dbContext.Set <SalesDocReturn>(); DbSetSalesDoc = dbContext.Set <SalesDoc>(); DbSetSales = DbContext.Set <SalesDocDetailReturnItem>(); salesDocFacade = salesDocService; IdentityService = serviceProvider.GetService <IIdentityService>(); }
public bool Update(ItemCategory category) { PosDbContext db = new PosDbContext(); db.ItemCategories.Attach(category); db.Entry(category).State = EntityState.Modified; bool isUpdate = db.SaveChanges() > 0; return(isUpdate); }
public static void SeedHostDb(PosDbContext context) { context.SuppressAutoSetTenantId = true; // Host seed new InitialHostDbBuilder(context).Create(); // Default tenant seed (in host database). new DefaultTenantBuilder(context).Create(); new TenantRoleAndUserBuilder(context, 1).Create(); new DefaultCustomerBuilder(context).Create(); new DefaultProductBuilder(context).Create(); }
private Customer CustomerGetById(int?id) { PosDbContext db = new PosDbContext(); foreach (Customer aCustomer in db.Customers) { if (aCustomer.id == id) { return(aCustomer); } } return(null); }
/// <summary>Make a repository of type T.</summary> /// <typeparam name="T">Type of repository to make.</typeparam> /// <param name="dbContext"> /// The <see cref="DbContext"/> with which to initialize the repository. /// </param> /// <param name="factory"> /// Factory with <see cref="DbContext"/> argument. Used to make the repository. /// If null, gets factory from <see cref="_repositoryFactories"/>. /// </param> /// <returns></returns> protected virtual T MakeRepository <T>(Func <PosDbContext, object> factory, PosDbContext dbContext) { var f = factory ?? _repositoryFactories.GetRepositoryFactory <T>(); if (f == null) { throw new NotImplementedException("No factory for repository type, " + typeof(T).FullName); } var repo = (T)f(dbContext); Repositories[typeof(T)] = repo; return(repo); }
protected BaseController(IOptions <DatabaseSettings> dbSettings, IHostingEnvironment environment) { DbSettings = dbSettings; Environment = environment; //ErpDbContext = new ErpDbContext(DbSettings.Value.ConnString); PosDbContext = new PosDbContext(DbSettings.Value.ConnString); SecurityDbContext = new SecurityDbContext(DbSettings.Value.ConnString); //ToolsDbContext = new ToolsDbContext(DbSettings.Value.ConnString); //PayrollUoW = new PayrollUnitOfWork(ErpDbContext); PosUoW = new PosUnitOfWork(PosDbContext); SecurityUoW = new SecurityUnitOfWork(SecurityDbContext); //ToolsUoW = new ToolsUnitOfWork(ToolsDbContext); }
public Response <Documentos> Post(InvoiceType Documento) { FactElectronica Fact = new FactElectronica(); var Res = Fact.GeneraDocumentoElectronicoXML(Documento); if (Res.CodResponse == "0") { using (PosDbContext context = new PosDbContext()) { context.Add(Res.Data); //Guardamos los cambios context.SaveChanges(); } } Res.Data.IdTramaNavigation.Documentos = null; return(Res); }
public ActionResult Edit(Customer aCustomer) { PosDbContext db = new PosDbContext(); Customer existingCustomer = db.Customers.Find(aCustomer.id); if (existingCustomer != null) { existingCustomer.Name = aCustomer.Name; existingCustomer.Email = aCustomer.Email; existingCustomer.Address = aCustomer.Address; } if (db.SaveChanges() > 0) { ViewBag.message = "Customer Updated Sucessfully"; } return(View(existingCustomer)); }
public DepartamentosRepository(PosDbContext context) : base(context) { }
public UserRepository(PosDbContext dbContext) { db = dbContext; }
public ProductPremiseRepository(PosDbContext dbContext) : base(dbContext) { }
public PLUProductosRepository(PosDbContext context) : base(context) { }
public TipoPagoRepository(PosDbContext context) : base(context) { }
public ProductosProveedorRepository(PosDbContext context) : base(context) { }
public ProductMovementRepository(PosDbContext dbContext) : base(dbContext) { }
public DefaultProductBuilder(PosDbContext context) { _context = context; }
public DefaultTenantBuilder(PosDbContext context) { _context = context; }
public UnidadSatRepository(PosDbContext context) : base(context) { }
public ProveedoresRepository(PosDbContext context) : base(context) { }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { //if (code == null || code == "") //{ // yield return new ValidationResult("code is required", new List<string> { "code" }); //} if (store == null || store.Id == 0) { yield return(new ValidationResult("store is required", new List <string> { "storeId" })); } PosDbContext posDbContext = (PosDbContext)validationContext.GetService(typeof(PosDbContext)); if (posDbContext.SalesDocs.Where(x => x.Id == Convert.ToInt32(reference)).Count() == 0) { yield return(new ValidationResult("salesId not Found", new List <string> { "reference" })); } if (salesDetail == null) { yield return(new ValidationResult("salesDetail is required", new List <string> { "salesDetail" })); } if (salesDetail.paymentType == null || salesDetail.paymentType == "") { yield return(new ValidationResult("paymentType is required", new List <string> { "paymentType" })); } if (salesDetail.paymentType == "Card" || salesDetail.paymentType == "Partial") { if (salesDetail.card == null || salesDetail.card == "") { yield return(new ValidationResult("card is required", new List <string> { "card" })); } if (salesDetail.cardType == null || salesDetail.cardType._id == 0) { yield return(new ValidationResult("cardType is required", new List <string> { "cardTypeId" })); } if (salesDetail.bank == null || salesDetail.bank._id == 0) { yield return(new ValidationResult("bank is required", new List <string> { "bankId" })); } if (salesDetail.bankCard == null || salesDetail.bankCard._id == 0) { yield return(new ValidationResult("bankCard is required", new List <string> { "bankCardId" })); } if (string.IsNullOrWhiteSpace(salesDetail.cardNumber)) { yield return(new ValidationResult("cardNumber is required", new List <string> { "cardNumber" })); } if (string.IsNullOrWhiteSpace(salesDetail.cardName)) { yield return(new ValidationResult("bankCard is required", new List <string> { "cardName" })); } } if (date == null) { yield return(new ValidationResult("date is not valid", new List <string> { "date" })); } int itemErrorCount = 0; int returnitemsErrorCount = 0; if (this.items == null || items.Count <= 0) { yield return(new ValidationResult("item is required", new List <string> { "itemcount" })); } else { string itemError = "["; var index = 0; foreach (var item in items) { index++; itemError += "{"; if (item.item.item._id == 0) { itemErrorCount++; itemError += "itemId: 'itemId is required', "; } else { for (var i = index; i < items.Count(); i++) { if (item.item.item._id == items[i].item.item._id) { itemErrorCount++; itemError += "itemId : 'itemId already exists on another detail',"; } } var sales = from a in posDbContext.SalesDocs join b in posDbContext.SalesDocDetails on a.Id equals b.SalesDocId where a.Id == Convert.ToInt16(reference) select new { b.ItemId }; if (sales.Where(x => x.ItemId == item.item.item._id).Count() == 0) { itemErrorCount++; itemError += "itemId : 'itemId not exists in sales',"; } } if (item.quantity == 0) { itemErrorCount++; itemError += "quantity : 'quantity is required',"; } else if (item.quantity <= 0) { itemErrorCount++; itemError += "quantity : 'quantity must be greater than 0',"; } else { var sales = from a in posDbContext.SalesDocs join b in posDbContext.SalesDocDetails on a.Id equals b.SalesDocId where a.Code == reference select new { b.Quantity, b.ItemId, a.isReturn }; foreach (var itemsales in sales) { if (!itemsales.isReturn && itemsales.ItemId == item.item.item._id) { if (item.quantity > itemsales.Quantity) { itemErrorCount++; itemError += "quantity : 'quantity must not be greater than sales.Quantity',"; } } } } if (item.price == 0) { itemErrorCount++; itemError += "price : 'price is required',"; } else if (item.price < 0) { itemErrorCount++; itemError += "price : 'price must be greater than 0',"; } if (item.discount1 < 0 || item.discount1 > 100) { itemErrorCount++; itemError += "discount1 : 'discount1 must be greater than 0 or less than 100',"; } if (item.discount2 < 0 || item.discount2 > 100) { itemErrorCount++; itemError += "discount2 : 'discount2 must be greater than 0 or less than 100',"; } if (item.discountNominal < 0) { itemErrorCount++; itemError += "discountNominal : 'discountNominal must be greater than 0 ',"; } if (item.margin < 0) { itemErrorCount++; itemError += "margin : 'margin must be greater than 0 ',"; } if (item.specialDiscount < 0) { itemErrorCount++; itemError += "specialDiscount : 'specialDiscount must be greater than 0 ',"; } if (item.returnItems == null) { itemErrorCount++; itemError += "returnitems: 'returnitems is required', "; } else { string returnItemErrors = "["; foreach (var i in item.returnItems) { if (i.item._id == 0) { returnitemsErrorCount++; returnItemErrors += "itemId: itemId is required"; } foreach (var a in items) { foreach (var t in a.returnItems) { if (i.item._id == a.item.item._id) { returnitemsErrorCount++; returnItemErrors += "itemId : 'itemId already exists on another detail',"; } } } if (i.quantity == 0) { returnitemsErrorCount++; returnItemErrors += "quantity : 'quantity is required',"; } else if (i.quantity <= 0) { returnitemsErrorCount++; returnItemErrors += "quantity : 'quantity must be greater than 0',"; } if (i.price == 0) { returnitemsErrorCount++; returnItemErrors += "price : 'price is required',"; } else if (i.price < 0) { returnitemsErrorCount++; returnItemErrors += "price : 'price must be greater than 0',"; } if (i.discount1 < 0 || i.discount1 > 100) { returnitemsErrorCount++; returnItemErrors += "discount1 : 'discount1 must be greater than 0 or less than 100',"; } if (i.discount2 < 0 || i.discount2 > 100) { returnitemsErrorCount++; returnItemErrors += "discount2 : 'discount2 must be greater than 0 or less than 100',"; } if (i.discountNominal < 0) { returnitemsErrorCount++; returnItemErrors += "discountNominal : 'discountNominal must be greater than 0 ',"; } if (i.margin < 0) { returnitemsErrorCount++; returnItemErrors += "margin : 'margin must be greater than 0 ',"; } if (i.specialDiscount < 0) { returnitemsErrorCount++; returnItemErrors += "specialDiscount : 'specialDiscount must be greater than 0 ',"; } if (i.quantity > i.stock || i.stock == 0) { returnitemsErrorCount++; returnItemErrors += "quantity : 'Stok Tidak Tersedia ',"; } returnItemErrors += "}, "; } returnItemErrors += "]"; if (returnitemsErrorCount > 0) { itemErrorCount++; itemError += $"returnItems: {returnItemErrors }, "; } } itemError += "}, "; } itemError += "]"; if (itemErrorCount > 0) { yield return(new ValidationResult(itemError, new List <string> { "items" })); } } }