internal static UserLogin GetUserLoginFromEmail(string email)
{
UserLogin u = new UserLogin();
if (!string.IsNullOrEmpty(email))
{
SafeProcedure.ExecuteAndMapRecords(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.UserLogin_GetFromEmail",
delegate(IRecord record)
{
u.UserId = record.GetInt32OrDefault(0,0);
u.UserName = record.GetStringOrEmpty(1);
u.Password = record.GetStringOrEmpty(2);
u.Email = record.GetStringOrEmpty(3);
},
email);
}
return u;
}
public void SetUserLogin(UserLogin u)
{
UserDao.SetUserLogin(u);
}
internal static void SetUserLogin(UserLogin u)
{
if (u == null) return;
SafeProcedure.ExecuteNonQuery(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.UserLogin_Set",
u.UserId,
u.UserName,
u.Password,
u.Email);
}