public void SelectRight()
{
List <BLLUserRights> objlist = new List <BLLUserRights>();
BLLUserRights objbll = new BLLUserRights();
objbll.Emp_code = user;;
objbll.App_detail = "UserRights";
objlist = objbll.Selectuserrights(objbll);
if (objlist.Count > 0)
{
string r_add = objlist[0].Rr_add;
if (r_add == "1")
{
BtnSave.Enabled = true;
BtnNew.Enabled = false;
}
else
{
Response.Redirect("norights.aspx");
}
}
else
{
Response.Redirect("norights.aspx");
}
}
public void SelectRight()
{
List <BLLUserRights> objlist = new List <BLLUserRights>();
BLLUserRights objbll = new BLLUserRights();
objbll.Emp_code = user;
objbll.App_detail = "Designation";
objlist = objbll.Selectuserrights(objbll);
if (objlist.Count > 0)
{
string r_add = objlist[0].Rr_add;
string r_visible = objlist[0].Rr_visible;
string r_edit = objlist[0].Rr_edit;
string r_delete = objlist[0].Rr_delete;
if (r_edit == "1")
{
Session["update"] = "yes";
}
if (r_delete == "1")
{
Session["delete"] = "yes";
}
if (r_visible == "1")
{
SelectDesignation();
}
}
else
{
Response.Redirect("norights.aspx");
}
}
public List <BLLUserRights> Selectuserrights(BLLUserRights objbll)
{
List <BLLUserRights> objlist = new List <BLLUserRights>();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@emp_code", SqlDbType.NVarChar);
param[0].Value = objbll.Emp_code;
param[1] = new SqlParameter("@app_detail", SqlDbType.NVarChar);
param[1].Value = objbll.App_detail;
SqlDataReader dr;
objcon.OpenConnection();
dr = objcon.sqlcmdSelectByMultimoreprogram("sp_selectuserrights", param);
while (dr.Read())
{
objbll = new BLLUserRights();
objbll.Id = Convert.ToInt32(dr["id"].ToString());
objbll.Emp_code = dr["emp_code"].ToString();
objbll.Name = dr["name"].ToString();
objbll.App_detail = dr["app_detail"].ToString();
objbll.Rrights = (dr["rights"].ToString());
objbll.Rr_add = (dr["r_add"].ToString());
objbll.Rr_visible = (dr["r_visible"].ToString());
objbll.Rr_edit = (dr["r_edit"].ToString());
objbll.Rr_delete = (dr["r_delete"].ToString());
objlist.Add(objbll);
}
objcon.CloseConnection();
return(objlist);
}
public void LoadAppDetail()
{
BLLUserRights objbll = new BLLUserRights();
List <BLLUserRights> objlist = new List <BLLUserRights>();
objlist = objbll.SelectApplicationDetail();
if (objlist.Count > 0)
{
dgrights.DataSource = objlist;
dgrights.DataBind();
}
}
public List <BLLUserRights> SelectApplicationDetail()
{
List <BLLUserRights> objlist = new List <BLLUserRights>();
BLLUserRights objbll = new BLLUserRights();
SqlDataReader dr;
objcon.OpenConnection();
dr = objcon.sqlcmdSelectAll("sp_selectappdetail");
while (dr.Read())
{
objbll = new BLLUserRights();
objbll.App_detail = dr["app_detail"].ToString();
objlist.Add(objbll);
}
objcon.CloseConnection();
return(objlist);
}
public int Insertuserrights(BLLUserRights objbll)
{
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@emp_code", SqlDbType.NVarChar);
param[0].Value = objbll.Emp_code;
param[1] = new SqlParameter("@name", SqlDbType.NVarChar);
param[1].Value = objbll.Name;
param[2] = new SqlParameter("@app_detail", SqlDbType.NVarChar);
param[2].Value = objbll.App_detail;
param[3] = new SqlParameter("@rights", SqlDbType.Bit);
param[3].Value = objbll.Rights;
param[4] = new SqlParameter("@r_add", SqlDbType.Bit);
param[4].Value = objbll.R_add;
param[5] = new SqlParameter("@r_visible", SqlDbType.Bit);
param[5].Value = objbll.R_visible;
param[6] = new SqlParameter("@r_edit", SqlDbType.Bit);
param[6].Value = objbll.R_edit;
param[7] = new SqlParameter("@r_delete", SqlDbType.Bit);
param[7].Value = objbll.R_delete;
param[8] = new SqlParameter("@status", SqlDbType.Bit);
param[8].Value = objbll.Status;
param[9] = new SqlParameter("@insert_date", SqlDbType.DateTime);
param[9].Value = objbll.Insert_date;
param[10] = new SqlParameter("@update_date", SqlDbType.DateTime);
param[10].Value = objbll.Update_date;
objcon.OpenConnection();
int a = objcon.sqlcmdInsert("sp_insertuserrights", param);
objcon.CloseConnection();
return(a);
}
public void Insert()
{
int b = 0;
for (int a = 0; a < dgrights.Rows.Count; a++)
{
string app_detail = dgrights.Rows[a].Cells[0].Text.ToString();
bool r_rights = ((CheckBox)dgrights.Rows[a].Cells[1].FindControl("chrights")).Checked;
bool r_add = ((CheckBox)dgrights.Rows[a].Cells[2].FindControl("chadd")).Checked;
bool r_visible = ((CheckBox)dgrights.Rows[a].Cells[3].FindControl("chvisible")).Checked;
bool r_edit = ((CheckBox)dgrights.Rows[a].Cells[4].FindControl("chupdate")).Checked;
bool r_delete = ((CheckBox)dgrights.Rows[a].Cells[5].FindControl("chdelete")).Checked;
if (r_rights == true)
{
BLLUserRights objbll = new BLLUserRights();
objbll.Emp_code = cbemployeecode.SelectedItem.ToString();
objbll.Name = txtname.Text;
objbll.App_detail = app_detail;
objbll.Rights = r_rights;
objbll.R_add = r_add;
objbll.R_visible = r_visible;
objbll.R_edit = r_edit;
objbll.R_delete = r_delete;
b = objbll.Insertuserrights(objbll);
}
}
if (b == 1)
{
lblresult.Text = "Rights Assign Successfully..";
BtnSave.Enabled = false;
BtnNew.Enabled = true;
}
else
{
lblresult.Text = "Rights Not-Assign Successfully..";
}
}
public List <BLLUserRights> Selectuserrights(BLLUserRights objbll)
{
DALUserRights objdal = new DALUserRights();
return(objdal.Selectuserrights(objbll));
}
public int Insertuserrights(BLLUserRights objbll)
{
DALUserRights objdal = new DALUserRights();
return(objdal.Insertuserrights(objbll));
}
