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);
}
