public TblManagementUnitCollection FetchByID(object PkSBranchID)
{
TblManagementUnitCollection coll =
new TblManagementUnitCollection().Where("PK_sBranchID", PkSBranchID).Load();
return(coll);
}
public TblManagementUnitCollection FetchByQuery(Query qry)
{
var coll = new TblManagementUnitCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public TblManagementUnitCollection FetchAll()
{
var coll = new TblManagementUnitCollection();
var qry = new Query(TblManagementUnit.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static TblManagementUnitCollection GetTblManagementUnitCollection(string varPkSuid)
{
var cmd =
new QueryCommand(
"SELECT * FROM [dbo].[tbl_ManagementUnit] INNER JOIN [tbl_RolesForUsers] ON [tbl_ManagementUnit].[PK_sBranchID] = [tbl_RolesForUsers].[FP_sBranchID] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID",
Schema.Provider.Name);
cmd.AddParameter("@FP_sBranchID", varPkSuid, DbType.String);
IDataReader rdr = DataService.GetReader(cmd);
var coll = new TblManagementUnitCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static void SaveTblManagementUnitMap(string varPkSuid, TblManagementUnitCollection items)
{
var coll = new QueryCommandCollection();
//delete out the existing
var cmdDel =
new QueryCommand(
"DELETE FROM [tbl_RolesForUsers] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID",
Schema.Provider.Name);
cmdDel.AddParameter("@FP_sBranchID", varPkSuid, DbType.String);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (TblManagementUnit item in items)
{
var varTblRolesForUser = new TblRolesForUser();
varTblRolesForUser.SetColumnValue("FP_sBranchID", varPkSuid);
varTblRolesForUser.SetColumnValue("FP_sBranchID", item.GetPrimaryKeyValue());
varTblRolesForUser.Save();
}
}
