Beispiel #1
0
    public int updateOrderInfo(cOrder newO)
    {
        //Create a connection
        SqlConnection conn = new SqlConnection(connStr);

        //The procedure I want to call
        SqlCommand cmd = new SqlCommand("usp_ADMIN_edit_order", conn);

        //Command type I want to execute
        cmd.CommandType = CommandType.StoredProcedure;

        try
        {
            conn.Open();
            cmd.Parameters.AddWithValue("@orderID", newO.personID);
            cmd.Parameters.AddWithValue("@anstalldID", newO.anstalldID);
            cmd.Parameters.AddWithValue("@startTid", newO.startTid);
            cmd.Parameters.AddWithValue("@tjanstID", newO.tjanstID);

            return(cmd.ExecuteNonQuery());
        }
        catch
        {
            throw;
        }
        finally
        {
            cmd.Dispose();
            conn.Close();
            conn.Dispose();
        }
    }
Beispiel #2
0
    protected void btnUppdatera_Click(object sender, EventArgs e)
    {
        AdminDAL aDAL = new AdminDAL();
        cOrder   o    = new cOrder();

        o.anstalldID = anstalldID();
        o.tjanstID   = tjanstID();
        o.personID   = lblID.Text;
        o.startTid   = Convert.ToDateTime(tbStartTid.Text);

        aDAL.updateOrderInfo(o);

        FillOrdrar();
    }
 public void OnOrderReceived(cOrder newOrder)
 {
     myConsumer.orderQueue.Add(cOrder);
 }