public Countrie Get(string Country)
{
Countrie data = null;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"SELECT * FROM Countries WHERE CountryName = @CountryName";
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@CountryName", Country);
using (SqlDataReader dbReader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
if (dbReader.Read())
{
data = new Countrie()
{
CountryName = Convert.ToString(dbReader["CountryName"])
};
}
}
connection.Close();
}
return(data);
}
public void ReadAdressFile()
{
string text = System.IO.File.ReadAllText(@"C:\Users\GodOfWar\Desktop\db.sql");
text = text.Replace("\n", "");
text = text.Replace("'", "");
string[] CRC = text.Split(new string[] { "INSERT INTO" }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < CRC.Length; i++)
{
CRC[i] = CRC[i].Split(new string[] { "VALUES" }, StringSplitOptions.RemoveEmptyEntries)[1];
}
using (var context = new EstablishmentContext())
{
string[] cities = CRC[0].Split(new string[] { ")," }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < cities.Length; i++)
{
string[] element = cities[i].Split(new string[] { "," }, StringSplitOptions.None);
element[0] = element[0].Replace("(", "");
City city = new City()
{
Id_City = int.Parse(element[0].Replace(" ", "")),
Id_Region = int.Parse(element[1].Replace(" ", "")),
Id_Country = int.Parse(element[2].Replace(" ", "")),
Name = element[3] != "" ? element[3] : "--"
};
context.Cityes.Add(city);
}
string[] countries = CRC[1].Split(new string[] { ")," }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < countries.Length; i++)
{
string[] element = countries[i].Split(new string[] { "," }, StringSplitOptions.None);
element[0] = element[0].Replace("(", "");
Countrie countrie = new Countrie()
{
Id_Country = int.Parse(element[0].Replace(" ", "")),
Name = element[1] != "" ? element[1] : "--"
};
context.Countries.Add(countrie);
}
string[] regions = CRC[2].Split(new string[] { ")," }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < regions.Length; i++)
{
string[] element = regions[i].Split(new string[] { "," }, StringSplitOptions.None);
element[0] = element[0].Replace("(", "");
Region region = new Region()
{
Id_Region = int.Parse(element[0].Replace(" ", "")),
Id_Country = int.Parse(element[1].Replace(" ", "")),
Name = element[2] != "" ? element[2] : "--"
};
context.Regions.Add(region);
}
context.SaveChanges();
}
}
public ActionResult Input(string id = "")
{
if (string.IsNullOrEmpty(id))
{
ViewBag.Title = "Create new country";
ViewBag.SmallTitle = "Thêm Quốc Gia";
Countrie newCountry = new Countrie()
{
CountryName = ""
};
return(View(newCountry));
}
else
{
ViewBag.Title = "Edit a country";
ViewBag.SmallTitle = "Sửa Quốc Gia";
Countrie editCountry = CatalogBLL.Get(id);
return(View(editCountry));
}
}
public int Add(Countrie data)
{
int countryId = 0;
using (SqlConnection connection = new SqlConnection(this.connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"INSERT INTO Countries (CountryName) VALUES(@CountryName)";
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@CountryName", data.CountryName);
countryId = Convert.ToInt32(cmd.ExecuteScalar());
connection.Close();
}
return(countryId);
}
public ActionResult Input(Countrie model, string method, string country)
{
if (string.IsNullOrEmpty(model.CountryName))
{
ModelState.AddModelError("CountryName", "CountryName Expected");
}
if (!ModelState.IsValid)
{
ViewBag.Title = model.CountryName == "" ? "Create new Country" : "Edit a Country";
return(View(model));
}
if (method == "Edit a country")
{
CatalogBLL.Update(model, country);
}
else
{
if (CatalogBLL.Get(model.CountryName) != null)
{
ModelState.AddModelError("CountryName", "CountryName Existed");
if (!ModelState.IsValid)
{
ViewBag.Title = model.CountryName == "" ? "Create new Country" : "Edit a Country";
return(View(model));
}
}
else
{
CatalogBLL.Add(model);
}
}
return(RedirectToAction("Index"));
}
public bool Update(Countrie data, string country)
{
int rowsAffected = 0;
using (SqlConnection connection = new SqlConnection(this.connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"UPDATE Countries
SET CountryName = @CountryName
WHERE CountryName = @country";
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@CountryName", data.CountryName);
cmd.Parameters.AddWithValue("@country", country);
rowsAffected = Convert.ToInt32(cmd.ExecuteNonQuery());
connection.Close();
}
return(rowsAffected > 0);
}
public static bool Update(Countrie data, string country)
{
return(CountrieDB.Update(data, country));
}
public static int Add(Countrie data)
{
return(CountrieDB.Add(data));
}
