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 }