Kodlar
private void btnSatınal_Click(object sender, EventArgs e)
{
if (UserProfile != null)
{
// Kullanıcının son oluşturuduğu beklemedeki siparişi getirilir
// OrderStatus = -1 : Beklemede
// = 1 : Onaylandı
// = 0 : İptal edildi
string sql = " SELECT TOP 1 * FROM [Order] o WHERE o.Status = 1 AND o.OrderStatus = -1 AND o.UsersId = " + UserProfile.UserId + " ORDER BY o.OrderId DESC ";
DataTable dt = dataAccess.ReturnDataTable(sql);
if (dt != null)
{
if (dt.Rows.Count == 1)
{
Order order = OrderHelper.ConvertDataRowToEntity(dt.Rows[0]);
OrderDetail orderDetail = new OrderDetail();
Product product = null;
if (dt != null)
{
if (dt.Rows.Count == 1)
{
product = ProductHelper.ConvertDataRowToEntity(dt.Rows[0]);
}
}
if (product == null)
{
MessageBox.Show("Ürün seçiniz!");
return;
}
if (order.OrderId > 0)
{
orderDetail.OrderId = order.OrderId;
sql = "update [Order] SET TotalAmount = (TotalAmount + " + product.ProductAmount + ") WHERE OrderId = " + order.OrderId;
}
else
{
sql = "SELECT TOP 1 * FROM Product p WHERE p.ProductsId = " + SelectedProductId;
dt = dataAccess.ReturnDataTable(sql);
sql = "insert into [Order] (UsersId, TotalAmount, TaxAmount, OrderStatus, CreatedDate, CreatedBy)";
sql += " VALUES (@UserId, @TotalAmount, @TaxAmount, -1, GETDATE(), @UserId) ";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@UserId", UserProfile.UserId));
parameters.Add(new SqlParameter("@TotalAmount", product.ProductAmount));
parameters.Add(new SqlParameter("@TaxAmount", (product.ProductAmount * 18) / 100));
orderDetail.OrderId = dataAccess.ExecuteIdentity(sql, parameters);
}
orderDetail.CreatedBy = UserProfile.UserId;
orderDetail.CreatedDate = DateTime.Now;
orderDetail.ProductId = SelectedProductId;
orderDetail.ProductsNum = 1;
orderDetail.Status = 1;
sql = " insert into OrderDetail (OrderId, ProductId, ProductsNum, Status, CreatedDate, CreatedBy ) ";
sql += " VALUES ";
sql += " (" + orderDetail.OrderId + ", " + orderDetail.ProductId + ", 1,1,GETDATE()," + UserProfile.UserId + ") ";
if (dataAccess.ExecuteIdentity(sql, null) > 0)
{
MessageBox.Show("Sepete eklendi !");
}
else
{
MessageBox.Show("Hata oluştu tekrar deneyiniz !");
}
}
}