void client_GetPhotoTrendCompleted(object sender, GetPhotoTrendCompletedEventArgs e)
{
foreach (PhotoTrend item in e.Result)
{
PhotoTrendTable photoTrendTable = new PhotoTrendTable()
{
Describe = item.Describe,
Time = item.Time,
ItemId = item.ItemId,
UserId = item.UserId,
Name = item.Name
};
photoTrendTable.Describe = photoTrendTable.Describe.Insert(photoTrendTable.Describe.IndexOf(' '), "\r\n");
db.PhotoTrends.InsertOnSubmit(photoTrendTable);
}
db.SubmitChanges();
dealWithPhotoTrend();
callback3();
}
public string Post(PostItem postItem)
{
UserTable user = db.UserTables.SingleOrDefault(c => c.Id == postItem.UserId);
Console.WriteLine(user.UserName + "Post" + postItem.Name);
user.Point += postItem.GetPoints;
ItemTable item = new ItemTable()
{
Amount = postItem.Amount,
CategoryId = postItem.CategoryId,
Describe = postItem.Describe,
Name = postItem.Name,
UserId = postItem.UserId,
Image = postItem.PostImage,
Time = DateTime.Now.ToShortDateString()
};
db.ItemTables.AddObject(item);
db.SaveChanges();
Console.WriteLine(user.UserName + "Post" + postItem.Name + "Save To DataBase Success");
PostAffectTable postAffect = new PostAffectTable()
{
UserId = postItem.UserId,
Time = DateTime.Now.ToShortDateString(),
PostAffect = postItem.PostAffect,
Describe = "Posts " + postItem.Amount + " " + postItem.Name,
};
db.PostAffectTables.AddObject(postAffect);
PhotoTrendTable photoTrendTable = new PhotoTrendTable()
{
Describe = " posts " + postItem.Name,
ItemId = item.Id,
Time = DateTime.Now.ToShortDateString(),
UserId = postItem.UserId
};
db.PhotoTrendTables.AddObject(photoTrendTable);
db.SaveChanges();
int i = 0;
foreach (UserTable userTable in db.UserTables.ToList().OrderByDescending(c => c.Point))
{
i++;
if (userTable.Id == postItem.UserId)
{
user.NowRank = i;
break;
}
}
i = 0;
foreach (UserTable userTable in db.UserTables.Where(c => c.City == user.City).ToList().OrderByDescending(c => c.Point))
{
i++;
if (userTable.Id == postItem.UserId)
{
user.NowCityRank = i;
break;
}
}
dealWithAchievement(user);
user.UserRank = user.NowRank - user.LastRank;
user.CityRank = user.NowCityRank - user.CityLastRank;
user.LastRank = user.NowRank;
user.CityLastRank = user.NowCityRank;
db.SaveChanges();
return(postItem.Name + "Unload OK");
}
