protected void addCelebrite()
{
Stream fs = FileUploadControl.PostedFile.InputStream;
using (BinaryReader br = new BinaryReader(fs))
{
byte[] bytes = br.ReadBytes((Int32)fs.Length);
using (SqlConnection con = new SqlConnection("Data Source=fp-server.database.windows.net;" +
"Initial Catalog=fp-database;User ID=fp-admin;Password=Cebula1."))
{
string query = "insert into CELEBRITE_ALBUM values (@id_character, @name, @surname, @image)";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@id_character", amount_character);
cmd.Parameters.AddWithValue("@name", name.Text);
cmd.Parameters.AddWithValue("@surname", surname.Text);
cmd.Parameters.AddWithValue("@image", bytes);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
bytes = null;
br.Dispose();
br.Close();
}
fs.Dispose();
fs.Close();
FileUploadControl.Dispose();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
Panel1.BackImageUrl = "~/res/img/face.JPG";
db = new SQLDatabase();
characters = new List <string>();
all_characters = new List <string>();
FileUploadControl.Dispose();
}
/// <summary>
/// Metoda wywoływana po wciśnięciu przycisku Wykonaj. Wstawia wskazane zdjęcie do bazy danych. Następnie zczytuje zamodelowaną twarz i wysyła przepis do silnika.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void UploadButton_Click(object sender, EventArgs e)
{
db.Connect();
id = db.getId((string)Session["id"]);
db.InsertCharacter();
amount_character = db.AmountCharacters();
db.Disconnect();
Stream fs = FileUploadControl.PostedFile.InputStream;
using (BinaryReader br = new BinaryReader(fs))
{
byte[] bytes = br.ReadBytes((Int32)fs.Length);
using (SqlConnection con = new SqlConnection("Data Source=fp-server.database.windows.net;" +
"Initial Catalog=fp-database;User ID=fp-admin;Password=Cebula1."))
{
string query = "insert into USER_ALBUM values (@id_user, @id_character, @image)";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@id_user", id);
cmd.Parameters.AddWithValue("@id_character", amount_character);
cmd.Parameters.AddWithValue("@image", bytes);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
bytes = null;
br.Dispose();
br.Close();
}
fs.Dispose();
fs.Close();
FileUploadControl.Dispose();
checkCharacter();
exec(id, recepta);
if (oneCelebrite.Checked)
{
if (ranking.Checked)
{
Response.Redirect("Raport.aspx?type=one&ranking=true");
}
else
{
Response.Redirect("Raport.aspx?type=one&ranking=false");
}
}
else if (allCelebrite.Checked)
{
if (ranking.Checked)
{
Response.Redirect("Raport.aspx?type=all&ranking=true");
}
else
{
Response.Redirect("Raport.aspx?type=all&ranking=false");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
FileUploadControl.Dispose();
db = new SQLDatabase();
FileUploadControl.Dispose();
}
