private IList <SalesDetail> GetSalesDetails(int salesId)
{
const string salesDetailsQuery = "Select * from Sales_Product where SalesId = @salesid";
_sqliteDataProvider.AddParameter("@salesid", salesId);
DataSet dataSet = _sqliteDataProvider.ExecuteDataSet(salesDetailsQuery);
var salesDetails = new List <SalesDetail>();
foreach (DataRow row in dataSet.Tables[0].Rows)
{
var productId = Convert.ToInt32(row["ProductId"]);
var productCode = new ProductDataService().GetProductById(productId).Code;
var quantity = Convert.ToInt32(row["Quantity"]);
var unitPrice = Convert.ToDouble(row["UnitPrice"]);
salesDetails.Add(new SalesDetail
{
ProductCode = productCode,
Quantity = quantity,
SalesId = salesId,
UnitPrice = unitPrice
});
}
return(salesDetails);
}
public Sales GetSalesById(int id)
{
const string query = "SELECT * From sales Where id = @id";
_sqliteDataProvider.AddParameter("@id", id);
var dataRow = _sqliteDataProvider.ExecuteDataRows(query).First();
var sales = CreateSales(dataRow);
const string salesDetailsQuery = "Select * from Sales_Product where SalesId = @salesid";
_sqliteDataProvider.AddParameter("@salesid", id);
DataSet dataSet = _sqliteDataProvider.ExecuteDataSet(salesDetailsQuery);
var salesDetails = new List <SalesDetail>();
foreach (DataRow row in dataSet.Tables[0].Rows)
{
var productId = Convert.ToInt32(row["ProductId"]);
var productCode = new ProductDataService().GetProductById(productId).Code;
var quantity = Convert.ToInt32(row["Quantity"]);
var unitPrice = Convert.ToDouble(row["UnitPrice"]);
salesDetails.Add(new SalesDetail
{
ProductCode = productCode,
Quantity = quantity,
SalesId = id,
UnitPrice = unitPrice
});
}
sales.SalesDetails = salesDetails;
return(sales);
}
private PackedProduct CreatePackedProductObject(DataRow row)
{
var productId = Convert.ToInt32(row["ProductId"]);
var productCode = new ProductDataService().GetProductById(productId).Code;
return(new PackedProduct
{
OrderId = Convert.ToInt32(row["SalesId"]),
PalletId = Convert.ToInt32(row["PalletId"]),
ProductCode = productCode,
Quantity = Convert.ToInt32(row["Quantity"])
});
}
private void CreateSalesDetails(SalesDetail salesDetail, int salesId)
{
string salesDetailQuery = "Insert into Sales_Product (SalesId,ProductId,Quantity,UnitPrice) values (@salesid,@productid," +
"@quantity,@unitprice);";
_sqliteDataProvider.AddParameter("@salesid", salesId);
var productId = new ProductDataService().GetProductByCode(salesDetail.ProductCode).Id;
_sqliteDataProvider.AddParameter("@productid", productId);
_sqliteDataProvider.AddParameter("@quantity", salesDetail.Quantity);
_sqliteDataProvider.AddParameter("@unitprice", salesDetail.UnitPrice);
_sqliteDataProvider.ExecuteScalar(salesDetailQuery);
}
public bool CreatePackedProduct(PackedProduct packedProduct)
{
const string query = "Insert into Packing (SalesId, PalletId, ProductId, Quantity) values " +
"(@SalesId, @PalletId, @ProductId, @Quantity);" +
"select last_insert_rowid();";
_sqliteDataProvider.AddParameter("@SalesId", packedProduct.OrderId);
_sqliteDataProvider.AddParameter("@PalletId", packedProduct.PalletId);
var productId = new ProductDataService().GetProductByCode(packedProduct.ProductCode).Id;
_sqliteDataProvider.AddParameter("@ProductId", productId);
_sqliteDataProvider.AddParameter("@Quantity", packedProduct.Quantity);
var queryResult = _sqliteDataProvider.ExecuteScalar(query);
return(queryResult != null);
}