private void GetirUser()
{
DataTable data = BLLUser.SelectData();
RepeaterUsers.DataSource = data;
RepeaterUsers.DataBind();
}
private void GetirCategories()
{
DataTable data = BLLUser.SelectCategories();
RepeaterUsers.DataSource = data;
RepeaterUsers.DataBind();
}
private void GetirVerifications()
{
DataTable data = BLLUser.SelectVerifications();
RepeaterUsers.DataSource = data;
RepeaterUsers.DataBind();
}
private void GetirAddress()
{
DataTable data = BLLUser.SelectUserAddress();
RepeaterUsers.DataSource = data;
RepeaterUsers.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["SessionUserGroup"].ToString() != "0")
{
Response.Redirect("Home.aspx");
}
else
{
if (!IsPostBack)
{
SqlConnection ProgramFilesCon = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ProgramFilesDB;Data Source=ACER-PC\\SQLEXPRESS");
SqlDataAdapter ProgramFilesAdapter = new SqlDataAdapter();
DataTable ProgramFilesTable = new DataTable();
ProgramFilesCon.Open();
SqlCommand PopulateCategoryRepeater = new SqlCommand("select * from Users", ProgramFilesCon);
ProgramFilesAdapter.SelectCommand = PopulateCategoryRepeater;
ProgramFilesAdapter.Fill(ProgramFilesTable);
ProgramFilesAdapter.Dispose();
PopulateCategoryRepeater.Dispose();
ProgramFilesCon.Close();
RepeaterUsers.DataSource = ProgramFilesTable;
RepeaterUsers.DataBind();
}
}
}
private void Carrega()
{
UsuarioController usuarioController = new UsuarioController();
DataSet dataSet = usuarioController.selectAll();
RepeaterUsers.DataSource = dataSet.Tables[0].DefaultView;
RepeaterUsers.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var context = new ApplicationDbContext();
try
{
var users = context.Users.ToList().OrderBy(x => x.FullName);
RepeaterUsers.DataSource = users;
RepeaterUsers.DataBind();
}
catch (Exception ex)
{
ErrorSuccessNotifier.AddErrorMessage(ex);
}
}
private void BindigRepeaterUsers()
{
/*string query = " select Product.productId, Product.productName,Product.price, Product.description,Product.quantity," +
* "Category.description from Product inner join Category on Category.categoryId = Product.categoryId " +
* "order by Product.productName";*/
List <User> users = new List <User>();
SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["OnShopCenterConnectionString"].ConnectionString);
SqlCommand mycommand = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
CommandText = "ListUserCustumer",
Connection = myConn
};
myConn.Open();
var reader = mycommand.ExecuteReader();
while (reader.Read())
{
users.Add(new User
{
UserId = reader.GetInt32(0),
FullName = reader.GetString(1),
TaxNumber = reader.GetString(2),
DateOfBirth = reader.GetDateTime(3).ToShortDateString(),
Email = reader.GetString(4),
IsActive = reader.GetBoolean(5),
RoleName = reader.GetString(6)
});
}
reader.Close();
myConn.Close();
RepeaterUsers.DataSource = users;
RepeaterUsers.DataBind();
}
