nettier Data Access Code

 

// 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