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));
if (table1.Rows.Count > 0)
catenewPermissionBSO.DeleteCateNewsPermissionRoles(Convert.ToInt32(hddRoles.Value));
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;
catenewPermissionBSO.CreateCateNewsPermission(cateNewsPermission);
error.Text = String.Format(Resources.StringAdmin.AddNewsSuccessful);
}
}
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
public void CreateCateNewsPermission(CateNewsPermission cateNewsPermission)
{
using (SqlConnection connection = base.GetConnection())
{
SqlCommand command = new SqlCommand("_CateNewsPermissionUpdate", connection) {
CommandType = CommandType.StoredProcedure
};
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@CateNewsPermissionID", 0);
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);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Khong them duoc quang cao");
}
command.Dispose();
}
}
protected void btn_add_Click(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;
catenewPermissionBSO.CreateCateNewsPermission(cateNewsPermission);
}
}
}
clientview.Text = String.Format(Resources.StringAdmin.AddNewsSuccessful);
//ViewCateGroup(Convert.ToInt32(HddGroupCate.Value));
}
catch (Exception ex)
{
clientview.Text = ex.Message.ToString();
}
}
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");
int cateNewsId = 0;
Int32.TryParse(dataItem["CateNewsID"].Text, out cateNewsId);
if (cateNewsId != 0)
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 void UpdateCateNewsPermission(CateNewsPermission cateNewsPermission)
{
new CateNewsPermissionDAO().UpdateCateNewsPermission(cateNewsPermission);
}
public void CreateCateNewsPermission(CateNewsPermission cateNewsPermission)
{
new CateNewsPermissionDAO().CreateCateNewsPermission(cateNewsPermission);
}
