/// <summary>
/// Fetches affiliate banners by specified arguments.
/// It returns an empty array if there are no affiliate banners in DB by specified arguments.
/// If these arguments are null it returns all affiliate banners from DB.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="name">The name.</param>
/// <param name="deleted">The deleted.</param>
/// <returns></returns>
private static AffiliateBanner[] Fetch(int? id, string name, bool? deleted)
{
//using (var conn = Config.DB.Open())
{
List<AffiliateBanner> lAffiliateBanners = new List<AffiliateBanner>();
using (var reader = SqlHelper.GetDB().ExecuteReader("FetchAffiliateBanners", id, name, deleted))
{
while (reader.Read())
{
AffiliateBanner affiliateBanner = new AffiliateBanner();
affiliateBanner.id = (int) reader["ID"];
affiliateBanner.name = (string) reader["Name"];
affiliateBanner.deleted = (bool) reader["Deleted"];
lAffiliateBanners.Add(affiliateBanner);
}
reader.Close();
}
return lAffiliateBanners.ToArray();
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
if (!HasWriteAccess) return;
if (txtName.Text.Trim().Length == 0)
{
MessageBox.Show(Lang.TransA("Please enter name!"), Misc.MessageType.Error);
return;
}
AffiliateBanner affiliateBanner = new AffiliateBanner();
affiliateBanner.Name = txtName.Text.Trim();
if (fuAffiliateBannerImage.HasFile)
{
System.Drawing.Image image = null;
try
{
image = System.Drawing.Image.FromStream
(fuAffiliateBannerImage.PostedFile.InputStream);
}
catch
{
MessageBox.Show(Lang.TransA("Invalid image!"), Misc.MessageType.Error);
return;
}
affiliateBanner.Image = image;
}
else
{
MessageBox.Show(Lang.TransA("Invalid image!"), Misc.MessageType.Error);
return;
}
affiliateBanner.Save();
loadAffiliateBanners();
mvAffiliateBanners.SetActiveView(viewAffiliateBanners);
}
