protected void checkit_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "delteitem")
{
AllNewsTb delteTb = new AllNewsTb();
try
{
if (ModelState.IsValid)
{
string Txtid = ((Label)e.Item.FindControl("DeltText")).Text;
using (var deleteContent = new Tafias_blogDb())
{
var query = (from del in deleteContent.AllNewsTbs where (del.AllNewsTbID.Equals(Txtid)) select del).FirstOrDefault();
if (query != null)
{
deleteContent.Entry(query).State = System.Data.EntityState.Deleted;
deleteContent.SaveChanges();
Response.Redirect("~/Admin/Posts.aspx?ID=" + "Deleted");
}
}
}
}
catch
{
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserDetails"] == null)
{
Response.Redirect("~/Login/Sign_In.aspx");
}
else
{
if (!Page.IsPostBack)
{
BBCID.Text = Convert.ToString(Session["UserDetails"]);
}
}
int SingleID = 3016;
using (var upload = new Tafias_blogDb())
{
var query = (from t in upload.Sapele_NewsTb
where t.Sapele_NewsID.Equals(SingleID)
select t).FirstOrDefault();
if (query != null)
{
bannerImage.Src = query.Photo.ToString();
datettime.InnerText = DateTime.Now.ToString("hh:mm tt" + ',' + " dd-MMM-yyy");
titleNEws.InnerText = query.Title.ToString();
}
}
}
protected void view_post_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "commbtn")
{
string PostiD = ((Label)e.Item.FindControl("CommetTbID")).Text;
string CommetTxtbox = ((TextBox)e.Item.FindControl("Commettxt")).Text;
try
{
if (CommetTxtbox == "")
{
}
else
{
//using (var comment = new Tafias_blogDb())
//{
// var query = (from commentitem in comment.AllNewsTbs where (commentitem.AllNewsTbID.Equals(PostiD)) select commentitem).FirstOrDefault();
// if (query != null)
// {
string BBCID = Convert.ToString(Session["userID"]);
using (var getRegId = new Tafias_blogDb())
{
string userComment = commentID();
var getID = (from commentitem in getRegId.RegistrationTbs where (commentitem.RegisterID.Equals(ClientDetails.Text)) select commentitem).FirstOrDefault();
if (getID != null)
{
CommentPostT.username = getID.First_Name + " " + getID.Last_name;
CommentPostT.body_commet = CommetTxtbox;
CommentPostT.Date_Time = DateTime.Now.ToString("MMM-dd-yyy" + " " + "hh:mm tt");
CommentPostT.Other_isues = labtxt.Text;
CommentPostT.commentTbId = userComment;
((TextBox)e.Item.FindControl("Commettxt")).Text = "";
getRegId.commentTbs.Add(CommentPostT);
getRegId.SaveChanges();
Response.Redirect("~/News/View_Comment.aspx?ID=" + labtxt.Text + "Coment_Added=1 " + "#Comment");
}
}
}
}
catch (Exception)
{
((TextBox)e.Item.FindControl("Commettxt")).Text = "error";
}
}
}
protected void btnreg_Click(object sender, EventArgs e)
{
try
{
if (Txtemail.Value == "" && txtpassword.Value == "")
{
Response.Redirect("~/Login/Sign_In.aspx?ID=" + "Unknown");
}
else
{
txtErr.Text = "Incorrect Login Details";
}
if (Txtemail.Value == "*****@*****.**" && txtpassword.Value == "SapeleTafia")
{
long details;
details = 812883838230 - 0 - 0323233233333;
Session["AdminLogin"] = Convert.ToString(details);
Response.Redirect("~/Admin/SapeleTafia_Admin.aspx?ID=" + Convert.ToString(details) + "AdminBBC");
}
else
{
if (ModelState.IsValid)
{
using (var login = new Tafias_blogDb())
{
var query = (from signin in login.RegistrationTbs
where (signin.Email.Equals(Txtemail.Value) &&
signin.Password.Equals(txtpassword.Value))
select signin).FirstOrDefault();
if (query != null)
{
string CID = query.First_Name + query.Last_name;
string details = query.RegisterID;
String i = Convert.ToString(CID);
Session["UserDetails"] = Convert.ToString(details);
Response.Redirect("~/News/Timeline.aspx?ID?ID=" + Convert.ToString(i));
}
else
{
txtErr.Text = "Incorrect Login Details";
}
}
}
}
}
catch (Exception)
{
txtErr.Text = "Opps! You cant login At This time Try Again";
}
}
protected void btnreg_Click(object sender, EventArgs e)
{
try
{
string cID = RndNumber();
using (var CheckEmail_Validity = new Tafias_blogDb())
{
var query = (from signup in CheckEmail_Validity.RegistrationTbs
where (signup.Email.Equals(Txtemail.Value))
select signup).FirstOrDefault();
if (query == null)
{
if (ModelState.IsValid)
{
tblReg.RegisterID = cID;
tblReg.First_Name = TxtFirstname.Value;
tblReg.Last_name = TxtLastName.Value;
tblReg.Time_date = DateTime.Now.ToString("hh:mm tt" + " , " + "dd-MMM-yyy");
tblReg.Email = Txtemail.Value;
tblReg.Password = txtpassword2.Value;
CheckEmail_Validity.RegistrationTbs.Add(tblReg);
CheckEmail_Validity.SaveChanges();
Session["ClientId"] = cID;
}
Response.Redirect("~/Login/Sign_In.aspx");
}
else
{
errText2.InnerText = "Email Already Exit ";
}
}
}
catch (Exception ex)
{
errText.InnerText = "ERROR OCCURED : " + ex.Message + "\n" + " Please Try again";
}
}
private void uploadbanner()
{
int SingleID = 3016;
using (var upload = new Tafias_blogDb())
{
var query = (from t in upload.Sapele_NewsTb
where t.Sapele_NewsID.Equals(SingleID)
select t).FirstOrDefault();
if (query != null)
{
if (upload_Picture.HasFile)
{
string f = "";
string virFolder = "~/Admin/bannerImage//";
string filename = Path.GetFileName(upload_Picture.PostedFile.FileName);
string fileExtension = System.IO.Path.GetExtension(upload_Picture.PostedFile.FileName);
string filePath = Server.MapPath("~/Admin/bannerImage/" + filename);
f = filePath;
if (fileExtension == ".JPG" || fileExtension == ".jpg" || fileExtension == ".png" || fileExtension == ".PNG")
{
query.Title = Body_text.Text;
query.Photo = virFolder + filename;
//query.= DescriptionLanding.Text;
upload.Entry(query).State = System.Data.EntityState.Modified;
upload_Picture.SaveAs(filePath);
upload.SaveChanges();
Response.Redirect("~/Admin/Banner_UpDate.aspx?ID=" + "Successful");
Body_text.Text = "";
}
}
}
}
}
protected void NewsPost_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "clikebtn")
{
string Refid = ((Label)e.Item.FindControl("Tbid")).Text;
using (var likeItem = new Tafias_blogDb())
{
var likeQuery = (from likes in likeItem.AllNewsTbs where (likes.AllNewsTbID.Equals(Refid)) select likes).FirstOrDefault();
if (likeQuery != null)
{
int like = Convert.ToInt32(likeQuery.Likes);
int result;
result = like + 1;
likeQuery.Likes = Convert.ToString(result);
likeItem.Entry(likeQuery).State = System.Data.EntityState.Modified;
likeItem.SaveChanges();
Response.Redirect("~/News/Timeline.aspx?ID=" + "1Like_Added");
}
}
}
if (e.CommandName == "commbtn")
{
if (ModelState.IsValid)
{
string Refid = ((Label)e.Item.FindControl("Tbid")).Text;
using (var redirect = new Tafias_blogDb())
{
var query = (from redirec in redirect.AllNewsTbs where (redirec.AllNewsTbID.Equals(Refid)) select redirec).FirstOrDefault();
if (query != null)
{
var i = query.AllNewsTbID;
string ID = Convert.ToString(i);
using (var getRegId = new Tafias_blogDb())
{
var getid = (from UserID in getRegId.RegistrationTbs where (UserID.RegisterID.Equals(BBCID.Text)) select UserID).SingleOrDefault();
if (getid != null)
{
string CID = getid.RegisterID;
string cid = Convert.ToString(CID);
Session["UserID"] = Convert.ToString(CID);
}
}
Session["Redirect"] = Convert.ToString(ID);
Response.Redirect("~/News/View_Comment.aspx?ID=" + Convert.ToString(ID));
}
else
{
Response.Redirect("~/News/Timeline.aspx?ID=" + Convert.ToString(ID));
}
}
}
}
}
//private void News_Upload()
//{
// string postID = postNumber();
// HttpFileCollection filecoll = Request.Files;
// using (var Upload = new Tafias_blogDb())
// {
// foreach (string uploader in filecoll)
// {
// HttpPostedFile file = filecoll[uploader];
// if (file.ContentLength > 0)
// {
// BinaryReader br = new BinaryReader(file.InputStream);
// byte[] buffer = br.ReadBytes(file.ContentLength);
// string f = "";
// string virFolder = "~/Admin/images/";
// string filename = Path.GetFileName(upload_Picture.PostedFile.FileName);
// string fileExtension = System.IO.Path.GetExtension(upload_Picture.PostedFile.FileName);
// string filePath = Server.MapPath("~/Admin/images/" + filename);
// f = filePath;
// if (fileExtension == ".JPG" || fileExtension == ".jpg" || fileExtension == ".png" || fileExtension == ".PNG")
// {
// tbSapele_News.Title = Title_Text.Text;
// tbSapele_News.Body = Body_text.Text;
// tbSapele_News.Admin_Name = Addmin_Name.Text;
// tbSapele_News.Time_and_Date = DateTime.Now.ToString("hh:mm tt" + ',' + "dd-MMM-yyy");
// tbSapele_News.Sapele_NewsTbID = postID;
// tbSapele_News.Photo = virFolder + filename;
// Upload.Sapele_NewsTb.Add(tbSapele_News);
// upload_Picture.SaveAs(filePath);
// Upload.SaveChanges();
// Errortxt.InnerText = "Your Post is sent Successfuly";
// }
// }
// }
// }
//}
private void ALlUpload()
{
string postID = postNumber();
try
{
if (Title_Text.Text == "" && Body_text.Text == "" && TextBox1.Text == "" && upload_Picture.FileName == "" && FileUpload2.FileName == "" && FileUpload3.FileName == "")
{
//Do while
}
else
{
if (ModelState.IsValid)
{
using (var Upload = new Tafias_blogDb())
{
allnewsTb.Title = Title_Text.Text;
allnewsTb.body = Body_text.Text;
allnewsTb.caption = TextBox1.Text;
allnewsTb.Admin_Name = Addmin_Name.Text;
allnewsTb.Date_time = DateTime.Now.ToString("hh:mm tt" + ',' + "dd-MMM-yyy");
allnewsTb.AllNewsTbID = postID;
allnewsTb.Category = Category.SelectedValue;
Upload.AllNewsTbs.Add(allnewsTb);
Upload.SaveChanges();
if (upload_Picture.HasFile)
{
string f = "";
string virFolder = "~/Admin/images/";
string filename = Path.GetFileName(upload_Picture.PostedFile.FileName);
string fileExtension = System.IO.Path.GetExtension(upload_Picture.PostedFile.FileName);
string filePath = Server.MapPath("~/Admin/images/" + filename);
f = filePath;
if (fileExtension == ".JPG" || fileExtension == ".jpg" || fileExtension == ".png" || fileExtension == ".PNG")
{
//allnewsTb.Title = Title_Text.Text;
//allnewsTb.body = Body_text.Text;
//allnewsTb.caption = TextBox1.Text;
//allnewsTb.Admin_Name = Addmin_Name.Text;
//allnewsTb.Date_time = DateTime.Now.ToString("hh:mm tt" + ',' + "dd-MMM-yyy");
//allnewsTb.AllNewsTbID = postID;
//allnewsTb.Category = Category.SelectedValue;
allnewsTb.Photo = virFolder + filename;
upload_Picture.SaveAs(filePath);
Upload.SaveChanges();
Errortxt.InnerText = "Your Post is sent Successfuly";
}
}
if (FileUpload2.HasFile)
{
string f = "";
string virFolder = "~/Admin/images/";
string filename = Path.GetFileName(FileUpload2.PostedFile.FileName);
string fileExtension = System.IO.Path.GetExtension(FileUpload2.PostedFile.FileName);
string filePath = Server.MapPath("~/Admin/images/" + filename);
f = filePath;
if (fileExtension == ".JPG" || fileExtension == ".jpg" || fileExtension == ".png" || fileExtension == ".PNG")
{
allnewsTb.Photo2 = virFolder + filename;
FileUpload2.SaveAs(filePath);
Upload.SaveChanges();
Errortxt.InnerText = "Your Post is sent Successfuly";
}
}
if (FileUpload3.HasFile)
{
string f = "";
string virFolder = "~/Admin/images/";
string filename = Path.GetFileName(FileUpload3.PostedFile.FileName);
string fileExtension = System.IO.Path.GetExtension(FileUpload3.PostedFile.FileName);
string filePath = Server.MapPath("~/Admin/images/" + filename);
f = filePath;
if (fileExtension == ".JPG" || fileExtension == ".jpg" || fileExtension == ".png" || fileExtension == ".PNG")
{
allnewsTb.Photo3 = virFolder + filename;
FileUpload3.SaveAs(filePath);
Upload.SaveChanges();
Errortxt.InnerText = "Your Post is sent Successfuly";
}
}
if (UpLoad_Video.HasFile)
{
string f = "";
string virFolder = "~/Admin/Video/";
string filename = Path.GetFileName(UpLoad_Video.PostedFile.FileName);
string fileExtension = System.IO.Path.GetExtension(UpLoad_Video.PostedFile.FileName);
string filePath = Server.MapPath("~/Admin/Video/" + filename);
f = filePath;
if (fileExtension == ".JPG" || fileExtension == ".jpg" || fileExtension == ".png" || fileExtension == ".PNG")
{
allnewsTb.video = virFolder + filename;
UpLoad_Video.SaveAs(filePath);
Upload.SaveChanges();
Errortxt.InnerText = "Your Post is sent Successfuly";
}
}
Response.Redirect("~/Admin/SapeleTafia_Admin.aspx");
Title_Text.Text = "";
Body_text.Text = "";
TextBox1.Text = "";
}
}
else
{
Errortxt.InnerText = "Something When Wrong";
}
}
}
catch (Exception)
{
}
}
