public void AddCat(Cat cat, string changes)
{
var conn = new SqlConnection(GetConnectionString());
var sql = "INSERT INTO " + _table + " VALUES('" + cat.GetBreed().Trim() + "','" + cat.GetCountry().Trim() + "','" + cat.GetOrigin().Trim() + "','" + cat.GetBodyType().Trim() + "','" + cat.GetCoat().Trim() + "','" + cat.GetPattern().Trim() + "','" + cat.GetImage().Trim() + "','" + cat.GetInfo().Trim();
if (_admin)
{
sql += "','" + changes;
}
sql += "')";
try
{
conn.Open();
var cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
var msg = "AddCat Sql Error: ";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
conn.Close();
}
}
//protected void TextStyle(object sender, EventArgs e)
//{
// var btn = (Button)sender;
// var btnText = btn.Text;
// if (btnText.Equals("b"))
// {
// }
// else if (btnText.Equals("/"))
// {
// }
// else if (btnText.Equals("_"))
// {
// }
// else if (btnText.Equals("h1"))
// {
// }
// else if (btnText.Equals("h2"))
// {
// }
// else if (btnText.Equals("h3"))
// {
// textDiv.InnerHtml += "catInformation";
// }
//}
protected void SubmitButton_Click(object sender, EventArgs e)
{
//ADD IMAGE!!!!!!!!!!!!
var breed = CatBreedNameTextBox.Text.Trim();
var country = CountryTextBox.Text.Trim();
var origin = OriginTextBox.Text.Trim();
var bodyType = BodyTypeTextBox.Text.Trim();
var coat = CoatTextBox.Text.Trim();
var pattern = PatternTextBox.Text.Trim();
var image = "";
var information = EditTextBox.Text.Trim();
var cat = new Cat(breed, country, origin, bodyType, coat, pattern, image, information);
if (_admin == false)
{
_catBL.AddCat(cat, "new cat");
Response.Write("<script>alert('You successfully added a breed, the changes are waiting for the approval of the administrator');</script>");
}
else
{
if (_catBL.AddCat(cat, ""))
{
Response.Write("<script>alert('You successfully added a breed');</script>");
return;
}
Response.Write("<script>alert('Breed is already exists, try the add specifications page');</script>");
}
Page_Load(sender, e);
}
public Boolean AddCat(Cat cat, string changes)
{
var catBl = new CatBL(_admin);
if (!_admin && catBl.IsCatExist(cat.GetBreed().Trim()))
{
return false;
}
_catDal.AddCat(cat, changes);
return true;
}
public Cat GetCat(string breed)
{
Cat cat = null;
var conn = new SqlConnection(GetConnectionString());
var sql = "SELECT * FROM " + _table + " WHERE [Breed]='" + breed + "'";
try
{
conn.Open();
var cmd = new SqlCommand(sql, conn);
var catReader = cmd.ExecuteReader();
if (catReader.HasRows)
{
catReader.Read();
cat = new Cat(Convert.ToString(catReader["Breed"]).Trim(),
Convert.ToString(catReader["Country"]).Trim(),
Convert.ToString(catReader["Origin"]).Trim(),
Convert.ToString(catReader["Body Type"]).Trim(),
Convert.ToString(catReader["Coat"]).Trim(),
Convert.ToString(catReader["Pattern"]).Trim(),
Convert.ToString(catReader["Image"]).Trim(),
Convert.ToString(catReader["Information"]).Trim());
}
}
catch (SqlException ex)
{
var msg = "GetCat Sql Error: ";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
conn.Close();
}
return cat;
}
public LinkedList<Cat> GetAllCatsWithChanges()
{
var catsList = new LinkedList<Cat>();
var conn = new SqlConnection(GetConnectionString());
const string sql = "SELECT * FROM CatsAdmin";
try
{
conn.Open();
var cmd = new SqlCommand(sql, conn);
var catsReader = cmd.ExecuteReader();
if (catsReader.HasRows)
{
while (catsReader.Read())
{
var cat = new Cat(Convert.ToString(catsReader["Breed"]).Trim(),
Convert.ToString(catsReader["Country"]).Trim(),
Convert.ToString(catsReader["Origin"]).Trim(),
Convert.ToString(catsReader["Body Type"]).Trim(),
Convert.ToString(catsReader["Coat"]).Trim(),
Convert.ToString(catsReader["Pattern"]).Trim(),
Convert.ToString(catsReader["Image"]).Trim(),
Convert.ToString(catsReader["Information"]).Trim(),
Convert.ToString(catsReader["Changes"]).Trim());
if (catsList.Count == 0)
{
catsList.AddFirst(cat);
}
else
{
catsList.AddAfter(catsList.Last, cat);
}
}
}
}
catch (SqlException ex)
{
var msg = "GetAllCatsWithChanges Sql Error: ";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
conn.Close();
}
return catsList;
}
public LinkedList<Cat> FindBreedBySpecifications(string[] specifications)
{
var breedList = new LinkedList<Cat>();
var conn = new SqlConnection(GetConnectionString());
var sql = "SELECT [Breed], [Image] FROM " + _table + " WHERE [Body type]='" + specifications[0] + "' OR [Coat]='" + specifications[1] + "' OR [Pattern]='" + specifications[2] + "'";
try
{
conn.Open();
var cmd = new SqlCommand(sql, conn);
var breedAndImageReader = cmd.ExecuteReader();
while (breedAndImageReader.Read())
{
var cat = new Cat(Convert.ToString(breedAndImageReader["Breed"]).Trim(), Convert.ToString(breedAndImageReader["Image"]).Trim());
if (breedList.Count == 0)
{
breedList.AddFirst(cat);
}
else
{
breedList.AddAfter(breedList.Last, cat);
}
}
}
catch (SqlException ex)
{
var msg = "FindBreedBySpecification Sql Error: ";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
conn.Close();
}
return breedList;
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
var breed = ChooseBreedDownList.SelectedItem.Text.Trim();
var country = CountryTextBox.Text.Trim();
var origin = OriginTextBox.Text.Trim();
var bodyType = BodyTypeTextBox.Text.Trim();
var coat = CoatTextBox.Text.Trim();
var pattern = PatternTextBox.Text.Trim();
var image = "";
var specifications = new string[6];
specifications[0] = "Country";
specifications[1] = "Origin";
specifications[2] = "Body Type";
specifications[3] = "Coat";
specifications[4] = "Pattern";
specifications[5] = "Image";
var specificationsValues = new string[7];
specificationsValues[0] = country;
specificationsValues[1] = origin;
specificationsValues[2] = bodyType;
specificationsValues[3] = coat;
specificationsValues[4] = pattern;
specificationsValues[5] = image;
if (_admin == false)
{
var cat = _userCatBL.GetCat(breed);
var newCat = new Cat(breed, country, origin, bodyType, coat, pattern, cat.GetInfo(), image);
_catBL.AddCat(newCat, "specifications");
}
else
{
_catBL.AddSpecificationsToBreed(breed, specifications, specificationsValues);
}
Response.Write(_admin
? "<script>alert('You successfully added specifications');</script>"
: "<script>alert('You successfully added specifications, the changes are waiting for the approval of the administrator');</script>");
}