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 DeletePhotosByAppIDAndOsType(string appID, int osTpye)
{
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.WisAppPhotoTable.DeleteAppPhotoByAppID(appID, osTpye);
Db.Commit();
}
}
public void InsertSecurityUserAccount(SecurityUserAccount securityUserAccount)
{
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.SecurityUserAccountTable.Insert(securityUserAccount);
Db.Commit();
}
}
public void InsertPhotosByOsType(List <WisAppPhoto> wisAppPhotos)
{
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.WisAppPhotoTable.InsertAppPhoto(wisAppPhotos);
Db.Commit();
}
}
/// <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 InsertAppOs(WisAppOs wisAppOs)
{
bool inserted = false;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.WisAppOsTable.Insert(wisAppOs);
Db.Commit();
inserted = true;
}
return(inserted);
}
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);
}
/// <summary>
///
/// </summary>
/// <param name="wisAppList"></param>
/// <param name="wisAppUserList">更新授權名單 清單</param>
/// <returns></returns>
public bool ModifyAppName(WisAppList wisAppList, List <WisAppUserList> wisAppUserList)
{
bool isModified;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
isModified = Db.WisAppListTable.Update(wisAppList);
Db.WisAppUserListTable.DeleteByAppID(wisAppList.AppID);
Db.WisAppUserListTable.Insert(wisAppUserList);
Db.Commit();
}
return(isModified);
}
public bool InsertAppName(WisAppList wisAppList, List <WisAppUserList> wisAppUserList)
{
bool inserted = false;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
inserted = Db.WisAppListTable.Insert(wisAppList);
Db.WisAppUserListTable.DeleteByAppID(wisAppList.AppID);
Db.WisAppUserListTable.Insert(wisAppUserList);
Db.Commit();
inserted = true;
}
return(inserted);
}
public bool DisableAppOsStatusAndInsertAppOsAndPhotoAndOsOther(WisAppOs wisAppOs, List <WisAppPhoto> wisAppPhotos, List <WisAppOsOther> wisAppOsOthers)
{
bool inserted = false;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.WisAppOsTable.DisabledAppOsStatus(wisAppOs.AppID, wisAppOs.OSType);
int getAppOsID = Db.WisAppOsTable.Insert(wisAppOs);
Db.WisAppPhotoTable.DeleteAppPhotoByAppID(wisAppOs.AppID, wisAppOs.OSType);
Db.WisAppPhotoTable.InsertAppPhoto(wisAppPhotos);
//多載點新增
wisAppOsOthers.ForEach(p => p.AppOsID = getAppOsID);
Db.WisAppOsOtherTable.InsertAppOsOther(wisAppOsOthers);
Db.Commit();
inserted = true;
}
return(inserted);
}
public bool DisableAppOsStatusAndModifyAppOsAndPhotoAndOsOther(WisAppOs wisAppOs, List <WisAppPhoto> wisAppPhotos, List <WisAppOsOther> wisAppOsOthers)
{
bool isModify = false;
using (IMcpDataBaseRepository Db = new McpDataBaseRepository(_connectionProvider))
{
Db.WisAppOsTable.DisabledAppOsStatus(wisAppOs.AppID, wisAppOs.OSType);
isModify = Db.WisAppOsTable.Update(wisAppOs);
Db.WisAppPhotoTable.DeleteAppPhotoByAppID(wisAppOs.AppID, wisAppOs.OSType);
Db.WisAppPhotoTable.InsertAppPhoto(wisAppPhotos);
//多載點更新
Db.WisAppOsOtherTable.DeleteAppOsOther(wisAppOs.AppID, wisAppOs.AppOSID.ToString());
Db.WisAppOsOtherTable.InsertAppOsOther(wisAppOsOthers);
Db.Commit();
}
return(isModify);
}
public void Test_InsertAppOs()
{
//Arrange
WisAppOs wisAppOs = new WisAppOs
{
AppID = "TESTAPPID",
OSType = 1,
Version = "TEST",
PackageName = "TEST",
Status = true,
MultipleDownload = false
};
//Act
_targetObj.InsertAppOs(wisAppOs);
IConnectionProvider connectionProvider = new SqlConnectionProvider(_configContext.McpDb);
using (McpDataBaseRepository mcpDataBaseRepository = new McpDataBaseRepository(connectionProvider))
{
mcpDataBaseRepository.WisAppOsTable.DeleteAppOs("TESTAPPID");
mcpDataBaseRepository.Commit();
}
}