public List <tHistory> getInvoices(int UserID)
{
List <tHistory> transactionHistories = new List <tHistory>();
dynamic tings = (from th in db.TransactionHistories
select th);
foreach (TransactionHistory t in tings)
{
bDetails details = getBillDetail(t.Order_ID);
if (details.User_ID.Equals(UserID))
{
tHistory thi = new tHistory
{
Order_ID = t.Order_ID,
Prod_ID = t.Prod_ID,
purchase_ID = t.Purchase_ID,
Quantity = Convert.ToInt32(t.Quantity),
Date = Convert.ToDateTime(t.Date)
};
transactionHistories.Add(thi);
}
}
return(transactionHistories);
}
public bool AddTransaction(tHistory transaction)
{
TransactionHistory entry = new TransactionHistory
{
Prod_ID = transaction.Prod_ID,
Order_ID = transaction.Order_ID,
Date = transaction.Date,
Quantity = transaction.Quantity
};
db.TransactionHistories.InsertOnSubmit(entry);
try
{
db.SubmitChanges();
return(true);
}
catch (Exception e)
{
e.GetBaseException();
return(false);
}
}
public List <tHistory> getInvoice(int order)
{
List <tHistory> transactionHistories = new List <tHistory>();
dynamic tings = (from th in db.TransactionHistories
where th.Order_ID.Equals(order)
select th);
foreach (TransactionHistory t in tings)
{
tHistory thi = new tHistory
{
Order_ID = t.Order_ID,
Prod_ID = t.Prod_ID,
purchase_ID = t.Purchase_ID,
Quantity = Convert.ToInt32(t.Quantity),
Date = Convert.ToDateTime(t.Date)
};
transactionHistories.Add(thi);
}
return(transactionHistories);
}