public List<InvoiceItem> InvoiceItems()
{
List<InvoiceItem> invoiceItemList = null;
using (DataTable table = DataProvider.ExecuteSelectCommand("sp_InvoiceItems_Sales",
CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
invoiceItemList = new List<InvoiceItem>();
foreach (DataRow row in table.Rows)
{
InvoiceItem item = new InvoiceItem();
item.CartItemID = (int)row["CartItemID"];
item.ProductID = (int)row["ProductID"];
item.InvoiceID = Convert.ToInt32(row["InvoiceID"]);
item.InvoiceLineID = Convert.ToInt32(row["InvoiceLineNo"]);
item.Price = Convert.ToDouble(row["Price"]);
item.Quantity = Convert.ToInt32(row["Quantity"]);
invoiceItemList.Add(item);
}
}
}
return invoiceItemList;
}
public List<InvoiceItem> GetInvoiceItemList(int InvoiceID)
{
List<InvoiceItem> invoiceItems = null;
SqlParameter[] Params = { new SqlParameter("@InvoiceID", InvoiceID) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_ViewInvoiceItems", CommandType.StoredProcedure, Params))
{
if (table.Rows.Count > 0)
{
invoiceItems = new List<InvoiceItem>();
foreach (DataRow row in table.Rows)
{
InvoiceItem invoiceItem = new InvoiceItem();
invoiceItem.InvoiceLineID = Convert.ToInt32(row["InvoiceLineNo"]);
invoiceItem.ProductID = Convert.ToInt32(row["ProductID"]);
invoiceItem.InvoiceID = Convert.ToInt32(row["InvoiceID"]);
invoiceItem.Quantity = Convert.ToInt32(row["Quantity"]);
invoiceItem.CartItemID = Convert.ToInt32(row["CartItemID"]);
invoiceItem.Price = Convert.ToDouble(row["Price"]);
invoiceItems.Add(invoiceItem);
}
}
}
return invoiceItems;
}
public bool InsertInvoiceItem(InvoiceItem item)
{
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@Quantity", item.Quantity),
new SqlParameter("@ProductID", item.ProductID),
new SqlParameter("@CartItemID", item.CartItemID),
new SqlParameter("@InvoiceID", item.InvoiceID),
new SqlParameter("@Price", item.Price)
};
return DataProvider.ExecuteNonQuery("sp_InsertInvoiceItems", CommandType.StoredProcedure,
Params);
}
public InvoiceItem GetInvoiceNumber(Invoice invoice)
{
InvoiceItem reciept;
SqlParameter[] Params = { new SqlParameter("@Date", invoice.DateCreated),
new SqlParameter("@DeliveryAddress", invoice.DeliveryAddress),
new SqlParameter("@Status", invoice.Status),
new SqlParameter("@User_Id", invoice.User_Id),
new SqlParameter("@DeliveryServiceID", invoice.DeliveryServiceID)
};
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_InsertInvoice", CommandType.StoredProcedure, Params))
{
reciept = new InvoiceItem();
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
reciept.InvoiceID = Convert.ToInt32(row["InvoiceID"]);
}
}
return reciept;
}
public bool AddinvoiceItem(InvoiceItem item)
{
InvoiceItemHandler myHandler = new InvoiceItemHandler(); return myHandler.InsertInvoiceItem(item);
}
public List<InvoiceItem> InvoiceItemsGroupedByInvoiceID(DateTime dateFrom, DateTime dateTo)
{
List<InvoiceItem> invoiceItemList = null;
SqlParameter[] Params = { new SqlParameter("@dateFrom", dateFrom), new SqlParameter("@dateTo", dateTo) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_ViewAllInvoiceItems", CommandType.StoredProcedure, Params))
{
if (table.Rows.Count > 0)
{
invoiceItemList = new List<InvoiceItem>();
foreach (DataRow row in table.Rows)
{
InvoiceItem item = new InvoiceItem();
item.InvoiceID = Convert.ToInt32(row["InvoiceID"]);
item.Price = Convert.ToDouble(row["Price"]);
invoiceItemList.Add(item);
}
}
}
return invoiceItemList;
}
