public List <Vari> haeVari()
{
List <Vari> palaute = new List <Vari>();
string haku = "SELECT * FROM Varit";
connectDatabase();
int id;
string Vari, ID_string;
SqlCommand käsky = new SqlCommand(haku, dbYhteys);
SqlDataReader Lukija = käsky.ExecuteReader();
while (Lukija.Read())
{
Vari haeVarit = new Vari();
ID_string = string.Format("{0}", Lukija[0]);
id = int.Parse(ID_string);
Vari = string.Format("{0}", Lukija[1]);
haeVarit.Varit = Vari;
haeVarit.ID = id;
palaute.Add(haeVarit);
}
disconnectDatabase();
return(palaute);
}
public List <Vari> getColor()
{
myConnection = new SqlConnection(connectionstring);
Vari Vari;
List <Vari> Varit = new List <Vari>();
myConnection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM Varit", myConnection);
try
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i = i + 2)
{
Vari = new Vari();
Vari.ID1 = Convert.ToInt32(reader.GetValue(0));
Vari.AutonVari1 = Convert.ToString(reader.GetValue(1));
Varit.Add(Vari);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
myConnection.Close();
return(Varit);
}
public List <Vari> GetColors()
{
connectDB();
List <Vari> varit = new List <Vari>();
SqlCommand command = new SqlCommand("SELECT * FROM Autot.dbo.Varit", connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Vari vari = new Vari();
vari.Id = int.Parse(reader["Id"].ToString());
vari.VariNimi = reader["Varin_nimi"].ToString();
varit.Add(vari);
}
disconnectDB();
return(varit);
}
private int EdellisenAutonhaku(int nykyinenID)
{
Kulkuneuvo auto = Rekisteri.EdellinenAutoTietokannassa(nykyinenID);
Mittarilukema_Text.Text = auto.Mittarilukema.ToString();
Moottori_text.Text = auto.Moottorintilavuus.ToString();
Hinta_text.Text = auto.Hinta.ToString();
rekisteri_PVM.Value = auto.Rekisteröiti_päivämäärä;
Autonmerkki merkki = Rekisteri.HaeValmisMerkki(auto.AutonMerkkiID);
Autonmallit malli = Rekisteri.HaeValmisMalli(auto.AutonMalliID);
Vari vari = Rekisteri.HaeValittuVäri(auto.VaritID);
Polttoaine polttoaine = Rekisteri.HaeValittuPolttoaine(auto.PolttoaineID);
Merkki_laatikko.SelectedIndex = Merkki_laatikko.FindStringExact(merkki.MerkkiNimi);
malli_laatikko.SelectedIndex = malli_laatikko.FindStringExact(malli.MalliNimi);
Vari_laatikko.SelectedIndex = Vari_laatikko.FindStringExact(vari.Varit);
Polttoaine_laatikko.SelectedIndex = Polttoaine_laatikko.FindStringExact(polttoaine.Polttoaineet);
return(auto.Id);
}
public Vari HaeValittuVäri(int VariID)
{
Vari haeVari = new Vari();
string haku = "SELECT * FROM Varit A WHERE ID =" + VariID;
connectDatabase();
string Vari, ID_string;
int ID;
SqlCommand käsky = new SqlCommand(haku, dbYhteys);
SqlDataReader Lukija = käsky.ExecuteReader();
while (Lukija.Read())
{
ID_string = string.Format("{0}", Lukija[0]);
ID = int.Parse(ID_string);
haeVari.ID = ID;
Vari = string.Format("{0}", Lukija[1]);
haeVari.Varit = Vari;
}
disconnectDatabase();
return(haeVari);
}
protected override void Seed(TyonohjausDbContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
context.ProductPropertyDescriptions.AddOrUpdate(
p => p.Id,
new ProductPropertyDescription {
Id = 1, Description = "Kuvaus"
},
new ProductPropertyDescription {
Id = 2, Description = "Tuotekuva"
},
new ProductPropertyDescription {
Id = 3, Description = "Väri"
},
new ProductPropertyDescription {
Id = 4, Description = "Paino"
},
new ProductPropertyDescription {
Id = 5, Description = "Varastopaikka"
},
new ProductPropertyDescription {
Id = 6, Description = "Ripustusmäärä"
},
new ProductPropertyDescription {
Id = 7, Description = "Uunitusaika"
},
new ProductPropertyDescription {
Id = 8, Description = "Pesupaine"
},
new ProductPropertyDescription {
Id = 9, Description = "Maalauskierto"
},
new ProductPropertyDescription {
Id = 10, Description = "Maalausresepti"
}
);
context.TyoDescriptions.AddOrUpdate(
t => t.DescriptionId,
new TyoDescription {
DescriptionId = 1, Description = "Määrä"
},
new TyoDescription {
DescriptionId = 2, Description = "Väri"
},
new TyoDescription {
DescriptionId = 3, Description = "Työkoodi"
}
);
//Kieliasetus
var lang = (from s in context.Settings
where s.Description == "Language"
select s.Value).FirstOrDefault();
if (lang == null)
{
context.Settings.Add(new Setting()
{
Description = "Language",
Value = "fi-FI"
});
}
//Linjan suunta
var direction = (from s in context.Settings
where s.Description == "Direction"
select s.Value).FirstOrDefault();
if (direction == null)
{
context.Settings.Add(new Setting()
{
Description = "Direction",
Value = "clockwise"
});
}
//Pesupainevalinta
var pesupaine2 = (from s in context.Settings
where s.Description == "Pesupaine2"
select s.Value).FirstOrDefault();
if (pesupaine2 == null)
{
context.Settings.Add(new Setting()
{
Description = "Pesupaine2",
Value = "max bar"
});
}
//Uunitusaikavalinta
var uunitusaika2 = (from s in context.Settings
where s.Description == "Uunitusaika2"
select s.Value).FirstOrDefault();
if (uunitusaika2 == null)
{
context.Settings.Add(new Setting()
{
Description = "Uunitusaika2",
Value = "50"
});
}
string json = System.Text.Encoding.UTF8.GetString(Nipema.Tyonohjaus.EF.Properties.Resources.colors);
dynamic stuff = JsonConvert.DeserializeObject(json);
List <Vari> myList = new List <Vari>();
foreach (var o in stuff)
{
string x = o.Value.ToString();
Vari jc = JsonConvert.DeserializeObject <Vari>(x);
myList.Add(jc);
}
context.Varit.AddOrUpdate(
v => v.code,
myList.ToArray()
);
}
