protected void btnCreer_Click(object sender, EventArgs e)
{
recetteTableAdapter tableAdapter = new recetteTableAdapter();
QueriesTableAdapter queries = new QueriesTableAdapter();
DataTable table = tableAdapter.GetData();
string img = Image1.ImageUrl;
try
{
tableAdapter.Insert(TextBox1.Text, DateTime.Now, RadioButtonList1.SelectedValue, int.Parse(TextBox2.Text), TextBox3.Text, img, int.Parse(DropDownList1.SelectedValue));
}catch (Exception ex)
{
Label4.Visible = true;
return;
}
int recId = (int)queries.getLastRecetteId();
Response.Redirect("DetailRecette.aspx?code=" + recId + "&nom=" + TextBox1.Text);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//getComposition user-defined function in Sql Server, it returns recipe ingredients by the number of the recipe
getComposition rec = new getComposition();
int numRec = int.Parse(Request.QueryString["numRec"]);
Repeater1.DataSource = rec.GetData(numRec);
Repeater1.DataBind();
recetteTableAdapter recette = new recetteTableAdapter();
DataTable dt = recette.GetDataBy(numRec);
QueriesTableAdapter queries = new QueriesTableAdapter();
Label1.Text = dt.Rows[0][1].ToString();
Label2.Text += " " + dt.Rows[0][3].ToString();
Label3.Text += " " + Convert.ToDateTime(dt.Rows[0][2]).ToString("MM/dd/yyyy");
Label4.Text += " " + dt.Rows[0][4].ToString() + " min";
Label5.Text += " " + queries.getCoutForRecette(numRec);
string imgsrc = dt.Rows[0][6].ToString();
Image1.ImageUrl = imgsrc;
Label7.Text = dt.Rows[0][5].ToString();
}
}
