public static void fillDropDownItems(System.Web.UI.WebControls.DropDownList ddl,UserGroup _userGroupObj)
{
try
{
//if (Branch.dropDownItems.Count < 1)
//{
// new BranchSelectDataByUser().getBranchDropDownItemsByUser(-1);
//}
UserGroup _u = new UserGroup();
_u = _userGroupObj;
new UserGroupSelect(_u).UserGroupDropDownList(_u._dropDownList);
ddl.DataSource = _u._dropDownList;
ddl.DataTextField = "Name";
ddl.DataValueField = "Value";
ddl.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
ddl = null;
}
}
public void fillListedUnitGroups(System.Web.UI.WebControls.ListBox lstbx)
{
UnitAndUnitGroupSelect _unitNGroup = new UnitAndUnitGroupSelect();
UserGroup ug = new UserGroup();
try
{
_unitNGroup.UserID = this._userID;
_unitNGroup.ComID = this._comID;
_unitNGroup.LoadListedUnitGroups(ug._dropDownList);
lstbx.DataSource = ug._dropDownList;
lstbx.DataTextField = "Name";
lstbx.DataValueField = "Value";
lstbx.DataBind();
}
catch (Exception ex)
{
ex.Message.ToString();
}
finally
{
_unitNGroup = null;
ug = null;
}
}
public NotListedGroupSelect(UserGroup _ugroup)
{
this.UsrGrp = _ugroup;
Command = @"SELECT groupID,groupName FROM tblGroup WHERE groupID NOT IN" +
@" (SELECT groupID FROM tblGroupWiseUnit WHERE unitID = :unitID)" +
@" AND tblGroup.comID= :comID AND coalesce(isDelete,'0') != '1'" +
@" ORDER BY groupName ASC;";
}
public UserGroupSelect(UserGroup _userGroup)
{
this._usergrouppObj = _userGroup;
Command = "SELECT groupID,groupName FROM tblGroup WHERE coalesce(isDelete,'0') != '1'" +
"AND groupName != 'Administrator' AND comID = :comID ORDER BY groupName ASC;";
}
public GroupListSelect(UserGroup _ugroup)
{
this.UsrGrp = _ugroup;
Command = "SELECT groupID,groupName FROM tblGroup WHERE comID = :comID AND" +
" coalesce(isDelete,'0') != '1' ORDER BY groupName ASC;";
}
public makeUpdateParam(UserGroup _userGroup)
{
this._userGroup = _userGroup;
build();
}
public makeInsertParams(UserGroup _userGroup)
{
this._userGroup = _userGroup;
build();
}
public static void fillNotListedGroupList(System.Web.UI.WebControls.ListBox LstBox, UserGroup _UsrGroup)
{
try
{
UserGroup _UG = new UserGroup();
_UG = _UsrGroup;
new NotListedGroupSelect(_UG).LoadNotListedGroupList(_UG._dropDownList);
LstBox.DataSource = _UG._dropDownList;
LstBox.DataTextField = "Name";
LstBox.DataValueField = "Value";
LstBox.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
//LstBox = null;
}
}