// query
DepartmentQuery query = new DepartmentQuery();
query.Append(DepartmentColumn.DepartmentName, textBox_addDep.Text.Trim());
//AppendEquals - (if parameter with space, it will be 2 paramenters, so use AppendEquals to instead append)
query.AppendGreaterThan(DepartmentColumn.DepartmentId, "1");
query.AppendLessThan(DepartmentColumn.DepartmentId, "5");
TList<Department> departments = DataRepository.DepartmentProvider.Find(query.GetParameters());
***DataRepository.RoomProvider.DeepLoad(departments); // not tested
// insert
Room room = Room.CreateRoom("RoomID-1", "Second floor", 4);
DataRepository.RoomProvider.Insert(room);
// edit
foreach (Room myRoom in rooms)
{
// Do something
}
DataRepository.RoomProvider.Save(rooms);
// delete
DataRepository.RoomProvider.Delete(room);
// deepload
OrderService service_order = new OrderService();
TList<Order> list_order = service_order.GetAll();
service_order.DeepLoad(list_order, true, DeepLoadType.IncludeChildren, typeof TList<OrderItem>));
//get order item id
Order o = list_order.FirstOrDefault(order => order.OrderCode == OrderCode);
if (o == null)
{
throw new Exception("OrderCode doesn't exist in the DB");
}
else
{
Guid orderId = o.OrderId;
OrderItem oi = o.OrderItemCollection.FirstOrDefault(item => item.OrderItemId == orderId);
if (oi == null)
{
throw new Exception("orderItemId doesn't exsit in the DB");
}
else
{
tran.OrderItemId = oi.OrderItemId;
}
}
//Get method
OrderInfoService service = new OrderInfoService();
var infos = service.Get ("order_id='"+ id + "'","order_date DESC"); // use original column name in DB
// get and update
var orderItemIds = list_orderItem.Select(oItem => oItem.OrderItemId.ToString()).ToArray();
WeighTransactionService wtService = new WeighTransactionService();
WeighTransactionQuery query = new WeighTransactionQuery();
query.AppendIn(WeighTransactionColumn.OrderItemId, orderItemIds);
var wtList = wtService.Find(query);
wtList.ForEach(wt => wt.OrderItemId = null);
wtService.Save(wtList);
public VList<ReportLayoutInfo> GetAllSystemReport() { ReportLayoutInfoService service = new ReportLayoutInfoService(); ReportLayoutInfoQuery query = new ReportLayoutInfoQuery(); //query.AppendLike(ReportLayoutInfoColumn.ReportTypeName, ((int)ReportTypeList.system).ToString()); // two way to search //string whereClause = string.Format( ReportLayoutInfoColumn.ReportTypeName + " LIKE '{0}' AND " + ReportLayoutInfoColumn.ReportTypeName + " NOT LIKE '{1}' AND " + ReportLayoutInfoColumn.ReportTypeName + " NOT LIKE '{2}' ", // "system%", // "%docket", //"%ticket" // ); // service.Find(whereClause) query.AppendLike(ReportLayoutInfoColumn.ReportTypeName, "system%"); //query.Junction = "AND"; query.AppendNotLike(ReportLayoutInfoColumn.ReportTypeName, "%docket"); //query.Junction = "OR"; query.AppendNotLike(ReportLayoutInfoColumn.ReportTypeName, "%ticket"); return service.Find(query); }
http://nettiers.com/GettingStarted.ashx#FB:_Quick_Start_Sample_API_13
http://community.codesmithtools.com/nettiers/f/16/t/2068.aspx