public static PurchaseInfo GetPurchase(int PurchaseID)
{
if (!Purchase.purchaseExists(PurchaseID))
{
throw new ArgumentException("Purchase doesn't exist");
}
PurchaseTableAdapter purchaseAdapter = new PurchaseTableAdapter();
NuRacingDataSet.PurchaseDataTable purchaseTable = purchaseAdapter.GetDataByWorkTypeID(PurchaseID);
return new PurchaseInfo((NuRacingDataSet.PurchaseRow) purchaseTable[0]);
}
public static PurchaseInfo GetPurchase(int PurchaseID)
{
if (!Purchase.purchaseExists(PurchaseID))
{
throw new ArgumentException("Purchase doesn't exist");
}
PurchaseTableAdapter purchaseAdapter = new PurchaseTableAdapter();
NuRacingDataSet.PurchaseDataTable purchaseTable = purchaseAdapter.GetDataByWorkTypeID(PurchaseID);
return(new PurchaseInfo((NuRacingDataSet.PurchaseRow)purchaseTable[0]));
}
public static List<PurchaseInfo> GetUserPurchases(string Username)
{
List<PurchaseInfo> result = new List<PurchaseInfo>();
PurchaseTableAdapter purchaseAdapter = new PurchaseTableAdapter();
NuRacingDataSet.PurchaseDataTable purchaseTable = purchaseAdapter.GetDataByUsername(Username);
foreach (NuRacingDataSet.PurchaseRow purchaseRow in purchaseTable)
{
result.Add(new PurchaseInfo(purchaseRow));
}
return result;
}
public static List<PurchaseInfo> GetProjectPurchases(int ProjectID)
{
List<PurchaseInfo> result = new List<PurchaseInfo>();
PurchaseTableAdapter purchaseAdapter = new PurchaseTableAdapter();
NuRacingDataSet.PurchaseDataTable purchaseTable = purchaseAdapter.GetDataByProjectID(ProjectID);
foreach (NuRacingDataSet.PurchaseRow purchaseRow in purchaseTable.Rows)
{
result.Add(new PurchaseInfo(purchaseRow));
}
return result;
}
public static List <PurchaseInfo> GetUserPurchases(string Username)
{
List <PurchaseInfo> result = new List <PurchaseInfo>();
PurchaseTableAdapter purchaseAdapter = new PurchaseTableAdapter();
NuRacingDataSet.PurchaseDataTable purchaseTable = purchaseAdapter.GetDataByUsername(Username);
foreach (NuRacingDataSet.PurchaseRow purchaseRow in purchaseTable)
{
result.Add(new PurchaseInfo(purchaseRow));
}
return(result);
}
public static List <PurchaseInfo> GetWorkTypePurchases(int WorkTypeID)
{
List <PurchaseInfo> result = new List <PurchaseInfo>();
PurchaseTableAdapter purchaseAdapter = new PurchaseTableAdapter();
NuRacingDataSet.PurchaseDataTable purchaseTable = purchaseAdapter.GetDataByWorkTypeID(WorkTypeID);
foreach (NuRacingDataSet.PurchaseRow purchaseRow in purchaseTable.Rows)
{
result.Add(new PurchaseInfo(purchaseRow));
}
return(result);
}
public static void addPurchase(string Username, string Supplier, string GoodPurchased, decimal totalPrice, DateTime purchaseMade, int WorkTypeID)
{
PurchaseTableAdapter purchaseAdapter = new PurchaseTableAdapter();
NuRacingDataSet.PurchaseDataTable purchaseTable = purchaseAdapter.GetData();
NuRacingDataSet.PurchaseRow newPurchaseRow = purchaseTable.NewPurchaseRow();
newPurchaseRow.Purchase_Good = GoodPurchased;
newPurchaseRow.Purchase_Supplier = Supplier;
newPurchaseRow.Purchase_TotalPrice = totalPrice;
newPurchaseRow.User_Username = Username;
newPurchaseRow.Purchase_DatePurchased = purchaseMade;
newPurchaseRow.WorkType_UID = WorkTypeID;
purchaseTable.AddPurchaseRow(newPurchaseRow);
purchaseAdapter.Update(purchaseTable);
}
public static void addPurchase(string Username, string Supplier, string GoodPurchased, decimal totalPrice, DateTime purchaseMade, int WorkTypeID)
{
PurchaseTableAdapter purchaseAdapter = new PurchaseTableAdapter();
NuRacingDataSet.PurchaseDataTable purchaseTable = purchaseAdapter.GetData();
NuRacingDataSet.PurchaseRow newPurchaseRow = purchaseTable.NewPurchaseRow();
newPurchaseRow.Purchase_Good = GoodPurchased;
newPurchaseRow.Purchase_Supplier = Supplier;
newPurchaseRow.Purchase_TotalPrice = totalPrice;
newPurchaseRow.User_Username = Username;
newPurchaseRow.Purchase_DatePurchased = purchaseMade;
newPurchaseRow.WorkType_UID = WorkTypeID;
purchaseTable.AddPurchaseRow(newPurchaseRow);
purchaseAdapter.Update(purchaseTable);
}
