using System; using System.Data; using System.Collections.Generic; using System.Linq; using System.Text; namespace SDC.Business { public class OrderBiz() { } /// <summary> /// Has Changes /// are there any changes to the data? /// </summary> /// <returns>True/False</returns> public bool HasChanges(OrderDataSet.OrderDataTable dt) { bool retVal = false; DataTable dtChanged = dt.GetChanges(); if (dtChanged != null && dtChanged.Rows.Count > 0) { retVal = true; } return retVal; }------------------------------------------------------------------------------------
/// <summary> /// Find /// returns all orders matching the search criteria. /// </summary> /// <param name="customerName">Customer name</param> /// <param name="startDate">Order start date</param> /// <param name="endDate">Order end date</param> /// <returns>Order Table</returns> public OrderDataSet.OrderDataTable Find(Int32 orderNo, DateTime startDate, DateTime endDate) { OrderDataSet.OrdersDataTable dt = new OrderDataSet.OrdersDataTable(); OrdersTableAdapter ta = new OrdersTableAdapter(); //This line shows in red in intellisense if (customerName.Equals("ANY")) { customerName = string.Empty; } ta.FillBy(dt, startDate, endDate, "%"+customerName+"%"); return dt; }