public ReferenceData.Entity.Account GetAccountBySignInInfo(string email, string password) { var list = db.Usp_GetAccountBySignInInfo(email, password).ToList(); ReferenceData.Entity.Account acc = null; if (list.Count > 0) { string imagesFolder = Path.GetDirectoryName(Process.GetCurrentProcess().MainModule.FileName) + @"\Files\Images\"; acc = new ReferenceData.Entity.Account(); foreach (var u in list) { acc.id = u.id; acc.email = u.email; acc.password = u.password; acc.firstName = u.firstName; acc.lastName = u.lastName; acc.avatar = ChatAppUtils.ConvertFileToByte(imagesFolder + u.avatar); acc.birthday = u.birthday; acc.createdAt = u.createdAt; } } return(acc); }