public static List <User> ReadAllUsers(this MSSqlHelper db)
{
List <User> userList = new List <User>();
using (DbDataReader reader = db.GetReader(SQL_QUERY_USERS))
{
while (reader != null && reader.Read())
{
User item = new User(reader);
userList.Add(item);
}
}
foreach (User user in userList)
{
using (DbDataReader reader = db.GetReader("Select vocationClass,VocationLevel from vocation where CID=" + user.CID))
{
while (reader != null && reader.Read())
{
user.UpdateGroup(reader);
break;
}
}
}
return(userList);
}
public static List <long> GetTitles(this MSSqlHelper db, User user)
{
List <long> titles = new List <long>();
using (DbDataReader reader = db.GetReader("select TitleID from Title where Acquired =1 and CID=" + user.CID)){
while (reader != null && reader.Read())
{
titles.Add(reader.ReadInt64("TitleID"));
}
}
return(titles);
}
public static List <Mail> ReadRecvMailList(this MSSqlHelper db, User user)
{
List <Mail> mails = new List <Mail>();
if (user == null)
{
return(mails);
}
using (DbDataReader reader = db.GetReader("select mi.itemCount,m.* from Mail as m LEFT JOIN MailItem as mi ON mi.MailID = m.MailID"
+ " where m.ToCID =" + user.CID))
{
while (reader != null && reader.Read())
{
mails.Add(new Mail().AttachBox(reader));
}
}
return(mails);
}
public static List <Mail> ReadSendMailList(this MSSqlHelper db, User user)
{
List <Mail> mails = new List <Mail>();
if (user == null)
{
return(mails);
}
using (DbDataReader reader = db.GetReader("SELECT * FROM QueuedItem WHERE CID =" + user.CID))
{
while (reader != null && reader.Read())
{
Mail item = new Mail(reader);
mails.Add(item);
}
}
return(mails);
}
