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 );
}
