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;
}
}
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;
}
}
