public Photos AddPhoto(Photos photo) { var p = db.Photos.Add(photo); db.SaveChanges(); return(p); }
public Albums AddAlbum(Albums album) { var a = db.Albums.Add(album); db.SaveChanges(); return(a); }
public void DeleteCategory(int uid, int cid) { var category = db.Categories.Where(n => n.UID == uid && n.CID == cid).FirstOrDefault(); if (category != null) { db.Categories.Remove(category); db.SaveChanges(); } }
public void DeleteTag(int uid, int tid) { var tag = db.Tags.Where(n => n.UID == uid && n.TID == tid).FirstOrDefault(); if (tag != null) { db.Tags.Remove(tag); db.SaveChanges(); } }
public CommentsViewModel AddComment(Comments comments) { Comments commentadded = db.Comments.Add(comments); db.SaveChanges(); var u = db.Users.Where(n => n.UID == commentadded.UID).First(); return(new CommentsViewModel { Id = commentadded.ID, Author = u.UserName, Comment = commentadded.Content, ParentId = commentadded.ParentId, UserAvatar = u.HeadPic, CanDelete = true, CanReplay = true, Date = commentadded.CreateTime.ToString() }); }
public void ViewNumPlusOne(int aid) { var s = db.Articles.Where(n => n.AID == aid).FirstOrDefault(); if (s != null) { s.ViewNum += 1; db.SaveChanges(); } }
public void AddCompaint(Complaint complaint) { db.Complaint.Add(complaint); db.SaveChanges(); }
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model) { string provider = null; string providerUserId = null; string returnUrl = null; if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) { return RedirectToAction("Manage"); } if (ModelState.IsValid) { // Insert a new user into the database using (BlogEntities db = new BlogEntities()) { UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.Name.ToLower()); // Check if user already exists if (user == null) { //pegando a imagem do perfil do facebook e passando para base64 Image image = null; string base64String = null; string URL = "https://graph.facebook.com/" + providerUserId + "/picture"; HttpWebRequest req = (System.Net.HttpWebRequest)HttpWebRequest.Create(URL); req.AllowWriteStreamBuffering = true; req.Timeout = 20000; WebResponse resp = req.GetResponse(); System.IO.Stream stream = resp.GetResponseStream(); image = Image.FromStream(stream); resp.Close(); using (MemoryStream ms = new MemoryStream()) { // Convert Image to byte[] image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] imageBytes = ms.ToArray(); // Convert byte[] to Base64 String base64String = Convert.ToBase64String(imageBytes); } //fim da conversão da imagem // Insert name into the profile table db.UserProfiles.Add(new UserProfile { UserName = model.Name, FacebookProfileImgUrl = base64String, UserLink = model.Link }); db.SaveChanges(); OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.Name); OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false); return RedirectToAction("Index", "Home"); //return RedirectToLocal(returnUrl); } } } ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName; ViewBag.ReturnUrl = returnUrl; return RedirectToAction("Index", "Home"); }
public void AddUser(Users users) { db.Users.Add(users); db.SaveChanges(); }