internal void Update(OutputInvoice parent) { try { this.RaiseListChangedEvents = false; SessionCode = parent.SessionCode; // update (thus deleting) any deleted child objects foreach (CobroFactura obj in DeletedList) { obj.DeleteSelf(parent); } // now that they are deleted, remove them from memory too DeletedList.Clear(); // add/update any current child objects foreach (CobroFactura obj in this) { if (obj.IsNew) { obj.Insert(parent); } else { obj.Update(parent); } } } finally { this.RaiseListChangedEvents = true; } }
internal void DeleteSelf(OutputInvoice parent) { // if we're not dirty then don't update the database if (!this.IsDirty) { return; } // if we're new then don't update the database if (this.IsNew) { return; } try { SessionCode = parent.SessionCode; Session().Delete(Session().Get <ChargeOperationRecord>(Oid)); } catch (Exception ex) { throw new iQPersistentException(iQExceptionHandler.GetAllMessages(ex)); } MarkNew(); }
private void BUT_Save_Click(object sender, EventArgs e) { _invoice = new OutputInvoice(Convert.ToInt32(TB_InvoiceNumber.Text), _products[0].Date, _products[0].ClientId); _queries.SaveOutputInvoice(_invoice, _products); _queries.SaveProductsSoldCount(_products); this.Close(); }
public static CQueryDef SaveIntoSaleProducts(OutputInvoice Invoice, OutputProduct Product) { var sql = string.Format(@"INSERT INTO Sale_Products(Product_Key, Count, Price, Sale_Key) VALUES('{0}', '{1}', '{2}', '{3}')", Product.Product_Key, Product.Count, Product.Price, Invoice.SaleKey); return(new CQueryDef(sql, CSqlReader.SqlStorage.ExecuteNonQuery)); }
public OutputInvoice Delete(int id) { // Load output invoice that will be deleted OutputInvoice dbEntry = context.OutputInvoices //.Include(o => o.InvoiceItems) .FirstOrDefault(x => x.Id == id && x.Active == true); if (dbEntry != null) { // Set activity dbEntry.Active = false; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; //if (dbEntry.InvoiceItems != null && dbEntry.InvoiceItems.Count > 0) //{ // foreach (var item in dbEntry.InvoiceItems) // { // if (item != null) // { // item.Active = false; // } // } //} } return(dbEntry); }
public OutputInvoiceResponse Update(OutputInvoiceViewModel oi) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { //List<OutputInvoiceItem> outputInvoiceItems = oi.ConvertToOutputInvoice().InvoiceItems; //oi.SumOfBase = outputInvoiceItems.Sum(x => x.Base); //oi.SumOfPdvValue = outputInvoiceItems.Sum(x => x.Pdv); //oi.SumOfTotalValue = outputInvoiceItems.Sum(x => x.TotalPrice); //oi.OutputInvoiceSubItems = null; OutputInvoice updatedOutputInvoice = unitOfWork.GetOutputInvoiceRepository().Update(oi.ConvertToOutputInvoice()); //unitOfWork.GetOutputInvoiceItemRepository().UpdateOutputInvoiceItems(outputInvoiceItems ?? new List<OutputInvoiceItem>(), updatedOutputInvoice); unitOfWork.Save(); response.OutputInvoice = updatedOutputInvoice.ConvertToOutputInvoiceViewModel(); response.Success = true; } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
internal void DeleteSelf(OutputInvoice parent) { // if we're not dirty then don't update the database if (!this.IsDirty) { return; } // if we're new then don't update the database if (this.IsNew) { return; } try { SessionCode = parent.SessionCode; Session().Delete(Session().Get <OutputDeliveryInvoiceRecord>(Oid)); } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkNew(); }
public OutputInvoice Create(OutputInvoice outputInvoice) { //// Attach business partner //int businessPartnerId = outputInvoice.BusinessPartner?.Id ?? 0; //outputInvoice.BusinessPartner = context.BusinessPartners // .FirstOrDefault(x => x.Id == businessPartnerId && x.Active == true); // Attach company int companyId = outputInvoice.Company?.Id ?? 0; outputInvoice.Company = context.Companies .FirstOrDefault(x => x.Id == companyId && x.Active == true); // Attach user int userId = outputInvoice?.CreatedBy?.Id ?? 0; outputInvoice.CreatedBy = context.Users .FirstOrDefault(x => x.Id == userId && x.Active == true); // Set activity outputInvoice.Active = true; // Set timestamps outputInvoice.CreatedAt = DateTime.Now; outputInvoice.UpdatedAt = DateTime.Now; // Add OutputInvoice to database context.OutputInvoices.Add(outputInvoice); return(outputInvoice); }
public void SaveOutputInvoice(OutputInvoice invoice, List <OutputProduct> products) { doQuery.Start(SqlQueries.SaveIntoSales(invoice)); foreach (var p in products) { doQuery.Start(SqlQueries.SaveIntoSaleProducts(invoice, p)); } }
public InvoiceUIForm(OutputInvoice invoice) : base(null) { InitializeComponent(); _entity = invoice.Clone(); _entity.BeginEdit(); SetFormData(); }
internal void Update(OutputInvoice parent) { // if we're not dirty then don't update the database if (!this.IsDirty) { return; } this.OidFactura = parent.Oid; ValidationRules.CheckRules(); if (!IsValid) { throw new iQValidationException(Library.Resources.Messages.GENERIC_VALIDATION_ERROR); } SessionCode = parent.SessionCode; OutputInvoiceLineRecord obj = Session().Get <OutputInvoiceLineRecord>(Oid); obj.CopyValues(Base.Record); Session().Update(obj); if (OidPartida == 0) { OutputDeliveries albaranes = OutputDeliveries.GetList(parent.GetAlbaranes(), true, true, parent.SessionCode); OutputDeliveryLine concepto = null; OutputDelivery albaran = null; foreach (OutputDelivery item in albaranes) { albaran = item; foreach (OutputDeliveryLine ca in item.Conceptos) { if (ca.Oid == OidConceptoAlbaran) { concepto = ca; break; } } if (concepto != null) { break; } } if (concepto != null) { concepto.CopyFrom(this); albaran.CalculateTotal(); } } MarkOld(); }
public static AlbaranFacturas GetChildList(OutputInvoice parent, bool childs) { CriteriaEx criteria = AlbaranFactura.GetCriteria(parent.SessionCode); criteria.Query = AlbaranFacturas.SELECT(parent); criteria.Childs = childs; return(DataPortal.Fetch <AlbaranFacturas>(criteria)); }
public static CobroFacturas GetChildList(OutputInvoice parent, bool childs) { CriteriaEx criteria = CobroFactura.GetCriteria(parent.SessionCode); criteria.Query = CobroFacturas.SELECT_BY_FACTURA(parent.Oid); criteria.Childs = childs; return(DataPortal.Fetch <CobroFacturas>(criteria)); }
public override void OpenAddForm() { InvoiceAddForm form = new InvoiceAddForm(this); AddForm(form); if (form.ActionResult == DialogResult.OK) { _entity = form.Entity; } }
public void OpenAddForm(ClienteInfo cliente, OutputDeliveryInfo delivery) { InvoiceAddForm form = new InvoiceAddForm(cliente, delivery, this); AddForm(form); if (form.ActionResult == DialogResult.OK) { _entity = form.Entity; } }
public override void UpdateList() { switch (_current_action) { case molAction.Add: case molAction.Copy: if (_entity == null) { return; } List.AddItem(_entity.GetInfo(false)); if (FilterType == IFilterType.Filter) { OutputInvoiceList listA = OutputInvoiceList.GetList((SortedBindingList <OutputInvoiceInfo>)_filter_results); listA.AddItem(_entity.GetInfo(false)); _filter_results = listA.GetSortedList(); } break; case molAction.Edit: case molAction.ChangeStateContabilizado: case molAction.ChangeStateEmitido: case molAction.Unlock: case molAction.PrintDetail: case molAction.ExportPDF: case molAction.EmailPDF: if (_entity == null) { return; } ActiveItem.CopyFrom(_entity); break; case molAction.Delete: if (ActiveItem == null) { return; } List.RemoveItem(ActiveOID); if (FilterType == IFilterType.Filter) { OutputInvoiceList listD = OutputInvoiceList.GetList((SortedBindingList <OutputInvoiceInfo>)_filter_results); listD.RemoveItem(ActiveOID); _filter_results = listD.GetSortedList(); } break; } RefreshSources(); if (_entity != null) { Select(_entity.Oid); } _entity = null; }
private static ModeloList GetList(string query, bool childs) { CriteriaEx criteria = OutputInvoice.GetCriteria(OutputInvoice.OpenSession()); criteria.Childs = childs; criteria.Query = query; ModeloList list = DataPortal.Fetch <ModeloList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public void Remove(OutputInvoice factura, OutputDeliveryInfo albaran) { foreach (AlbaranFactura item in this) { if (item.OidFactura == factura.Oid && item.OidAlbaran == albaran.Oid) { this.Remove(item.Oid); factura.SetAlbaranes(); break; } } }
internal void Update(OutputInvoice parent) { try { this.RaiseListChangedEvents = false; SessionCode = parent.SessionCode; // update (thus deleting) any deleted child objects foreach (AlbaranFactura obj in DeletedList) { if (!GetItem(obj.OidFactura, obj.OidAlbaran)) { obj.DeleteSelf(parent); } } // add/update any current child objects foreach (AlbaranFactura obj in this) { bool existe = false; if (obj.IsNew) { //Si el albarán se ha eliminado y se ha vuelto a insertar no hay que volver a guardarlo foreach (AlbaranFactura albaran in DeletedList) { if (albaran.OidAlbaran == obj.OidAlbaran) { existe = true; break; } } if (existe) { continue; } obj.Insert(parent); } else { obj.Update(parent); } } // now that they are deleted, remove them from memory too DeletedList.Clear(); } finally { this.RaiseListChangedEvents = true; } }
public static CobroFacturaList GetChildList(OutputInvoiceInfo parent, bool childs) { CriteriaEx criteria = CobroFactura.GetCriteria(OutputInvoice.OpenSession()); criteria.Query = CobroFacturaList.SELECT_BY_FACTURA(parent.Oid); criteria.Childs = childs; CobroFacturaList list = DataPortal.Fetch <CobroFacturaList>(criteria); list.CloseSession(); return(list); }
public static CobroFactura NewChild(OutputInvoice parent) { if (!CanAddObject()) { throw new System.Security.SecurityException(Library.Resources.Messages.USER_NOT_ALLOWED); } CobroFactura obj = new CobroFactura(); obj.OidFactura = parent.Oid; return(obj); }
public OutputInvoice Update(OutputInvoice outputInvoice) { // Load output invoice that will be updated OutputInvoice dbEntry = context.OutputInvoices //.Include(x => x.BusinessPartner) .Include(x => x.CreatedBy) .FirstOrDefault(x => x.Id == outputInvoice.Id && x.Active == true); if (dbEntry != null) { // Attach business partner //int businessPartnerId = outputInvoice.BusinessPartner?.Id ?? 0; //dbEntry.BusinessPartner = context.BusinessPartners // .FirstOrDefault(x => x.Id == businessPartnerId && x.Active == true); // Attach company int companyId = outputInvoice.Company?.Id ?? 0; dbEntry.Company = context.Companies .FirstOrDefault(x => x.Id == companyId && x.Active == true); // Attach user int userId = outputInvoice?.CreatedBy?.Id ?? 0; dbEntry.CreatedBy = context.Users .FirstOrDefault(x => x.Id == userId && x.Active == true); // Set properties dbEntry.Code = outputInvoice.Code; dbEntry.Construction = outputInvoice.Construction; dbEntry.InvoiceDate = outputInvoice.InvoiceDate; dbEntry.BusinessPartner = outputInvoice.BusinessPartner; dbEntry.InvoiceType = outputInvoice.InvoiceType; dbEntry.Quantity = outputInvoice.Quantity; dbEntry.TrafficDate = outputInvoice.TrafficDate; dbEntry.Price = outputInvoice.Price; dbEntry.Rebate = outputInvoice.Rebate; dbEntry.RebateValue = outputInvoice.RebateValue; dbEntry.Base = outputInvoice.Base; dbEntry.PDV = outputInvoice.PDV; dbEntry.Total = outputInvoice.Total; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); }
public OutputInvoice Create(OutputInvoice outputInvoice) { if (context.OutputInvoices.Where(x => x.Identifier != null && x.Identifier == outputInvoice.Identifier).Count() == 0) { outputInvoice.Id = 0; outputInvoice.Code = GetNewCodeValue(outputInvoice.CompanyId ?? 0); outputInvoice.Active = true; outputInvoice.UpdatedAt = DateTime.Now; outputInvoice.CreatedAt = DateTime.Now; context.OutputInvoices.Add(outputInvoice); return(outputInvoice); } else { // Load favor that will be updated OutputInvoice dbEntry = context.OutputInvoices .FirstOrDefault(x => x.Identifier == outputInvoice.Identifier && x.Active == true); if (dbEntry != null) { dbEntry.BusinessPartnerId = outputInvoice.BusinessPartnerId ?? null; dbEntry.CompanyId = outputInvoice.CompanyId ?? null; dbEntry.CreatedById = outputInvoice.CreatedById ?? null; // Set properties dbEntry.Code = outputInvoice.Code; dbEntry.Supplier = outputInvoice.Supplier; dbEntry.Address = outputInvoice.Address; dbEntry.InvoiceNumber = outputInvoice.InvoiceNumber; dbEntry.InvoiceDate = outputInvoice.InvoiceDate; dbEntry.AmountNet = outputInvoice.AmountNet; dbEntry.PdvPercent = outputInvoice.PdvPercent; dbEntry.Pdv = outputInvoice.Pdv; dbEntry.AmountGross = outputInvoice.AmountGross; dbEntry.Currency = outputInvoice.Currency; dbEntry.DateOfPayment = outputInvoice.DateOfPayment; dbEntry.Status = outputInvoice.Status; dbEntry.StatusDate = outputInvoice.StatusDate; dbEntry.Description = outputInvoice.Description; dbEntry.Path = outputInvoice.Path; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); } }
public OutputInvoice GetOutputInvoice(int id) { OutputInvoice outputInvoice = context.OutputInvoices .Include(x => x.CreatedBy) //.Include(x => x.InvoiceItems) .FirstOrDefault(x => x.Id == id && x.Active == true); //if (outputInvoice != null && outputInvoice.InvoiceItems != null) //{ // outputInvoice.InvoiceItems.RemoveAll(x => x.Active == false); //} return(outputInvoice); }
public static OutputInvoiceViewModel ConvertToOutputInvoiceViewModel(this OutputInvoice outputInvoice) { OutputInvoiceViewModel outputInvoiceViewModel = new OutputInvoiceViewModel() { Id = outputInvoice.Id, Code = outputInvoice.Code, Construction = outputInvoice.Construction, InvoiceDate = outputInvoice.InvoiceDate, BusinessPartner = outputInvoice.BusinessPartner, InvoiceType = outputInvoice.InvoiceType, Quantity = outputInvoice.Quantity, TrafficDate = outputInvoice.TrafficDate, Price = outputInvoice.Price, Rebate = outputInvoice.Rebate, RebateValue = outputInvoice.RebateValue, Base = outputInvoice.Base, PDV = outputInvoice.PDV, Total = outputInvoice.Total, //Status = outputInvoice.Status, //IsLocked = outputInvoice.IsLocked, //LockedDate = outputInvoice.LockedDate, Company = outputInvoice.Company?.ConvertToCompanyViewModelLite(), UpdatedAt = outputInvoice.UpdatedAt, CreatedAt = outputInvoice.CreatedAt, //IsCancelItem = outputInvoice.IsCancelItem, }; //if (outputInvoice.InvoiceItems != null && outputInvoice.InvoiceItems.Count > 0) //{ // outputInvoiceViewModel.OutputInvoiceSubItems = new ObservableCollection<OutputInvoiceSubItemViewModel>(outputInvoice.InvoiceItems.ConvertToOutputInvoiceSubItemViewModelListLite()); //} //else //{ // outputInvoiceViewModel.OutputInvoiceSubItems = new ObservableCollection<OutputInvoiceSubItemViewModel>(); //} return(outputInvoiceViewModel); }
public static FacREAList GetNoCobradas() { CriteriaEx criteria = OutputInvoice.GetCriteria(OutputInvoice.OpenSession()); criteria.Childs = false; if (nHManager.Instance.UseDirectSQL) { criteria.Query = FacREAList.SELECT_NO_COBRADAS(); } FacREAList list = DataPortal.Fetch <FacREAList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public OutputInvoice Delete(Guid identifier) { // Load OutputInvoice that will be deleted OutputInvoice dbEntry = context.OutputInvoices .FirstOrDefault(x => x.Identifier == identifier && x.Active == true); if (dbEntry != null) { // Set activity dbEntry.Active = false; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); }
public static REAResumen Get(Expedient expediente) { CriteriaEx criteria = OutputInvoice.GetCriteria(OutputInvoice.OpenSession()); if (nHManager.Instance.UseDirectSQL) { criteria.Query = REAResumen.SELECT(expediente); } OutputInvoice.BeginTransaction(criteria.Session); REAResumen obj = DataPortal.Fetch <REAResumen>(criteria); OutputInvoice.CloseSession(criteria.SessionCode); return(obj); }
public OutputInvoice SetInvoiceStatus(int id, int status) { OutputInvoice dbEntry = context.OutputInvoices .FirstOrDefault(x => x.Id == id && x.Active == true); if (dbEntry != null) { // Set status //dbEntry.Status = status; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); }
public static FacREAList GetListByCobro(long oid_cobro) { CriteriaEx criteria = OutputInvoice.GetCriteria(OutputInvoice.OpenSession()); criteria.Childs = false; //No criteria. Retrieve all de List if (nHManager.Instance.UseDirectSQL) { criteria.Query = FacREAList.SELECT_BY_COBRO(oid_cobro); } FacREAList list = DataPortal.Fetch <FacREAList>(criteria); CloseSession(criteria.SessionCode); return(list); }