protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request["CategoryId"] != null)
{
// get categoryID from Query string
int categoryId = int.Parse(Request["CategoryId"]);
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
//Bind all the images of the selected category
var image = from i in data.ImageInfoes where i.CategoryId == categoryId select i;
rptPortfolio.DataSource = image.ToList();
rptPortfolio.DataBind();
//get category name for Heading
var cate = from c in data.CategoryInfoes where c.categoryId == categoryId select c;
foreach (CategoryInfo ci in cate)
{
Myheading.InnerText = ci.CategoryName;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// // Get all Categories on page load
/// </summary>
private void ViewCategory()
{
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
rptrCategory.DataSource = data.CategoryInfoes.ToList();
rptrCategory.DataBind();
}
/// <summary>
/// view portfolio images in admin
/// </summary>
private void ViewImages()
{
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
rptrGallery.DataSource = data.ImageInfoes.ToList();
rptrGallery.DataBind();
}
/// <summary>
/// Add New Category
/// </summary>
protected void btnAddCategory_Click(object sender, EventArgs e)
{
try
{
string category = txtCategory.Text.Trim();
if (Checks.Empty(category))
{
lblmsg.Text = "*Category Name is Required!!";
}
else
{
// give data to class
CategoryInfo ci = new CategoryInfo();
ci.CategoryName = category;
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
// save data to database
data.CategoryInfoes.Add(ci);
data.SaveChanges();
ViewCategory(); // bind categories
lblmsg.Text = "*New Category Saved!!";
txtCategory.Text = ""; // clear textbox text
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
// Bind images on page load
private void ViewBanner()
{
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
rptrBanner.DataSource = data.BannerInfoes.ToList();
rptrBanner.DataBind();
}
protected void rptrGallery_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{ // delete any image from portfolio
if (e.CommandName.Equals("del"))
{
int ImageID = int.Parse(e.CommandArgument.ToString());
string path;
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
ImageInfo bt = new ImageInfo();
bt = data.ImageInfoes.Single(c => c.ImageID == ImageID); // lambda expression
data.ImageInfoes.Attach(bt);
data.ImageInfoes.Remove(bt);
data.SaveChanges(); // remove the
//delete the image from the path as well
path = Server.MapPath("~/Image/Banner/" + bt.ImageSize + bt.ImageName);
if (File.Exists(path))
{
File.Delete(path);
lblmsg.Text = "*Image Deleted!!";
}
ViewImages(); // bind images after that
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
protected void lnkvideo_Click(object sender, EventArgs e)
{ // save the videos to the database
try
{
if (Checks.Empty(txtsrc.Text.Trim()))
{
lblmsg.Text = "*Video Source is Required!!";
}
else
{
// give data to class
videoYoutube vy = new videoYoutube();
vy.VideoSource = txtsrc.Text.Trim();
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
data.videoYoutubes.Add(vy); // Add the video code to database
data.SaveChanges();
ViewVideo(); // method calling to bind videos
lblmsg.Text = "*New Video Saved!!";
txtsrc.Text = "";
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
/// <summary>
/// Get all videos for the page
/// </summary>
private void ViewVideo()
{
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
rptrvideo.DataSource = data.videoYoutubes.ToList();
rptrvideo.DataBind();
}
/// <summary>
/// add portfolio data
/// </summary>
protected void lnkaddImage_Click(object sender, EventArgs e)
{
try
{
string ImageDescription = txtdescription.Text.Trim();
string caption = txtCaption.Text.Trim();
string CategoryId = ddlCategory.SelectedValue;
if (CategoryId.Contains("-1"))
{
lblmsg.Text = "*Category is required!!";
}
else if (fufImage.HasFiles == false)
{
lblmsg.Text = " *Please select image to upload!!";
}
else
{
foreach (var file in fufImage.PostedFiles)
{
//add image data
ImageInfo data = new ImageInfo();
data.ImageName = file.FileName;
data.ImageExtension = file.FileName.Substring(file.FileName.LastIndexOf('.'));
data.ImageSize = file.ContentLength;
data.ImageType = file.ContentType;
data.ImageDescription = ImageDescription;
data.Imagecaption = caption;
data.CategoryId = int.Parse(CategoryId);
if (file.ContentType == "image/jpeg" || file.ContentType == "image/png")
{
AmanpreetPortEntities1 apData = new AmanpreetPortEntities1();
apData.ImageInfoes.Add(data);
apData.SaveChanges();
//save image at given path
string path = Server.MapPath("~/Image/Gallery/" + file.ContentLength + file.FileName);
file.SaveAs(path);
txtdescription.Text = ""; // clear textbox text
txtCaption.Text = "";
ddlCategory.SelectedIndex = 0; // reset dropdown index
ViewImages(); //method calling: bind images
lblmsg.Text = "*New Item Saved!!";
}
else
{
lblmsg.Text = "Please choose a .JPEG or .PNG image only";
}
}
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
//Bind Categories to menubar (portfolio)
private void BindMenuCategory()
{
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
var cate = from c in data.CategoryInfoes select c;
repCategories.DataSource = cate.ToList();
repCategories.DataBind();
}
//bind categories to menuber item(portfolio)
private void BindDDLcategory()
{
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
ddlCategory.DataSource = data.CategoryInfoes.ToList();
ddlCategory.DataValueField = "categoryId";
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, new ListItem("Select Category", "-1"));
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
// Bind all the home images to home page
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
var ban = from b in data.BannerInfoes select b;
rptrHomeImages.DataSource = ban.ToList();
rptrHomeImages.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
//Add images to database
protected void lnkaddBanner_Click(object sender, EventArgs e)
{
try
{
if (fufBanner.HasFiles == false)
{
lblmsg.Text = " *Please select a file to upload";
}
else
{
foreach (var file in fufBanner.PostedFiles)
{
//put image info to class
BannerInfo data = new BannerInfo();
data.BannerName = file.FileName;
data.BannerExtension = file.FileName.Substring(file.FileName.LastIndexOf('.'));
data.BannerSize = file.ContentLength;
data.BannerType = file.ContentType;
if (file.ContentType == "image/jpeg" || file.ContentType == "image/png")
{
AmanpreetPortEntities1 apData = new AmanpreetPortEntities1();
apData.BannerInfoes.Add(data);
int ans = apData.SaveChanges();
string path;
if (ans > 0)
{
// save the image to the path
path = Server.MapPath("~/Image/Banner/" + file.ContentLength + file.FileName);
file.SaveAs(path);
ViewBanner();
}
lblmsg.Text = "*New Item Saved!!";
}
else
{
lblmsg.Text = "Please choose a .JPEG or .PNG image only";
}
}
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try {
if (!IsPostBack)
{
// Bind all the videos to the page
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
var video = from v in data.videoYoutubes select v;
rptrvid.DataSource = video.ToList();
rptrvid.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void rptrvideo_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
/// <summary>
/// Delete the selected video
/// </summary>
if (e.CommandName.Equals("del"))
{
int videoId = int.Parse(e.CommandArgument.ToString()); // get video id
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
videoYoutube vid = new videoYoutube();
vid = data.videoYoutubes.Single(v => v.VideoYoutubeID == videoId);
data.videoYoutubes.Attach(vid);
data.videoYoutubes.Remove(vid);
data.SaveChanges();
ViewVideo(); // method calling to bind videos grid after delete
}
else if (e.CommandName.Equals("delall"))
{ // delete all videos
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
// get video id's for delete all operation
var videoids = from b in data.videoYoutubes select b.VideoYoutubeID;
foreach (var v in videoids)
{ // iterate through each video id to delete all one by one
videoYoutube vybt = new videoYoutube();
vybt = data.videoYoutubes.Single(c => c.VideoYoutubeID == v); // lamda expression
data.videoYoutubes.Attach(vybt);
data.videoYoutubes.Remove(vybt);
}
data.SaveChanges();
ViewVideo(); // method calling: to bind video grid
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
// count total number of Home Images
var count = (from b in data.BannerInfoes select b).Count();
if (count.ToString() != null)
{
lblBanner.Text = count.ToString();
}
// count total number portfolio images
var count1 = (from i in data.ImageInfoes select i).Count();
if (count1.ToString() != null)
{
lblPortfolio.Text = count1.ToString();
}
// count total number of Categories
var count2 = (from c in data.CategoryInfoes select c).Count();
if (count2.ToString() != null)
{
lblCategory.Text = count2.ToString();
}
// count total number of videos
var count3 = (from v in data.videoYoutubes select v).Count();
if (count3.ToString() != null)
{
lblVideo.Text = count3.ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{ // Update the category
string categoryname = txtCategoryEdit.Text.Trim();
int categoryID = int.Parse(lblCategoryID1.Text);
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
var CategoryInfo = from c in data.CategoryInfoes where c.categoryId == categoryID select c;
foreach (CategoryInfo c in CategoryInfo)
{
c.CategoryName = categoryname;
}
data.SaveChanges();
ViewCategory(); // method calling: to bind categories
pnlCategory.Visible = false; // popup will disapper after updation
}
/// <summary>
/// login the admin
/// </summary>
protected void btnlogin_Click(object sender, EventArgs e)
{
try
{
/*if RememberME checkBox is check then
* set the cookiee username and pswd for 30days */
if (chkremeber.Checked)
{
Response.Cookies["UserNamecookie"].Expires = DateTime.Now.AddDays(30);
Response.Cookies["passwordcoookie"].Expires = DateTime.Now.AddDays(30);
}
else
{
// if not, then expire the cookiee
Response.Cookies["UserNamecookie"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["passwordcoookie"].Expires = DateTime.Now.AddDays(-1);
}
// put textbox values to cookiee
Response.Cookies["UserNamecookie"].Value = txtusername.Text.Trim();
Response.Cookies["passwordcoookie"].Value = txtpassword.Text.Trim();
string username, password;
username = txtusername.Text.Trim();
password = txtpassword.Text.Trim();
if (Checks.Empty(username) && Checks.Empty(password))
{
lblmsg.Text = "*Please fill all fields!!";
}
else if (Checks.Empty(username))
{
lblmsg.Text = "*Username is required!";
}
else if (Checks.Empty(password))
{
lblmsg.Text = "*Password is required!";
}
else if (!Checks.Empty(username) && !Checks.Empty(password))
{
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
LoginInfo li = new LoginInfo();
// linq query: to get data by user name and password
li = (from log in data.LoginInfoes
where log.UserName == username & log.Password == password
select log).First();
if (li != null)
{
Session["Username"] = username; // store user-name in session
Session["UserID"] = li.UserID; // store user-id in session
Response.Redirect("Admin/Dashboard.aspx");
}
else
{
lblmsg.Text = "*Invalid Username Or Password!!";
}
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
protected void rptrCategory_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
/// <summary>
/// Delete selected Category;
/// As the category deleted, its related portfolio data will be deleted as well
/// as cascade delete is implemented in database.
/// </summary>
if (e.CommandName.Equals("del"))
{
int CategoryId = int.Parse(e.CommandArgument.ToString()); // get category id
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
//get the category to delete
CategoryInfo cid = new CategoryInfo();
cid = data.CategoryInfoes.Single(v => v.categoryId == CategoryId); // lambda expression
// delete the category
data.CategoryInfoes.Attach(cid);
data.CategoryInfoes.Remove(cid);
data.SaveChanges();
ViewCategory();
lblmsg.Text = "*Category Deleted!!";
}
else if (e.CommandName.Equals("delall"))
{ // Delete all categories here
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
var cateIds = from ct in data.CategoryInfoes select ct.categoryId;
// delete all categories one by one
foreach (var ctx in cateIds)
{
CategoryInfo ci = new CategoryInfo();
ci = data.CategoryInfoes.Single(c => c.categoryId == ctx); // lamda expression
data.CategoryInfoes.Attach(ci);
data.CategoryInfoes.Remove(ci);
}
data.SaveChanges();
ViewCategory(); // method calling- to bind the categories
}
else if (e.CommandName.Equals("edit"))
{ // edit the selected category
pnlCategory.Visible = true; // show popup to bind edit record
int CategoryId = int.Parse(e.CommandArgument.ToString()); // get category id
lblCategoryID1.Text = CategoryId.ToString();
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
// get category info for the selected category
var cid = from c in data.CategoryInfoes
where c.categoryId == CategoryId select c;
foreach (CategoryInfo c in cid)
{
txtCategoryEdit.Text = c.CategoryName; // set the category name in popup textbox
}
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
protected void rptrBanner_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
// to delete selected image
if (e.CommandName.Equals("del"))
{
string path;
int BannerID = int.Parse(e.CommandArgument.ToString());
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
BannerInfo bt = new BannerInfo();
bt = data.BannerInfoes.Single(c => c.BannerID == BannerID);
// lamda expression to get image info
if (bt != null)
{
//remove image
data.BannerInfoes.Attach(bt);
data.BannerInfoes.Remove(bt);
data.SaveChanges();
//delete image from the path
path = Server.MapPath("~/Image/Banner/" + bt.BannerName);
if (File.Exists(path))
{
File.Delete(path);
lblmsg.Text = "*Image Deleted!!";
}
}
ViewBanner(); //method calling to bind image after delete
}
else if (e.CommandName.Equals("delall"))
{ // delete all images
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
//get all image info data to delete
var dbBannerId = from b in data.BannerInfoes select b.BannerID;
string path;
foreach (var bid in dbBannerId)
{
BannerInfo bt = new BannerInfo();
bt = data.BannerInfoes.Single(c => c.BannerID == bid); // lamda expression
path = Server.MapPath("~/Image/Banner/" + bt.BannerName);
if (File.Exists(path))
{
// delete images from the path
File.Delete(path);
}
data.BannerInfoes.Attach(bt);
data.BannerInfoes.Remove(bt); // remove image data
}
data.SaveChanges();
ViewBanner(); // method calling to bind images
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
/// <summary>
/// // Change the login password
/// </summary>
protected void lnkaddchnge_Click(object sender, EventArgs e)
{
try
{
string oldpassword, newpassword, confirmpassword;
oldpassword = txtoldpswd.Text.Trim(); // enter old pswd
newpassword = txtnewpswd.Text.Trim(); // enter new pswd
confirmpassword = txtnewpswd.Text.Trim(); // confirm new pswd
if (Checks.Empty(oldpassword) && Checks.Empty(newpassword) && Checks.Empty(confirmpassword))
{
lblmsg.Text = "*Please Fill all Fields!!";
}
else if (Checks.Empty(oldpassword))
{
lblmsg.Text = "*Please Enter Old Password!!";
}
else if (Checks.Empty(newpassword))
{
lblmsg.Text = "*Please Enter New Password!!";
}
else if (Checks.Empty(confirmpassword))
{
lblmsg.Text = "*Please Enter confirm Password!!";
}
else if (newpassword != confirmpassword)
{
lblmsg.Text = "*Password Doesn't matched!!";
}
else if (newpassword == confirmpassword && !Checks.Empty(oldpassword) && !Checks.Empty(newpassword) && !Checks.Empty(confirmpassword))
{
int user = int.Parse(Session["UserID"].ToString()); //get user id from session
AmanpreetPortEntities1 data = new AmanpreetPortEntities1();
LoginInfo li = new LoginInfo();
// get user info from password
li = (from l in data.LoginInfoes where l.UserID == user
where l.Password == oldpassword select l).FirstOrDefault();
if (li != null)
{
var dt = from l in data.LoginInfoes
where l.UserID == user
select l;
foreach (LoginInfo li1 in dt)
{
li1.Password = newpassword; // give new password to class
lblmsg.Text = "! Password Changed Successfully";
}
}
else if (li == null)
{
lblmsg.Text = "!Old Password Incorrect";
}
data.SaveChanges(); // password updated!
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
