private void BindUserGrid()
{
MembershipUserCollection allUsers = Membership.GetAllUsers();
UserGrid.DataSource = allUsers;
UserGrid.DataBind();
}
protected void DeleteUser(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(UserNameText.Text))
{
Membership.DeleteUser(UserNameText.Text);
UserGrid.DataBind();
}
}
protected void SearchButton_Click(object sender, EventArgs e)
{
UserGrid.PageIndex = 0;
UserGrid.DataBind();
// DISPLAY THE RESET BUTTON
ResetSearchButton.Visible = true;
}
private void SortGridView(string sortExpression, string direction)
{
DataSet ds = objQMS.UserDetails();
DataView dv = new DataView(ds.Tables[0]);
dv.Sort = sortExpression + " " + direction;
this.UserGrid.DataSource = dv;
UserGrid.DataBind();
}
private void FinishLoaded()
{
RightManagerViewModel userManagerViewModel = this.DataContext as RightManagerViewModel;
foreach (CollectionViewGroup group in userManagerViewModel.UserDataView.Groups)
{
UserGrid.CollapseRowGroup(group, true);
}
}
/// <summary>
/// Handles the Click event of the btnGetUsers control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing
/// the event data.</param>
protected void OnGetUsersButtonClick(object sender, EventArgs e)
{
ConfigureUserForOAuth();
try {
// Get the UserService.
UserService userService = (UserService)user.GetService(DfpService.v201405.UserService);
// Create a Statement to get all users.
StatementBuilder statementBuilder = new StatementBuilder()
.OrderBy("id ASC")
.Limit(StatementBuilder.SUGGESTED_PAGE_LIMIT);
// Set default for page.
UserPage page = new UserPage();
DataTable dataTable = new DataTable();
dataTable.Columns.AddRange(new DataColumn[] {
new DataColumn("Serial No.", typeof(int)),
new DataColumn("User Id", typeof(long)),
new DataColumn("Email", typeof(string)),
new DataColumn("Role", typeof(string))
});
do
{
// Get users by Statement.
page = userService.getUsersByStatement(statementBuilder.ToStatement());
if (page.results != null && page.results.Length > 0)
{
int i = page.startIndex;
foreach (User usr in page.results)
{
DataRow dataRow = dataTable.NewRow();
dataRow.ItemArray = new object[] { i + 1, usr.id, usr.email, usr.roleName };
dataTable.Rows.Add(dataRow);
i++;
}
}
statementBuilder.IncreaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT);
} while (statementBuilder.GetOffset() < page.totalResultSetSize);
if (dataTable.Rows.Count > 0)
{
UserGrid.DataSource = dataTable;
UserGrid.DataBind();
}
else
{
Response.Write("No users were found.");
}
} catch (Exception ex) {
Response.Write(string.Format("Failed to get users. Exception says \"{0}\"",
ex.Message));
}
}
private void chkSelectAll_Click(object sender, RoutedEventArgs e)
{
if (chkSelectAll.IsChecked.Value == true)
{
UserGrid.SelectAll();
}
else
{
UserGrid.UnselectAll();
}
}
private void UserGrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (UserGrid.CurrentRowValue(UsersCols.AccessLevel) is int)
{
DisplayAccess(Convert.ToInt32(UserGrid.CurrentRowValue(UsersCols.AccessLevel)));
}
else
{
DisplayAccess(0);
}
SelectedRow = e.RowIndex;
}
protected void Page_Load(object sender, EventArgs e)
{
//SELECT user.BsnNumber,user.EmailAdress, user.FirstName,user.LastName from user where user.Confirmed=0
if (!IsPostBack)
{
Messager.Text = "";
Messager.Visible = false;
loggedinUser = Session["User"] as Entities.User;
if (loggedinUser != null)
{
try
{
UserGrid.DataSource = dBUserConnection.getPendingUsers(loggedinUser);
UserGrid.DataBind();
ListBoxUsers.DataSource = dBUserConnection.GetAllUsers(loggedinUser);
ListBoxUsers.DataTextField = "FirstName";
ListBoxUsers.DataValueField = "BsnNumber";
ListBoxUsers.DataBind();
DAL.DBRoleConnection dBRoleConnection = new DAL.DBRoleConnection();
ListBoxRoles.DataSource = dBRoleConnection.GetRoles();
ListBoxRoles.DataTextField = "Description";
ListBoxRoles.DataValueField = "RoleID";
ListBoxRoles.DataBind();
ListBoxUserTherapist.DataSource = ListBoxUsers.DataSource;
ListBoxUserTherapist.DataTextField = "FirstName";
ListBoxUserTherapist.DataValueField = "BsnNumber";
ListBoxUserTherapist.DataBind();
ListBoxTherapist.DataSource = dBUserConnection.GetAllUsersWithRole(loggedinUser);
ListBoxTherapist.DataTextField = "FirstName";
ListBoxTherapist.DataValueField = "ID";
ListBoxTherapist.DataBind();
ListboxFunctionRoles.DataSource = dBRoleConnection.GetRoles();
ListboxFunctionRoles.DataTextField = "Description";
ListboxFunctionRoles.DataValueField = "RoleID";
ListboxFunctionRoles.DataBind();
RoleGrid.DataSource = dBRoleConnection.GetRights();
RoleGrid.DataBind();
}
catch (Exception ex)
{
showMessage(ex.Message);
}
}
}
}
private void RefreshGrid()
{
var userId = Context.User.Identity.GetUserId();
var user = _userCache.Get(userId);
var users = _userDal.GetByCompany(user.CompanyId)
.Where(u => !u.Id.Equals(userId))
.ToSafeList();
UserGrid.DataSource = string.IsNullOrEmpty(SearchText.Text)
? users
: users.Where(d => d.UserName.ToLower().Contains(SearchText.Text.ToLower())).ToList();
UserGrid.DataBind();
}
private void GetUsers()
{
UsersOnlineLabel.Text = Membership.GetNumberOfUsersOnline().ToString();
UserGrid.DataSource = Membership.GetAllUsers(currentPage - 1, pageSize, out totalUsers);
totalPages = ((totalUsers - 1) / pageSize) + 1;
// Ensure that we do not navigate past the last page of users.
if (currentPage > totalPages)
{
currentPage = totalPages;
GetUsers();
return;
}
UserGrid.DataBind();
CurrentPageLabel.Text = currentPage.ToString();
TotalPagesLabel.Text = totalPages.ToString();
if (currentPage == totalPages)
{
NextButton.Visible = false;
}
else
{
NextButton.Visible = true;
}
if (currentPage == 1)
{
PreviousButton.Visible = false;
}
else
{
PreviousButton.Visible = true;
}
if (totalUsers <= 0)
{
NavigationPanel.Visible = false;
}
else
{
NavigationPanel.Visible = true;
}
}
protected void searchManagerB_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(managerT.Text))
{
M1.SetMessage = "Поле не должно быть пустым!";
MessageExtender.Show();
return;
}
if (managerT.Text.Length < 2)
{
M1.SetMessage = "Минимальная длина фамилии 3 символа!";
MessageExtender.Show();
return;
}
List <ADuser> usr = new ADconnector().GetUser(managerT.Text);
if (usr.Count > 0)
{
if (usr.Count == 1)
{
managerT.Text = usr[0].name;
subdivisionT.Text = usr[0].reply;
officeT.Text = usr[0].office;
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("ФИО");
dt.Columns.Add("Офис");
dt.Columns.Add("Подразделение");
foreach (ADuser one in usr)
{
dt.Rows.Add(one.name, one.office, one.reply);
}
dt.AcceptChanges();
UserGrid.DataSource = dt;
UserGrid.DataBind();
UserPanelExtender.Show();
}
}
else
{
subdivisionT.Text = "<Не найдено!>";
officeT.Text = "<Не найдено!>";
}
}
private void FetchUsers()
{
try
{
{
SqlCommand cmd = new SqlCommand("mts_User_Select", Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@role", SqlDbType.NVarChar).Value = int.Parse(Session["role"].ToString());
cmd.Parameters.Add("@fk_CompanyID", SqlDbType.NVarChar).Value = int.Parse(Session["fk_CompanyID"].ToString());
cmd.Parameters.Add("@fk_OrgID", SqlDbType.NVarChar).Value = int.Parse(Session["fk_OrgID"].ToString());
if (int.Parse(Session["role"].ToString()) == 50)
{
cmd.Parameters.Add("@userID", SqlDbType.NVarChar).Value = int.Parse(Session["userID"].ToString());
}
else
{
cmd.Parameters.Add("@userID", SqlDbType.NVarChar).Value = 0;
}
SqlDataAdapter dap = new SqlDataAdapter(cmd);
DataSet DS = new DataSet();
dap.Fill(DS);
if (DS != null)
{
if (DS.Tables[0].Rows.Count != 0)
{
UserGrid.Visible = true;
UserGrid.DataSource = DS;
UserGrid.DataBind();
}
else
{
UserGrid.Visible = false;
lblUserPermission.Text = "No Records Found..";
}
}
}
}
catch (Exception ex)
{
}
}
protected void AlphabetRepeater_ItemCommand(object source, System.Web.UI.WebControls.RepeaterCommandEventArgs e)
{
if ((e.CommandArgument.ToString().Length == 1))
{
SearchUserName.Text = (e.CommandArgument.ToString() + "*");
}
else
{
SearchUserName.Text = String.Empty;
}
// CLEAR OUT OTHER CRITERIA
SearchEmail.Text = string.Empty;
SearchFirstName.Text = string.Empty;
SearchLastName.Text = string.Empty;
SearchGroup.SelectedIndex = 0;
SearchCompany.Text = string.Empty;
SearchPhone.Text = string.Empty;
UserGrid.DataBind();
}
private void FillGrid()
{
var userManager = new UserManager(ctx);
var allUsers = userManager.GetUsers();
var farmManager = new FarmManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString);
var farms = farmManager.GetAllFarmsForDropDown();
foreach (var user in allUsers)
{
var farm = farms.FirstOrDefault(x => x.Cod == user.UserCod);
if (farm != null)
{
user.UserCod = farm.Cod + " - " + farm.Nume;
}
}
lcount.Text = allUsers.Count + " useri";
UserGrid.DataSource = allUsers;
UserGrid.DataBind();
}
public UserGrid SearchUserInfos(int pageSize, int pageIndex, System.Linq.Expressions.Expression <Func <tbl_User, bool> > WhereLambda)
{
var datagrid = new UserGrid();
var userlist = new List <tbl_User>();
var userset = DBContextFactory.CreateDB().Set <tbl_User>();
datagrid.total = userset.Where(WhereLambda).Count();
var users = userset.Where(WhereLambda).OrderBy(u => u.keyid).Skip(pageSize * (pageIndex - 1)).Select(u => new { u.keyid, u.C_Name, u.C_LoginName, u.C_PassWord, u.C_Enabled, u.C_Sex, u.C_CreatedDate, u.C_UpdatedDate }).Take(pageSize);
foreach (var u in users)
{
userlist.Add(new tbl_User()
{
keyid = u.keyid, C_CreatedDate = u.C_CreatedDate, C_Enabled = u.C_Enabled, C_LoginName = u.C_LoginName, C_Name = u.C_Name, C_PassWord = u.C_PassWord, C_Sex = u.C_Sex, C_UpdatedDate = u.C_UpdatedDate
});
}
datagrid.OriginRows = userlist;
return(datagrid);
}
private void cmdUpdate_Click(object sender, EventArgs e)
{
try
{
var blah = OtherFunctions.Message("Are you sure? Committed changes cannot be undone.", MessageBoxButtons.YesNo, MessageBoxIcon.Question, "Commit Changes", this);
if (blah == DialogResult.Yes)
{
UserGrid.EndEdit();
AddGuids();
DBFactory.GetDatabase().UpdateTable(Queries.SelectUsersTable, (DataTable)UserGrid.DataSource);
ListUsers();
SecurityTools.PopulateUserAccess();
}
else
{
}
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
}
protected void ManageUserSave(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser(UserGrid.SelectedRow.Cells[1].Text);
if (user != null)
{
user.Email = UserEmailTxt.Text;
user.IsApproved = ActiveBox.Checked;
Membership.UpdateUser(user);
foreach (Control control in roleDiv.Controls)
{
if (control is CheckBox)
{
CheckBox box = (CheckBox)control;
List <string> roleUsers = new List <string>(System.Web.Security.Roles.GetUsersInRole(box.ID));
if (box.Checked)
{
if (!roleUsers.Contains(user.UserName))
{
System.Web.Security.Roles.AddUserToRole(user.UserName, box.ID);
}
}
else
{
if (roleUsers.Contains(user.UserName))
{
System.Web.Security.Roles.RemoveUserFromRole(user.UserName, box.ID);
}
}
}
}
UserGrid.DataBind();
}
}
//New Role
private void simpleButton4_Click(object sender, EventArgs e)
{
groupControl2.Text = "Peran Baru :";
textEdit4.Text = string.Empty;
checkEdit4.Checked = true;
checkEdit5.Checked = false;
simpleButton3.Enabled = false;
foreach (UserSelection pu in ListUser)
{
pu.Select = false;
}
UserGrid.RefreshDataSource();
listBoxControl2.SelectedIndex = -1;
CurrentRole = string.Empty;
dateEdit3.DateTime = DateTime.Today;
dateEdit4.DateTime = DateTime.Today;
foreach (clsModule mdl in ListModule.Values)
{
mdl.Ma.Variables.Clear();
mdl.Node.SetValue(treeListColumn2, string.Empty);
}
textEdit4.Focus();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "FindAD")
{
int rowInd = Convert.ToInt32(e.CommandArgument);
Session["_editRowIndex"] = rowInd;
TextBox t = GridView1.Rows[rowInd].FindControl("managerTb") as TextBox;
Label sd = GridView1.Rows[rowInd].FindControl("divisionFactL") as Label;
if (string.IsNullOrEmpty(t.Text))
{
M1.SetMessage = "Поле не должно быть пустым!";
MessageExtender.Show();
return;
}
if (t.Text.Length < 2)
{
M1.SetMessage = "Минимальная длина фамилии 3 символа!";
MessageExtender.Show();
return;
}
List <ADuser> usr = new ADconnector().GetUser(t.Text);
if (usr.Count > 0)
{
if (usr.Count == 1)
{
t.Text = usr[0].name;
sd.Text = usr[0].office + "<br/>" + usr[0].reply;
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("ФИО");
dt.Columns.Add("Офис");
dt.Columns.Add("Подразделение");
foreach (ADuser one in usr)
{
dt.Rows.Add(one.name, one.office, one.reply);
}
dt.AcceptChanges();
UserGrid.DataSource = dt;
UserGrid.DataBind();
UserPanelExtender.Show();
}
}
else
{
sd.Text = "<Не найдено!>";
}
}
else if (e.CommandName == "DuplicateUE")
{
int rowInd = Convert.ToInt32(e.CommandArgument);
string mySQLid = GridView1.DataKeys[rowInd].Value.ToString();
comm = new MySqlCommand("SELECT type_id,model_id,status_id,subdivision_id,ue_price FROM ue WHERE id=@id", conn);
comm.Parameters.AddWithValue("@id", mySQLid);
newUEDiv.Visible = true;
conn.Open();
reader = comm.ExecuteReader();
string modelID = null;
while (reader.Read())
{
typeDdl.SelectedValue = reader.GetString(0);
modelID = reader.GetString(1);
statusDdl.SelectedValue = reader.GetString(2);
subdivisionDdl.SelectedValue = reader.GetString(3);
priceT.Text = reader.GetString(4);
}
reader.Close();
// тут изврат, строим таблицу моделей исходя из типа и выбираем его
comm = new MySqlCommand("SELECT name,id FROM models WHERE type_id=@id", conn);
comm.Parameters.AddWithValue("@id", typeDdl.SelectedValue);
reader = comm.ExecuteReader();
while (reader.Read())
{
modelsDdl.Items.Add(new ListItem(reader.GetString(0), reader.GetString(1)));
}
reader.Close();
modelsDdl.SelectedValue = modelID;
conn.Close();
}
}
private void BindData()
{
//Bind the grid view
UserGrid.DataSource = RetrieveData();
UserGrid.DataBind();
}
protected void SaveButton_Click(object sender, EventArgs e)
{
// CHECK IF PAGE IS VALID
if (Page.IsValid)
{
// MAKE SURE PASSWORD VALIDATES AGAINST POLICY
if (ValidatePassword())
{
// ATTEMPT TO CREATE THE USER
MembershipCreateStatus status;
User newUser = UserDataSource.CreateUser(AddEmail.Text, AddEmail.Text, AddPassword.Text, string.Empty, string.Empty, true, 0, out status);
if (status == MembershipCreateStatus.Success)
{
// FORCE PASSWORD EXPIRATION
newUser.Passwords[0].ForceExpiration = ForceExpiration.Checked;
newUser.Passwords[0].Save();
// ASSIGN GROUPS TO NEW USER
IList <Group> availableGroups = SecurityUtility.GetManagableGroups();
int groupId = AlwaysConvert.ToInt(AddGroup.SelectedValue);
if (groupId > 0)
{
int index = availableGroups.IndexOf(groupId);
if (groupId > -1)
{
// ADD THE GROUP ASSOCIATION FOR THE NEW USER
newUser.UserGroups.Add(new UserGroup(newUser, availableGroups[index]));
newUser.Save();
}
}
// REDIRECT TO EDIT FORM IF INDICATED
if (((Button)sender).ID == "AddEditButton")
{
Response.Redirect("EditUser.aspx?UserId=" + newUser.Id.ToString());
}
// NO REDIRECT, DISPLAY A CONFIRMATION FOR CREATED USER
UserAddedMessage.Text = string.Format(UserAddedMessage.Text, newUser.UserName);
UserAddedMessage.Visible = true;
// RESET THE ADD FORM FIELDS
AddEmail.Text = String.Empty;
AddPassword.Text = String.Empty;
AddConfirmPassword.Text = String.Empty;
AddGroup.SelectedIndex = -1;
//REBIND THE SEARCH
UserGrid.DataBind();
}
else
{
// CREATE USER FAILED WITHIN THE API
switch (status)
{
case MembershipCreateStatus.DuplicateEmail:
case MembershipCreateStatus.DuplicateUserName:
AddCustomValidationError(phEmailValidation, AddEmail, "The email address is already registered.");
break;
case MembershipCreateStatus.InvalidEmail:
case MembershipCreateStatus.InvalidUserName:
AddCustomValidationError(phEmailValidation, AddEmail, "The email address is invalid.");
break;
case MembershipCreateStatus.InvalidPassword:
AddCustomValidationError(phPasswordValidation, AddPassword, "The password is invalid.");
break;
default:
AddCustomValidationError(phEmailValidation, AddEmail, "Unexpected error: " + status.ToString());
break;
}
AddPopup.Show();
}
}
else
{
AddPopup.Show();
}
}
else
{
AddPopup.Show();
}
}
// Load Peran
private void listBoxControl2_SelectedIndexChanged(object sender, EventArgs e)
{
if (OnAddRole)
{
return;
}
if (listBoxControl2.SelectedIndex == 0)
{
groupControl2.Text = "Peran Baru :";
textEdit4.Text = string.Empty;
checkEdit4.Checked = true;
checkEdit5.Checked = false;
simpleButton3.Enabled = false;
foreach (UserSelection pu in ListUser)
{
pu.Select = false;
}
UserGrid.RefreshDataSource();
CurrentRole = string.Empty;
dateEdit3.DateTime = DateTime.Today;
dateEdit4.DateTime = DateTime.Today;
//if (sender == null || XtraMessageBox.Show(
// "Masukkan Data Hak Akses Peran Lama ke Peran Baru ?",
// "Konfirmasi Penyalinan Data Hak Akses ke Peran Baru",
// MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
foreach (clsModule mdl in ListModule.Values)
{
mdl.Ma.Variables.Clear();
mdl.Node.SetValue(treeListColumn2, string.Empty);
foreach (List <string> ListStr in mdl.ListKey.Values)
{
ListStr.Clear();
}
}
textEdit4.Focus();
}
else
{
simpleButton3.Enabled = true;
groupControl2.Text = "Edit Peran";
Role Role = BaseSecurity.CurrentLogin.Admin.Role
.QueryRole(listBoxControl2.Text);
if (Role == null)
{
XtraMessageBox.Show(string.Concat("Peran ", listBoxControl2.Text,
" sudah dihapus dari database !"), "Error Baca Peran",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
RemoveSelectedRole();
}
else
{
textEdit4.Text = Role.RoleName;
checkEdit4.Checked = Role.IsActive;
checkEdit5.Checked = Role.UseDateLimit;
dateEdit4.DateTime = Role.StartDate;
dateEdit3.DateTime = Role.EndDate;
foreach (UserSelection s in ListUser)
{
s.Select = Role.ListUser.IndexOf(s.UserName) >= 0;
}
UserGrid.RefreshDataSource();
CurrentRole = Role.RoleName;
treeList1.BeginUpdate();
foreach (clsModule mdl in ListModule.Values)
{
mdl.Ma.Variables.Clear();
mdl.Node.SetValue(treeListColumn2, string.Empty);
}
// Isi Variabel...
IDataReader Rdr = BaseSecurity.CurrentLogin.Admin
.RoleModule.OpenDataReader(Role.RoleName);
try
{
clsModule mdl;
while (Rdr.Read())
{
if (ListModule.TryGetValue(Rdr.GetString(0), out mdl))
{
BaseUtility.String2Dictionary(Rdr.GetString(1),
mdl.Ma.Variables);
mdl.Node.SetValue(treeListColumn2, mdl.Ma.ToString());
mdl.AllDocumentData = Rdr.GetBoolean(2);
}
}
}
finally
{
Rdr.Close();
treeList1.EndUpdate();
}
foreach (clsModule mdl in ListModule.Values)
{
foreach (List <string> ListStr in mdl.ListKey.Values)
{
ListStr.Clear();
}
foreach (ModuleDataField mdf in mdl.Ma.ListDataField)
{
Rdr = BaseSecurity.CurrentLogin.Admin.RoleModule.GetListDocumentVariable(
Role.RoleName, mdl.Ma.ModuleName,
mdf.DataFieldName);
try
{
List <string> ListKey = mdl.ListKey[mdf.DataFieldName];
ListKey.Clear();
while (Rdr.Read())
{
ListKey.Add((string)Rdr[0]);
}
}
finally
{
Rdr.Close();
}
}
}
}
}
}
protected void SearchButton_Click(object sender, EventArgs e)
{
UserGrid.Visible = true;
UserGrid.DataBind();
}
public static void Execute (Atom parent){
Task v= new Task( ()=> Firebug.Console.Log("hello"));
v.Start ();
var store = new UserStore ();
var grid = new UserGrid (parent, store);
store.Read ();
var form = new UserForm (parent);
form.ButtonCreate.Disabled = false;
form.ButtonCreate.Clicked+= (e) => {
grid.ClearSelection();
form.Clear();
};
form.ButtonDestroy.Clicked+= (e) => {
form.Clear();
var u = store.First(r=>r.Id== int.Parse( grid.SelectedRow.RecordId ));
store.Remove(u);
};
form.Changed+= (e) => {
form.ButtonSave.Disabled= !form.HasChanges();
};
form.Updated += (fr, ac) => {
form.ButtonDestroy.Disabled= ac == FormUpdatedAction.Clear;
form.ButtonSave.Disabled=true;
};
form.SubmitHandler = fr => SubmitHandler (grid, form, store);
grid.RowSelected += (g, row) => {
var u = store.First(r=>r.Id== int.Parse( row.RecordId));
form.PopulateFrom(u);
};
parent.Append("Paged Tables".Header (3));
var cu = new CustomerStore ();
new CustomerGrid(parent, cu);
parent.Append (new StorePager<Customer>(cu));
cu.Read ();
parent.Append ("Filters".Header (3));
var cu2 = new CustomerStore ();
new TextInput (parent, i=> {
i.Placeholder="Country";
i.On("keyup", evt=>{
var st = i.Value.ToUpper();
cu2.Filter( f=>f.Country.ToUpper().StartsWith(st));
});
});
new CustomerGrid (parent, cu2);
parent.Append (new StorePager<Customer>(cu2));
cu2.Read ();
parent.Append ("C# code".Header(3));
var rq =jQuery.GetData<string> ("code/demotables.html");
rq.Done (s=> {
var code=new Div();
code.InnerHTML= s;
parent.Append(code);
});
}
protected void UserDetails_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
UserGrid.DataBind();
UserGrid.SelectRow(-1);
}
private void UserGrid_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
UserGrid.BeginEdit(false);
}
private void simpleButton5_Click(object sender, EventArgs e)
{
textEdit1.Focus();
try
{
using (EntityTransaction tr =
new EntityTransaction(BaseWinSecurity.DataPersistance))
{
if (simpleButton2.Enabled == false) // User Baru
{
string UserName = textEdit1.Text;
BaseSecurity.CurrentLogin.Admin.User.Add(UserName,
buttonEdit1.Text, checkEdit1.Checked, checkEdit2.Checked,
checkEdit3.Checked, dateEdit1.DateTime, dateEdit2.DateTime);
string SelRole = listBoxControl2.Text;
bool AddSelRole = false;
BaseSecurity.CurrentLogin.Admin.RoleUser.DeleteUser(UserName);
foreach (RoleSelection r in ListRole)
{
if (r.Select)
{
if (r.RoleName == SelRole)
{
AddSelRole = true;
}
BaseSecurity.CurrentLogin.Admin.RoleUser.Add(
r.RoleName, UserName);
}
}
UserSelection s = new UserSelection(UserName);
if (AddSelRole)
{
s.Select = true;
}
ListUser.Add(s);
UserGrid.RefreshDataSource();
OnAddUser = true;
listBoxControl1.Items.Add(UserName);
OnAddUser = false;
simpleButton1_Click(null, null);
}
else // User Lama
{
string UserName = textEdit1.Text;
BaseSecurity.CurrentLogin.Admin.RoleUser.DeleteUser(CurrentUser);
BaseSecurity.CurrentLogin.Admin.User.Update(CurrentUser,
UserName, checkEdit1.Checked, checkEdit2.Checked,
checkEdit3.Checked, dateEdit1.DateTime, dateEdit2.DateTime);
string SelRole = listBoxControl2.Text;
bool UpdateSelRole = false;
foreach (RoleSelection r in ListRole)
{
if (r.Select)
{
if (r.RoleName == SelRole)
{
UpdateSelRole = true;
}
BaseSecurity.CurrentLogin.Admin.RoleUser.Add(
r.RoleName, UserName);
}
}
foreach (UserSelection s in ListUser)
{
if (s.UserName == CurrentUser)
{
s.Select = UpdateSelRole;
s.UserName = UserName;
break;
}
}
UserGrid.RefreshDataSource();
if (CurrentUser != UserName)
{
listBoxControl1.Items[listBoxControl1.SelectedIndex] = UserName;
}
CurrentUser = UserName;
textEdit1.Focus();
}
tr.CommitTransaction();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Error Simpan User",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Load Peran
private void listBoxControl2_SelectedIndexChanged(object sender, EventArgs e)
{
if (OnAddRole || listBoxControl2.SelectedIndex == -1)
{
return;
}
simpleButton3.Enabled = true;
groupControl2.Text = "Edit Peran";
Role Role = BaseSecurity.CurrentLogin.Admin.Role
.QueryRole(listBoxControl2.Text);
if (Role == null)
{
XtraMessageBox.Show(string.Concat("Peran ", listBoxControl2.Text,
" sudah dihapus dari database !"), "Error Baca Peran",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
RemoveSelectedRole();
}
else
{
textEdit4.Text = Role.RoleName;
checkEdit4.Checked = Role.IsActive;
checkEdit5.Checked = Role.UseDateLimit;
dateEdit4.DateTime = Role.StartDate;
dateEdit3.DateTime = Role.EndDate;
foreach (UserSelection s in ListUser)
{
s.Select = Role.ListUser.IndexOf(s.UserName) >= 0;
}
UserGrid.RefreshDataSource();
CurrentRole = Role.RoleName;
// Isi Variabel...
IDataReader Rdr = BaseSecurity.CurrentLogin.Admin
.RoleModule.OpenDataReader(Role.RoleName);
foreach (clsModule mdl in ListModule.Values)
{
mdl.Ma.Variables.Clear();
}
try
{
treeList1.BeginUpdate();
while (Rdr.Read())
{
string ModuleName = Rdr.GetString(0);
foreach (clsModule mdl in ListModule.Values)
{
if (mdl.Ma.ModuleName == ModuleName)
{
mdl.Ma.Variables = BaseUtility
.String2Dictionary(Rdr.GetString(1));
mdl.Node.SetValue(treeListColumn2, mdl.Ma.ToString());
mdl.AllDocumentData = Rdr.GetBoolean(2);
break;
}
}
}
}
finally
{
Rdr.Close();
treeList1.EndUpdate();
}
foreach (clsModule mdl in ListModule.Values)
{
mdl.ListKey.Clear();
foreach (ModuleDataField mdf in mdl.Ma.ListDataField)
{
Rdr = BaseSecurity.CurrentLogin.Admin.RoleModule.GetListDocumentVariable(
Role.RoleName, mdl.Ma.ModuleName,
mdf.DataFieldName);
try
{
List <string> ListKey = new List <string>();
while (Rdr.Read())
{
ListKey.Add((string)Rdr[0]);
}
mdl.ListKey.Add(mdf.DataFieldName, ListKey);
}
finally
{
Rdr.Close();
}
}
}
}
}
protected void UserDetails_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
{
UserGrid.DataBind();
UserGrid.SelectRow(UserGrid.SelectedRow.RowIndex);
}
protected void Setup_Tabs()
{
//OK, HOW THIS WORKS.
//We loop trough all roles. per function of the system the user has access to we add a number that is a bitwise new number ( 0,1,2,4,8,16,32,64,128,...)
//after we've looped trough the roles, we do a bitwise or so we can easily tell if the user has access to a part of the system
User user = null;
if (LoggedInUser.IsUserLoggedIn)
{
user = LoggedInUser.GetUser();
}
var roles = RoleManager.GetUserPermissions(user);
//handle the tasks tab
if (!roles.Any(x => x == RolesPermissions.Tasks))
{
TasksTab.Visible = false;
Tasks.Visible = false;
}
else
{
//link the departments drop down
var list = SystemLists.General.Departments;
var DepartmentsList = new ObservableCollection <Department>();
DepartmentsList.Add(new Department(0)
{
Description = LanguageFiles.GetLocalTranslation("AllDepartments", "All")
});
foreach (var item in SystemLists.General.Departments)
{
DepartmentsList.Add(item);
}
DropDownSorting.DataSource = DepartmentsList;
DropDownSorting.DataBind();
if (LoggedInUser.IsUserLoggedIn && (!roles.Any(x => x == RolesPermissions.Technician)))
{
DropDownSorting.SelectedIndex =
DepartmentsList.ToList().FindIndex(x => x.ID == LoggedInUser.GetUser().Department.ID);
}
else
{
DropDownSorting.SelectedIndex = 0;
}
//set the parameters for the datasource
string departmentID = Request.QueryString["depID"];
var searchText = Request.QueryString["Search"];
var departmentField = TaskSource.SelectParameters["DepartmentID"];
var searchField = TaskSource.SelectParameters["SearchText"];
if (LoggedInUser.IsUserLoggedIn)
{
if (
!RoleManager.UserHasPermission(LoggedInUser.GetUser(), RolesPermissions.ManageTasks) &&
(
(String.IsNullOrWhiteSpace(departmentID) && String.IsNullOrWhiteSpace(searchText)) ||
(LoggedInUser.GetUser().Department.ID.ToString() == departmentID)
))
{
// logged in + either nothing was given or the user's department was chosen -> show department + user's tasks
departmentField.DefaultValue = LoggedInUser.GetUser().Department.ID.ToString();
searchText = LoggedInUser.GetUser().UserName;
}
else if (!String.IsNullOrWhiteSpace(departmentID))
{
//department was set.
departmentField.DefaultValue = departmentID;
}
if (!String.IsNullOrWhiteSpace(searchText))
{
//search text was given.
searchField.DefaultValue = searchText;
}
}
else
{
if (!String.IsNullOrWhiteSpace(departmentID))
{
departmentField.DefaultValue = departmentID;
}
if (!String.IsNullOrWhiteSpace(searchText))
{
searchField.DefaultValue = searchText;
}
}
//set the department parameter
TaskSource.SelectParameters["DepartmentID"] = departmentField;
TaskSource.SelectParameters["SearchText"] = searchField;
//set datasource and bind/retrieve data (databind also executes all inline code to bind to them)
TaskSource.DataBind();
TaskGrid.DataSourceID = nameof(TaskSource);
TaskGrid.DataBind();
}
//handle machines tab
//if (!roles.Any(x => x == RolesPermissions.ManageMachines))
{
//no permissions!
MachinesTab.Visible = false;
//Machines.Visible = false;
}
/*else
* {
* MachinesTab.Visible = true;
* //Machines.Visible = true;
* }*/
//permissions to the Suppliers tab!
/*if (!roles.Any(x => x == RolesPermissions.ManageSuppliers) &&
* !roles.Any(x => x == RolesPermissions.ViewSuppliers))*/
{
SuppliersTab.Visible = false;
//Suppliers.Visible = false;
}
/*else
* {
* SuppliersTab.Visible = true;
* Suppliers.Visible = true;
* }*/
//permissions for the Users tab!
if (!roles.Any(x => x == RolesPermissions.ManageUsers))
{
UsersTab.Visible = false;
Users.Visible = false;
}
else
{
UsersTab.Visible = true;
Users.Visible = true;
var RolesList = new ObservableCollection <RoleModel>();
var roleList = LanguageFiles.LoadLanguageFile("Roles");
for (int i = 0; i < roleList.Length; i++)
{
RolesList.Add(RoleModel.CreateModel((Role)i, roleList[i]));
}
//bind User dropdown of roles
selectUserType.DataSource = RolesList;
selectUserType.DataBind();
//set the parameters for the datasource
string role = Request.QueryString["UserRole"];
var searchText = Request.QueryString["SearchUser"];
if (!String.IsNullOrWhiteSpace(role) && role != nameof(Role.AllRoles))
{
var RoleField = UserSource.SelectParameters["role"];
RoleField.DefaultValue = role;
UserSource.SelectParameters["role"] = RoleField;
}
if (!String.IsNullOrWhiteSpace(searchText))
{
var searchField = UserSource.SelectParameters["contains"];
searchField.DefaultValue = searchText;
UserSource.SelectParameters["contains"] = searchField;
}
UserSource.DataBind();
UserGrid.DataSourceID = nameof(UserSource);
UserGrid.DataBind();
}
//set the last known open tab
if (!String.IsNullOrWhiteSpace(ActiveTab))
{
hidTABControl.Value = ActiveTab;
}
}
