public dsUser UserByID(int id)
{
dsUser tempDS = new dsUser();
SqlConnection connection = new SqlConnection(
Configuration.GetValue("DSN"));
connection.Open();
SqlCommand command = new SqlCommand();
command.CommandText = "FindUserByID";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
SqlParameterCollection parameters = command.Parameters;
DbUtility.AddParameter(parameters,
SqlDbType.Int, 50, "@id", id);
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(tempDS);
connection.Close();
return(tempDS);
}
public void Save(dsUser p_ds)
{
//this is executed from authorize.aspx
DbUtility.ExecStoredProcForSave(
p_ds.Tables[0],
User_Insert(),
User_Update(),
User_Delete());
}
public dsUser GetAllUsers()
{
dsUser tempDS = new dsUser();
SqlConnection connection = new SqlConnection(
Configuration.GetValue("DSN"));
connection.Open();
SqlCommand command = new SqlCommand();
command.CommandText = "Users_GetAll";
command.CommandType = CommandType.StoredProcedure;
SqlParameterCollection parameters = command.Parameters;
command.Connection = connection;
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(tempDS);
connection.Close();
return(tempDS);
}