public void DeletePhotosByAppIDAndOsType(string appID, int osTpye)
{
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.WisAppPhotoTable.DeleteAppPhotoByAppID(appID, osTpye);
}
}
public void InsertPhotosByOsType(List <WisAppPhoto> wisAppPhotos)
{
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.WisAppPhotoTable.InsertAppPhoto(wisAppPhotos);
}
}
public void Test_InsertAppName()
{
//Arrange
WisAppList wisAppList = new WisAppList
{
AppID = "TESTAPPID",
AppName = "TEST",
Development = "TEST",
LastUpdateUser = "",
LastUpdateDT = DateTime.Now,
CreateDT = DateTime.Now,
CompanyApp = true,
};
List <WisAppUserList> wisAppUserList = new List <WisAppUserList>
{
new WisAppUserList {
AppID = "TESTAPPID", UserID = "TESTUSERID"
}
};
//Act
_targetObj.InsertAppName(wisAppList, wisAppUserList);
IConnectionProvider connectionProvider = new SqlConnectionProvider(_configContext.McpDb);
//做完後必須刪除假資料
using (McpDataBaseRepository mcpDataBaseRepository = new McpDataBaseRepository(connectionProvider))
{
mcpDataBaseRepository.WisAppListTable.Delete("TESTAPPID");
mcpDataBaseRepository.WisAppUserListTable.DeleteByAppID("TESTAPPID");
mcpDataBaseRepository.Commit();
}
}
public void InsertSecurityUserAccount(SecurityUserAccount securityUserAccount)
{
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.SecurityUserAccountTable.Insert(securityUserAccount);
Db.Commit();
}
}
public List <WisGroupUser> CheckIsAdminOrMember(string userId)
{
List <WisGroupUser> wisGroupUser;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
wisGroupUser = Db.WisGroupUserTable.FindGroupByUserId(userId);
}
return(wisGroupUser);
}
public List <MdsHrEmpData> GetHrEmpByUId(List <string> uid)
{
List <MdsHrEmpData> mdsHrEmpDatas;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
mdsHrEmpDatas = Db.MdsHrEmpDataTable.GetUId(uid);
}
return(mdsHrEmpDatas);
}
public List <AppListItem> InitGetAppList()
{
List <AppListItem> appLists;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
appLists = Db.WisAppListTable.GetAppList();
}
return(appLists);
}
/// <summary>
///
/// </summary>
/// <param name="appID"></param>
/// <param name="osType"></param>
/// <param name="version"></param>
/// <returns></returns>
public WisAppOs AppOsIsExisted(string appID, int osType, string version)
{
WisAppOs wisAppOs;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
wisAppOs = Db.WisAppOsTable.FindOsIsExisted(appID, osType, version);
}
return(wisAppOs);
}
public List <InSideOrOutSideApp> GetIsTopAppList()
{
List <InSideOrOutSideApp> inSideOrOutSideApps;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
inSideOrOutSideApps = Db.WisAppListTable.GetInsideAndOutsideApp();
}
return(inSideOrOutSideApps);
}
public bool FindSecurityUserAccount(string userId)
{
bool isFind;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
isFind = Db.SecurityUserAccountTable.FindAccountId(userId);
}
return(isFind);
}
public List <MdsHrEmpData> GetHrEmpByDept(List <string> groupID)
{
List <MdsHrEmpData> mdsHrEmpDatas;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
mdsHrEmpDatas = Db.MdsHrEmpDataTable.GetUIdByDeptID(groupID);
}
return(mdsHrEmpDatas);
}
public List <AppListItem> GetAppList(string sqlAppendStr, DynamicParameters parameters)
{
List <AppListItem> appLists;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
appLists = Db.WisAppListTable.SearchAppList(sqlAppendStr, parameters);
}
return(appLists);
}
public List <WisDefineGroup> GetSearchDefineGroup(List <string> groupID, string searchGroup)
{
List <WisDefineGroup> wisDefineGroups;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
wisDefineGroups = Db.WisDefineGroupTable.GetAvailableDefineGroupByGroupName(groupID, searchGroup);
}
return(wisDefineGroups);
}
public WisAppList GetAppName(string appID)
{
WisAppList wisAppList;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
wisAppList = Db.WisAppListTable.GetAppNameByAppID(appID);
}
return(wisAppList);
}
public List <WisAppPhoto> GetPhotos(string appID)
{
List <WisAppPhoto> wisAppPhotos;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
wisAppPhotos = Db.WisAppPhotoTable.GetAppPhotoByAppID(appID);
}
return(wisAppPhotos);
}
public AppListItem GetByAppIdAndAppOsId(string appID, string appOsID)
{
AppListItem appListItem;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
appListItem = Db.WisAppListTable.GetAppByAppIdAndAppOsId(appID, appOsID);
}
return(appListItem);
}
public List <WisAppOs> GetAppOs(string appID)
{
List <WisAppOs> wisAppOs;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
wisAppOs = Db.WisAppOsTable.GetAppEditAndHistoryByAppID(appID);
}
return(wisAppOs);
}
public WisAppOs CheckAppOsStatus(string appID, int appOsType)
{
WisAppOs wisAppOs;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
wisAppOs = Db.WisAppOsTable.FindAppOsStatusIsEnabled(appID, appOsType);
}
return(wisAppOs);
}
public List <McpCategory> GetCategory()
{
List <McpCategory> mcpCategories;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
mcpCategories = Db.McpCategoryTable.GetCategory();
}
return(mcpCategories);
}
public List <WisDefineGroup> GetDefineGroup(List <string> groupID)
{
List <WisDefineGroup> wisDefineGroups;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
wisDefineGroups = Db.WisDefineGroupTable.GetDefineGroup(groupID);
}
return(wisDefineGroups);
}
public List <AvailableAppList> GetAvailableApp(string sqlAppendStr, DynamicParameters parameters)
{
List <AvailableAppList> availableAppLists;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
availableAppLists = Db.WisAppListTable.GetAvailableApp(sqlAppendStr, parameters);
}
return(availableAppLists);
}
public List <WisAppOsOther> GetWisAppOsOther(string appID, string appOsID)
{
List <WisAppOsOther> wisAppOsOther;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
wisAppOsOther = Db.WisAppOsOtherTable.GetAppOsOther(appID, appOsID);
}
return(wisAppOsOther);
}
public bool AppNameIsExisted(string appname)
{
bool isExisted;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
isExisted = Db.WisAppListTable.AppNameisExisted(appname);
}
return(isExisted);
}
public bool ModifyAppOs(WisAppOs wisAppOs)
{
bool isModified;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
isModified = Db.WisAppOsTable.Update(wisAppOs);
}
return(isModified);
}
public List <MdsAdUserData> GetMdsAdUser(List <string> uID)
{
List <MdsAdUserData> mdsHrEmpData;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
mdsHrEmpData = Db.MdsAdUserDataTable.GetHrEmpByUid(uID);
}
return(mdsHrEmpData);
}
/// <summary>
///
/// </summary>
/// <param name="appID"></param>
/// <returns></returns>
public bool DeleteApp(string appID)
{
bool deleted = false;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
deleted = Db.WisAppListTable.DeleteAppByAppId(appID);
Db.Commit();
}
return(deleted);
}
public bool EnableOrDisableApp(string appOSID, string status)
{
bool updated = false;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
updated = Db.WisAppOsTable.EnableOrDisableApp(appOSID, status);
Db.Commit();
}
return(updated);
}
public bool DeleteAppFilePath(string appOsId)
{
bool deleted = false;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
deleted = Db.WisAppOsTable.DeleteFilePathByAppOsId(appOsId);
Db.Commit();
}
return(deleted);
}
public bool DeleteAppFileMultiple(string appID, string appOsId)
{
bool deleted = false;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.WisAppOsOtherTable.DeleteAppOsOther(appID, appOsId);
Db.Commit();
deleted = true;
}
return(deleted);
}
public bool InsertAppOs(WisAppOs wisAppOs)
{
bool inserted = false;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.WisAppOsTable.Insert(wisAppOs);
Db.Commit();
inserted = true;
}
return(inserted);
}
