protected void Page_Load(object sender, EventArgs e) { using (var db = new ModelLMH()) { //var teste = db.Utilizadores.First(); //db.Posts.Add(new Post() { PostId = 1, PostDate = DateTime.Now, PostHeader = "Acartador de Batatas", PostDescription = "Preciso de alguem para acartar batatas em troca de 30kg das mesmas", UserId = 50, User= teste }); //db.SaveChanges(); if (db.Posts.Count() == 0) { } else { DivNoPosts.Visible = false; foreach (var post in db.Posts.ToList().OrderBy(p => p.PostDate)) { HtmlGenericControl example = new HtmlGenericControl("div"); HtmlGenericControl title = new HtmlGenericControl("h2"); title.InnerText = post.PostHeader; title.ID = post.PostId.ToString(); #region Criar um <a href> HtmlGenericControl redirector = new HtmlGenericControl("a"); redirector.InnerHtml = $"<a href=veranuncio?postId={post.PostId}>"; #endregion HtmlImage image = new HtmlImage(); image.Src = post.PostImg; image.Alt = "Post Image"; image.Height = 100; image.Width = 100; #region Add Elements of Post redirector.Controls.Add(title); redirector.Controls.Add(image); example.Controls.Add(redirector); //example.Controls.Add(title); //example.Controls.Add(image); #endregion postsDedicated.Controls.Add(example); postsDedicated.Controls.Add(new HtmlGenericControl("br")); } } } }
private void ExecuteInsert(User aUser) { using (var db = new ModelLMH()) { db.Utilizadores.Add(aUser); db.SaveChanges(); } Response.Redirect("Login.aspx?registed=1"); }
private bool EmailInUse(string aEmail) { using (var db = new ModelLMH()) { if (db.Utilizadores.Any(u => u.UserMail == aEmail)) { return(true); } return(false); } }
protected void Post_Load(int apostId) { int _postId = apostId; using (var db = new ModelLMH()) { var post = db.Posts.ToList().Find(i => i.PostId == _postId); Titulo.InnerText = post.PostHeader; descr.Text = post.PostDescription; oferta.Text = post.PostOfertaInicial; Data.Text = post.PostDate.ToString(); imgPost.ImageUrl = post.PostImg; } }
private void UpdateUser() { using (var db = new ModelLMH()) { var _user = db.Utilizadores.ToList().Find(i => i.UserId == int.Parse(Session["uID"].ToString())); _user.UserFullName = TextBoxNome.Text.Trim(); _user.UserPhone = int.Parse(TextBoxTel.Text.Trim()); _user.UserBio = TextAreaDescription.Text.Trim(); _user.UserPass = TextBoxPass2.Text.Trim(); _user.UserPicLink = UploadFile(_user.UserPicLink.ToString()); db.SaveChanges(); Session["uFullName"] = _user.UserFullName; } }
protected void UserPost_Load(int apostId) { int _postId = apostId; using (var db = new ModelLMH()) { var post = db.Posts.ToList().Find(i => i.PostId == _postId); var user = db.Utilizadores.ToList().Find(i => i.UserId == post.UserId); ImgPerfil.ImageUrl = user.UserPicLink; anunciante.InnerText = user.UserFullName; anuncDescr.Text = user.UserBio; anuncTel.Text = user.UserPhone.ToString(); } }
protected void ButtonEnviar_Click(object sender, EventArgs e) { try { using (var db = new ModelLMH()) { var post = db.Posts.ToList().Find(i => i.PostId == int.Parse(Request.QueryString["postId"])); var user = db.Utilizadores.ToList().Find(i => i.UserId == post.UserId); var userSubmit = db.Utilizadores.ToList().Find(i => i.UserId == int.Parse(Session["uID"].ToString())); SendEmail(user.UserMail.Trim(), post.PostHeader, userSubmit.UserMail); } } catch (Exception ex) { ErroEnviar.Text = "Falha ao enviar a mensagem!\n" + ex; divErro.Visible = true; } }