public string GetPosts()
{
List<post> posts = new List<post>();
post newPost = new post();
newPost.id = 1;
newPost.title = "Rails is Omakase";
newPost.author = "d2h";
newPost.publishedAt = new DateTime(2012, 12, 27);
newPost.intro = "There are lots of a la carte software environments in the world Places where in order...";
newPost.extended = "I want this for my ORM, I want that for my template language, and lets finish it ....";
posts.Add(newPost);
newPost = new post();
newPost.id = 2;
newPost.title = "The Parley Letter";
newPost.author = "d2h";
newPost.publishedAt = new DateTime(2012, 12, 24);
newPost.intro = "My appearance on the bury rogues podcast was amazing";
newPost.extended = "A Long list of topics were raised and i took a time to ramble at large about all of them ...";
posts.Add(newPost);
//string json = string.Empty;
//using (MemoryStream ms = new MemoryStream())
//{
// DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(post));
// ser.WriteObject(ms, newPost);
// json = System.Text.Encoding.UTF8.GetString(ms.GetBuffer(), 0, Convert.ToInt16(ms.Length));
//}
return posts.ToString();
}
public void EdytujPost(post new_post)
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
var e = dp.posts.Single(x => x.ID == new_post.ID);
e.tytul = new_post.tytul;
e.tresc = new_post.tresc;
e.status = new_post.status;
e.data_modyfikacji = DateTime.Now;
dp.SubmitChanges();
}
}
public ActionResult edytujPost(post k)
{
try
{
//ViewData["id"] = id;
db_admin.EdytujPost(k);
return RedirectToAction("Index", "Home");
}
catch
{
return RedirectToAction("Error", "Shared");
}
}
// GET: posts/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
post post = await db.post.FindAsync(id);
if (post == null)
{
return(HttpNotFound());
}
return(View(post));
}
public IHttpActionResult Deletepost(int id)
{
post post = db.Posts.Find(id);
if (post == null)
{
return(NotFound());
}
db.Posts.Remove(post);
db.SaveChanges();
return(Ok(post));
}
// GET: posts/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
post post = db.post.Find(id);
if (post == null)
{
return(HttpNotFound());
}
return(View(post));
}
public override BaseEntity Update(object Obj)
{
dbEntities = new mpi_dbEntities();
post post = (post)Obj;
post DBpost = (post)GetById(post.id);
if (DBpost == null)
{
return(null);
}
dbEntities.Entry(DBpost).CurrentValues.SetValues(post);
dbEntities.SaveChanges();
return(post);
}
void getNewURL()
{
url = "https://maps.googleapis.com/maps/api/staticmap?";
url += "&zoom=18&size=200x432&maptype=satellite";
string key = "&key=AIzaSyDzZE_iL05RSddPakPeDCcDR56HdWw34Is";
string location = "¢er=" + global.latitude + "," + global.longitude;
url += key;
url += location;
global.displayedPosts = new List <post>();
FirebaseDatabase.DefaultInstance.GetReference("posts").GetValueAsync().ContinueWith(task =>
{
DataSnapshot snapshot = task.Result;
int i = 1;
while (true)
{
if (snapshot.Child(i.ToString()).Child("dt").Value == null)
{
break;
}
float markerLat = float.Parse(snapshot.Child(i.ToString()).Child("latitude").Value.ToString());
float markerLon = float.Parse(snapshot.Child(i.ToString()).Child("longitude").Value.ToString());
float dist = calculateDistance(global.latitude, global.longitude, markerLat, markerLon);
Debug.Log(dist);
post p = new post();
p.dt = snapshot.Child(i.ToString()).Child("dt").Value.ToString();
p.pst = snapshot.Child(i.ToString()).Child("pst").Value.ToString();
p.user = snapshot.Child(i.ToString()).Child("user").Value.ToString();
p.likes = int.Parse(snapshot.Child(i.ToString()).Child("likes").Value.ToString());
p.longitude = markerLon;
p.latitude = markerLat;
if (dist <= 200)
{
url += markerText(p);
}
if (dist <= 50)
{
global.displayedPosts.Add(p);
}
i++;
}
Debug.Log(url);
});
}
public async Task CreateDbAsync()
{
db = Database.Create <MySqlConnection>(ConnectionStrings.Get(_connectionStringName));
await db.ExecuteAsync(@"
DROP TABLE IF EXISTS posts;
DROP TABLE IF EXISTS authors;
CREATE TABLE posts (
id bigint AUTO_INCREMENT NOT NULL,
title varchar(127) NOT NULL,
author bigint NOT NULL,
PRIMARY KEY (id)
) ENGINE=INNODB;
CREATE TABLE authors (
id bigint AUTO_INCREMENT NOT NULL,
name varchar(127) NOT NULL,
PRIMARY KEY (id)
) ENGINE=INNODB;
" );
var a1 = new author();
a1.name = "Bill";
await db.InsertAsync(a1);
var a2 = new author();
a2.name = "Ted";
await db.InsertAsync(a2);
var p = new post();
p.title = "post1";
p.author = a1.id;
await db.InsertAsync(p);
p = new post();
p.title = "post2";
p.author = a1.id;
await db.InsertAsync(p);
p = new post();
p.title = "post3";
p.author = a2.id;
await db.InsertAsync(p);
}
public void CreateDB()
{
db = new Database(_connectionStringName);
db.Execute(@"
DROP TABLE IF EXISTS posts;
DROP TABLE IF EXISTS authors;
CREATE TABLE posts (
id bigint AUTO_INCREMENT NOT NULL,
title varchar(127) NOT NULL,
author bigint NOT NULL,
PRIMARY KEY (id)
) ENGINE=INNODB;
CREATE TABLE authors (
id bigint AUTO_INCREMENT NOT NULL,
name varchar(127) NOT NULL,
PRIMARY KEY (id)
) ENGINE=INNODB;
" );
var a1 = new author();
a1.name = "Bill";
db.Insert(a1);
var a2 = new author();
a2.name = "Ted";
db.Insert(a2);
var p = new post();
p.title = "post1";
p.author = a1.id;
db.Insert(p);
p = new post();
p.title = "post2";
p.author = a1.id;
db.Insert(p);
p = new post();
p.title = "post3";
p.author = a2.id;
db.Insert(p);
}
public post getPostbyID(int _id)
{
post fundPost = new post();
try
{
fundPost = db.posts.Find(_id);
return(fundPost);
}
catch (Exception ex)
{
throw ex;
}
}
void displayPost(post p)
{
postDetails.SetActive(true);
postText.text = p.pst;
foreach (Button button in buttons)
{
Debug.Log(button);
button.gameObject.SetActive(false);
}
foreach (Button button in buttons)
{
Debug.Log(button.gameObject.activeSelf);
}
}
public async Task <ActionResult <SucceedInfomation> > createpostcontent([FromForm] PostPayload postpayload)
{
SucceedInfomation succeedinformation = new SucceedInfomation();
post Newpost = new post()
{
posttitle = postpayload.posttitle
};
if (postpayload.imgfile == null || postpayload.posttitle.Length < 3)
{
succeedinformation.Issucceed = false;
succeedinformation.SucceedDetail = "Please complete the form";
return(Ok(succeedinformation));
}
if (postpayload.imgfile.FileName.EndsWith(".jpg"))
{
Newpost.titleimgurl = await _imgservice.SaveFileJpg(postpayload.imgfile);
}
else if (postpayload.imgfile.FileName.EndsWith(".png"))
{
Newpost.titleimgurl = await _imgservice.SaveFilePng(postpayload.imgfile);
}
// else if(postpayload.imgfile.Length == 0)
// {
// succeedinformation.Issucceed = false;
// succeedinformation.SucceedDetail = "file format invalide , pls use jpg or png";
// return Ok(succeedinformation);
// }
content Newcontent = new content()
{
contentdetail = postpayload.contentdetail
};
_Context.posts.Add(Newpost);
_Context.contents.Add(Newcontent);
_Context.SaveChanges();
var Newposcontent = new postcontent()
{
postid = Newpost.postid,
contentid = Newcontent.contentid,
userid = postpayload.userid,
categoryid = postpayload.categoryid,
postcontentcreated = DateTime.UtcNow
};
_Context.postcontents.Add(Newposcontent);
_Context.SaveChanges();
return(succeedinformation);
}
public string post(string user_id, string select, string title, string content)
{
post post1 = new post();
Hashtable ht = post1.Post(user_id, select, title, content);
foreach (string i in common.pic)
{
insert_post_picture(i, post1.post_id);
}
ht.Add("picture", common.pic);
JavaScriptSerializer js = new JavaScriptSerializer();
string strJson = js.Serialize(ht);
return(strJson);
}
public void NewPost(post newPost)
{
try
{
using (BlogEntities db = new BlogEntities())
{
db.posts.Add(newPost);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void imgExcluiComentario_Command(object sender, CommandEventArgs e)
{
comentario Comentario = CR.GetOne(int.Parse(e.CommandArgument.ToString()));
post Postagem = PR.GetOne(Comentario.id_post);
if (Comentario.id_usuarioremetente == UsuarioAtual.id_usuario || Postagem.id_usuario == UsuarioAtual.id_usuario)
{
CR.Delete(Comentario.id_comentario);
//CriaTimeline();
/*rptComentario.DataBind();
* rptPostagem.DataBind();*/
CriaComentario(Postagem.id_post);
}
}
public IHttpActionResult Deletepost(Guid guid)
{
post post = db.post.Where(u => u.guid == guid).FirstOrDefault <post>();
//post post = db.post.Find(id);
if (post == null)
{
return(NotFound());
}
db.post.Remove(post);
db.SaveChanges();
return(Ok(post));
}
// GET: Admin/Post/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
post mpost = db.Posts.Find(id);
if (mpost == null)
{
return(HttpNotFound());
}
ViewBag.listTopic = db.Topics.Where(m => m.status != 0).ToList();
return(View(mpost));
}
// GET: posts/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
post post = db.posts.Find(id);
if (post == null)
{
return(HttpNotFound());
}
ViewBag.author_userId = new SelectList(db.users, "userId", "firstName", post.author_userId);
return(View(post));
}
protected void imgExcluiComentario_Command(object sender, CommandEventArgs e)
{
comentario Comentario = CR.GetOne(int.Parse(e.CommandArgument.ToString()));
post Postagem = PR.GetOne(Comentario.id_post);
if (Comentario.id_usuarioremetente == UsuarioAtual.id_usuario || Postagem.id_usuario == UsuarioAtual.id_usuario)
{
CR.Delete(Comentario.id_comentario);
CriaTimeline();
if (Session["idpostaberto"] != null)
{
CriaComentario(Postagem.id_post);
}
}
}
//public Dictionary<string, string> post()
//{
// try
// {
// Docupload d = new Docupload();
// var file = Request.Form.Files[0];
// var folderName = Path.Combine("Resources", "Images");
// var pathToSave = Path.Combine(Directory.GetCurrentDirectory(), folderName);
// if (file.Length > 0)
// {
// var fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
// var fullPath = Path.Combine(pathToSave, fileName);
// var dbPath = Path.Combine(folderName, fileName);
// using (var stream = new FileStream(fullPath, FileMode.Create))
// {
// file.CopyTo(stream);
// }
// d.DocName = fileName;
// d.Path = dbPath;
// //d.AccepterId = Convert.ToInt32(Message);
// context.Add(d);
// context.SaveChanges();
// return Ok();
// }
// }
// catch (Exception ex)
// {
// return StatusCode(500, $"Internal server error: {ex}");
// }
//}
public IHttpActionResult Put(int id, [FromBody] post s)
{
post a = context.posts.Single(post => post.post_id == id);
a.title = s.title;
a.category = s.category;
a.description = s.description;
a.target_amount = s.target_amount;
a.received_amount = s.received_amount;
//context.Update(s);
context.SaveChanges();
return(Ok());
}
public async Task CreateDbAsync()
{
db = new Database(_connectionStringName);
await db.ExecuteAsync(@"
DROP TABLE IF EXISTS posts;
DROP TABLE IF EXISTS authors;
CREATE TABLE posts (
id bigint AUTO_INCREMENT NOT NULL,
title varchar(127) NOT NULL,
author bigint NOT NULL,
PRIMARY KEY (id)
) ENGINE=INNODB;
CREATE TABLE authors (
id bigint AUTO_INCREMENT NOT NULL,
name varchar(127) NOT NULL,
PRIMARY KEY (id)
) ENGINE=INNODB;
");
var a1 = new author();
a1.name = "Bill";
await db.InsertAsync(a1);
var a2 = new author();
a2.name = "Ted";
await db.InsertAsync(a2);
var p = new post();
p.title = "post1";
p.author = a1.id;
await db.InsertAsync(p);
p = new post();
p.title = "post2";
p.author = a1.id;
await db.InsertAsync(p);
p = new post();
p.title = "post3";
p.author = a2.id;
await db.InsertAsync(p);
}
public override bool Delete(object Obj)
{
try
{
post post = (post)Obj;
dbEntities = new mpi_dbEntities();
dbEntities.posts.Remove(post);
dbEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public void DelPost(int _id)
{
try
{
var post = new post {
C_id = _id
};
db.posts.Attach(post);
db.posts.Remove(post);
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult AddPost(post post)
{
if (ModelState.IsValid)
{
int id = Convert.ToInt32(Session["id"]);
var writer = db.users.Where(model => model.id == id).FirstOrDefault();
post.state = 0;
post.user_id = writer.id;
db.posts.Add(post);
db.SaveChanges();
return(RedirectToAction("newHomePage", "Home"));
}
return(View(post));
}
/// <summary>
/// Sets the post defaults.
/// </summary>
/// <param name="_p">Instatiated Post</param>
private static void setPostDefaults(ref post _p)
{
_p.post_author = post_author;
_p.post_status = post_status;
_p.post_type = post_type;
_p.comment_status = sub_status;
_p.ping_status = sub_status;
// Added by Jun 12/2020
// The post_content in Wordpress post table need to have an value instead of null
// T12262020 - A - create - workshop
_p.post_content = post_content;
_p.post_excerpt = post_excerpt;
_p.to_ping = to_ping;
_p.pinged = pinged;
_p.post_content_filtered = post_content_filtered;
}
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
int idsel = Convert.ToInt32(GridView1.DataKeys[e.NewSelectedIndex].Value);
Panel1.Visible = true;
Btnupd.Visible = true;
Btnsave.Visible = false;
post postEdit = new post();
postEdit = blogNegocio.GetPostbyID(idsel);
txttitulo.Text = postEdit.titulo;
txtpost.Text = postEdit.post1;
txtimg.Text = postEdit.urlimagen;
txtautor.Text = postEdit.autor;
lblID.Text = idsel.ToString();
}
public IActionResult Edit(int id, post post, IFormFile image, string returnUrl = null)
{
if (id != post.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
this.repository.UpdateEntity(post, image);
return(RedirectToLocal(returnUrl));
}
ViewData["ReturnUrl"] = returnUrl;
return(View(post));
}
public ViewResult makepost(Homelist homelistviewmodel)
{
var id = _post.getallposts().Max(c => c.p_id) + 1;
Homelist list = new Homelist();
var newpost = new post()
{
p_id = id,
p_content = homelistviewmodel.newpost.p_content,
P_user = homelistviewmodel.newpost.P_user,
comments = new List <Icomment>(),
like = 0
};
list.newpost = _post.addpost(newpost);
list.allposts = _post.getallposts();
return(View("makepost", list));
}
public ActionResult Edit([Bind(Include = "postid,title,text,users_userid,date")] post post)
{
if (ModelState.IsValid)
{
//Fin the user id
string username = User.Identity.Name.ToString();
var userid = db.AspNetUsers.SqlQuery("SELECT * FROM AspNetUsers WHERE UserName = "******"'" + username + "'").ToList();
AspNetUser user = userid[0];
post.date = DateTime.Now;
post.users_userid = user.Id;
db.Entry(post).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.users_userid = new SelectList(db.AspNetUsers, "Id", "Email", post.users_userid);
return(View(post));
}
public ActionResult Edit(post p)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:520122/api/");
var putTask = client.PutAsJsonAsync <post>("posts/" + p.postNumber, p);
putTask.Wait();
var result = putTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
}
ModelState.AddModelError(string.Empty, "Error");
return(View(p));
}
protected void Button2_Click(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["rowenref"];//declaration of cookie
user usrtrash = db.users.First(use => use.username == cookie["username"]);
post Pstid = db.posts.First(use => use.user_id == Convert.ToInt16(cookie["userid"]));
tbl_gallery gll = db.tbl_galleries.First(use => use.pst_id == Pstid.pst_id);
string file_name = Pstid.Image;
string Username = usrtrash.Image;
string userpaths = Server.MapPath("../profilepic/oreginal/" + Username);
string paths = Server.MapPath("../images/oreginal/" + file_name);
FileInfo userfiles = new FileInfo(userpaths);
FileInfo files = new FileInfo(paths);
if (files.Exists)
{
files.Delete();
}
else if (userfiles.Exists)
{
userfiles.Delete();
}
else
{
}
db.sp_DELETE_tbl_commentuser(Convert.ToInt16(cookie["userid"])); //delete user comment
db.sp_DELETE_tbl_postuser(Convert.ToInt16(cookie["userid"])); //delete user post
db.tbl_galleries.DeleteOnSubmit(gll);
db.users.DeleteOnSubmit(usrtrash);
db.SubmitChanges();
// cookie distroy
cookie.Expires = DateTime.Now.AddDays(-1);
Response.Cookies.Add(cookie);
Response.Redirect("home.aspx");
}
/*protected void bttPostaComentario_Command(object sender, CommandEventArgs e)
* {
* if (txtComentario.Text != "")
* {
* comentario Comentario = new comentario();
* Comentario.id_post = (int)Session["idpostaberto"];
* Comentario.id_usuarioremetente = UsuarioAtual.id_usuario;
* Comentario.comentariocontent = txtComentario.Text;
* Comentario.datacomentario = DateTime.Now;
* CR.Salvar(Comentario);
*
* txtComentario.Text = "";
* }
* CriaComentario((int)Session["idpostaberto"]);
* }*/
protected void bttComentar_Command(object sender, CommandEventArgs e)
{
if (int.Parse(e.CommandArgument.ToString()) != 0)
{
pnlComentario.Attributes.Add("style", "Display: flex");
Session["idpostaberto"] = int.Parse(e.CommandArgument.ToString());
post Postagem = PR.GetOne((int)Session["idpostaberto"]);
followusuario Seguindo = FUR.GetOne(UsuarioAtual.id_usuario, Postagem.id_usuario);
usuario Usuario = UR.GetOne(Postagem.id_usuario);
txtComentario.Text = "";
txtComentario.Enabled = true;
bttPostaComentario.Enabled = true;
if (Seguindo == null && Postagem.id_usuario != UsuarioAtual.id_usuario)
{
txtComentario.Text = "Você não segue " + Usuario.nicknameusuario + " para comentar em seu post!";
txtComentario.Enabled = false;
bttPostaComentario.Enabled = false;
}
DataTable table = new DataTable();
table.Columns.Add("DataPostagem");
table.Columns.Add("NomeUsuario");
table.Columns.Add("NicknameUsuario");
table.Columns.Add("LinkfotoUsuario");
table.Columns.Add("ConteudoPost");
table.Columns.Add("id_usuario");
table.Columns.Add("id_post");
DataRow datarow = table.NewRow();
datarow["id_usuario"] = Postagem.id_usuario;
datarow["DataPostagem"] = Postagem.datapostagem;
datarow["ConteudoPost"] = Postagem.contentpost;
datarow["NomeUsuario"] = Usuario.nomeusuario;
datarow["NicknameUsuario"] = Usuario.nicknameusuario;
datarow["LinkfotoUsuario"] = Usuario.linkfoto;
datarow["id_post"] = Postagem.id_post;
table.Rows.Add(datarow);
rptPostComentario.DataSource = table;
rptPostComentario.DataBind();
CriaComentario(int.Parse(e.CommandArgument.ToString()));
}
}
public post MapIt(post p, author a)
{
// Get existing author object, or if not found store this one
author aExisting;
if (authors.TryGetValue(a.id, out aExisting))
{
a = aExisting;
}
else
{
authors.Add(a.id, a);
}
// Wire up objects
p.author_obj = a;
return(p);
}
public void DodajPost(Klasa new_post)
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
var p = new post();
p.tytul = new_post.tytul;
p.tresc = new_post.tresc;
p.status = new_post.status;
p.data_dodania = DateTime.Now;
dp.posts.InsertOnSubmit(p);
dp.SubmitChanges();
var t = new tagi();
t.id_posta = p.ID;
t.keywords = new_post.keywords;
t.description = new_post.description;
dp.tagis.InsertOnSubmit(t);
dp.SubmitChanges();
}
}
public post MapIt(post p, author a)
{
// Get existing author object, or if not found store this one
author aExisting;
if (authors.TryGetValue(a.id, out aExisting))
a = aExisting;
else
authors.Add(a.id, a);
// Wire up objects
p.author_obj = a;
return p;
}
public author MapIt(author a, post p)
{
// Terminating call. Since we can return null from this function
// we need to be ready for PetaPoco to callback later with null
// parameters
if (a == null)
return current;
// Is this the same author as the current one we're processing
if (current != null && current.id == a.id)
{
// Yes, just add this post to the current author's collection of posts
current.posts.Add(p);
// Return null to indicate we're not done with this author yet
return null;
}
// This is a different author to the current one, or this is the
// first time through and we don't have an author yet
// Save the current author
var prev = current;
// Setup the new current author
current = a;
current.posts = new List<post>();
current.posts.Add(p);
// Return the now populated previous author (or null if first time through)
return prev;
}
