コード例 #1
0
 public void updateSalesStockDetails(DataTable salesTable, SalesData sale)
 {
     try
     {
         conn = new SqlConnection(connectionString);
         conn.Open();
         foreach (DataRow row in salesTable.Rows)
         {
             SqlCommand comm = new SqlCommand("UPDATE stockDetails SET quantity = @Quantity, lastUpdatedDate = @UpdatedDate WHERE itemName = @ItemName", conn);
             comm.Parameters.AddWithValue("@ItemName", row["itemName"].ToString());
             comm.Parameters.AddWithValue("@Quantity", row["quantity"].ToString());
             comm.Parameters.AddWithValue("@UpdatedDate", sale.SalesDate);
             comm.ExecuteNonQuery();
         }
     }
     catch (SqlException ex)
     {
         throw ex;
     }
     finally
     {
         if (conn != null)
         {
             conn.Close();
         }
     }
 }
コード例 #2
0
        public int executeSalesMaster(SalesData sale)
        {
            String query         = "INSERT INTO salesMaster(invoiceID,customerName,date,sellingCenter,totalPrice,totalNoOfItems,transportation) VALUES (@InvoiceID,@CustomerName,@Date,@SellingCenter,@TotalPrice,@TotalNoOfItems,@Transportation)";
            int    affectedLines = 0;

            try
            {
                conn = new SqlConnection(connectionString);
                SqlCommand comm = new SqlCommand(query, conn);
                comm.Parameters.AddWithValue("@InvoiceID", sale.InvoiceID);
                comm.Parameters.AddWithValue("@CustomerName", sale.CustomerName);
                comm.Parameters.AddWithValue("@Date", sale.SalesDate);
                comm.Parameters.AddWithValue("@SellingCenter", sale.SellingCenter);
                comm.Parameters.AddWithValue("@TotalPrice", sale.TotalPrice);
                comm.Parameters.AddWithValue("@TotalNoOfItems", sale.TotalItems);
                comm.Parameters.AddWithValue("@Transportation", sale.Transport.ToString());
                conn.Open();
                affectedLines = comm.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
            return(affectedLines);
        }