protected void UsersDataGrid_RadioButton_Checked(object sender, EventArgs e) { try { /* foreach (DataGridItem oldrow in UsersDataGrid.Items) * { * ((RadioButton)oldrow.FindControl("UsersDataGrid_RadioButton")).Checked = false; * }*/ //Set the new selected row RadioButton rb = (RadioButton)sender; DataGridItem row = (DataGridItem)rb.NamingContainer; ((RadioButton)row.FindControl("UsersDataGrid_RadioButton")).Checked = true; int userId = ((List <int>)Session["UsersTab_UserControl_UsersIds"])[row.DataSetIndex]; Selected_UsersDataGrid_Index.Value = userId.ToString(); LoadUserAdditionalInfo(userId); UsersDataGridUpdatePanel.Update(); DetailedInformationUpdatePanel.Update(); } catch (Exception ex) { RaiseException(ex); } }
protected void ApplyUsersFilter_Click(object sender, EventArgs e) { try { int userTypeId = Convert.ToInt32(UsersFilterTable_TypeDropDownList.SelectedValue); int userRoleId = Convert.ToInt32(UsersFilterTable_RoleDropDownList.SelectedValue); int selectedDealerId = Convert.ToInt32(UsersFilterTable_DealerDropDownList.SelectedValue); string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); int orgId = Convert.ToInt32(Session["CURRENT_ORG_ID"]); List <int> usersIds = new List <int>(); dataBlock.OpenConnection(); if (userTypeId != -1) { usersIds.AddRange(dataBlock.usersTable.Get_AllUsersId(orgId, userTypeId)); } else { usersIds.AddRange(dataBlock.usersTable.Get_AllUsersId(orgId, dataBlock.usersTable.DriverUserTypeId)); usersIds.AddRange(dataBlock.usersTable.Get_AllUsersId(orgId, dataBlock.usersTable.AdministratorUserTypeId)); usersIds.AddRange(dataBlock.usersTable.Get_AllUsersId(orgId, dataBlock.usersTable.ManagerUserTypeId)); } Session["UsersTab_UserControl_UsersIds"] = usersIds; DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add(new DataColumn("DEALER", typeof(string))); dt.Columns.Add(new DataColumn("SURNAME", typeof(string))); dt.Columns.Add(new DataColumn("NAME", typeof(string))); dt.Columns.Add(new DataColumn("PAtronimic", typeof(string))); dt.Columns.Add(new DataColumn("LOGIN", typeof(string))); dt.Columns.Add(new DataColumn("REG_DATE", typeof(string))); dt.Columns.Add(new DataColumn("ROLE", typeof(string))); dt.Columns.Add(new DataColumn("USER_TYPE", typeof(string))); dt.Columns.Add(new DataColumn("STATE", typeof(string))); int userInfoId = 0; //int dealerId; string dealerName = ""; DateTime date = new DateTime(); int dealerId; foreach (int userId in usersIds) { if (userRoleId != -1) { if (dataBlock.usersTable.GetUserRoleId(userId) != userRoleId) { continue; } } /*if (userTypeId != -1) * if (dataBlock.usersTable.Get_UserTypeId(userId) != userTypeId) * continue;*/ if (selectedDealerId != -1) { userInfoId = dataBlock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_DealerId); if (int.TryParse(dataBlock.usersTable.GetUserInfoValue(userId, userInfoId), out dealerId)) { if (selectedDealerId != dealerId) { continue; } else { dealerName = dataBlock.organizationTable.GetOrganizationName(dealerId); } } else { continue; } } else { userInfoId = dataBlock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_DealerId); if (int.TryParse(dataBlock.usersTable.GetUserInfoValue(userId, userInfoId), out dealerId)) { dealerName = dataBlock.organizationTable.GetOrganizationName(dealerId); } else { dealerName = "???"; } if (dealerName.Trim() == "") { dealerName = "???"; } } dr = dt.NewRow(); //DEALER dr["DEALER"] = dealerName; //SURNAME userInfoId = dataBlock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_Surname); dr["SURNAME"] = dataBlock.usersTable.GetUserInfoValue(userId, userInfoId); //NAME userInfoId = dataBlock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_Name); dr["NAME"] = dataBlock.usersTable.GetUserInfoValue(userId, userInfoId); //Patronimic userInfoId = dataBlock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_Patronimic); dr["PAtronimic"] = dataBlock.usersTable.GetUserInfoValue(userId, userInfoId); //LOGIN dr["LOGIN"] = dataBlock.usersTable.Get_UserName(userId); //REG_DATE if (DateTime.TryParse(dataBlock.usersTable.GetUserInfoValue(userId, DataBaseReference.UserInfo_RegDate), out date)) { dr["REG_DATE"] = date.ToLongDateString() + " " + date.ToShortTimeString(); } //ROLE dr["ROLE"] = dataBlock.usersTable.Get_UserRoleName(userId); //USER_TYPE dr["USER_TYPE"] = dataBlock.usersTable.Get_UserTypeStr(userId); //STATE date = dataBlock.usersTable.Get_TimeConnect(userId); if (date == (new DateTime())) { dr["STATE"] = "Вход не производился"; } else { dr["STATE"] = "Последний вход " + date.ToLongDateString() + " " + date.ToShortTimeString(); } // dt.Rows.Add(dr); } dataBlock.CloseConnection(); UsersDataGrid.DataSource = dt; UsersDataGrid.DataBind(); UsersDataGridUpdatePanel.Update(); } catch (Exception ex) { RaiseException(ex); } }