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"); }