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); }
public static TableCaravan ZnajdzKarawane(string id) { TableCaravan karawana = tableCaravan.Select(n => n).Where(x => x.GetId() == id).FirstOrDefault(); return(karawana); }
internal void UpdateCaravan(TableCaravan Caravan) { SqlConnection conn = new SqlConnection(connectionString); try { conn.Open(); } catch (SqlException se) { return; } SqlCommand cmd = new SqlCommand("Insert into Caravan" + "(IdCaravan, IdLoc, Wagons, Guard, Duration, Minions) Values (@IdCaravan, @IdLoc, @Wagons, @Guard, @Duration, @Minions)", conn); SqlParameter param = new SqlParameter(); param.ParameterName = "@IdCaravan"; param.Value = Caravan.GetId(); param.SqlDbType = SqlDbType.VarChar; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@IdLoc"; param.Value = Caravan.GetIdLoc(); param.SqlDbType = SqlDbType.VarChar; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@Wagons"; param.Value = Caravan.GetWagons(); param.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@Guard"; param.Value = Caravan.GetGuard(); param.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@Duration"; param.Value = Caravan.GetDuration(); param.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@Minions"; param.Value = Caravan.GetMinions(); param.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(param); try { cmd.ExecuteNonQuery(); } catch (SqlException se) { return; } conn.Close(); conn.Dispose(); }