protected void usersControl_OnEdit(object sender, GenericEventArgs <Guid> e)
{
var user = HbSession.Query <UM_User>().FirstOrDefault(n => n.ID == e.Value);
if (user == null)
{
return;
}
var converter = new UserEntityModelConverter(HbSession);
var userModel = converter.Convert(user);
userModel.Password = String.Empty;
var createUserModel = new CreateUserModel
{
User = userModel
};
btUserOK.Visible = true;
pnlCreateUser.Enabled = true;
createUserControl.Model = createUserModel;
mpeUserForm.Show();
}
protected void FillUserGrid()
{
var filterModel = usersFilterControl.Model;
var keyword = filterModel.Keyword;
var query = from n in HbSession.Query <UM_User>()
where n.DateDeleted == null
select n;
if (filterModel.LoginName.GetValueOrDefault() && !String.IsNullOrWhiteSpace(keyword))
{
query = from n in query
where n.LoginName.Contains(keyword) || n.Email.Contains(keyword)
select n;
}
if (filterModel.FirstName.GetValueOrDefault() && !String.IsNullOrWhiteSpace(keyword))
{
query = from n in query
where n.FirstName.Contains(keyword)
select n;
}
if (filterModel.LastName.GetValueOrDefault() && !String.IsNullOrWhiteSpace(keyword))
{
query = from n in query
where n.LastName.Contains(keyword)
select n;
}
if (filterModel.Address.GetValueOrDefault() && !String.IsNullOrWhiteSpace(keyword))
{
query = from n in query
where n.Address.Contains(keyword)
select n;
}
if (filterModel.Password.GetValueOrDefault() && !String.IsNullOrWhiteSpace(keyword))
{
query = from n in query
where n.Password.Contains(keyword)
select n;
}
if (filterModel.Status != null)
{
query = from n in query
where n.IsActive == filterModel.Status
select n;
}
if (filterModel.CategoryID != null)
{
query = from n in query
where n.UserCategoryID == filterModel.CategoryID
select n;
}
query = from n in query
orderby n.DateCreated descending
select n;
var entities = query.OrderBy(n => n.LoginName).ToList();
var converter = new UserEntityModelConverter(HbSession);
var model = new UsersModel
{
List = entities.Select(n => converter.Convert(n)).ToList()
};
usersControl.Model = model;
usersControl.DataBind();
}
