public List <ServPeca> Carregar()
{
List <ServPeca> lista = new List <ServPeca>();
ServPeca s = new ServPeca();
DataBase bd = DataBase.GetInstance();
bd.GetConnection();
SQLiteConnection conn = new SQLiteConnection(Data);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM SERVPECA", conn);
SQLiteDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
s.CodPeca1 = int.Parse(dr["codPeca"].ToString());
s.CodServ1 = int.Parse(dr["codSev"].ToString());
s.Quantidade = int.Parse(dr["quantidade"].ToString());
lista.Add(new ServPeca(s.CodServ1, s.CodPeca1, s.Quantidade));
}
return(lista);
}
public List <Servico> test()
{
List <Stage> stages = new List <Stage>();
List <Servico> lista = new List <Servico>();
List <ServPeca> servPecas = new List <ServPeca>();
Servico s = new Servico();
Stage st = new Stage();
ServPeca sp = new ServPeca();
DataBase bd = DataBase.GetInstance();
bd.GetConnection();
SQLiteConnection conn = new SQLiteConnection(Data);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM SERVICO", conn);
SQLiteDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
s.Codigo = Int32.Parse(dr["codigo"].ToString());
s.CpfCliente1 = dr["cpfcliente"].ToString();
s.CpfFuncionario1 = dr["cpfFunc"].ToString();
s.PlacaCarro1 = dr["placaCarro"].ToString();
s.ValorTotal = double.Parse(dr["valorTotal"].ToString());
lista.Add(new Servico(s.Codigo, s.CpfCliente1, s.CpfFuncionario1, s.PlacaCarro1, s.ValorTotal));
}
return(lista);
}
public void Salvar(ServPeca sv)
{
DataBase bd = DataBase.GetInstance();
bd.GetConnection();
String sql = string.Format("INSERT INTO SERVPECA(codSev,codPeca,quantidade) VALUES ('{0}','{1}','{2}')", sv.CodServ1, sv.CodPeca1, sv.Quantidade);
bd.ExecuteSQL(sql);
}