public Users FindUserid(string userName)
{
DbCommand command = db.GetStoredProcCommand("Users_FindUserid");
db.AddInParameter(command, "@Username", System.Data.DbType.String, userName);
db.ExecuteScalar(command);
var result = new Users();
using (var reader = db.ExecuteReader(command))
{
while (reader.Read())
{
if (!reader.IsDBNull(reader.GetOrdinal("Userid")))
{
result.Userid = reader.GetInt32(reader.GetOrdinal("Userid"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Type")))
{
result.Type = reader.GetString(reader.GetOrdinal("Type"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Pass")))
{
result.Pass = reader.GetString(reader.GetOrdinal("Pass"));
}
}
return result;
}
}
public List<Users> BuildList()
{
var list = new List<Users>();
DbCommand command = db.GetStoredProcCommand("Users_BuildList");
using (var reader = db.ExecuteReader(command))
{
while (reader.Read())
{
var User = new Users();
if (!reader.IsDBNull(reader.GetOrdinal("Type")))
{
User.Type = reader.GetString(reader.GetOrdinal("Type"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Pass")))
{
User.Pass = Crypto.Hash(reader.GetString(reader.GetOrdinal("Pass")));
}
list.Add(User);
}
}
return list;
}
public ActionResult SubmitPassword(Users User)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand command = db.GetStoredProcCommand("Users_InsertUser");
db.AddInParameter(command, "@Type", System.Data.DbType.String, User.Type);
db.AddInParameter(command, "@Pass", System.Data.DbType.String, User.Pass);
db.ExecuteScalar(command);
return RedirectToAction("Index", "Home");
}
