public void Insert(int?OrderNumber, int?DepartmentID, DateTime?InvoiceDate, int?Customer, float?InvoiceCurrencyID, string Description, decimal?ExchangeRate, string Notes, bool?Crosstrade, DateTime?PaymentDueDate, int?InvoiceRaisedBy, DateTime?InvoiceRaised, decimal?InsuranceValue, string Contact, decimal?OriginalProfitMargin, DateTime?OriginalProfitDate, DateTime?DateQueryRaised, string DetailsOfQuery, string Resolution, int?ConfirmedCompleted, DateTime?CompletionDate, int?Controller, string LossApproved, DateTime?LossApprovedDate, byte[] Tscol)
        {
            InvoiceTable item = new InvoiceTable();

            item.OrderNumber = OrderNumber;

            item.DepartmentID = DepartmentID;

            item.InvoiceDate = InvoiceDate;

            item.Customer = Customer;

            item.InvoiceCurrencyID = InvoiceCurrencyID;

            item.Description = Description;

            item.ExchangeRate = ExchangeRate;

            item.Notes = Notes;

            item.Crosstrade = Crosstrade;

            item.PaymentDueDate = PaymentDueDate;

            item.InvoiceRaisedBy = InvoiceRaisedBy;

            item.InvoiceRaised = InvoiceRaised;

            item.InsuranceValue = InsuranceValue;

            item.Contact = Contact;

            item.OriginalProfitMargin = OriginalProfitMargin;

            item.OriginalProfitDate = OriginalProfitDate;

            item.DateQueryRaised = DateQueryRaised;

            item.DetailsOfQuery = DetailsOfQuery;

            item.Resolution = Resolution;

            item.ConfirmedCompleted = ConfirmedCompleted;

            item.CompletionDate = CompletionDate;

            item.Controller = Controller;

            item.LossApproved = LossApproved;

            item.LossApprovedDate = LossApprovedDate;

            item.Tscol = Tscol;


            item.Save(UserName);
        }
 public bool Destroy(object InvoiceNumber)
 {
     return(InvoiceTable.Destroy(InvoiceNumber) == 1);
 }
 public bool Delete(object InvoiceNumber)
 {
     return(InvoiceTable.Delete(InvoiceNumber) == 1);
 }