C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;

namespace turism
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        public static string constr = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lasth\Desktop\Olimpiada\turism\turism\bin\Debug\Turism.mdf;Integrated Security=True;Connect Timeout=30";

        private void sterge()
        {
            SqlConnection con = new SqlConnection(constr);
            con.Open();
            SqlCommand cmd = new SqlCommand("Delete From Imagini", con);
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            cmd = new SqlCommand("Delete from Planificari", con);
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            cmd = new SqlCommand("Delete from Localitati", con);
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
        }

        private static void Initializare()
        {
            SqlConnection con = new SqlConnection(constr);
            SqlCommand cmd;
            StreamReader sr = new StreamReader(Application.StartupPath + @"\..\..\planificari.txt");
            string sir;
            char[] split = { '*' };
            con.Open();
            DateTime dt1, dt2;
            while ((sir = sr.ReadLine()) != null)
            {
                string[] siruri = sir.Split(split);
                cmd = new SqlCommand("INSERT INTO Localitati(Nume) VALUES (@Localitate)", con);
                cmd.Parameters.AddWithValue("Localitate", siruri[0].Trim());
                cmd.ExecuteNonQuery();
                cmd = new SqlCommand("SELECT IDLocalitate FROM Localitati WHERE nume=@nume", con);
                cmd.Parameters.AddWithValue("nume", siruri[0].Trim());
                int IDLocalitate = Convert.ToInt32(cmd.ExecuteScalar());
                int nrzile;
                switch(siruri[1].Trim())
                {
                    case "ocazional":
                        string d1 = siruri[2], d2 = siruri[3];
                        dt1 = Convert.ToDateTime(d1.Trim(), System.Globalization.CultureInfo.GetCultureInfo("fr-FR"));
                        dt2 = Convert.ToDateTime(d2.Trim(), System.Globalization.CultureInfo.GetCultureInfo("fr-FR"));
                        int i = 4;
                        while (i < siruri.Length)
                        {
                            cmd = new SqlCommand(@"INSERT INTO Imagini(IDLocalitate, CaleFisier) values(@IDLocalitate, @Calefisier)", con);
                            cmd.Parameters.AddWithValue("IDLocalitate", IDLocalitate);
                            cmd.Parameters.AddWithValue("calefisier", siruri[i].Trim());
                            cmd.ExecuteNonQuery();
                            i++;
                        }
                        cmd = new SqlCommand(@"INSERT INTO Planificari(IDLocalitate,Frecventa, datastart, datastop) VALUES(@IDLocalitate, @frecventa, @datastart, @datastop)", con);
                        cmd.Parameters.AddWithValue("IDLocalitate", IDLocalitate);
                        cmd.Parameters.AddWithValue("frecventa", "ocazional");
                        cmd.Parameters.AddWithValue("datastart", dt1);
                        cmd.Parameters.AddWithValue("datastop", dt2);
                        cmd.ExecuteNonQuery();
                        break;
                    case "anual":
                        nrzile = int.Parse(siruri[2]);
                        i = 3;
                        while (i < siruri.Length)
                        {
                            cmd = new SqlCommand(@"INSERT INTO Imagini(IDLocalitate, CaleFisier) values(@IDLocalitate, @Calefisier)", con);
                            cmd.Parameters.AddWithValue("IDLocalitate", IDLocalitate);
                            cmd.Parameters.AddWithValue("calefisier", siruri[i].Trim());
                            cmd.ExecuteNonQuery();
                            i++;
                        }
                        cmd = new SqlCommand(@"INSERT INTO Planificari(IDLocalitate,Frecventa, ziua) VALUES(@IDLocalitate, @frecventa, @ziua)", con);
                        cmd.Parameters.AddWithValue("IDLocalitate", IDLocalitate);
                        cmd.Parameters.AddWithValue("frecventa", "anual");
                        cmd.Parameters.AddWithValue("ziua", nrzile);
                        cmd.ExecuteNonQuery();
                        break;
                    case "lunar":
                        nrzile = int.Parse(siruri[2]);
                        i = 3;
                        while (i < siruri.Length)
                        {
                            cmd = new SqlCommand(@"INSERT INTO Imagini(IDLocalitate, CaleFisier) values(@IDLocalitate, @Calefisier)", con);
                            cmd.Parameters.AddWithValue("IDLocalitate", IDLocalitate);
                            cmd.Parameters.AddWithValue("calefisier", siruri[i].Trim());
                            cmd.ExecuteNonQuery();
                            i++;
                        }
                        cmd = new SqlCommand(@"INSERT INTO Planificari(IDLocalitate,Frecventa, ziua) VALUES(@IDLocalitate, @frecventa, @ziua)", con);
                        cmd.Parameters.AddWithValue("IDLocalitate", IDLocalitate);
                        cmd.Parameters.AddWithValue("frecventa", "lunar");
                        cmd.Parameters.AddWithValue("ziua", nrzile);
                        cmd.ExecuteNonQuery();
                        break;
                }
            }
            MessageBox.Show("Succes");
        }
        private void button1_Click(object sender, EventArgs e)
        {
            sterge();
            Initializare();

        }

        private void button2_Click(object sender, EventArgs e)
        {
            Form2 f = new Form2();
            f.ShowDialog();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }
    }
}