protected void Button_Opret_Click(object sender, EventArgs e)
{
string pris = TextBox_Price.Text;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = @"INSERT INTO products(product_name, FK_category_id, product_price, product_storage, product_min_storage, product_max_storage, product_recomended_dirt, product_growthtime, product_image_1, product_image_2, product_image_3, product_description, product_number) VALUES (@name, @fk_category, @price, @storage, @min_storage, @max_storage, @recomended_dirt, @growthtime, @image1, @image2, @image3, @description, @number);";
cmd.Parameters.AddWithValue("@name", TextBox_Name.Text);
cmd.Parameters.AddWithValue("@price", Convert.ToDecimal(pris));
cmd.Parameters.AddWithValue("@storage", TextBox_Storage.Text);
cmd.Parameters.AddWithValue("@min_storage", TextBox_Min_Storage.Text);
cmd.Parameters.AddWithValue("@max_storage", TextBox_Max_Storage.Text);
cmd.Parameters.AddWithValue("@recomended_dirt", TextBox_Dirt.Text);
cmd.Parameters.AddWithValue("@growthtime", TextBox_Time.Text);
cmd.Parameters.AddWithValue("@description", TextBox_Description.Text);
cmd.Parameters.AddWithValue("@number", TextBox_Productnumber.Text);
cmd.Parameters.AddWithValue("@fk_category", DropDownList_Categorys.SelectedValue);
//database sti til billede
string bill_sti = "intetbillede.jpg";
//Hvis der er en fil i FilUploaden
#region image1
if (FileUpload_Img1.HasFile)
{
//NewGuid danner uniq navn for billeder
bill_sti = Guid.NewGuid() + Path.GetExtension(FileUpload_Img1.FileName);
// Opret
String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/");
String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/");
String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img1.FileName;
bill_sti = Filnavn;
//Gem det orginale Billede
FileUpload_Img1.SaveAs(UploadeMappe + Filnavn);
// Definer hvordan
ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings();
//Lav nogle nye skalerings instillinger
BilledeSkalering = new ImageResizer.ResizeSettings();
BilledeSkalering.Width = 120;
BilledeSkalering.Height = 90;
BilledeSkalering.Mode = ImageResizer.FitMode.Crop;
//Udfør selve skaleringen
ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering);
}
// Tildel parameter-værdierne, fra input felterne.
cmd.Parameters.AddWithValue("@image1", bill_sti);
#endregion
#region image2
if (FileUpload_Img2.HasFile)
{
//NewGuid danner uniq navn for billeder
bill_sti = Guid.NewGuid() + Path.GetExtension(FileUpload_Img2.FileName);
// Opret
String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/");
String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/");
String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img2.FileName;
bill_sti = Filnavn;
//Gem det orginale Billede
FileUpload_Img2.SaveAs(UploadeMappe + Filnavn);
// Definer hvordan
ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings();
//Lav nogle nye skalerings instillinger
BilledeSkalering = new ImageResizer.ResizeSettings();
BilledeSkalering.Width = 90;
BilledeSkalering.Height = 120;
BilledeSkalering.Mode = ImageResizer.FitMode.Crop;
//Udfør selve skaleringen
ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering);
}
// Tildel parameter-værdierne, fra input felterne.
cmd.Parameters.AddWithValue("@image2", bill_sti);
#endregion
#region image3
if (FileUpload_Img3.HasFile)
{
//NewGuid danner uniq navn for billeder
bill_sti = Guid.NewGuid() + Path.GetExtension(FileUpload_Img3.FileName);
// Opret
String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/");
String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/");
String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img3.FileName;
bill_sti = Filnavn;
//Gem det orginale Billede
FileUpload_Img3.SaveAs(UploadeMappe + Filnavn);
// Definer hvordan
ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings();
//Lav nogle nye skalerings instillinger
BilledeSkalering = new ImageResizer.ResizeSettings();
BilledeSkalering.Width = 90;
BilledeSkalering.Height = 120;
BilledeSkalering.Mode = ImageResizer.FitMode.Crop;
//Udfør selve skaleringen
ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering);
}
// Tildel parameter-værdierne, fra input felterne.
cmd.Parameters.AddWithValue("@image3", bill_sti);
#endregion
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
Response.Redirect("Produkter.aspx");
}
protected void Button_Gem_Ret_Click(object sender, EventArgs e)
{
string pris = TextBox_Price.Text;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = @"UPDATE products SET product_name = @name, FK_category_id = @fk_category, product_price = @price, product_storage = @storage, product_min_storage = @min_storage, product_max_storage = @max_storage, product_recomended_dirt = @dirt, product_growthtime = @growthtime, product_image_1 = @image1, product_image_2 = @image2, product_image_3 = @image3, product_description = @description, product_number = @number WHERE product_id = @product_id";
cmd.Parameters.AddWithValue("@product_id", ViewState["product_id"]);
cmd.Parameters.AddWithValue("@name", TextBox_Name.Text);
cmd.Parameters.AddWithValue("@number", TextBox_Productnumber.Text);
cmd.Parameters.AddWithValue("@price", Convert.ToDecimal(pris));
cmd.Parameters.AddWithValue("@storage", TextBox_Storage.Text);
cmd.Parameters.AddWithValue("@min_storage", TextBox_Min_Storage.Text);
cmd.Parameters.AddWithValue("@max_storage", TextBox_Max_Storage.Text);
cmd.Parameters.AddWithValue("@dirt", TextBox_Dirt.Text);
cmd.Parameters.AddWithValue("@growthtime", TextBox_Time.Text);
cmd.Parameters.AddWithValue("@description", TextBox_Description.Text);
cmd.Parameters.AddWithValue("@fk_category", DropDownList_Categorys.SelectedValue);
#region Image 1
string product_image1 = HiddenField_oldImage1.Value;
if (FileUpload_Img1.HasFile)
{
//NewGuid danner uniq navn for billeder
product_image1 = Guid.NewGuid() + Path.GetExtension(FileUpload_Img1.FileName);
// Opret
String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/");
String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/");
String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img1.FileName;
product_image1 = Filnavn;
//Gem det orginale Billede
FileUpload_Img1.SaveAs(UploadeMappe + Filnavn);
// Definer hvordan
ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings();
//Lav nogle nye skalerings instillinger
BilledeSkalering = new ImageResizer.ResizeSettings();
BilledeSkalering.Width = 120;
BilledeSkalering.Height = 90;
//Udfør selve skaleringen
ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering);
string old_img = HiddenField_oldImage1.Value;
if (File.Exists(Server.MapPath("~/images/resizer/Croppede/") + old_img))
{
File.Delete(Server.MapPath("~/images/resizer/Croppede/") + old_img);
}
if (File.Exists(Server.MapPath("~/images/resizer/Original_Images/") + old_img))
{
File.Delete(Server.MapPath("~/images/resizer/Original_Images/") + old_img);
}
}
cmd.Parameters.AddWithValue("@image1", product_image1);
#endregion
#region image 2
string product_image2 = HiddenField_oldImage2.Value;
if (FileUpload_Img2.HasFile)
{
//NewGuid danner uniq navn for billeder
product_image2 = Guid.NewGuid() + Path.GetExtension(FileUpload_Img2.FileName);
// Opret
String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/");
String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/");
String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img2.FileName;
product_image2 = Filnavn;
//Gem det orginale Billede
FileUpload_Img2.SaveAs(UploadeMappe + Filnavn);
// Definer hvordan
ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings();
//Lav nogle nye skalerings instillinger
BilledeSkalering = new ImageResizer.ResizeSettings();
BilledeSkalering.Width = 120;
BilledeSkalering.Height = 90;
//Udfør selve skaleringen
ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering);
string old_img = HiddenField_oldImage2.Value;
if (File.Exists(Server.MapPath("~/images/resizer/Croppede/") + old_img))
{
File.Delete(Server.MapPath("~/images/resizer/Croppede/") + old_img);
}
if (File.Exists(Server.MapPath("~/images/resizer/Original_Images/") + old_img))
{
File.Delete(Server.MapPath("~/images/resizer/Original_Images/") + old_img);
}
}
cmd.Parameters.AddWithValue("@image2", product_image2);
#endregion
#region Image 3
string product_image3 = HiddenField_oldImage3.Value;
if (FileUpload_Img3.HasFile)
{
//NewGuid danner uniq navn for billeder
product_image3 = Guid.NewGuid() + Path.GetExtension(FileUpload_Img3.FileName);
// Opret
String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/");
String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/");
String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img3.FileName;
product_image3 = Filnavn;
//Gem det orginale Billede
FileUpload_Img3.SaveAs(UploadeMappe + Filnavn);
// Definer hvordan
ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings();
//Lav nogle nye skalerings instillinger
BilledeSkalering = new ImageResizer.ResizeSettings();
BilledeSkalering.Width = 120;
BilledeSkalering.Height = 90;
//Udfør selve skaleringen
ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering);
string old_img = HiddenField_oldImage3.Value;
if (File.Exists(Server.MapPath("~/images/resizer/Croppede/") + old_img))
{
File.Delete(Server.MapPath("~/images/resizer/Croppede/") + old_img);
}
if (File.Exists(Server.MapPath("~/images/resizer/Original_Images/") + old_img))
{
File.Delete(Server.MapPath("~/images/resizer/Original_Images/") + old_img);
}
}
cmd.Parameters.AddWithValue("@image3", product_image3);
#endregion
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
Response.Redirect("Produkter.aspx");
}
