private void ChnageGroupRoleStatus(int grId, int roleid, bool IsActive) { GroupRoleBAL gr = new GroupRoleBAL(); DataTable dTable = new DataTable(); try { int res = gr.UpdateGroupRole(grId, IsActive, LoginUser, Ret); } catch { } finally { gr = null; } }
/// <summary> /// To change status of Group Role details /// </summary> /// <param name="GrId"></param> /// <param name="RoleId"></param> /// <param name="IsActive"></param> private void ChangeGroupRoleStatus(int GrId, int RoleId, bool IsActive) { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); try { int IntResult = GroupRoleBAL.UpdateGroupRole(GrId, IsActive, LoginUser, Ret); } catch { throw; } finally { GroupRoleBAL = null; } }
/// <summary> /// To get Group Role Details from database /// </summary> /// <param name="GroupRoleId"></param> /// <returns></returns> private DataTable GetGroupRoleDetails(int GroupRoleId) { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtGrpRolDe = new DataTable(); try { DtGrpRolDe = GroupRoleBAL.SelectGroupRoleID(GroupRoleId, LoginUser, Ret); } catch { } finally { GroupRoleBAL = null; } return(DtGrpRolDe); }
/// <summary> /// To get group Role details from Business logic layer /// </summary> /// <returns></returns> private DataTable GridDataSource() { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtGridDet = new DataTable(); try { DtGridDet = GroupRoleBAL.LoadAllGroupRole(LoginUser, Ret); } catch { throw; } finally { GroupRoleBAL = null; } return(DtGridDet); }
/// <summary> /// To get Active Status group role details /// </summary> /// <returns></returns> private DataTable ActiveGridDataSource() { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtActSou = new DataTable(); try { DtActSou = GroupRoleBAL.LoadActiveGroupRole(true, LoginUser, Ret); } catch { throw; } finally { GroupRoleBAL = null; } return(DtActSou); }
private DataTable getRoledetails(int Groupid) { GroupRoleBAL gr = new GroupRoleBAL(); DataTable dTable = new DataTable(); try { dTable = gr.SelectGroupID(true, Groupid, LoginUser, Ret); } catch { } finally { gr = null; } return(dTable); }
/// <summary> /// To check status of group role /// </summary> /// <param name="NGRID"></param> /// <returns></returns> private DataTable CheckGroupRoleStatus(int NGRID) { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtGrpRolSta = new DataTable(); try { DtGrpRolSta = GroupRoleBAL.SelectGroupRoleID(NGRID, LoginUser, Ret); } catch { throw; } finally { GroupRoleBAL = null; } return(DtGrpRolSta); }
/// <summary> /// To take Group Role list from database /// </summary> /// <returns></returns> private DataTable ddlGroupRoleDe() { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtGrpRolDe = new DataTable(); try { DtGrpRolDe = GroupRoleBAL.GroupRoleLoad(LoginUser, Ret); } catch { throw; } finally { GroupRoleBAL = null; } return(DtGrpRolDe); }
/// <summary> /// To save and update Group Role Details /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string Status = ddlGroupRoleStatus.SelectedItem.Text; GroupId = Convert.ToInt16(ddlGroupName.SelectedValue); RoleId = Convert.ToInt16(ddlRoleName.SelectedValue); if (Session["GroupRoleId"] != null) { GroupRoleId = Convert.ToInt32(Session["GroupRoleId"].ToString()); } bool GroupRolestatus = false; if (ddlGroupRoleStatus.SelectedItem.Text != "Select") { if (Status == "Active") { GroupRolestatus = true; } else if (Status == "InActive") { GroupRolestatus = false; } if (btnSave.Text == "Save") { int IntResult = 0; GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); try { // 'InsertGroupRole' is GroupRole business Access Layer function called // to insert GroupRole details IntResult = GroupRoleBAL.InsertGroupRole(GroupId, RoleId, GroupRolestatus, LoginUser, Ret); ClearGroupRole(); msgGroupRole.Msg = "Group Role details submitted successfully"; msgGroupRole.showmsg(); } catch (Exception ee) { // Duplicate Entry is catched when inserting GroupRole if (ee.Message == "Duplicate Entry") { msgGroupRole.Msg = "Duplicate Entry!"; msgGroupRole.showmsg(); ClearGroupRole(); } } finally { GroupRoleBAL = null; } } else if (btnSave.Text == "Update") { int IntResult = 0; GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); try { // 'UpdateGroupRole' is GroupRole business Access Layer function called // to update GroupRole details IntResult = GroupRoleBAL.UpdateGroupRole(GroupRoleId, GroupRolestatus, LoginUser, Ret); ClearGroupRole(); Session["GroupId"] = null; btnSave.Text = "Save"; msgGroupRole.Msg = "Group Role updated successfully"; msgGroupRole.showmsg(); //Response.Redirect("GroupRoleList.aspx",false); } catch (Exception ee) { // Duplicate Entry is catched when updating GroupRole if (ee.Message == "Duplicate Entry") { msgGroupRole.Msg = "Duplicate Entry!"; msgGroupRole.showmsg(); } } finally { GroupRoleBAL = null; } } } }
/// <summary> /// To get group Role details from Business logic layer /// </summary> /// <returns></returns> private DataTable GridDataSource() { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtGridDet = new DataTable(); try { DtGridDet = GroupRoleBAL.LoadAllGroupRole(LoginUser, Ret); } catch { throw; } finally { GroupRoleBAL = null; } return DtGridDet; }
/// <summary> /// To get Active Status group role details /// </summary> /// <returns></returns> private DataTable ActiveGridDataSource() { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtActSou = new DataTable(); try { DtActSou = GroupRoleBAL.LoadActiveGroupRole(true, LoginUser, Ret); } catch { throw; } finally { GroupRoleBAL = null; } return DtActSou; }
/// <summary> /// To take Group Role list from database /// </summary> /// <returns></returns> private DataTable ddlGroupRoleDe() { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtGrpRolDe = new DataTable(); try { DtGrpRolDe = GroupRoleBAL.GroupRoleLoad(LoginUser, Ret ); } catch { throw; } finally { GroupRoleBAL = null; } return DtGrpRolDe; }
/// <summary> /// To check status of group role /// </summary> /// <param name="NGRID"></param> /// <returns></returns> private DataTable CheckGroupRoleStatus(int NGRID) { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtGrpRolSta = new DataTable(); try { DtGrpRolSta = GroupRoleBAL.SelectGroupRoleID(NGRID, LoginUser, Ret); } catch { throw; } finally { GroupRoleBAL = null; } return DtGrpRolSta; }
/// <summary> /// To get Group Role Details from database /// </summary> /// <param name="GroupRoleId"></param> /// <returns></returns> private DataTable GetGroupRoleDetails(int GroupRoleId) { GroupRoleBAL GroupRoleBAL = new GroupRoleBAL(); DataTable DtGrpRolDe = new DataTable(); try { DtGrpRolDe = GroupRoleBAL.SelectGroupRoleID(GroupRoleId, LoginUser, Ret); } catch { } finally { GroupRoleBAL = null; } return DtGrpRolDe; }
private DataTable getRoledetails(int Groupid) { GroupRoleBAL gr = new GroupRoleBAL(); DataTable dTable = new DataTable(); try { dTable = gr.SelectGroupID(true, Groupid, LoginUser, Ret); } catch { } finally { gr = null; } return dTable; }