public Customer(C5.Debitor Debitor) { this._id = Guid.NewGuid (); this._createtimestamp = SNDK.Date.CurrentDateTimeToTimestamp (); this._updatetimestamp = SNDK.Date.CurrentDateTimeToTimestamp (); this._erpid = string.Empty; this._c5debitor = Debitor; }
public Order(Debitor Debitor) { this._id = C5.Helpers.NewOrderId (); this._createtimestamp = SNDK.Date.CurrentDateTimeToTimestamp (); this._updatetimestamp = SNDK.Date.CurrentDateTimeToTimestamp (); this._debitor = Debitor; this._orderlines = new List<OrderLine> (); }
public static List<Order> List(Debitor Debitor) { return List (Debitor.Id); }
public static void Main(string[] args) { C5.Runtime.DBConnection = new Connection ( SNDK.Enums.DatabaseConnector.Mssql, "172.20.0.54", "c5qnax", "c5qnax", "c5qnax", true); bool testvatcode = false; bool testcreditpolicy = false; bool testdebitor = true; bool testinvoice = false; bool testorder = false; bool testproduct = false; Console.WriteLine (C5.Runtime.DBConnection.Connect ()); if (testvatcode) { foreach (VatCode vc in VatCode.List ()) { Console.WriteLine (vc.Id +" : "+ vc.Text); } } if (testcreditpolicy) { foreach (CreditPolicy c in CreditPolicy.List ()) { Console.WriteLine (c.Id +" : "+ c.Text); } } if (testproduct) { // C5.Product p1 = C5.Product.Load ("516"); // Console.WriteLine (p1.Name); // Console.WriteLine (p1.Price); foreach (C5.Product p in C5.Product.List ()) { Console.WriteLine (p.Name +" = "+ p.Price); } } if (testdebitor) { Debitor d1 = new Debitor (); d1.Name = "Rasmus Pedersen"; Console.WriteLine (d1.Id); // d1.Save (); // Debitor d1 = Debitor.Load ("1200470"); // Console.WriteLine (d1.VatCode.Text); // Console.WriteLine (d1.CreditPolicy.Text); // d1.VatCode = VatCode.Load ("U25"); // d1.Save (); // d1.CreditPolicy = CreditPolicy.Load ("14dgNet"); // d1.Save (); } if (testorder) { // Order o1 = Order.Load ("11223"); // o1.RemoveLine (1); // Debitor.Delete ("1200470"); Debitor d1 = Debitor.Load ("1200470"); Product d2 = Product.Load ("514"); Product d3 = Product.Load ("016"); Order o1 = new Order (d1); o1.AddLine (d2.Id, d2.Name, DateTime.Now, DateTime.Now, d2.Unit, 1, d2.Price, d2.Price, "Nota linie #1\nNota linie #2"); o1.AddLine (d3.Id, d3.Name, DateTime.Now, DateTime.Now, d3.Unit, 1, d3.Price, d3.Price, string.Empty); o1.Save (); Order o2 = Order.Load (o1.Id); Console.WriteLine ("id:"+ o2.Id); foreach (OrderLine line in o2.OrderLines) { Console.WriteLine ("text:"+ line.Text); Console.WriteLine ("notes:"+ line.Notes); Console.WriteLine (""); } // for (int i = 0; i < 1000; i++) // { // Product d2 = Product.Load ("514"); // Product d3 = Product.Load ("016"); // // Order o1 = new Order (d1); // o1.AddLine (d2.Id, d2.Name, DateTime.Now, DateTime.Now, d2.Unit, 1, d2.Price, d2.Price); // o1.AddLine (d3.Id, d3.Name, DateTime.Now, DateTime.Now, d3.Unit, 1, d3.Price, d3.Price); // // foreach (OrderLine line in o1.OrderLines) // { // Console.WriteLine (line.Id +" "+ line.Sort +" "+ line.Text); // } // // Console.WriteLine (o1.Id); // // o1.Save (); // } // foreach (Order o in Order.List (d1)) // { // Console.WriteLine (o.Id +" "+ o.Invoiced); // Order.Delete (o.Id); // } // Environment.Exit (0); // o1.RemoveLine (o1.OrderLines[0].Id); // // // // // o1.Save (); // // Order o2 = Order.Load (o1.Id); // // foreach (OrderLine line in o2.OrderLines) // { // Console.WriteLine (line.Id +" "+ line.Sort +" "+ line.Text); // } // Console.WriteLine (o1.Id); // OrderLine.Delete ("194767"); // OrderLine o1 = OrderLine.Load ("194767"); // Console.WriteLine (o1.Text); // Console.WriteLine (o1.Amount); // Console.WriteLine (o1.Unit); // Console.WriteLine (o1.Price); // Console.WriteLine (o1.Total); // Debitor d1 = Debitor.Load ("1200470"); // Product d2 = Product.Load ("514"); // Order o1 = new Order (d1); // o1.AddLine (d2.Id, d2.Name, DateTime.Now, DateTime.Now, d2.Unit, 1, d2.Price, d2.Price); // o1.Save (); // Console.WriteLine ("Order id:"+ o1.Id); // C5.Order o1 = C5.Order.Load ("11163"); // Console.WriteLine (o1.Debitor.Name); // 11170 // Order o1 = Order.Load ("11170"); // Console.WriteLine (o1.Debitor.Name); // Console.WriteLine (C5.Helpers.NewOrderLineNo (o1.Id)); // foreach (Order o in C5.Order.List ()) // { // Console.WriteLine (o.Id); // } // Console.WriteLine ("GetDebitorId: "+ C5.Helpers.GetDebitorId ()); // // C5.Debitor debitor = new C5.Debitor (); // debitor.Name = "Rasmus Pedersen"; // debitor.Address1 = "Agersøvej 303"; // debitor.PostCode = "4200"; // debitor.City = "Slagelse"; // debitor.Save (); // C5.Debitor debitor = C5.Debitor.Load ("1200380"); // // Console.WriteLine ("Name: "+ debitor.Name); // Console.WriteLine ("Address1: "+ debitor.Address1); // Console.WriteLine ("Address2: "+ debitor.Address2); // Console.WriteLine ("PostCode: "+ debitor.PostCode); // Console.WriteLine ("City: "+ debitor.City); // Console.WriteLine ("Country: "+ debitor.Country); // Console.WriteLine ("Attention: "+ debitor.Attention); // Console.WriteLine ("Phone: "+ debitor.Phone); // Console.WriteLine ("Fax: "+ debitor.Fax); // Console.WriteLine ("Email: "+ debitor.Email); // Console.WriteLine ("Url: "+ debitor.Url); // Console.WriteLine ("VatNo: "+ debitor.VatNo); // // Console.WriteLine (""); // foreach (C5.Debitor d in C5.Debitor.List ()) // { // Console.WriteLine (d.Name); // } } if (testinvoice) { C5.Invoice invoice = C5.Invoice.Get (2236); Console.WriteLine (invoice.AccountId); Console.WriteLine (invoice.Name); Console.WriteLine (invoice.Address1); Console.WriteLine (invoice.Address2); Console.WriteLine (invoice.ZipCode); Console.WriteLine (invoice.City); Console.WriteLine (invoice.Attention); Console.WriteLine (""); Console.WriteLine (invoice.Date); Console.WriteLine (invoice.DueDate); Console.WriteLine (""); Console.WriteLine (invoice.Type); Console.WriteLine (""); foreach (InvoiceLine line in invoice.Lines) { Console.WriteLine (line.LineNumber +" "+ line.PartNumber +" "+ line.Text +" "+ line.Note +" "+ line.Amount +" "+ line.Unit +" "+ line.Price +" "+ line.Total); } Console.WriteLine (""); Console.WriteLine (invoice.SubTotal); Console.WriteLine (invoice.VAT); Console.WriteLine (invoice.Total); } }
public static Debitor Load(string Id) { bool success = true; Debitor result = new Debitor (); QueryBuilder qb = new QueryBuilder (QueryBuilderType.Select); qb.Table ("debkart"); qb.Columns ( "sidstrettet", "navn", "adresse1", "adresse2", "postby", "land", "attention", "telefon", "telefax", "email", "url", "betaling", "momsnummer", "moms" ); qb.AddWhere ("konto like '%"+ Id +"'"); Query query = Runtime.DBConnection.Query (qb.QueryString); if (query.Success) { if (query.NextRow ()) { result._id = Id; result._updatetimestamp = SNDK.Date.DateTimeToTimestamp (query.GetDateTime (qb.ColumnPos ("sidstrettet"))); result._name = query.GetString (qb.ColumnPos ("navn")); result._address1 = query.GetString (qb.ColumnPos ("adresse1")); result._address2 = query.GetString (qb.ColumnPos ("adresse2")); try { string postby = query.GetString (qb.ColumnPos ("postby")); result._postcode = postby.Split (" ".ToCharArray (), StringSplitOptions.RemoveEmptyEntries)[0]; result._city = postby.Split (" ".ToCharArray (), StringSplitOptions.RemoveEmptyEntries)[1]; } catch { // This will catch empty postcode or city. } result._country = query.GetString (qb.ColumnPos ("land")); result._attention = query.GetString (qb.ColumnPos ("attention")); result._phone = query.GetString (qb.ColumnPos ("telefon")); result._fax = query.GetString (qb.ColumnPos ("telefax")); result._email = query.GetString (qb.ColumnPos ("email")); result._url = query.GetString (qb.ColumnPos ("url")); result._creditpolicyid = query.GetString (qb.ColumnPos ("betaling")); result._vatno = query.GetString (qb.ColumnPos ("momsnummer")); result._vatcodeid = query.GetString (qb.ColumnPos ("moms")); } } query.Dispose (); query = null; qb = null; if (!success) { // Exception: DebitorLoadId throw new Exception (string.Format (Strings.Exception.DebitorLoadId, Id)); } // TEMP1 result._temp1 = false; return result; }