///<summary>
/// Reklam Data Update
///</summary>
public static int Update(Reklam p)
{
int rowsAffected = 0;
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "UPDATE Reklam SET BannerName=@BannerName,ImageUrl=@ImageUrl,NavigateUrl=@NavigateUrl,AlternateText=@AlternateText,Keyword=@Keyword,Impressions=@Impressions,Width=@Width,Height=@Height,IsActive=@IsActive WHERE ID=@ID", conneciton))
{
cmd.Parameters.Add("ID", p.ID, MSqlDbType.Int);
cmd.Parameters.Add("BannerName", p.BannerName, MSqlDbType.NVarChar);
cmd.Parameters.Add("ImageUrl", p.ImageUrl, MSqlDbType.VarChar);
cmd.Parameters.Add("NavigateUrl", p.NavigateUrl, MSqlDbType.VarChar);
cmd.Parameters.Add("AlternateText", p.AlternateText, MSqlDbType.NVarChar);
cmd.Parameters.Add("Keyword", p.Keyword, MSqlDbType.NVarChar);
cmd.Parameters.Add("Impressions", p.Impressions, MSqlDbType.Int);
cmd.Parameters.Add("Width", p.Width, MSqlDbType.Int);
cmd.Parameters.Add("Height", p.Height, MSqlDbType.Int);
cmd.Parameters.Add("IsActive", p.IsActive, MSqlDbType.Bit);
rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
///<summary>
/// Reklam Data Delete
///</summary>
public static int Delete(Reklam p)
{
int rowsAffected = 0;
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "DELETE FROM Reklam WHERE ID=@ID", conneciton))
{
cmd.Parameters.Add("ID", p.ID, MSqlDbType.Int);
rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
///<summary>
/// Reklam Data PrimaryKey
///</summary>
public static Reklam GetReklam(int pID)
{
Reklam rvReklam = new Reklam();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "SELECT * FROM Reklam WHERE ID=@ID", conneciton))
{
cmd.Parameters.Add("ID", pID, MSqlDbType.Int);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvReklam = new Reklam(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["BannerName"]), MConvert.NullToString(IDR["ImageUrl"]), MConvert.NullToString(IDR["NavigateUrl"]), MConvert.NullToString(IDR["AlternateText"]), MConvert.NullToString(IDR["Keyword"]), MConvert.NullToInt(IDR["Impressions"]), MConvert.NullToInt(IDR["Width"]), MConvert.NullToInt(IDR["Height"]), MConvert.NullToBool(IDR["IsActive"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvReklam);
}
void CustomizeControl1_SubmitClick(SortedDictionary <string, Control> controls)
{
if (!string.IsNullOrEmpty(((TextBox)controls["BannerName"]).Text)
& !string.IsNullOrEmpty(((TextBox)controls["NavigateUrl"]).Text)
& !string.IsNullOrEmpty(((TextBox)controls["Impressions"]).Text))
{
using (Lib.Reklam m = Lib.ReklamMethods.GetReklam(BAYMYO.UI.Converts.NullToInt(Request.QueryString["rklid"])))
{
m.BannerName = ((TextBox)controls["BannerName"]).Text;
m.NavigateUrl = ((TextBox)controls["NavigateUrl"]).Text;
m.AlternateText = ((TextBox)controls["AlternateText"]).Text;
m.Keyword = ((TextBox)controls["Keyword"]).Text;
m.Impressions = BAYMYO.UI.Converts.NullToInt(((TextBox)controls["Impressions"]).Text);
m.Width = BAYMYO.UI.Converts.NullToInt(((DropDownList)controls["ReklamTipleri"]).SelectedValue.Split('x')[0]);
m.Height = BAYMYO.UI.Converts.NullToInt(((DropDownList)controls["ReklamTipleri"]).SelectedValue.Split('x')[1]);
m.IsActive = ((CheckBox)controls["IsActive"]).Checked;
if (m.ID > 0)
{
if ((controls["ImageUrl"] as FileUpload).HasFile)
{
if (BAYMYO.UI.FileIO.Remove(Server.MapPath(m.ImageUrl)))
{
m.ImageUrl = Settings.ImagesPath + "reklam/" + BAYMYO.UI.FileIO.Upload(controls["ImageUrl"] as FileUpload, Server.MapPath(Settings.ImagesPath + "reklam/"));
}
}
if (Lib.ReklamMethods.Update(m) > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "x", "alert('Güncelleme işleminiz başarılı bir şekilde tamamlandı!');", true);
}
}
else if ((controls["ImageUrl"] as FileUpload).HasFile)
{
m.ImageUrl = Settings.ImagesPath + "reklam/" + BAYMYO.UI.FileIO.Upload(controls["ImageUrl"] as FileUpload, Server.MapPath(Settings.ImagesPath + "reklam/"));
if (Lib.ReklamMethods.Insert(m) > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "x", "alert('Kayıt ekleme işleminiz başarılı bir şekilde tamamlandı!');", true);
Settings.ClearControls(controls);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "x", "alert('Lütfen reklam dosyası seçininiz!');", true);
}
}
}
}
void CustomizeControl1_RemoveClick(SortedDictionary <string, Control> controls)
{
using (Lib.Reklam m = Lib.ReklamMethods.GetReklam(BAYMYO.UI.Converts.NullToInt(Request.QueryString["rklid"])))
{
if (m != null)
{
if (BAYMYO.UI.FileIO.Remove(Server.MapPath(m.ImageUrl)))
{
if (Lib.ReklamMethods.Delete(m) > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "x", "alert('Silme işleminiz başarılı bir şekilde tamamlandı!');", true);
Settings.ClearControls(controls);
}
}
}
}
}
/// <summary>
/// Reklam Getir
/// </summary>
public static Reklam GetReklam(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
Reklam rvReklam = new Reklam();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvReklam = new Reklam(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["BannerName"]), MConvert.NullToString(IDR["ImageUrl"]), MConvert.NullToString(IDR["NavigateUrl"]), MConvert.NullToString(IDR["AlternateText"]), MConvert.NullToString(IDR["Keyword"]), MConvert.NullToInt(IDR["Impressions"]), MConvert.NullToInt(IDR["Width"]), MConvert.NullToInt(IDR["Height"]), MConvert.NullToBool(IDR["IsActive"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvReklam);
}
protected override void OnInit(EventArgs e)
{
CustomizeControl1.FormTitle = string.Format(Settings.FormTitleFormat, "Reklam", "Ekleme/Düzeltme Formu");
using (Lib.Reklam m = Lib.ReklamMethods.GetReklam(BAYMYO.UI.Converts.NullToInt(Request.QueryString["rklid"])))
{
CustomizeControl1.RemoveVisible = (m.ID > 0);
TextBox txt = new TextBox();
txt.ID = "BannerName";
txt.CssClass = "noHtml emptyValidate";
txt.Text = m.BannerName;
txt.MaxLength = 75;
CustomizeControl1.AddControl("Reklam Adı", txt, "Liste üzerinde görünen isim!");
FileUpload flu = new FileUpload();
flu.ID = "ImageUrl";
flu.ToolTip = m.ImageUrl;
CustomizeControl1.AddControl("Reklam Dosyası", flu);
txt = new TextBox();
txt.ID = "NavigateUrl";
txt.CssClass = "noHtml";
txt.Text = m.NavigateUrl;
txt.MaxLength = 75;
CustomizeControl1.AddControl("Bağlantı Adresi", txt, "Örnek; http://www.siteadresi.com");
txt = new TextBox();
txt.ID = "AlternateText";
txt.CssClass = "noHtml";
txt.Text = m.AlternateText;
txt.MaxLength = 100;
CustomizeControl1.AddControl("Alternatif Yazı", txt, "Alternatif yazı, resimin görüntülenemediği durumlar için.");
txt = new TextBox();
txt.ID = "Keyword";
txt.CssClass = "noHtml";
txt.Text = m.Keyword;
txt.MaxLength = 100;
CustomizeControl1.AddControl("Keywords", txt, string.Format("Lütfen virgül({0}) ile ayrıarak ve boşluk bırakmadan yazınız! Örnek: elma{0}meyve{0}sebze{0}bahçe", Settings.SplitFormat));
txt = new TextBox();
txt.ID = "Impressions";
txt.CssClass = "noHtml isNumber";
txt.Text = m.Impressions.ToString();
txt.MaxLength = 100;
CustomizeControl1.AddControl("Impressions", txt, "Sadece sayısal değer giriniz.");
DropDownList ddl = new DropDownList();
ddl.ID = "ReklamTipleri";
ddl.Width = 300;
ddl.DataValueField = "Key";
ddl.DataTextField = "Value";
ddl.DataSource = Settings.ReklamTipleri();
ddl.DataBind();
ddl.SelectedValue = m.Width + "x" + m.Height;
CustomizeControl1.AddControl("Reklam Tipleri", ddl);
CheckBox chk = new CheckBox();
chk.ID = "IsActive";
chk.Checked = m.IsActive;
CustomizeControl1.AddControl("Yayımla", chk);
CustomizeControl1.SubmitClick += new CustomizeControl.ButtonEvent(CustomizeControl1_SubmitClick);
CustomizeControl1.RemoveClick += new CustomizeControl.ButtonEvent(CustomizeControl1_RemoveClick);
}
base.OnInit(e);
}
public void Remove(Reklam obj)
{
this.List.Remove(obj);
}
public int IndexOf(Reklam obj)
{
return(this.List.IndexOf(obj));
}
public bool Contains(Reklam obj)
{
return(this.List.Contains(obj));
}
public void Insert(int index, Reklam obj)
{
this.List.Insert(index, obj);
}
public int Add(Reklam obj)
{
return(this.List.Add(obj));
}