public void SubDocuments_InsertAndLoad() { var row = new MyInvoice { GDID = new GDID(1, 1, 100), Name = "Dimon Khachaturyan", Date = new DateTime(1990, 08, 15, 14, 0, 0, DateTimeKind.Utc), Lines = new MyInvoiceLine[] { new MyInvoiceLine { LineNo = 1, Description = "Sosiki", Amount = 12.67m }, new MyInvoiceLine { LineNo = 2, Description = "Mylo", Amount = 8.50m }, new MyInvoiceLine { LineNo = 3, Description = "Туалетная Бумага 'Зева'", Amount = 9.75m }, new MyInvoiceLine { LineNo = 4, Description = "Трусы Мужские", Amount = 3.72m } } }; m_Store.Insert(row); var row2 = m_Store.LoadDoc(new Query <MyInvoice>("CRUD.LoadInvoice") { new Query.Param("id", row.GDID) }); Aver.IsNotNull(row2); Aver.AreEqual(row.GDID, row2.GDID); Aver.AreEqual(row.Name, row2.Name); Aver.AreEqual(row.Date, row2.Date); Aver.IsNotNull(row2.Lines); Aver.AreEqual(4, row2.Lines.Length); Aver.AreEqual(1, row2.Lines[0].LineNo); Aver.AreEqual("Sosiki", row2.Lines[0].Description); Aver.AreEqual(12.67m, row2.Lines[0].Amount); Aver.AreEqual(2, row2.Lines[1].LineNo); Aver.AreEqual("Mylo", row2.Lines[1].Description); Aver.AreEqual(8.50m, row2.Lines[1].Amount); Aver.AreEqual(3, row2.Lines[2].LineNo); Aver.AreEqual("Туалетная Бумага 'Зева'", row2.Lines[2].Description); Aver.AreEqual(9.75m, row2.Lines[2].Amount); Aver.AreEqual(4, row2.Lines[3].LineNo); Aver.AreEqual("Трусы Мужские", row2.Lines[3].Description); Aver.AreEqual(3.72m, row2.Lines[3].Amount); }
public SearchInvoice(String q, string teamIDStr, string myIDStr) { int teamID = Convert.ToInt32(teamIDStr); int myID = Convert.ToInt32(myIDStr); Items = new List <ItemOption>(); var mi = new MyInvoice(); List <Sales_JobMasterList_Invoice> items = mi.GetInvoicesBySalesID(myID); try { string[] search = q.Split(' '); if (items.Count == 0) { return; } foreach (Sales_JobMasterList_Invoice item in items) { string namevalue = item.invoiceNo + "V" + item.Revision.ToString() + "-" + item.Title; if (!MyString.IsContainsAny(namevalue, search)) { continue; } var st = new ItemOption { Name = namevalue, SelectedID = Convert.ToString(item.invoiceID), Value = namevalue }; Items.Add(st); } } catch (Exception ex) { string exp = ex.ToString(); //Setup a breakpoint here to verify any exceptions raised. } }
public void SubDocuments_InsertAndLoad() { var row = new MyInvoice { GDID = new GDID(1, 1, 100), Name = "Dimon Khachaturyan", Date = new DateTime(1990, 08, 15, 14, 0, 0, DateTimeKind.Utc), Lines = new MyInvoiceLine[] { new MyInvoiceLine{ LineNo = 1, Description = "Sosiki", Amount = 12.67m }, new MyInvoiceLine{ LineNo = 2, Description = "Mylo", Amount = 8.50m }, new MyInvoiceLine{ LineNo = 3, Description = "Туалетная Бумага 'Зева'", Amount = 9.75m }, new MyInvoiceLine{ LineNo = 4, Description = "Трусы Мужские", Amount = 3.72m } } }; store.Insert(row); var row2 = store.LoadRow(new Query<MyInvoice>("CRUD.LoadInvoice") { new Query.Param("id", row.GDID) }); Assert.IsNotNull( row2 ); Assert.AreEqual(row.GDID, row2.GDID); Assert.AreEqual(row.Name, row2.Name); Assert.AreEqual(row.Date, row2.Date); Assert.IsNotNull( row2.Lines ); Assert.AreEqual(4, row2.Lines.Length ); Assert.AreEqual(1, row2.Lines[0].LineNo ); Assert.AreEqual("Sosiki", row2.Lines[0].Description ); Assert.AreEqual(12.67m, row2.Lines[0].Amount ); Assert.AreEqual(2, row2.Lines[1].LineNo ); Assert.AreEqual("Mylo", row2.Lines[1].Description ); Assert.AreEqual(8.50m, row2.Lines[1].Amount ); Assert.AreEqual(3, row2.Lines[2].LineNo ); Assert.AreEqual("Туалетная Бумага 'Зева'", row2.Lines[2].Description ); Assert.AreEqual(9.75m, row2.Lines[2].Amount ); Assert.AreEqual(4, row2.Lines[3].LineNo ); Assert.AreEqual("Трусы Мужские", row2.Lines[3].Description ); Assert.AreEqual(3.72m, row2.Lines[3].Amount ); }