public List <DTO_Resident> Get()
{
List <Resident> list = rc.ResidentList();
if (list == null)
{
return(null);
}
List <DTO_Resident> dto_list = new List <DTO_Resident>();
foreach (var item in list)
{
TimeStamp t = null;
if (item.Timestamp == null)
{
item.Timestamp = dbTools.CreateTimeStamp();
}
t = dbTools.GetTimeStamp(item.Timestamp);
User user = uc.GetUserById(item.User);
Address address = ac.GetAddressById(item.Address);
dto_list.Add(new DTO_Resident()
{
Resident = item, User = user, Address = address, Timestamp = t
});
}
return(dto_list);
}
public List <DTO_User> Get()
{
List <User> userlist = uc.UserList();
if (userlist == null)
{
return(null);
}
List <DTO_User> users = new List <DTO_User>();
foreach (var u in userlist)
{
TimeStamp t = null;
if (u.Timestamp == null)
{
u.Timestamp = dbTools.CreateTimeStamp();
}
t = dbTools.GetTimeStamp(u.Timestamp);
users.Add(new DTO_User()
{
user = u, timestamp = t
});
}
return(users);
}
internal int CreateUser(User user)
{
user.Timestamp = dbTools.CreateTimeStamp(); // Creates a new timestamp
SqlCommand cmd = new SqlCommand("INSERT INTO [user] (email, phone, name, password, lastlogin, timestamp_fk)" +
"OUTPUT INSERTED.id VALUES (@email, @phone, @name, @password, @lastlogin, @timestamp)");
cmd.Parameters.Add("@email", SqlDbType.NVarChar, 50);
cmd.Parameters["@email"].Value = user.Email;
cmd.Parameters.AddWithValue("@phone", user.Phone);
cmd.Parameters.AddWithValue("@name", user.Name);
cmd.Parameters.AddWithValue("@password", user.Password);
cmd.Parameters.AddWithValue("@lastlogin", user.LastLogin);
cmd.Parameters.AddWithValue("@timestamp", user.Timestamp);
return(dbTools.ExecuteSQLGetID(cmd)); //executes sqlcommand and returns id of created user
}
