protected void Button1_Click1(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
int imgWidth = new ContentManager().BannerWidth;
int imgHeight = new ContentManager().BannerHeight;
int impressions = 0; // Impressions
impressions = int.Parse(tbFrequence.Text); // Create the impressions
int Index = 0;
string Namn = tbName.Text;
Namn = Namn.Replace("'", "");
string Beskrivning = tbText.Text;
Beskrivning = Beskrivning.Replace("'", "");
string AltText = tbAltText.Text;
AltText = AltText.Replace("'", "");
string Url = tbLink.Text;
string Keywords = tbKeywords.Text;
DateTime _StartDate = StartTime.SelectedDate;
DateTime _EndDate = EndTime.SelectedDate;
System.Web.HttpPostedFile a = FileUpload1.PostedFile;
StreamReader f = new StreamReader(a.InputStream);
Byte[] Bytes = new Byte[f.BaseStream.Length];
a.InputStream.Read(Bytes, 0, Bytes.Length);
/*
* If advertisement directory does not exists,
* create it
* */
String targetDirectory = Server.MapPath("..\\ads\\");
String fileName = targetDirectory + FileUpload1.FileName;
if (!Directory.Exists(targetDirectory))
{
Directory.CreateDirectory(targetDirectory);
}
FileStream Writer = new FileStream(fileName, FileMode.Create);
Writer.Write(Bytes, 0, Bytes.Length);
Writer.Close();
Bitmap img = (Bitmap)Bitmap.FromFile(fileName);
// If the image's ratio is wrong, do not continue
if (!(img.Width == imgWidth && img.Height == imgHeight))
{
// Raise the image validator error
imageValidator.IsValid = false;
imageValidator.Text = "Bilden måste vara exakt "+imgWidth.ToString()+" pixlar bred x "+imgHeight.ToString()+" pixlar hög";
// invalidate the request
return;
}
SqlConnection Conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);
Conn.Open();
if (Index == 0)
{
SqlCommand Query = new System.Data.SqlClient.SqlCommand(@"INSERT INTO ads(startDate,endDate,ImageUrl,NavigateUrl,AlternateText,Keywords,Impressions,Width,Height) VALUES ('" + _StartDate.ToString("yyyy-MM-dd HH:mm:ss") + "','" + _EndDate.ToString("yyyy-MM-dd HH:mm:ss") + "','ads/" + FileUpload1.FileName + "','" + Url + "','" + AltText + "','" + Keywords + "'," + impressions.ToString() + "," + imgWidth + "," + imgHeight + ")", Conn);
Query.ExecuteNonQuery();
var id = new SqlCommand("SELECT @@IDENTITY", Conn).ExecuteScalar();
Query = new SqlCommand(@"UPDATE ads SET NavigateUrl = '"+Url.Replace("'","")+"', clicks = 0 WHERE id = " + id, Conn);
Query.ExecuteNonQuery();
}
else
{
SqlCommand Query = new System.Data.SqlClient.SqlCommand("UPDATE ads SET startDate='" + _StartDate.ToString("yyyy'-'MM'-'dd' 'HH':'mm':'ss") + "',endDate='" + _EndDate.ToString("yyyy-MM-dd HH:mm:ss") + "',keywords='" + Keywords + "',AlternateText='" + AltText + "' WHERE ads.ID=" + Index + "");
Query.ExecuteNonQuery();
Conn.Close();
}
Response.Redirect("banners.aspx");
}
