public static void GrabarDB(DataSet dt, bool grabarFallidas)
{
MySqlConnection SqlConnection1;
SqlConnection1 = DALBase.GetConnection();
MySqlDataAdapter da = AdaptadorABM(SqlConnection1);
da.Update(dt, "Clientes");
SqlConnection1.Close();
}
public static void GrabarDB(DataTable tbl)
{
MySqlConnection SqlConnection1;
SqlConnection1 = DALBase.GetConnection();
MySqlDataAdapter da = AdaptadorABM(SqlConnection1);
da.Update(tbl);
SqlConnection1.Close();
}
private static MySqlDataAdapter AdaptadorGetArticulosBorrar()
{
MySqlConnection SqlConnection1;
MySqlDataAdapter SqlDataAdapter1;
MySqlCommand SqlSelectCommand1;
SqlConnection1 = DALBase.GetConnection();
SqlDataAdapter1 = new MySqlDataAdapter();
SqlSelectCommand1 = new MySqlCommand("Articulos_BorrarCons", SqlConnection1);
SqlDataAdapter1.SelectCommand = SqlSelectCommand1;
SqlSelectCommand1.CommandType = CommandType.StoredProcedure;
SqlConnection1.Close();
return(SqlDataAdapter1);
}
public static void BorrarByPK(int PK, bool borrarRemotas)
{
MySqlConnection SqlConnection1;
SqlConnection1 = DALBase.GetConnection();
MySqlDataAdapter SqlDataAdapter1 = new MySqlDataAdapter();
MySqlCommand SqlDeleteCommand1 = new MySqlCommand("Ventas_Borrar", SqlConnection1);
SqlDataAdapter1.DeleteCommand = SqlDeleteCommand1;
SqlDeleteCommand1.Parameters.AddWithValue("p_id", PK);
SqlDeleteCommand1.CommandType = CommandType.StoredProcedure;
SqlDeleteCommand1.ExecuteNonQuery();
SqlConnection1.Close();
}
public static DataSet GetData()
{
MySqlConnection SqlConnection1;
MySqlDataAdapter SqlDataAdapter1;
MySqlCommand SqlSelectCommand1;
SqlConnection1 = DALBase.GetConnection();
SqlDataAdapter1 = new MySqlDataAdapter();
SqlSelectCommand1 = new MySqlCommand("DatosServer_Listar", SqlConnection1);
SqlDataAdapter1.SelectCommand = SqlSelectCommand1;
SqlSelectCommand1.CommandType = CommandType.StoredProcedure;
datos = new DataSet();
SqlDataAdapter1.Fill(datos);
SqlConnection1.Close();
return(datos);
}
public void CadastrarSeguro(Seguro seguro)
{
MySqlConnection conn = new SqlConnection1().Criar();
MySqlCommand command = new MySqlCommand("INSERT INTO Seguro (Seguradora, Veiculo_Id, Plano, Apolice, Validade) values (@Seguradora, @Veiculo_Id, @Plano, @Apolice, @Validade)", conn);
command.Parameters.Add(new MySqlParameter("Seguradora", seguro.Seguradora));
command.Parameters.Add(new MySqlParameter("Veiculo_Id", seguro.Veiculo_id));
command.Parameters.Add(new MySqlParameter("Plano", seguro.Plano));
command.Parameters.Add(new MySqlParameter("Apolice", seguro.Apolice));
command.Parameters.Add(new MySqlParameter("Validade", seguro.Validade));
command.Prepare();
try
{
command.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
