private void loadGrid_withAccountsName()
{
string sqlString = " select * from AccChartOfAccountsBranchView where BrId =" + Int32.Parse(DropDownListBranchNameList.SelectedValue) + " and id =" + Int32.Parse(DropDownListAccountsHead.SelectedValue);
DataSet givenPermission = objServiceHandler.ExecuteQuery(sqlString);
GridViewPermissionGiven.DataSource = givenPermission;
GridViewPermissionGiven.DataBind();
if (givenPermission.Tables["Table1"].Rows.Count == 0)
{
string sqlString1 = " select * from AccChartOfAccountsMasterView where id =" + Int32.Parse(DropDownListAccountsHead.SelectedValue);
DataSet availableHead = objServiceHandler.ExecuteQuery(sqlString1);
GridViewAvailable.DataSource = availableHead;
GridViewAvailable.DataBind();
}
else
{
string strSql = "SELECT top 0 * FROM AccChartOfAccountsMasterView";
DataSet oDs = objServiceHandler.ExecuteQuery(strSql);
GridViewAvailable.DataSource = oDs;
GridViewAvailable.DataBind();
}
}
private void loadGrid()
{
// var givenBrPermission = from t in db.BranchPermissionViews where t.UserId == Int32.Parse(DropDownListUserList.SelectedValue) select t;
string sqlString = " select * from AccChartOfAccountsBranchView where BrId =" + Int32.Parse(DropDownListBranchNameList.SelectedValue);
DataSet givenPermission = objServiceHandler.ExecuteQuery(sqlString);
GridViewPermissionGiven.DataSource = givenPermission;
GridViewPermissionGiven.DataBind();
if (givenPermission.Tables["Table1"].Rows.Count == 0)
{
//var availableBr = from t in db.BranchNames select t;
string sqlString1 = " select * from AccChartOfAccountsMasterView order by AccountsName";
DataSet availableHead = objServiceHandler.ExecuteQuery(sqlString1);
GridViewAvailable.DataSource = availableHead;
GridViewAvailable.DataBind();
}
else
{
string qry = "";
//foreach (var br in givenBrPermission)
foreach (DataRow prows in givenPermission.Tables["Table1"].Rows)
{
if (qry == "")
{
qry = qry + "Id<>" + prows["Id"];
}
else
{
qry = qry + "and " + "Id<>" + prows["Id"];
}
string strSql = "SELECT * FROM AccChartOfAccountsMasterView where " + qry;
DataSet oDs = objServiceHandler.ExecuteQuery(strSql);
GridViewAvailable.DataSource = oDs;
GridViewAvailable.DataBind();
//var availableBr = from t in db.BranchPermissionViews where + qry + select t;
// GridViewAvailable.DataSource = availableBr;
// GridViewAvailable.DataBind();
}
}
}
