/// <summary> /// Retrieves items. /// </summary> /// <param name="memberNumber">Member ID</param> /// <returns>Items Data Set</returns> public ItemsDataSet GetItems(Int16 memberNumber) { ItemsTableAdapter ita = new ItemsTableAdapter(); ItemsDataSet ids = new ItemsDataSet(); ita.Fill(ids.Items, memberNumber); return(ids); }
public static ReportDocument LoadItemList() { ReportDocument rpt = new Master.rptItemList(); dsReports ds = new dsReports(); ds.EnforceConstraints = false; ItemsTableAdapter ta = new ItemsTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.Fill(ds.Items); RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); return(rpt); }
public static ReportDocument LoadItemList() { ReportDocument rpt = new Master.rptItemList(); dsReports ds = new dsReports(); ds.EnforceConstraints = false; ItemsTableAdapter ta = new ItemsTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.Fill(ds.Items); RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); return rpt; }
public bool deleteItem(int Item_id) { objItem = new ItemsTableAdapter(); return(objItem.DeleteItem(Item_id) > 0); }
public bool updateItem(int sid, string item_name, int count, decimal cost, int Item_id) { objItem = new ItemsTableAdapter(); return(objItem.UpdateItem(sid, item_name, count, cost, Item_id) > 0); }
public bool insertItem(int sid, string item_name, int count, decimal cost) { objItem = new ItemsTableAdapter(); return(objItem.InsertItem(sid, item_name, count, cost) > 0); }
public DataTable getItem() { objItem = new ItemsTableAdapter(); return(objItem.GetItem()); }
public DataTable getItemBySID(int sid) { objItem = new ItemsTableAdapter(); return(objItem.GetItemBySID(sid)); }
// constructor public ItemsDAL() { adpItems = new ItemsTableAdapter(); tblItems = new MyDataSet.ItemsDataTable(); }