public DataTable Insert(OrderDetailsDE OrderDetails)
{
dataAccess.Open();
dataAccess.BeginTran();
DataTable table;
try
{
QueryParameter[] list = new QueryParameter[5];
list[0] = new QueryParameter("OrderDetailsId", OrderDetails.OrderDetailsId, DbType.Int32);
list[1] = new QueryParameter("OrderId", OrderDetails.OrderId, DbType.Int32);
list[2] = new QueryParameter("ProductId", OrderDetails.ProductId, DbType.Int32);
list[3] = new QueryParameter("Quantity", OrderDetails.Quantity, DbType.Int32);
list[4] = new QueryParameter("TotalPrice", OrderDetails.TotalPrice, DbType.Decimal);
string sql = "insert into OrderDetails values(@OrderId,@ProductId,@Quantity,@TotalPrice)";
dataAccess.ExecuteNonQuery(sql, list);
dataAccess.CommitTran();
string sql1 = "SELECT dbo.OrderDetails.OrderDetailId, dbo.OrderDetails.OrderId, dbo.Product.ProductName, dbo.OrderDetails.Quantity, dbo.OrderDetails.TotalPrice FROM dbo.OrderDetails INNER JOIN dbo.Product ON dbo.OrderDetails.ProductId = dbo.Product.ProductId and OrderId='" + OrderDetails.OrderId + "'";
table = dataAccess.GetTable(sql1);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataAccess.Close();
}
return(table);
}
public bool Update(OrderDetailsDE OrderDetails)
{
bool result = true;
dataAccess.Open();
try
{
QueryParameter[] list = new QueryParameter[5];
list[0] = new QueryParameter("OrderDetailId", OrderDetails.OrderDetailsId, DbType.Int32);
list[1] = new QueryParameter("OrderId", OrderDetails.OrderId, DbType.Int32);
list[2] = new QueryParameter("ProductId", OrderDetails.ProductId, DbType.Int32);
list[3] = new QueryParameter("Quantity", OrderDetails.Quantity, DbType.Int32);
list[4] = new QueryParameter("TotalPrice", OrderDetails.TotalPrice, DbType.Decimal);
string sql = "update OrderDetails set ProductId=@ProductId, Quantity=@Quantity, TotalPrice=@TotalPrice where OrderId=@OrderId and OrderDetailId=@OrderDetailId";
int i = dataAccess.ExecuteNonQuery(sql, list);
if (i == 0)
{
result = false;
}
else
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataAccess.Close();
}
return(result);
}
public List <OrderDetailsDE> GetAllOrderDetails()
{
List <OrderDetailsDE> list = new List <OrderDetailsDE>();
dataAccess.Open();
try
{
string sql = "select * from OrderDetails";
IDataReader reader = dataAccess.GetReader(sql);
while (reader.Read())
{
OrderDetailsDE OrderDetails = new OrderDetailsDE();
OrderDetails.OrderDetailsId = reader.GetInt32(0);
OrderDetails.OrderId = reader.GetInt32(1);
//Product.ProductId = OrderDetails.ProductDE.ProductId;
//OrderDetails.ProductDE.ProductName = reader.GetString(2);
OrderDetails.Quantity = reader.GetInt32(3);
OrderDetails.TotalPrice = reader.GetDecimal(4);
int productId = reader.GetInt32(2);
//OrderDetails.ProductDE.ProductId = reader.GetInt32(2);
//string sql1 = "select ProductName from Product where ProductId=" + productId;
//dataAccess.Open();
//SqlCommand cmd = new SqlCommand(sql1);
ProductDE product = GetById(productId);
//product.ProductName = cmd.ExecuteScalar().ToString();
//ProductDE Product = GetById(productId);
OrderDetails.ProductDE = product;
list.Add(OrderDetails);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataAccess.Close();
}
return(list);
}