public void UpdateCateNewsGroupPermission(CateNewsGroupPermission _cateNewsGroupPermission) { using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("_CateNewsGroupPermissionUpdate", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Type", 1); command.Parameters.AddWithValue("@CateNewsGroupPermissionID", _cateNewsGroupPermission.CateNewsGroupPermissionID); command.Parameters.AddWithValue("@RolesID", _cateNewsGroupPermission.RolesID); command.Parameters.AddWithValue("@CateNewsGroupID", _cateNewsGroupPermission.CateNewsGroupID); command.Parameters.AddWithValue("@Permission", _cateNewsGroupPermission.Permission); command.Parameters.AddWithValue("@Created", _cateNewsGroupPermission.Created); command.Parameters.AddWithValue("@UserName", _cateNewsGroupPermission.UserName); command.Parameters.AddWithValue("@Language", _cateNewsGroupPermission.Language); connection.Open(); if (command.ExecuteNonQuery() <= 0) { throw new DataAccessException("Khong cap nhat duoc quang cao"); } else { command.Dispose(); } } }
public CateNewsGroupPermission GetCateNewsGroupPermissionById(int Id) { CateNewsGroupPermission _cateNewsGroupPermission = null; using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("_CateNewsGroupPermissionGetById", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@CateNewsGroupPermissionID", Id); connection.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { if (reader.Read()) { _cateNewsGroupPermission = CateNewsGroupPermissionReader(reader); } else { throw new DataAccessException("Khong tim thay gia tri nao"); } command.Dispose(); } } return(_cateNewsGroupPermission); }
private void VierPermissionID() { CateNewsGroupPermissionBSO _cateNewsGroupPermissionBSO = new CateNewsGroupPermissionBSO(); CateNewsGroupPermission _cateNewsGroupPermission = new CateNewsGroupPermission(); foreach (ListItem items in chkListCate.Items) { if (_cateNewsGroupPermissionBSO.CheckExitPermission(Convert.ToInt32(hddRoles_ID.Value), Convert.ToInt32(items.Value))) { items.Selected = true; } } }
private CateNewsGroupPermission CateNewsGroupPermissionReader(SqlDataReader reader) { CateNewsGroupPermission _cateNewsGroupPermission = new CateNewsGroupPermission(); _cateNewsGroupPermission.CateNewsGroupPermissionID = (int)reader["CateNewsGroupPermissionID"]; _cateNewsGroupPermission.RolesID = (int)reader["RolesID"]; _cateNewsGroupPermission.CateNewsGroupID = (int)reader["CateNewsGroupID"]; _cateNewsGroupPermission.Permission = (string)reader["Permission"]; _cateNewsGroupPermission.Created = (DateTime)reader["Created"]; _cateNewsGroupPermission.UserName = (string)reader["UserName"]; _cateNewsGroupPermission.Language = (string)reader["Language"]; return(_cateNewsGroupPermission); }
private void VierPermissionID() { CateNewsGroupPermissionBSO cateNewsPermissionBSO = new CateNewsGroupPermissionBSO(); CateNewsGroupPermission cateNewsPermission = new CateNewsGroupPermission(); foreach (GridViewRow rows in grvRoles.Rows) { CheckBox chkId = (CheckBox)rows.Cells[0].FindControl("chkId"); if (cateNewsPermissionBSO.CheckExitPermission(Convert.ToInt32(rows.Cells[0].Text), Convert.ToInt32(hddCateNewsGroupID.Value))) { chkId.Checked = true; } } }
public string GetPermission(int rolesID, int _cateNewsGroupID) { string permission = ""; CateNewsGroupPermission catenewsPermission = GetCateNewsGroupPermission(rolesID, _cateNewsGroupID); if (catenewsPermission != null) { permission = catenewsPermission.Permission; } //if (CheckExitPermission(rolesID, _cateNewsGroupID)) //{ // CateNewsGroupPermission catenewsPermission = GetCateNewsGroupPermission(rolesID, _cateNewsGroupID); // permission = catenewsPermission.Permission; //} return(permission); }
protected void btn_add_Click(object sender, EventArgs e) { try { CateNewsGroup catenewsGroup = ReceiveHtml(); CateNewsGroupBSO catenewsGroupBSO = new CateNewsGroupBSO(); int id = catenewsGroupBSO.CreateCateNewsGroup(catenewsGroup); if (!Session["Admin_UserName"].ToString().Equals("administrator")) { AdminRolesBSO adminRolesBSO = new AdminRolesBSO(); DataTable table = adminRolesBSO.GetAdminRolesByUserName(Session["Admin_UserName"].ToString()); CateNewsGroupPermissionBSO catenewGroupPermissionBSO = new CateNewsGroupPermissionBSO(); CateNewsGroupPermission cateNewsGroupPermission = new CateNewsGroupPermission(); if (table.Rows.Count > 0) { foreach (DataRow subrow in table.Rows) { cateNewsGroupPermission.CateNewsGroupID = id; cateNewsGroupPermission.RolesID = Convert.ToInt32(subrow["RolesID"].ToString()); cateNewsGroupPermission.Permission = ""; cateNewsGroupPermission.UserName = Session["Admin_UserName"].ToString(); cateNewsGroupPermission.Created = DateTime.Now; cateNewsGroupPermission.Language = Language.language; catenewGroupPermissionBSO.CreateCateNewsGroupPermission(cateNewsGroupPermission); } } } clientview.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Thêm mới thành công !</div>"; initControl(id); AspNetCache.Reset(); } catch (Exception ex) { clientview.Text = ex.Message.ToString(); } }
public bool CheckExitPermission(int rolesID, int _cateNewsGroupID) { bool check = false; CateNewsGroupPermission catenewsPermission = GetCateNewsGroupPermission(rolesID, _cateNewsGroupID); if (catenewsPermission != null) { check = true; } //DataTable dataTable = GetCateNewsGroupPermissionAll(); //if (dataTable != null) //{ // DataView dataView = new DataView(dataTable); // dataView.RowFilter = "RolesID = " + rolesID + " AND CateNewsGroupID = " + _cateNewsGroupID; // if (dataView.Count > 0) // check = true; //} return(check); }
protected void btn_add_cate_Click(object sender, EventArgs e) { DataTable datatable = CateNewsGroupID(); try { CateNewsGroupPermissionBSO catenewPermissionBSO = new CateNewsGroupPermissionBSO(); DataTable table1 = catenewPermissionBSO.GetCateNewsGroupPermissionByRoles(Convert.ToInt32(hddRoles_ID.Value), Language.language); if (table1.Rows.Count > 0) { catenewPermissionBSO.DeleteCateNewsGroupPermissionRoles(Convert.ToInt32(hddRoles_ID.Value), Language.language); } CateNewsGroupPermission _cateNewsGroupPermission = new CateNewsGroupPermission(); if (datatable.Rows.Count > 0) { foreach (DataRow subrow in datatable.Rows) { _cateNewsGroupPermission.CateNewsGroupID = Convert.ToInt32(subrow["CateNewsGroupID"].ToString()); _cateNewsGroupPermission.RolesID = Convert.ToInt32(hddRoles_ID.Value); _cateNewsGroupPermission.Permission = ""; _cateNewsGroupPermission.UserName = Session["Admin_UserName"].ToString(); _cateNewsGroupPermission.Created = DateTime.Now; _cateNewsGroupPermission.Language = Language.language; catenewPermissionBSO.CreateCateNewsGroupPermission(_cateNewsGroupPermission); errorCate.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Cập nhật thành công !</div>"; // initControl(_cateNewsGroupPermission.RolesID); } } } catch (Exception ex) { errorCate.Text = ex.Message.ToString(); } }
public CateNewsGroupPermission GetCateNewsGroupPermission(int rolesId, int _cateNewsGroupID) { CateNewsGroupPermission _cateNewsGroupPermission = null; using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("_CateNewsGroupPermissionGet", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@RolesID", rolesId); command.Parameters.AddWithValue("@CateNewsGroupID", _cateNewsGroupID); connection.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { if (reader.Read()) { _cateNewsGroupPermission = CateNewsGroupPermissionReader(reader); } //else // throw new DataAccessException("Không tìm thấy giá trị"); command.Dispose(); } } return(_cateNewsGroupPermission); }
public void UpdateCateNewsGroupPermission(CateNewsGroupPermission _cateNewsGroupPermission) { CateNewsGroupPermissionDAO _cateNewsGroupPermissionDAO = new CateNewsGroupPermissionDAO(); _cateNewsGroupPermissionDAO.UpdateCateNewsGroupPermission(_cateNewsGroupPermission); }