private void RoleForm_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter && GridViewRole.IsFilterRow(GridViewRole.FocusedRowHandle))
{
executeQuery();
}
}
protected void ToggleInRole_Click(object sender, EventArgs e)
{
// Grab text from button and parse, not so elegant, but gets the job done
Button bt = (Button)sender;
string buttonText = bt.Text;
char[] seps = new char[1];
seps[0] = ' ';
string[] buttonTextArray = buttonText.Split(seps);
string roleName = buttonTextArray[5];
string userName = buttonTextArray[2];
string whatToDo = buttonTextArray[0];
string[] userNameArray = new string[1];
userNameArray[0] = userName; // Need to do this because RemoveUserFromRole requires string array.
if (whatToDo.StartsWith("Qu"))
{
// need to remove assignment of this role to this user
Roles.RemoveUsersFromRole(userNameArray, roleName);
}
else
{
Roles.AddUserToRole(userName, roleName);
}
GridViewRole.DataBind();
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (!GridViewRole.IsFilterRow(e.RowHandle))
{
modified = true;
}
}
private void BindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
if (RoleBindingSource.Current == null)
{
return;
}
GridViewRole.CloseEditor();
tYPEComboBoxEdit.Focus();
// bindingNavigatorPositionItem.Focus();//trigger field leave eventoo
bool temp = newRec;
if (checkForms())
{
tYPEComboBoxEdit.Focus();
setReadOnly(true);
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Saved";
rowStatusSave = new Timer();
rowStatusSave.Interval = 3000;
rowStatusSave.Start();
rowStatusSave.Tick += TimedEventSave;
}
if (!temp && !modified)
{
context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, (ROLE)RoleBindingSource.Current);
}
}
protected void ButtonCreateNewRole_Click(object sender, EventArgs e)
{
if (TextBoxCreateNewRole.Text.Length > 0)
{
ObjectDataSourceRoleObject.InsertParameters["RoleName"].DefaultValue = TextBoxCreateNewRole.Text;;
ObjectDataSourceRoleObject.Insert();
GridViewRole.DataBind();
TextBoxCreateNewRole.Text = "";
}
}
protected void GridViewMembershipUser_SelectedIndexChanged(object sender, EventArgs e)
{
GridView gv = (GridView)sender;
// cover case where there is no current user
if (Membership.GetUser() != null)
{
ObjectDataSourceRoleObject.SelectParameters["UserName"].DefaultValue = Membership.GetUser().UserName;
ObjectDataSourceRoleObject.SelectParameters["ShowOnlyAssignedRolls"].DefaultValue = "true";
}
GridViewRole.DataBind();
}
public void ButtonAddRole_Click(object sender, EventArgs e)
{
String roleId = LabelRoleId.Text;
String peopleName = DPLPeople.SelectedValue;
String peopleid = People.getByName(peopleName).id;
String roleName = DPLRole.SelectedValue;
String sqlstr = String.Format("INSERT INTO role(id, movie_id, people_id, role) VALUES ('{0:s}', '{1:s}', '{2:s}', '{3:s}')",
roleId, getMovieId(), peopleid, roleName);
SqlData.getInstance().ExecuteSQL(sqlstr);
int id = SqlData.getInstance().getMaxId("role") + 1;
LabelRoleId.Text = id.ToString();
GridViewRole.DataBind();
}
private void SearchSubmit()
{
try
{
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
List <dbo_RoleClass> item = new List <dbo_RoleClass>();
if (user_class.User_Group_ID == "Agent")
{
item = dbo_RoleDataClass.Search(string.Empty, string.Empty, "Agent");
}
else
{
item = dbo_RoleDataClass.Search(string.Empty, string.Empty, string.Empty);
}
//List<dbo_RoleClass> item = new List<dbo_RoleClass>();
//if (ddlRoleType.SelectedIndex == 0)
//{
// item = dbo_RoleDataClass.Search(string.Empty, string.Empty, string.Empty);
//}
//else
//{
// item = dbo_RoleDataClass.Search(string.Empty, string.Empty, ddlRoleType.Text);
//}
//GridViewRole.ShowFooter = false;
if (item.Count == 0)
{
item.Add(new dbo_RoleClass());
GridViewRole.DataSource = item;
GridViewRole.DataBind();
GridViewRole.Rows[0].Visible = false;
}
else
{
GridViewRole.DataSource = item;
GridViewRole.DataBind();
}
}
catch (Exception)
{
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
// 33 9 : สิทธิ์ใช้งานหน้าตั้งค่าสิทธิ์การใช้งาน บันทึกข้อมูลสิทธิ์การใช้งาน
int AuthorizeId = 33;
if (SQLAuthorized.CheckAuthorized(ClassProperty.permisRoleId, AuthorizeId) == false)
{
SQLAuthorized.AlertAuthorized("สิทธิ์ใช้งานหน้าตั้งค่าสิทธิ์การใช้งาน", "ไม่มีสิทธิ์บันทึกข้อมูลสิทธิ์การใช้งาน");
return;
}
if (SaveData() == true)
{
GetRoles();
GridViewRole.FocusedRowHandle = GridViewRole.LocateByValue("RoleName", TxtRoleName.Text);
RoleId = Convert.ToInt32(GridViewRole.GetFocusedRowCellValue("RoleId"));
GetData(RoleId);
}
}
private bool move()
{
GridViewRole.CloseEditor();
tYPEComboBoxEdit.Focus();
// bindingNavigatorPositionItem.Focus();//trigger field leave event
temp = newRec;
if (checkForms())
{
if (!temp)
{
context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( ROLE)RoleBindingSource.Current);
}
setReadOnly(true);
newRec = false;
modified = false;
return(true);
}
return(false);
}
private void executeQuery()
{
this.Cursor = Cursors.WaitCursor;
string colName = GridViewRole.FocusedColumn.FieldName;
string value = String.Empty;
if (!string.IsNullOrWhiteSpace(GridViewRole.GetFocusedDisplayText()))
{
value = GridViewRole.GetFocusedDisplayText();
}
if (!string.IsNullOrWhiteSpace(value))
{
string query = String.Format("it.CODE like '{0}%'", GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE"));
var special = context.ROLE.Where(query);
if (!string.IsNullOrWhiteSpace(GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "DESC")))
{
query = String.Format("it.{0} like '{1}%'", "[DESC]", GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "DESC"));
special = special.Where(query);
}
if (!string.IsNullOrWhiteSpace(GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "TYPE")))
{
query = String.Format("it.{0} like '{1}%'", "[TYPE]", GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "TYPE"));
special = special.Where(query);
}
int count = special.Count();
if (count > 0)
{
RoleBindingSource.DataSource = special;
GridViewRole.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value);
GridViewRole.FocusedRowHandle = 0;
GridViewRole.FocusedColumn.FieldName = colName;
}
else
{
MessageBox.Show("No records in database.");
GridViewRole.ClearColumnsFilter();
}
}
this.Cursor = Cursors.Default;
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
GridViewRole.ClearColumnsFilter();
if (RoleBindingSource.Current == null)
{
//fake query in order to create a link between the database table and the binding source
RoleBindingSource.DataSource = from opt in context.ROLE where opt.CODE == "KJM9" select opt;
RoleBindingSource.AddNew();
if (GridViewRole.FocusedRowHandle == GridControl.AutoFilterRowHandle)
{
GridViewRole.FocusedRowHandle = GridViewRole.RowCount - 1;
}
tYPEComboBoxEdit.Focus();
setReadOnly(false);
newRec = true;
return;
}
tYPEComboBoxEdit.Focus();
//bindingNavigatorPositionItem.Focus(); //trigger field leave event
GridViewRole.CloseEditor();
temp = newRec;
if (checkForms())
{
if (!temp)
{
context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( ROLE)RoleBindingSource.Current);
}
RoleBindingSource.AddNew();
if (GridViewRole.FocusedRowHandle == GridControl.AutoFilterRowHandle)
{
GridViewRole.FocusedRowHandle = GridViewRole.RowCount - 1;
}
tYPEComboBoxEdit.Focus();
setReadOnly(false);
newRec = true;
}
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (RoleBindingSource.Current == null)
{
return;
}
GridViewRole.CloseEditor();
if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
modified = false;
newRec = false;
RoleBindingSource.RemoveCurrent();
errorProvider1.Clear();
context.SaveChanges();
setReadOnly(true);
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Deleted";
rowStatusDelete = new Timer();
rowStatusDelete.Interval = 3000;
rowStatusDelete.Start();
rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
}
currentVal = tYPEComboBoxEdit.Text;
}
protected void GridViewMembership_RowDeleted(object sender, GridViewDeletedEventArgs e)
{
FindFirstUserName(); // Current user is deleted so need to select a new user as current
GridViewRole.DataBind(); // update roll lists to reflect new counts
}