public SysManagementUnitCollection FetchAll()
{
SysManagementUnitCollection coll = new SysManagementUnitCollection();
Query qry = new Query(SysManagementUnit.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public SysManagementUnitCollection FetchByQuery(Query qry)
{
SysManagementUnitCollection coll = new SysManagementUnitCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public SysManagementUnitCollection FetchAll()
{
SysManagementUnitCollection coll = new SysManagementUnitCollection();
Query qry = new Query(SysManagementUnit.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static LIS.DAL.SysManagementUnitCollection GetSysManagementUnitCollection(long varIRole)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[Sys_ManagementUnit] INNER JOIN [tbl_RolesForUsers] ON [Sys_ManagementUnit].[PK_sBranchID] = [tbl_RolesForUsers].[FP_sBranchID] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysRole.Schema.Provider.Name);
cmd.AddParameter("@FP_sBranchID", varIRole, DbType.String);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
SysManagementUnitCollection coll = new SysManagementUnitCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static void SaveSysManagementUnitMap(long varIRole, SysManagementUnitCollection items)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [tbl_RolesForUsers] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysRole.Schema.Provider.Name);
cmdDel.AddParameter("@FP_sBranchID", varIRole, DbType.String);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (SysManagementUnit item in items)
{
TblRolesForUser varTblRolesForUser = new TblRolesForUser();
varTblRolesForUser.SetColumnValue("FP_sBranchID", varIRole);
varTblRolesForUser.SetColumnValue("FP_sBranchID", item.GetPrimaryKeyValue());
varTblRolesForUser.Save();
}
}
public SysManagementUnitCollection FetchByQuery(Query qry)
{
SysManagementUnitCollection coll = new SysManagementUnitCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public SysManagementUnitCollection FetchByID(object PkSBranchID)
{
SysManagementUnitCollection coll = new SysManagementUnitCollection().Where("PK_sBranchID", PkSBranchID).Load();
return coll;
}
public SysManagementUnitCollection FetchByID(object PkSBranchID)
{
SysManagementUnitCollection coll = new SysManagementUnitCollection().Where("PK_sBranchID", PkSBranchID).Load();
return(coll);
}