예제 #1
0
 private void allOrderListDataGrid_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
 {
     try
     {
         DialogResult dr = MessageBox.Show("Seçili satır için rapor yazdırmak istiyor musunuz?", "Uyarı",
                                           MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
         if (dr == DialogResult.Cancel)
         {
             return;
         }
         cmd.Connection  = con;
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.CommandText = "ab_listOrder";
         cmd.Parameters.Clear();
         cmd.Parameters.AddWithValue("@orderId", allOrderListDataGrid.CurrentRow.Cells[0].Value);
         SqlDataAdapter da = new SqlDataAdapter(cmd);
         DataTable      dt = new DataTable();
         da.Fill(dt);
         List <OrderDetail> orderDetailList = new List <OrderDetail>();
         Orders             orders          = new Orders();
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             OrderDetail ordDetail = new OrderDetail();
             ordDetail.productId       = Convert.ToInt32(dt.Rows[i]["productId"]);
             ordDetail.productName     = dt.Rows[i]["productName"].ToString();
             ordDetail.mainProductName = dt.Rows[i]["mainProductName"].ToString();
             ordDetail.quantity        = Convert.ToInt32(dt.Rows[i]["quantity"]);
             orderDetailList.Add(ordDetail);
         }
         orders.orderId           = Int32.Parse(allOrderListDataGrid.CurrentRow.Cells[0].Value.ToString());
         orders.orderBy           = allOrderListDataGrid.CurrentRow.Cells[1].Value.ToString();
         orders.orderAdress       = allOrderListDataGrid.CurrentRow.Cells[4].Value.ToString();
         orders.orderDate         = allOrderListDataGrid.CurrentRow.Cells[2].Value.ToString();
         orders.orderPrice        = Int32.Parse(allOrderListDataGrid.CurrentRow.Cells[3].Value.ToString());
         orders.orderExplaination = allOrderListDataGrid.CurrentRow.Cells[6].Value.ToString();
         orders.orderSite         = allOrderListDataGrid.CurrentRow.Cells[5].Value.ToString();
         rptOrder rpo = new rptOrder();
         rpo.Database.Tables["productDataTable"].SetDataSource(dt);
         ReportForm pdf = new ReportForm(orderDetailList, orders);
         pdf.ShowDialog();
     }
     catch (Exception Error)
     {
         MessageBox.Show(Error.ToString());
     }
 }
예제 #2
0
 private void saveOrder_Click(object sender, EventArgs e)
 {
     try
     {
         if (con.State == ConnectionState.Closed)
         {
             con.Open();
         }
         bool         report = false;
         DialogResult dr     = MessageBox.Show("İşlem sonucunda rapor istiyor musunuz?", "Uyarı", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning);
         if (dr == DialogResult.Cancel)
         {
             return;
         }
         else if (dr == DialogResult.Yes)
         {
             report = true;
         }
         cmd.Connection  = con;
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.CommandText = "ab_addOrder";
         cmd.Parameters.Clear();
         cmd.Parameters.AddWithValue("@orderBy", orderBy.Text.ToString());
         cmd.Parameters.AddWithValue("@orderDate", orderDate.Value);
         cmd.Parameters.AddWithValue("@orderPrice", Int32.Parse(orderPrice.Text.ToString()));
         cmd.Parameters.AddWithValue("@orderAdress", orderAdress.Text.ToString());
         cmd.Parameters.AddWithValue("@orderExplanation", orderExplanation.Text.ToString());
         cmd.Parameters.AddWithValue("@orderSite", siteList.selectedValue.ToString());
         cmd.Parameters.Add("@orderId", SqlDbType.Int).Direction = ParameterDirection.Output;
         cmd.ExecuteNonQuery();
         int orderId = Convert.ToInt32(cmd.Parameters["@orderId"].Value);
         foreach (ListViewItem itemList in orderList.Items)
         {
             cmd.Connection  = con;
             cmd.CommandType = CommandType.StoredProcedure;
             cmd.CommandText = "ab_addOrderProduct";
             cmd.Parameters.Clear();
             cmd.Parameters.AddWithValue("@orderId", orderId);
             cmd.Parameters.AddWithValue("@productId", Int32.Parse(itemList.SubItems[0].Text.ToString()));
             cmd.Parameters.AddWithValue("@quantity", Int32.Parse(itemList.SubItems[2].Text.ToString()));
             cmd.ExecuteNonQuery();
             cmd.Connection  = con;
             cmd.CommandType = CommandType.StoredProcedure;
             cmd.CommandText = "ab_decProductStock";
             cmd.Parameters.Clear();
             cmd.Parameters.AddWithValue("@productId", Int32.Parse(itemList.SubItems[0].Text.ToString()));
             cmd.Parameters.AddWithValue("@productQuantity", Int32.Parse(itemList.SubItems[2].Text.ToString()));
             cmd.ExecuteNonQuery();
         }
         MessageBox.Show("İşlem başarıyla tamamlandı. Sipariş Numarası : " + orderId.ToString());
         productGrid.Rows.Clear();
         if (report)
         {
             cmd.Connection  = con;
             cmd.CommandType = CommandType.StoredProcedure;
             cmd.CommandText = "ab_listOrder";
             cmd.Parameters.Clear();
             cmd.Parameters.AddWithValue("@orderId", orderId);
             SqlDataAdapter da = new SqlDataAdapter(cmd);
             DataTable      dt = new DataTable();
             da.Fill(dt);
             List <OrderDetail> orderDetailList = new List <OrderDetail>();
             Orders             orders          = new Orders();
             for (int i = 0; i < dt.Rows.Count; i++)
             {
                 OrderDetail ordDetail = new OrderDetail();
                 ordDetail.productId       = Convert.ToInt32(dt.Rows[i]["productId"]);
                 ordDetail.productName     = dt.Rows[i]["productName"].ToString();
                 ordDetail.mainProductName = dt.Rows[i]["mainProductName"].ToString();
                 ordDetail.quantity        = Convert.ToInt32(dt.Rows[i]["quantity"]);
                 orderDetailList.Add(ordDetail);
             }
             orders.orderId           = orderId;
             orders.orderBy           = orderBy.Text.ToString();
             orders.orderAdress       = orderAdress.Text.ToString();
             orders.orderDate         = orderDate.Value.ToString();
             orders.orderPrice        = Int32.Parse(orderPrice.Text.ToString());
             orders.orderExplaination = orderExplanation.Text.ToString();
             orders.orderSite         = siteList.selectedValue.ToString();
             rptOrder rpo = new rptOrder();
             rpo.Database.Tables["productDataTable"].SetDataSource(dt);
             ReportForm pdf = new ReportForm(orderDetailList, orders);
             pdf.ShowDialog();
         }
     }
     catch (Exception error)
     {
         MessageBox.Show(error.ToString());
     }
 }