protected void BtnUpdate_Click(object sender, EventArgs e)
{
string sql = "";
int tt = 0;
ClUserPermission cl = new ClUserPermission();
for (int i = 0; i < GridView1.Rows.Count - 1; i++)
{
GridViewRow gr = GridView1.Rows[i];
Label lblup = (Label)gr.FindControl("LblUpID");
CheckBox chview = (CheckBox)gr.FindControl("chview");
CheckBox chInsert = (CheckBox)gr.FindControl("chInsert");
CheckBox chUpdate = (CheckBox)gr.FindControl("chUpdate");
CheckBox chDel = (CheckBox)gr.FindControl("chDel");
cl.UserPermissinID = Convert.ToInt32(lblup.Text);
cl.CanView = chview.Checked;
cl.CanUpdate = chUpdate.Checked;
cl.CanInsert = chInsert.Checked;
cl.CanDel = chDel.Checked;
tt += UserPermissionClass.Update(cl);
// sql += "update Tbl_UserPermission set CanDel=" + CSharp.PublicFunction.BTS(chDel.Checked) + ",CanInsert=" + CSharp.PublicFunction.BTS(chInsert.Checked) + ",CanUpdate=" + CSharp.PublicFunction.BTS(chUpdate.Checked) + ",CanView=" + CSharp.PublicFunction.BTS(chUpdate.Checked) + " where UserPermissinID=" + lblup.Text + "";
}
if (tt != 0)
{
BindGrid();
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('خطا در ویرایش');", true);
}
}
protected void BtnInsert_Click(Object sender, System.EventArgs e)
{
ClUserPermission cl = Data;
int t = 0;
if (CSharp.PublicFunction.ModeInsert(cl.UserPermissinID.ToString()))
{
t = UserPermissionClass.insert(cl);
}
else
{
t = UserPermissionClass.Update(cl);
}
if (t == 0)
{
LblMsg.ForeColor = System.Drawing.Color.Red;
LblMsg.Text = "خطا در ثبت";
}
else
{
LblMsg.ForeColor = System.Drawing.Color.Green;
LblMsg.Text = "ثبت انجام شد.";
BindPermission();
BindGrid();
}
}
public void UpItem(object sender, EventArgs e)
{
String UserPermissinID = ((HtmlAnchor)sender).HRef.ToString();
ClUserPermission cl = new ClUserPermission();
cl.UserPermissinID = Convert.ToInt32(UserPermissinID);
Data = cl;
LightBox.Value = "1";
}
private void BindPermission()
{
ClUserPermission cl = new ClUserPermission();
cl.UserID = Convert.ToInt32(DDUserID.SelectedValue);
DDPermissionID.DataSource = UserPermissionClass.GetUserNotPermission(cl);
DDPermissionID.DataTextField = "PermissianName";
DDPermissionID.DataValueField = "PermissionID";
DDPermissionID.DataBind();
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList(ClUserPermission c)
{
SqlCommand cmd = new SqlCommand("PRC_UserPermission_GetList", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("PageIndex", SqlDbType.NVarChar)).Value = c.PageIndex;
cmd.Parameters.Add(new SqlParameter("PageSize", SqlDbType.NVarChar)).Value = c.PageSize;
cmd.Parameters.Add(new SqlParameter("Order", SqlDbType.NVarChar)).Value = c.OrderDirection;
cmd.Parameters.Add(new SqlParameter("OrderBy", SqlDbType.NVarChar)).Value = c.OrderBy;
cmd.Parameters.Add(new SqlParameter("UserPermissinID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UserPermissinID);
cmd.Parameters.Add(new SqlParameter("UserID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UserID);
cmd.Parameters.Add(new SqlParameter("PermissionID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PermissionID);
cmd.Parameters.Add(new SqlParameter("CanView", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanView);
cmd.Parameters.Add(new SqlParameter("CanUpdate", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanUpdate);
cmd.Parameters.Add(new SqlParameter("CanDel", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanDel);
cmd.Parameters.Add(new SqlParameter("CanInsert", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanInsert);
cmd.Parameters.Add(new SqlParameter("PageName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PageName);
SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int);
prmResult.Direction = ParameterDirection.Output;
cmd.Parameters.Add(prmResult);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
cnn.Open();
da.Fill(ds);
return(ds);
}
catch (Exception ex)
{
return(null);
}
finally
{
cnn.Close();
}
}
public static int insert(ClUserPermission c)
{
SqlCommand cmd = new SqlCommand("PRC_UserPermission_Insert", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID();
cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress();
cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS();
cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion();
cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL();
cmd.Parameters.Add(new SqlParameter("UserID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UserID);
cmd.Parameters.Add(new SqlParameter("PermissionID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PermissionID);
cmd.Parameters.Add(new SqlParameter("CanView", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanView);
cmd.Parameters.Add(new SqlParameter("CanUpdate", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanUpdate);
cmd.Parameters.Add(new SqlParameter("CanDel", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanDel);
cmd.Parameters.Add(new SqlParameter("CanInsert", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanInsert);
SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int);
prmResult.Direction = ParameterDirection.Output;
cmd.Parameters.Add(prmResult);
try
{
cnn.Open();
cmd.ExecuteNonQuery();
return(Convert.ToInt32(prmResult.Value));
}
catch (Exception ex)
{
return(0);
}
finally
{
cnn.Close();
}
}
public void BindGrid()
{
ClUserPermission cl = new ClUserPermission();
cl.UserID = Convert.ToInt32(DDUserID.SelectedValue);
DataSet ds = UserPermissionClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["UserPermission"] == null)
{
ViewState["UserPermission"] = "UserPermissinID Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["UserPermission"].ToString()).ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
if (GridView1.Rows.Count > 0)
{
BtnUpdate.Visible = true;
}
else
{
BtnUpdate.Visible = false;
}
}
