public void UpdateInvoice(Invoice invoice) { try { var currentInvoice = context.Invoices.Find(invoice.InvoiceID); context.Entry(currentInvoice).CurrentValues.SetValues(invoice); SaveChanges(); } catch (Exception ex) { throw ex; } }
public List<Invoice> GetInvoice(Invoice invoice) { var invoices = (from p in context.Invoices where p.InvoiceNumber == invoice.InvoiceNumber && p.CompanyID==invoice.CompanyID select p).ToList(); return invoices; }
public long InsertInvoice(Invoice invoice) { try { context.Entry(invoice).State = EntityState.Added; SaveChanges(); return invoice.InvoiceID; } catch (Exception ex) { throw ex; } }
public long OrderToInvoiceInsert(Invoice invoice) { return invoiceRepository.InsertInvoice(invoice); }
protected void ConvertButton_Click(object sender, EventArgs e) { long invoiceID; int companyid = Convert.ToInt32(HttpContext.Current.Session["CompanyID"]); long userid = Convert.ToInt32(HttpContext.Current.Session["UserID"]); long orderID = Convert.ToInt32(Session["EditOrderID"]); var orders = orderBL.ConvertOrderByID(orderID); if (orders.Count() > 0) { foreach (var order in orders) { long orderId = order.OrderID; Invoice invoice = new Invoice(); invoice.OrderID = orderId; string number = "invoice"; var generateNumber = GenerateCustomizeNumber(number); string invoiceNumber = generateNumber.Replace("Insert", "I"); invoice.Name = order.Name; invoice.InvoiceNumber = invoiceNumber; invoice.CreatedTime = DateTime.Now; invoice.ModifiedTime = DateTime.Now; invoice.CompanyID = companyid; invoice.CreatedBy = userid; invoiceID = orderBL.OrderToInvoiceInsert(invoice); if (invoiceID > 0) { orderBL.UpdateConvertOrder(orderId); Literal1.Text = "Convert Successfully"; Label1.Text = "This Order is Convert to Invoice Successfully"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "script", "ShowAlertModal();", true); } } } else { Literal1.Text = "!!!Not converted"; Label1.Text = "This Order is already converted to Invoice"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "script", "ShowAlertModal();", true); } }
private void ValidateInvoice(Invoice invoice) { if(invoice.InvoiceID!=null) { var duplicateInvoice = invoiceRepository.GetInvoice(invoice).FirstOrDefault(); if (duplicateInvoice != null && duplicateInvoice.InvoiceID != invoice.InvoiceID) { if (duplicateInvoice.InvoiceNumber == invoice.InvoiceNumber) { throw new InvoiceException(String.Format("Invoice {0} already exists",duplicateInvoice.Name, duplicateInvoice.InvoiceNumber)); } } } }
public void UpdateInvoice(Invoice invoice) { try { //ValidateInvoice(invoice); // invoiceRepository.UpdateInvoice(invoice); } catch (Exception ex) { throw ex; } }
public long InsertInvoice(Invoice invoice) { try { ValidateInvoice(invoice); return invoiceRepository.InsertInvoice(invoice); } catch (Exception ex) { throw ex; } }