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