/// <summary>
/// Delat old data base
/// </summary>
public void DelatOldDataBase()
{
ConnectionBD sqlConnection = new ConnectionBD();
sqlConnection.ConnectionTheBase(sqlConnection.sqlConnection);
SqlCommand command = new SqlCommand("DELETE [BazaBD]", sqlConnection.sqlConnection);
command.ExecuteNonQuery();
}
public string loaudBD(List <string[]> data)
{
ConnectionBD my_sqlConnection = new ConnectionBD();
my_sqlConnection.ConnectionTheBase(my_sqlConnection.sqlConnection);
try
{
string query = "SELECT * FROM BazaBD ORDER BY Id ";
SqlCommand command = new SqlCommand(query, my_sqlConnection.sqlConnection);
SqlDataReader reader = command.ExecuteReader();
//List<string[]> data = new List<string[]>();
while (reader.Read())
{
data.Add(new string[9]);
data[data.Count - 1][0] = reader[0].ToString(); data[data.Count - 1][1] = reader[1].ToString();
data[data.Count - 1][2] = reader[2].ToString(); data[data.Count - 1][3] = reader[3].ToString();
data[data.Count - 1][4] = reader[4].ToString(); data[data.Count - 1][5] = reader[5].ToString();
data[data.Count - 1][6] = reader[6].ToString(); data[data.Count - 1][7] = reader[7].ToString();
data[data.Count - 1][8] = reader[8].ToString();
}
reader.Close();
return(string.Join(" ", data));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (my_sqlConnection.sqlReader != null)
{
my_sqlConnection.sqlReader.Close();
my_sqlConnection.sqlConnection.Close();
}
}
return(string.Join(" ", data));
}
public void StartPrsingSet(string wwwAddresForm, string nrPag, string CodeBlockHtml1, string CodeBlockHtml2, string textBloc1_1, string textBloc1_2, string textBloc2_1, string textBloc2_2, string textBloc3_1,
string textBloc3_2, string textBloc4_1, string textBloc4_2, string textBloc5_1, string textBloc5_2,
string textBloc6_1, string textBloc6_2, string textBloc7_1, string textBloc7_2, string numberPage1_1, string numberPage1_2)
{
Controller controller = new Controller();
controller.DelatOldDataBase();
connection.ConnectionTheBase(connection.sqlConnection);
int numberOfPages = 1;
int identifierOfBase = 1;
int listNumberPages = 1;
for (int i = 1; i <= numberOfPages; i++)
{
nrPag = listNumberPages.ToString();
String Response;
System.Net.WebClient wc = new System.Net.WebClient();
wc.Encoding = Encoding.GetEncoding("UTF-8");
Response = wc.DownloadString(wwwAddresForm + nrPag);
string partParsingCode = $@"{CodeBlockHtml1}(.*?){CodeBlockHtml2}";
RegexOptions optionsRegex = RegexOptions.Singleline;
Regex regexMatch = new Regex(partParsingCode, optionsRegex);
MatchCollection parStringtParsingCode = regexMatch.Matches(Response);
int numberCollectionString = 0;
try
{
foreach (Match m in parStringtParsingCode)
{
ConnectionBD connectionString = new ConnectionBD();
connectionString.ConnectionTheBase(connectionString.sqlConnection);
SqlCommand command = new SqlCommand("INSERT INTO[BazaBD](Id, Title1, m2_1 , m2_2 , cena1, lokalizacja, id1, pokoje, list)" +
"VALUES (@Id, @Title1, @m2_1, @m2_2, @cena1, @lokalizacja, @id1, @pokoje, @list)",
connectionString.sqlConnection);
string TitleString = $@"{textBloc1_1}(.*?){textBloc1_2}";
Regex newTitleString = new Regex(TitleString, optionsRegex);
Match titleSample = newTitleString.Match(Convert.ToString(parStringtParsingCode[numberCollectionString]));
string title = titleSample.Groups[1].Value;
command.Parameters.AddWithValue("Title1", title.ToString());
string houseAreaString = $@"{textBloc2_1}(.*?){textBloc2_2}";
Regex houseAreaSample = new Regex(houseAreaString, optionsRegex);
Match houseArea = houseAreaSample.Match(Convert.ToString(parStringtParsingCode[numberCollectionString]));
string area = houseArea.Groups[1].Value;
command.Parameters.AddWithValue("m2_1", area.ToString());
string AreaYardString = $@"{textBloc3_1}(.*?){textBloc3_2}";
Regex AreaYardSample = new Regex(AreaYardString, optionsRegex);
Match AreaYardNew = AreaYardSample.Match(Convert.ToString(parStringtParsingCode[numberCollectionString]));
string areaYard = AreaYardNew.Groups[1].Value;
command.Parameters.AddWithValue("m2_2", areaYard.ToString());
string priceString = $@"{textBloc4_1}(.*?){textBloc4_2}";
Regex priceSample = new Regex(priceString, optionsRegex);
Match Price = priceSample.Match(Convert.ToString(parStringtParsingCode[numberCollectionString]));
string price = Price.Groups[1].Value;
command.Parameters.AddWithValue("cena1", price.ToString());
string locationString = $@"{textBloc5_1}(.*?){textBloc5_2}";
Regex locationSample = new Regex(locationString, optionsRegex);
Match Location = locationSample.Match(Convert.ToString(parStringtParsingCode[numberCollectionString]));
string location = Location.Groups[1].Value;
command.Parameters.AddWithValue("lokalizacja", location.ToString());
string IdentifierString = $@"{textBloc6_1}(.*?){textBloc6_2}";
Regex IdentifierSample = new Regex(IdentifierString, optionsRegex);
Match IdentifierNew = IdentifierSample.Match(Convert.ToString(parStringtParsingCode[numberCollectionString]));
string identifier = IdentifierNew.Groups[1].Value;
command.Parameters.AddWithValue("id1", identifier.ToString());
string RoomCountString = $@"{textBloc7_1}(.*?){textBloc7_2}";
Regex RoomCountSample = new Regex(RoomCountString, optionsRegex);
Match RoomCountNew = RoomCountSample.Match(Convert.ToString(parStringtParsingCode[numberCollectionString]));
string roomCount = RoomCountNew.Groups[1].Value;
command.Parameters.AddWithValue("pokoje", roomCount.ToString());
String NumberOfPagesString = System.Text.RegularExpressions.Regex.Match(Response, $@"{numberPage1_1}(.*?){numberPage1_2}").Groups[1].Value;
numberOfPages = Convert.ToInt32(NumberOfPagesString);
command.Parameters.AddWithValue("list", listNumberPages);
command.Parameters.AddWithValue("Id", identifierOfBase);
command.ExecuteNonQuery();
identifierOfBase++;
numberCollectionString++;
}
listNumberPages++;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}