public AcquirerImage GetImageByAcquirerId(int acquirerId)
{
AcquirerTable acquirer = db.AcquirerTables.Single(c => c.Id == acquirerId);
return
(new AcquirerImage()
{
AcquirerId = acquirerId,
Image = acquirer.Avatar
});
}
public Acquirer GetAcquirerInfo(int acquirerId)
{
AcquirerTable acquirerTable = db.AcquirerTables.SingleOrDefault(c => c.Id == acquirerId);
Acquirer acquirer = new Acquirer()
{
Address = acquirerTable.Address,
BinName = acquirerTable.BinName,
City = acquirerTable.City,
Latitude = acquirerTable.Latitude,
Longitude = acquirerTable.Longitude,
UserName = acquirerTable.UserName,
Phone = acquirerTable.Phone
};
return(acquirer);
}
public List <Resident> GetResidents(int acquirerId)
{
List <Resident> list = new List <Resident>();
AcquirerTable acquirer = db.AcquirerTables.SingleOrDefault(c => c.Id == acquirerId);
foreach (UserTable user in db.UserTables.Where(c => c.City == acquirer.City))
{
Resident resident = new Resident()
{
Address = user.Address,
Latitude = user.Latitude,
Longitude = user.Longitude,
UserName = user.UserName,
UserId = user.Id
};
list.Add(resident);
}
return(list);
}
public List <MessageToUser> GetMessge(int userId)
{
List <MessageToUser> list = new List <MessageToUser>();
foreach (MessageToUserTable item in db.MessageToUserTables.Where(c => c.ToId == userId && c.IsSee == false))
{
if (item.Type == 1)
{
string name = "";
AcquirerTable acquirer = db.AcquirerTables.FirstOrDefault(c => c.Id == item.FromId);
UserTable user = db.UserTables.FirstOrDefault(c => c.Id == item.FromId);
if (acquirer != null)
{
name = acquirer.UserName;
}
if (user != null)
{
name = user.UserName;
}
MessageToUser message = new MessageToUser()
{
Name = name,
FromId = item.FromId,
MessageContent = item.MessageContent,
Type = item.Type
};
list.Add(message);
item.IsSee = true;
}
else
{
MessageToUser message = new MessageToUser()
{
MessageContent = item.MessageContent,
Type = item.Type
};
item.IsSee = true;
list.Add(message);
}
}
db.SaveChanges();
return(list);
}
void client_GetAcquirerCompleted(object sender, GetAcquirerCompletedEventArgs e)
{
foreach (Panda.Phone.Publisher.PublisherServiceReference.Acquirer item in e.Result)
{
AcquirerTable acquirerTable = new AcquirerTable()
{
Address = item.Address,
BinName = item.BinName,
City = item.City,
Latitude = item.Latitude,
Longitude = item.Longitude,
Phone = item.Phone,
UserName = item.UserName,
Id = item.AcquirerId
};
db.Acquirers.InsertOnSubmit(acquirerTable);
}
db.SubmitChanges();
callback();
// client.GetMessgeAsync(userId);
}
public List <Item> GetItems(int acquirerId)
{
List <Item> list = new List <Item>();
AcquirerTable acquirer = db.AcquirerTables.SingleOrDefault(c => c.Id == acquirerId);
foreach (UserTable user in db.UserTables.Where(c => c.City == acquirer.City))
{
foreach (ItemTable item in db.ItemTables.Where(c => c.UserId == user.Id))
{
Item item1 = new Item()
{
CategoryId = item.CategoryId,
UserId = item.UserId,
Name = item.Name,
Num = item.Amount,
Time = item.Time,
ItemId = item.Id
};
list.Add(item1);
}
}
return(list);
}
public LoginBack Login(Login login)
{
Console.WriteLine(login.UserName + "Login");
LoginBack loginBack = new LoginBack();
UserTable user = db.UserTables.SingleOrDefault(c => c.UserName == login.UserName && c.Password == login.Passwrod);
AcquirerTable acquirer = db.AcquirerTables.SingleOrDefault(c => c.UserName == login.UserName && c.PassWord == login.Passwrod);
// MerChantTable merchant = db.MerChantTables.SingleOrDefault(c => c.UserName == login.UserName && c.PassWord == login.Passwrod);
if (user != null)
{
loginBack.Message = "OK";
loginBack.UserId = user.Id;
loginBack.UserType = 0;
Console.WriteLine(login.UserName + "Login Success");
return(loginBack);
}
if (acquirer != null)
{
loginBack.Message = "OK";
loginBack.UserId = acquirer.Id;
loginBack.UserType = 1;
Console.WriteLine(login.UserName + "Login Success");
return(loginBack);
}
//if (merchant != null)
//{
// loginBack.Message = "OK";
// loginBack.UserId = merchant.Id;
// loginBack.UserType = 2;
// return loginBack;
//}
loginBack.Message = "Error";
loginBack.UserId = -1;
loginBack.UserType = -1;
return(loginBack);
}
List <MessageModel> getMessageList()
{
List <MessageModel> List_Messages = new List <MessageModel>();
// List<MessageTable> list=db.Messages.Where(c => c.ToId == user.Id).ToList();
foreach (MessageTable message in db.Messages)
{
MessageModel model = new MessageModel();
AcquirerTable acquirer = db.Acquirers.Single(c => c.Id == message.FromId);
model.FromName = acquirer.UserName;
model.Time = message.Time;
if (message.IsSee)
{
model.ImageUri = "/Image_Recycle/Message/m_open.png";
}
else
{
model.ImageUri = "/Image_Recycle/Message/m_closed.png";
}
model.Message = message.Message;
List_Messages.Add(model);
}
return(List_Messages);
}
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");
}
