예제 #1
0
        public static void dodajKarawane(string a, string b)
        {
            TableCaravan nowa = new TableCaravan(a, b, 1, 0, 0, 1);

            tableCaravan.Add(nowa);
            TableArtInCaravan nowy = new TableArtInCaravan(a, "TO01", 0);

            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO01", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO02", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO03", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO04", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO05", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO06", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO07", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO08", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO09", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO10", 0);
            tableArtInCaravan.Add(nowy);
            nowy = new TableArtInCaravan(a, "TO11", 0);
            tableArtInCaravan.Add(nowy);
        }
예제 #2
0
        internal void UpdateArtInCaravan(TableArtInCaravan ArtInCaravan)
        {
            SqlConnection conn = new SqlConnection(connectionString);

            try
            {
                conn.Open();
            }
            catch (SqlException se)
            {
                return;
            }

            SqlCommand cmd = new SqlCommand("Insert into Art_in_Caravan" + "(IdCaravan, IdArticle, Number) Values (@Id, @IdArt, @Num)", conn);

            SqlParameter param = new SqlParameter();

            param.ParameterName = "@Id";
            param.Value         = ArtInCaravan.GetId();
            param.SqlDbType     = SqlDbType.VarChar;
            cmd.Parameters.Add(param);

            param = new SqlParameter();
            param.ParameterName = "@IdArt";
            param.Value         = ArtInCaravan.GetIdArticle();
            param.SqlDbType     = SqlDbType.VarChar;
            cmd.Parameters.Add(param);

            param = new SqlParameter();
            param.ParameterName = "@Num";
            param.Value         = ArtInCaravan.GetNumber();
            param.SqlDbType     = SqlDbType.Int;
            cmd.Parameters.Add(param);

            try
            {
                cmd.ExecuteNonQuery();
            }
            catch (SqlException se)
            {
                return;
            }
            conn.Close();
            conn.Dispose();
        }
예제 #3
0
        public static TableArtInCaravan ZnajdzTowarWKarawanie(string idt, string idk)
        {
            TableArtInCaravan towar = tableArtInCaravan.Select(n => n).Where(x => x.GetId() == idk && x.GetIdArticle() == idt).FirstOrDefault();

            return(towar);
        }