protected void Page_Load(object sender, EventArgs e)
{
AppCode appcode = new AppCode();
DataTable dt = appcode.DataTableSelectQuery("pic_update_category_select");
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Panel1.Visible = true;
DataTable dt = new DataTable();
AppCode appcode = new AppCode();
dt = appcode.DataTableSelectQuery("PictureGallery_Select", DropDownList1.SelectedValue, "category");
DataList1.DataSource = dt;
DataList1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
AppCode appcode = new AppCode();
int param1 = Convert.ToInt16(DropDownList1.SelectedValue);
int parma2 = Convert.ToInt16(DropDownList2.SelectedValue);
DataTable dt = appcode.DataTableSelectQuery("Calendar_Modify_Select", param1, "month", parma2, "year");
DataList1.DataSource = dt;
DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Button3.Attributes["onclick"] = "recurrdatepop()";
tbDateList.Visible = false;
if (!Page.IsPostBack)
{
AppCode appcode = new AppCode();
DataTable dt = appcode.DataTableSelectQuery("Calendar_Update_Icon_Select");
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
}
}
protected void Button4_Click(object sender, EventArgs e)
{
try
{
//AccessDataSource4.Insert();
AppCode appcode = new AppCode();
appcode.Query("pic_update_category_insert", "Category", TextBox2.Text);
}
catch (Exception)
{
}
// Notify the user that the category is uploaded ...
ClientScriptManager cs3 = Page.ClientScript;
Type cstype3 = this.GetType();
if (!cs3.IsStartupScriptRegistered(cstype3, "CategorySuccess"))
{
string s = "<script language=\"JScript\">window.alert('The new Picture Category was added successfully.');</script>";
ClientScript.RegisterStartupScript(cstype3, "CategorySuccess", s);
}
TextBox2.Text = "";
AppCode appcode1 = new AppCode();
DataTable dt = appcode1.DataTableSelectQuery("pic_update_category_select");
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
AppCode appcode = new AppCode();
DataTable dt = appcode.DataTableSelectQuery("pic_update_category_select");
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
DataTable dt1 = appcode.DataTableSelectQuery("pic_mod_recent_select");
DataList3.DataSource = dt1;
DataList3.DataBind();
DataTable dt2 = appcode.DataTableSelectQuery("pic_mod_home_select");
DataList2.DataSource = dt2;
DataList2.DataBind();
DataTable dt3 = appcode.DataTableSelectQuery("pic_mod_icon_select");
DataList1.DataSource = dt3;
DataList1.DataBind();
}
}
protected void Button4_Click(object sender, EventArgs e)
{
//AccessDataSource4.Delete();
AppCode appcode1 = new AppCode();
appcode1.Query("pic_mod_category_delete", "ID", DropDownList1.SelectedValue);
DataTable dt1 = appcode1.DataTableSelectQuery("pic_update_category_select");
DropDownList1.DataSource = dt1;
DropDownList1.DataBind();
}
protected void DataList2_SelectedIndexChanged(object sender, EventArgs e)
{
int ControlIndex = this.DataList2.SelectedIndex;
//Find the Image Control in the selected Datalist Colum
DataListItem dli = this.DataList2.Controls[ControlIndex] as DataListItem;
Image MyImage = dli.FindControl("Image2") as Image;
//Grab the ImageUrl for this picture.
string MyImagePath = MyImage.ImageUrl;
//Delete the actual image file.
string ActualImagePath = Server.MapPath(MyImagePath);
System.IO.File.Delete(ActualImagePath);
//Delete the original image file.
string OrignialImageName = "";
string[] split = MyImagePath.Split(new Char[] { '/' });
foreach (string s in split)
{
if (s.Trim().Contains(".jpg"))
{
OrignialImageName = s;
}
}
string OriginalImagePath = Server.MapPath("~/images/PictureGallery/Original_HomePic/" + OrignialImageName);
//Delete the image information from the database.
//AccessDataSource2.DeleteParameters.Add("FilePath", MyImagePath);
//AccessDataSource2.Delete();
try
{
AppCode appcode2 = new AppCode();
appcode2.Query("pic_mod_home_delete", "ImagePath", MyImagePath);
DataTable dt1 = appcode2.DataTableSelectQuery("pic_mod_home_select");
DataList2.DataSource = dt1;
DataList2.DataBind();
}
catch (Exception)
{
}
}