private void dealWithAchievement(UserTable user)
{
// List<int> list_FriendId = db.FriendTables.Where(c => c.UserId == userId).Select(c => c.FriendId).ToList<int>();
// list_FriendId.Add(userId);
//foreach (int j in list_FriendId) Console.WriteLine(j);
int[] Num=new int[10];
//foreach (int friendId in list_FriendId)
// {
// {
// // if (user.Id == friendId)
// {
if (user.NowRank<=8 && user.LastRank > 8)
{
AchievementTrendTable achievementTable = new AchievementTrendTable()
{
Achievement="rise to NO."+user.NowRank,
Time=DateTime.Now.ToShortDateString(),
UserId=user.Id
};
db.AchievementTrendTables.AddObject(achievementTable);
}
if (user.NowRank == 1 && user.LastRank != 1)
{
foreach (ItemTable item in db.ItemTables.Where(c=>c.UserId==user.Id))
{
Num[item.CategoryId]+=item.Amount;
}
int max=0;
int categotyId=0;
for(int j=1;j<=6;j++)
{
if(Num[j]>max)
{
max=Num[j];
categotyId=j;
}
}
string categoryName=db.CategoryTables.SingleOrDefault(c=>c.Id==categotyId).Name;
AchievementTrendTable achievementTable = new AchievementTrendTable()
{
Achievement = categoryName,
Time = DateTime.Now.ToShortDateString(),
UserId = user.Id
};
db.AchievementTrendTables.AddObject(achievementTable);
}
db.SaveChanges();
}
/// <summary>
/// 用于向 UserTables EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddToUserTables(UserTable userTable)
{
base.AddObject("UserTables", userTable);
}
public string Register(RegisterUser user)
{
Console.WriteLine(user.UserName + "Register");
if (user.UserType == 0)
{
UserTable userTable = new UserTable()
{
UserName = user.UserName,
Address = user.Address,
City = getCity(user.Address),
Latitude = user.Latitude,
Longitude = user.Longitude,
Password = user.Passwrod,
Point = 10,
Avatar = user.ImageFileData,
LastRank = 200,
CityLastRank=100,
NowRank=200,
NowCityRank=100,
UserRank=100,
CityRank=100
};
db.UserTables.AddObject(userTable);
db.SaveChanges();
UserTable userTable1 = db.UserTables.SingleOrDefault(c => c.UserName == userTable.UserName && c.Password == userTable.Password);
foreach (UserTable item in db.UserTables.Where(c=>c.City==userTable1.City))
{
FriendTable Friend = new FriendTable()
{
UserId = userTable1.Id,
FriendId=item.Id
};
if (Friend.UserId != Friend.FriendId)
{
db.FriendTables.AddObject(Friend);
// db.SaveChanges();
}
FriendTable Friend1 = new FriendTable()
{
UserId = item.Id,
FriendId = userTable1.Id
};
if (Friend1.UserId != Friend1.FriendId)
{
db.FriendTables.AddObject(Friend1);
// db.SaveChanges();
}
}
}
if (user.UserType == 1)
{
AcquirerTable acquirer = new AcquirerTable()
{
UserName = user.UserName,
Address = user.Address,
City = getCity(user.Address),
Latitude = user.Latitude,
Longitude = user. Longitude,
PassWord = user.Passwrod,
Phone=user.Phone,
BinName=user.StoreBinName,
Avatar = user.ImageFileData,
};
db.AcquirerTables.AddObject(acquirer);
}
if (user.UserType == 2)
{
MerChantTable merchant = new MerChantTable()
{
UserName = user.UserName,
Address = user.Address,
Latitude = user.Latitude,
Longitude = user.Longitude,
PassWord = user.Passwrod,
Phone = user.Phone,
StoreName = user.StoreBinName,
Avatar = user.ImageFileData,
};
db.MerChantTables.AddObject(merchant);
}
if (!db.CityTables.Select(c => c.Name).Contains(getCity(user.Address)))
{
CityTable city = new CityTable()
{
Name = user.City,
LastRank = 100,
Point = 10
};
db.CityTables.AddObject(city);
}
db.SaveChanges();
return "Register Success";
}
/// <summary>
/// 创建新的 UserTable 对象。
/// </summary>
/// <param name="id">Id 属性的初始值。</param>
/// <param name="userName">UserName 属性的初始值。</param>
/// <param name="latitude">Latitude 属性的初始值。</param>
/// <param name="longitude">Longitude 属性的初始值。</param>
/// <param name="point">Point 属性的初始值。</param>
/// <param name="cityLastRank">CityLastRank 属性的初始值。</param>
/// <param name="nowCityRank">NowCityRank 属性的初始值。</param>
/// <param name="nowRank">NowRank 属性的初始值。</param>
/// <param name="lastRank">LastRank 属性的初始值。</param>
/// <param name="avatar">Avatar 属性的初始值。</param>
/// <param name="address">Address 属性的初始值。</param>
/// <param name="city">City 属性的初始值。</param>
/// <param name="password">Password 属性的初始值。</param>
public static UserTable CreateUserTable(global::System.Int32 id, global::System.String userName, global::System.Decimal latitude, global::System.Decimal longitude, global::System.Int32 point, global::System.Int32 cityLastRank, global::System.Int32 nowCityRank, global::System.Int32 nowRank, global::System.Int32 lastRank, global::System.Byte[] avatar, global::System.String address, global::System.String city, global::System.String password)
{
UserTable userTable = new UserTable();
userTable.Id = id;
userTable.UserName = userName;
userTable.Latitude = latitude;
userTable.Longitude = longitude;
userTable.Point = point;
userTable.CityLastRank = cityLastRank;
userTable.NowCityRank = nowCityRank;
userTable.NowRank = nowRank;
userTable.LastRank = lastRank;
userTable.Avatar = avatar;
userTable.Address = address;
userTable.City = city;
userTable.Password = password;
return userTable;
}
