/// <summary>
/// To Bind Grid
/// </summary>
private void BindGrid()
{
// AutomobileOnline.Model.clsDesigRightsDAL objclsDesigRightsDAL = new AutomobileOnline.Model.clsDesigRightsDAL();
WebTransport.DAL.DesigRightsDAL objclsDesigRightsDAL = new WebTransport.DAL.DesigRightsDAL();
if (ddlType.SelectedItem.Text == "Form")
{
var lstGridData = objclsDesigRightsDAL.SelectForGridTypeForm(Convert.ToInt32(ddlDesign.SelectedValue));
objclsDesigRightsDAL = null;
grdMain.DataSource = lstGridData;
grdMain.DataBind();
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else if (ddlType.SelectedItem.Text == "Menu")
{
var lstGridData = objclsDesigRightsDAL.SelectForGridTypeMenu(Convert.ToInt32(ddlDesign.SelectedValue));
objclsDesigRightsDAL = null;
grdMain.DataSource = lstGridData;
grdMain.DataBind();
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else if (ddlType.SelectedItem.Text == "Report")
{
var lstGridData = objclsDesigRightsDAL.SelectForGridTypeRep(Convert.ToInt32(ddlDesign.SelectedValue));
objclsDesigRightsDAL = null;
grdMain.DataSource = lstGridData;
grdMain.DataBind();
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
lblcontant.Visible = false;
divpaging.Visible = false;
}
int count = grdMain.Rows.Count;
int RowCount = 0;
foreach (GridViewRow row in grdMain.Rows)
{
CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect");
if (chkSelect.Checked)
{
RowCount++;
}
}
if (RowCount == count)
{
chkSelectAllRows.Checked = true;
imgBtnSelectAllRows.ImageUrl = "~/Images/SelectAll_Active.png";
}
else
{
chkSelectAllRows.Checked = false;
imgBtnSelectAllRows.ImageUrl = "~/Images/SelectAll_Inactive.png";
}
if (count > 0)
{
selectall.Visible = true;
}
else
{
selectall.Visible = false;
}
}
protected void imgBtnSelectAllRows_Click(object sender, ImageClickEventArgs e)
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
int value = 0;
string strMsg = string.Empty;
int intDesigRghtsIdno = 0;
// AutomobileOnline.Model.clsDesigRightsDAL objclsDesigRightsDAL = new AutomobileOnline.Model.clsDesigRightsDAL();
WebTransport.DAL.DesigRightsDAL objclsDesigRightsDAL = new WebTransport.DAL.DesigRightsDAL();
if (ddlType.SelectedItem.Text == "Form")
{
var lstGridData = objclsDesigRightsDAL.SelectForGridTypeForm(Convert.ToInt32(ddlDesign.SelectedValue));
int i = 0;
foreach (GridViewRow row in grdMain.Rows)
{
bool bAdd = false;
bool bEdit = false;
bool bView = false;
bool bDelete = false;
bool bPrint = false;
if (lstGridData.Count > 0)
{
intDesigRghtsIdno = Convert.ToInt32(DataBinder.Eval(lstGridData[i], "DesigRghts_Idno"));
CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect");
if (chkSelect.Checked == true)
{
bAdd = true; bEdit = true; bView = true; bDelete = true; bPrint = true;
}
else if (chkSelect.Checked == false)
{
bAdd = false; bEdit = false; bView = false; bDelete = false; bPrint = false;
}
value = objclsDesigRightsDAL.UpdateAll(intDesigRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno);
bool bDesigRights = true;
if (bAdd == true && bEdit == true && bView == true && bDelete == true && bPrint == true)
{
bDesigRights = true;
}
if (bAdd == false && bEdit == false && bView == false && bDelete == false && bPrint == false)
{
bDesigRights = false;
}
int intDesigRights = 0;
intDesigRights = objclsDesigRightsDAL.UpdateDesigRights(Convert.ToInt32(ddlDesign.SelectedValue) /*intDesigRghtsIdno*/, bDesigRights);
}
i++;
}
}
else if (ddlType.SelectedItem.Text == "Menu")
{
var lstGridData = objclsDesigRightsDAL.SelectForGridTypeMenu(Convert.ToInt32(ddlDesign.SelectedValue));
int i = 0;
foreach (GridViewRow row in grdMain.Rows)
{
bool bAdd = false;
bool bEdit = false;
bool bView = false;
bool bDelete = false;
bool bPrint = false;
if (lstGridData.Count > 0)
{
intDesigRghtsIdno = Convert.ToInt32(DataBinder.Eval(lstGridData[i], "DesigRghts_Idno"));
CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect");
if (chkSelect.Checked == true)
{
bAdd = true; bEdit = true; bView = true; bDelete = true; bPrint = true;
}
else if (chkSelect.Checked == false)
{
bAdd = false; bEdit = false; bView = false; bDelete = false; bPrint = false;
}
value = objclsDesigRightsDAL.UpdateAll(intDesigRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno);
bool bDesigRights = true;
if (bAdd == true && bEdit == true && bView == true && bDelete == true && bPrint == true)
{
bDesigRights = true;
}
if (bAdd == false && bEdit == false && bView == false && bDelete == false && bPrint == false)
{
bDesigRights = false;
}
int intDesigRights = 0;
intDesigRights = objclsDesigRightsDAL.UpdateDesigRights(Convert.ToInt32(ddlDesign.SelectedValue) /*intDesigRghtsIdno*/, bDesigRights);
}
i++;
}
}
else if (ddlType.SelectedItem.Text == "Report")
{
var lstGridData = objclsDesigRightsDAL.SelectForGridTypeRep(Convert.ToInt32(ddlDesign.SelectedValue));
int i = 0;
foreach (GridViewRow row in grdMain.Rows)
{
bool bAdd = false;
bool bEdit = false;
bool bView = false;
bool bDelete = false;
bool bPrint = false;
if (lstGridData.Count > 0)
{
intDesigRghtsIdno = Convert.ToInt32(DataBinder.Eval(lstGridData[i], "DesigRghts_Idno"));
CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect");
if (chkSelect.Checked == true)
{
bAdd = true; bEdit = true; bView = true; bDelete = true; bPrint = true;
}
else if (chkSelect.Checked == false)
{
bAdd = false; bEdit = false; bView = false; bDelete = false; bPrint = false;
}
value = objclsDesigRightsDAL.UpdateAll(intDesigRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno);
bool bDesigRights = true;
if (bAdd == true && bEdit == true && bView == true && bDelete == true && bPrint == true)
{
bDesigRights = true;
}
if (bAdd == false && bEdit == false && bView == false && bDelete == false && bPrint == false)
{
bDesigRights = false;
}
int intDesigRights = 0;
intDesigRights = objclsDesigRightsDAL.UpdateDesigRights(Convert.ToInt32(ddlDesign.SelectedValue) /*intDesigRghtsIdno*/, bDesigRights);
}
i++;
}
}
objclsDesigRightsDAL = null;
if (value > 0)
{
this.BindGrid();
strMsg = "Record updated successfully.";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}