protected void loadMembersGrid(Dictionary <String, userDetails> userDict) { if (userDict == null || userDict.Count > 0) { userDict = BackEndObjects.DeptDetails. getAllUsersForDeptIdAndEntIdDB(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString(), hdnValueDeptId.Value); } DataTable dt = new DataTable(); dt.Columns.Add("userId"); dt.Columns.Add("Name"); Dictionary <String, String> existingUserForDept = new Dictionary <string, string>(); int counter = 0; foreach (KeyValuePair <String, userDetails> kvp in userDict) { existingUserForDept.Add(kvp.Key.ToString(), kvp.Key.ToString()); dt.Rows.Add(); dt.Rows[counter]["userId"] = kvp.Key.Trim(); dt.Rows[counter]["Name"] = kvp.Value.getName(); counter++; } GridView_Dept_Members.Visible = true; GridView_Dept_Members.SelectedIndex = -1; GridView_Dept_Members.DataSource = dt; GridView_Dept_Members.DataBind(); Cache.Remove("DeptMembersList"); Cache.Remove("DeptMembersDataTable"); Cache["DeptMembersList"] = existingUserForDept; Cache["DeptMembersDataTable"] = dt; }
protected void GridView_Dept_Members_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView_Dept_Members.PageIndex = e.NewPageIndex; DataTable dt = (DataTable)Cache["DeptMembersDataTable"]; GridView_Dept_Members.DataSource = dt; GridView_Dept_Members.DataBind(); //Dictionary<String, userDetails> userDict = BackEndObjects.DeptDetails. //getAllUsersForDeptIdAndEntIdDB(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString(), hdnValueDeptId.Value); //if (userDict != null && userDict.Count > 0) //loadMembersGrid(userDict); }
protected void GridView_Dept_Members_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow gVR = GridView_Dept_Members.Rows[e.RowIndex]; String userId = ((Label)gVR.Cells[0].FindControl("Label_UserId")).Text; Dictionary <String, String> whereCls = new Dictionary <string, string>(); Dictionary <String, String> targetVals = new Dictionary <string, string>(); whereCls.Add(BackEndObjects.userDetails.USER_DETAILS_COL_USERID, userId); whereCls.Add(BackEndObjects.userDetails.USER_DETAILS_COL_BUSINESS_ID, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString()); targetVals.Add(BackEndObjects.userDetails.USER_DETAILS_COL_DEPT_ID, ""); BackEndObjects.userDetails.updateUserDetailsDB(targetVals, whereCls, DBConn.Connections.OPERATION_UPDATE); DataTable dt = (DataTable)Cache["DeptMembersDataTable"]; int index = GridView_Dept_Members.Rows[e.RowIndex].DataItemIndex; dt.Rows[index].Delete(); GridView_Dept_Members.DataSource = dt; GridView_Dept_Members.DataBind(); }