public CateNewsPermission GetCateNewsPermissionById(int Id)
{
CateNewsPermission cateNewsPermission = null;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_CateNewsPermissionGetById", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@CateNewsPermissionID", Id);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.Read())
{
cateNewsPermission = CateNewsPermissionReader(reader);
}
else
{
throw new DataAccessException("Khong tim thay gia tri nao");
}
command.Dispose();
}
}
return(cateNewsPermission);
}
public void UpdateCateNewsPermission(CateNewsPermission cateNewsPermission)
{
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_CateNewsPermissionUpdate", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 1);
command.Parameters.AddWithValue("@CateNewsPermissionID", cateNewsPermission.CateNewsPermissionID);
command.Parameters.AddWithValue("@RolesID", cateNewsPermission.RolesID);
command.Parameters.AddWithValue("@CateNewsID", cateNewsPermission.CateNewsID);
command.Parameters.AddWithValue("@Permission", cateNewsPermission.Permission);
command.Parameters.AddWithValue("@Created", cateNewsPermission.Created);
command.Parameters.AddWithValue("@UserName", cateNewsPermission.UserName);
command.Parameters.AddWithValue("@Language", cateNewsPermission.Language);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Khong cap nhat duoc quang cao");
}
else
{
command.Dispose();
}
}
}
private CateNewsPermission CateNewsPermissionReader(SqlDataReader reader)
{
CateNewsPermission cateNewsPermission = new CateNewsPermission();
cateNewsPermission.CateNewsPermissionID = (int)reader["CateNewsPermissionID"];
cateNewsPermission.RolesID = (int)reader["RolesID"];
cateNewsPermission.CateNewsID = (int)reader["CateNewsID"];
cateNewsPermission.Permission = (string)reader["Permission"];
cateNewsPermission.Created = (DateTime)reader["Created"];
cateNewsPermission.UserName = (string)reader["UserName"];
cateNewsPermission.Language = (string)reader["Language"];
return(cateNewsPermission);
}
private void VierPermissionCateID()
{
CateNewsPermissionBSO cateNewsPermissionBSO = new CateNewsPermissionBSO();
CateNewsPermission cateNewsPermission = new CateNewsPermission();
foreach (GridDataItem dataItem in RadGrid1.MasterTableView.Items)
{
CheckBox chkId = (CheckBox)dataItem.FindControl("chkId");
if (cateNewsPermissionBSO.CheckExitPermission(Convert.ToInt32(hddRoles_ID.Value), Convert.ToInt32(dataItem["CateNewsID"].Text)))
{
chkId.Checked = true;
}
}
}
private void VierPermissionID()
{
//PermissionBSO permissionBSO = new PermissionBSO();
//DataTable table = permissionBSO.GetPermissionAll();
//DataView dataView = new DataView(table);
//dataView.Sort = "PermissionID ASC";
//DataTable dataTable = dataView.ToTable();
//commonBSO commonBSO = new commonBSO();
CateNewsPermissionBSO cateNewsPermissionBSO = new CateNewsPermissionBSO();
CateNewsPermission cateNewsPermission = new CateNewsPermission();
foreach (GridDataItem dataItem in RadGrid1.MasterTableView.Items)
{
//CheckBoxList chklist = (CheckBoxList)dataItem.FindControl("chklist");
CheckBox chkId = (CheckBox)dataItem.FindControl("chkId");
//commonBSO.FillToCheckBoxList(chklist, dataTable, "PermissionName", "Value");
if (cateNewsPermissionBSO.CheckExitPermission(Convert.ToInt32(hddRoles.Value), Convert.ToInt32(dataItem["CateNewsID"].Text)))
{
//Permission
//cateNewsPermission = cateNewsPermissionBSO.GetCateNewsPermission(Convert.ToInt32(hddRoles.Value), Convert.ToInt32(dataItem["CateNewsID"].Text));
//if (cateNewsPermission != null)
//{
// string sPermission = cateNewsPermission.Permission;
// if (!sPermission.Equals(""))
// {
// string[] sSlip = sPermission.Split(new char[] { ',' });
// foreach (string s in sSlip)
// {
// foreach (ListItem items in chklist.Items)
// {
// if (items.Value == s)
// items.Selected = true;
// }
// }
// }
//}
//CateID
chkId.Checked = true;
}
}
}
public string GetPermission(int rolesID, int cateNewsID)
{
string permission = "";
//if (CheckExitPermission(rolesID, cateNewsID))
//{
// CateNewsPermission catenewsPermission = GetCateNewsPermission(rolesID, cateNewsID);
// permission = catenewsPermission.Permission;
//}
CateNewsPermission catenewsPermission = GetCateNewsPermission(rolesID, cateNewsID);
if (catenewsPermission != null)
{
permission = catenewsPermission.Permission;
}
return(permission);
}
protected void btn_add_Click_more(object sender, EventArgs e)
{
try
{
CateNews catenews = ReceiveHtml();
CateNewsBSO catenewsBSO = new CateNewsBSO();
int catenews1 = catenewsBSO.CreateCateNewGet(catenews);
if (!Session["Admin_UserName"].ToString().Equals("administrator"))
{
AdminRolesBSO adminRolesBSO = new AdminRolesBSO();
DataTable table = adminRolesBSO.GetAdminRolesByUserName(Session["Admin_UserName"].ToString());
CateNewsPermissionBSO catenewPermissionBSO = new CateNewsPermissionBSO();
CateNewsPermission cateNewsPermission = new CateNewsPermission();
if (table.Rows.Count > 0)
{
foreach (DataRow subrow in table.Rows)
{
cateNewsPermission.CateNewsID = catenews1;
cateNewsPermission.RolesID = Convert.ToInt32(subrow["RolesID"].ToString());
//cateNewsPermission.Permission = subrow["Permission"].ToString();
cateNewsPermission.Permission = "";
cateNewsPermission.UserName = Session["Admin_UserName"].ToString();
cateNewsPermission.Created = DateTime.Now;
cateNewsPermission.Language = Language.language;
catenewPermissionBSO.CreateCateNewsPermission(cateNewsPermission);
}
}
}
clientview.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Thêm mới thành công !</div>";
ViewCateGroup(Convert.ToInt32(HddGroupCate.Value));
AspNetCache.Reset();
}
catch (Exception ex)
{
clientview.Text = ex.Message.ToString();
}
}
public bool CheckExitPermission(int rolesID, int cateNewsID)
{
bool check = false;
CateNewsPermission catenewsPermission = GetCateNewsPermission(rolesID, cateNewsID);
if (catenewsPermission != null)
{
check = true;
}
//DataTable dataTable = GetCateNewsPermissionAll();
//if (dataTable != null)
//{
// DataView dataView = new DataView(dataTable);
// dataView.RowFilter = "RolesID = " + rolesID + " AND CateNewsID = " + cateNewsID;
// if (dataView.Count > 0)
// check = true;
//}
return(check);
}
protected void btn_add_Click(object sender, EventArgs e)
{
DataTable datatable = CateNewsID();
try
{
CateNewsPermissionBSO catenewPermissionBSO = new CateNewsPermissionBSO();
DataTable table1 = catenewPermissionBSO.GetCateNewsPermissionByRoles(Convert.ToInt32(hddRoles.Value), Language.language);
if (table1.Rows.Count > 0)
{
catenewPermissionBSO.DeleteCateNewsPermissionRoles(Convert.ToInt32(hddRoles.Value), Language.language);
}
CateNewsPermission cateNewsPermission = new CateNewsPermission();
if (datatable.Rows.Count > 0)
{
foreach (DataRow subrow in datatable.Rows)
{
cateNewsPermission.CateNewsID = Convert.ToInt32(subrow["CateNewsID"].ToString());
cateNewsPermission.RolesID = Convert.ToInt32(hddRoles.Value);
// cateNewsPermission.Permission = subrow["Permission"].ToString();
cateNewsPermission.Permission = "";
cateNewsPermission.UserName = Session["Admin_UserName"].ToString();
cateNewsPermission.Created = DateTime.Now;
cateNewsPermission.Language = Language.language;
catenewPermissionBSO.CreateCateNewsPermission(cateNewsPermission);
error.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Cập nhật thành công !</div>";
// initControl(cateNewsPermission.RolesID);
}
}
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
public CateNewsPermission GetCateNewsPermission(int rolesId, int cateNewsID)
{
CateNewsPermission cateNewsPermission = null;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_CateNewsPermissionGet", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@RolesID", rolesId);
command.Parameters.AddWithValue("@CateNewsID", cateNewsID);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.Read())
{
cateNewsPermission = CateNewsPermissionReader(reader);
}
//else
// throw new DataAccessException("Không tìm thấy giá trị");
command.Dispose();
}
}
return(cateNewsPermission);
}
public void UpdateCateNewsPermission(CateNewsPermission cateNewsPermission)
{
CateNewsPermissionDAO cateNewsPermissionDAO = new CateNewsPermissionDAO();
cateNewsPermissionDAO.UpdateCateNewsPermission(cateNewsPermission);
}
