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