/// <summary>
/// 商品中心-获取商品总数
/// </summary>
/// <param name="brandId">品牌ID</param>
/// <param name="connectionStr">数据库连接字符串</param>
/// <param name="dbType">数据库类型；0:mysql;1:sqlserver;2:oracel</param>
/// <returns>商品总数</returns>
public ActionResult <CheckManagerModel.ApiResult <int> > GetRtlProdDetailCount(int brandId, string connectionStr, int dbType)
{
BllManager manager = new BllManager();
var s = manager.GetRtlProdDetailCount(brandId, connectionStr, dbType);
return(new CheckManagerModel.ApiResult <int>(s));
}
public void testGetNumberActorsByIdFilm(int idFilm)
{
BllManager bllManager = new BllManager();
Console.WriteLine("nombre d'acteur pour le fiml (" + idFilm + ") = " + bllManager.GetListActorsByIdFilm(idFilm));
Assert.Pass();
}
private void InitializeBllManager()
{
if (bll != null)
{
return;
}
bll = new BllManager(manager);
}
public void testGetListFilmTypesByIdFilm(int idFilm)
{
BllManager bllManager = new BllManager();
List <GenreDTO> genreDtos = bllManager.GetListFilmTypesByIdFilm(idFilm);
Console.WriteLine("Liste des genres pour le film : " + idFilm);
foreach (GenreDTO genreDto in genreDtos)
{
Console.WriteLine(genreDto);
}
Assert.Pass();
}
public ActionResult DeleteFilter(int filterId)
{
BllManager user = (BllManager)userService.Find(User.Identity.Name);
BllFilter filter = user.Filters.FirstOrDefault(x => x.Id == filterId);
if (filter == null)
{
throw new HttpException(404, "Page Not Found");
}
user.Filters.Remove(filter);
userService.Update(user);
return(RedirectToAction("Index"));
}
public ActionResult Filter(int filterId = 0)
{
BllFilter filter = null;
FilterViewModel filterModel;
if (filterId != 0)
{
BllManager user = (BllManager)userService.Find(User.Identity.Name);
filter = user.Filters.FirstOrDefault(x => x.Id == filterId);
}
filterModel = ExtractSkills(filter);
return(View("Filter", filterModel));
}
[TestCase(10)] //rien !
public void testGetFullFilmDetailsByIdFilm(int idFilm)
{
BllManager bllManager = new BllManager();
FullFilmDTO film = bllManager.GetFullFilmDetailsByIdFilm(idFilm);
if (film != null)
{
Console.WriteLine("Film pour l'id(" + idFilm + ") : \n" + film.ToStringAll());
}
else
{
Console.WriteLine("Pas de Film trouvé pour l'id : " + idFilm);
}
Assert.Pass();
}
public void TestGetFavoriteActors(int from, int to)
{
BllManager bllManager = new BllManager();
List <LightActorDTO> actors = bllManager.GetFavoriteActors(from, to).ToList();
Console.WriteLine("Acteur qui joue dans 2 films ou plus : de " + from + ", to " + to);
int i = 1;
foreach (LightActorDTO actor in actors)
{
Console.WriteLine("[" + i + "]" + actor);
i++;
}
Assert.Pass();
}
[TestCase(0, 25, 10)] //aucun film pour l'id 10
public void testGetListActorsByIdFilm(int from, int to, int idFilm)
{
BllManager bllManager = new BllManager();
List <LightActorDTO> lightActorDtos = bllManager.GetListActorsByIdFilm(from, to, idFilm).ToList();
Console.WriteLine("liste des acteurs pour le film : " + idFilm);
int i = 0;
foreach (LightActorDTO lightActorDto in lightActorDtos)
{
Console.WriteLine("[" + i + "]" + lightActorDto);
i++;
}
Assert.Pass();
}
public void testGetActorsFromTo(int from, int to)
{
BllManager bllManager = new BllManager();
List <ActorDTO> actors = bllManager.getActorsFromTo(from, to).ToList();
Console.WriteLine("Acteurs de " + from + " a " + to + " :");
int i = 1;
foreach (ActorDTO actor in actors)
{
Console.WriteLine("Acteurs [" + i + "]" + " : " + actor.ToStringWithFilms());
i++;
}
Console.WriteLine("Acteurs de : " + "Acteurs de " + from + " a " + to);
Assert.Pass();
}
public void testGetGenresFromTo(int from, int to)
{
BllManager bllManager = new BllManager();
List <GenreDTO> genres = bllManager.getGenresFromTo(from, to).ToList();
Console.WriteLine("Genres de " + from + " a " + to + " :");
int i = 1;
foreach (GenreDTO genre in genres)
{
Console.WriteLine("Genres [" + i + "]" + " : " + genre /*.ToStringWithFilms()*/);
i++;
}
Console.WriteLine("Genres de : " + "Genres de " + from + " a " + to);
Assert.Pass();
}
public void testGetFilmsFromTo(int from, int to)
{
BllManager bllManager = new BllManager();
List <FilmDTO> films = bllManager.getFilmsFromTo(from, to).ToList();
Console.WriteLine("Films de " + from + " a " + to + " :");
int i = 1;
foreach (FilmDTO film in films)
{
Console.WriteLine("Film [" + i + "]" + " : " + film.ToStringAll());
i++;
}
Console.WriteLine("fin de : " + "Films de " + from + " a " + to);
Assert.Pass();
}
private void SaveFilter(FilterViewModel model)
{
BllManager user = (BllManager)userService.Find(User.Identity.Name);
BllFilter filter = model.ToBal();
BllFilter userfilter = user.Filters.FirstOrDefault(x => x.Id == filter.Id);
if (userfilter == null)
{
user.Filters.Add(filter);
}
else
{
userfilter.Skills = filter.Skills;
userfilter.LastViewed = filter.LastViewed;
}
userService.Update(user);
}
public void testGetCommentsFromTo(int from, int to)
{
BllManager bllManager = new BllManager();
List <CommentDTO> comments = bllManager.getCommentsFromTo(from, to).ToList();
Console.WriteLine("Comments de " + from + " a " + to + " :");
int i = 1;
foreach (CommentDTO comment in comments)
{
Console.WriteLine("Comments [" + i + "]" + " : " + comment.ToStringWithFilm());
i++;
}
Console.WriteLine("Comments de : " + "Comments de " + from + " a " + to);
Assert.Pass();
}
public void testFindFilmsByPartialTitle(int from, int to, string titre)
{
BllManager bllManager = new BllManager();
IQueryable <FilmDTO> testNull = bllManager.FindFilmsByPartialTitle(from, to, titre);
Console.WriteLine("Liste des films dont le titre contient : " + titre);
if (testNull != null)
{
List <FilmDTO> films = testNull.ToList();
int i = 1;
Console.WriteLine("DEBUG nbr films = " + films.Count);
foreach (FilmDTO film in films)
{
Console.WriteLine("[" + i + "]\n" + film.ToStringAll());
i++;
}
}
}
public async Task <IActionResult> Index()
{
var manager = new BllManager();
Stopwatch sw = new Stopwatch();
sw.Start();
var list = await manager.GeBrandInfosAsycn("test");
sw.Stop();
var dd = sw.ElapsedMilliseconds;
sw.Restart();
var list1 = manager.GeBrandInfos("test");
sw.Stop();
var bb = sw.ElapsedMilliseconds;
return(View(list));
}
public async Task <ActionResult <string> > Get()
{
var manager = new BllManager();
Stopwatch sw = new Stopwatch();
sw.Start();
var list = await manager.GeBrandInfosAsycn("test");
sw.Stop();
var dd = sw.ElapsedMilliseconds;
sw.Restart();
var list1 = manager.GeBrandInfos("test");
sw.Stop();
var bb = sw.ElapsedMilliseconds;
return($"dd:{dd}/bb:{bb}");
}
[TestCase(0, 10, "a b c d")] //plus de 2 mots
public void testFindListFilmByPartialActorName(int from, int to, string nomActeur)
{
BllManager bllManager = new BllManager();
IQueryable <FilmDTO> testNull = bllManager.FindListFilmByPartialActorName(from, to, nomActeur);
Console.WriteLine("Liste des films dans lequel un acteur dont on donne un nom partiellement ou entierement : " + nomActeur);
if (testNull != null)
{
List <FilmDTO> films = testNull.ToList();
int i = 1;
Console.WriteLine("DEBUG nbr films = " + films.Count);
foreach (FilmDTO film in films)
{
Console.WriteLine("[" + i + "]\n" + film.ToStringAll());
i++;
}
}
Assert.Pass();
}
private static BllUser InitializeBalUserProperties(DalUser user)
{
BllUser balUser;
if (user is DalAdmin)
{
balUser = new BllAdmin();
}
else if (user is DalProgrammer)
{
DalProgrammer dalProgrammer = (DalProgrammer)user;
Dictionary <BllSkill, int> skillsDict = null;
if (dalProgrammer.Skills != null)
{
skillsDict = dalProgrammer.Skills.ToDictionary(k => k.Skill.ToBal(), v => v.Level);
}
balUser = new BllProgrammer()
{
Name = dalProgrammer.Name,
About = dalProgrammer.About,
BirthDate = dalProgrammer.BirthDate,
Photo = dalProgrammer.Photo,
ImageType = dalProgrammer.ImapeType,
Skills = skillsDict
};
}
else if (user is DalManager && ((DalManager)user).Filters != null)
{
balUser = new BllManager
{
Filters = ((DalManager)user).Filters.Select(f => f.ToBal()).ToList()
}
}
;
else
{
balUser = new BllUser();
}
return(balUser);
}
public ActionResult Browse(int Id = 0)
{
BllFilter filter;
if (Id != 0)
{
BllManager manager = (BllManager)userService.Find(User.Identity.Name);
filter = manager.Filters.FirstOrDefault(x => x.Id == Id);
}
else
{
filter = new BllFilter();
}
FilterViewModel filterViewModel = ExtractSkills(filter);
filterViewModel.LastViewed = DateTime.Now;
if (Id != 0)
{
SaveFilter(filterViewModel);
}
return(Browse(filterViewModel));
}
private void UpdateFilters(BllManager balManager)
{
var dbFilters = filterRepo.Get(x => x.UserId == balManager.Id);
foreach (var filter in balManager.Filters)
{
if (dbFilters.Any(x => x.Id == filter.Id))
{
filterRepo.Update(filter.ToDal(balManager.Id));
}
else
{
filterRepo.Create(filter.ToDal(balManager.Id));
}
}
foreach (var filter in dbFilters)
{
if (!balManager.Filters.Any(x => x.Id == filter.Id))
{
filterRepo.Remove(filter.Id);
}
}
}
public void testGetNumberActorsFromTo()
{
BllManager bllManager = new BllManager();
Console.WriteLine("nombre d'acteurs dans la bd = " + bllManager.getActorsFromTo());
}
// 选中或取消选中 Dpu 时执行的操作
private void treDpuCatalog_AfterCheck(object sender, TreeViewEventArgs e)
{
// 改变子节点的选中状态
if ((e.Action == TreeViewAction.ByMouse || actionTemp == TreeViewAction.ByMouse) && e.Node.Nodes.Count > 0)
{
foreach (TreeNode node in e.Node.Nodes)
{
actionTemp = TreeViewAction.ByMouse;
node.Checked = e.Node.Checked;
}
}
actionTemp = TreeViewAction.Unknown;
// 改变父节点的选中状态
if (e.Node.Parent != null)
{
if (!e.Node.Checked)
{
bool hasChecked = false;
foreach (TreeNode node in e.Node.Parent.Nodes)
{
if (node.Checked)
{
hasChecked = true;
break;
}
}
e.Node.Parent.Checked = hasChecked;
}
else
{
e.Node.Parent.Checked = true;
}
}
if ((e.Node.Tag as NodeTag).type == NodeType.Controller)
{
if (e.Node.Checked)
{
// 加载选中 Dpu 下的文档列表
BllManager bll = new BllManager(manager);
IList <Prj_Document> documents = bll.manager.DocumentCRUD.GetPrj_Documents_By_Prj_Controller_ID((e.Node.Tag as NodeTag).id);
foreach (Prj_Document doc in documents)
{
ListViewItem item = new ListViewItem(
new string[] {
doc.DocumentName.Substring(0, doc.DocumentName.IndexOf('-')).PadLeft(3, '0') + "-"
+ doc.DocumentName.Substring(doc.DocumentName.IndexOf('-') + 1).PadLeft(3, '0'),
doc.DocumentCaption
});
item.Tag = doc;
item.ToolTipText = doc.DocumentCaption;
this.lstPages.Items.Add(item);
}
}
else
{
// 移除对应 Dpu 的文档列表
IList <int> mastLeavedId = new List <int>();
for (int i = 0; i < this.lstPages.Items.Count;)
{
if (((Prj_Document)this.lstPages.Items[i].Tag).Prj_Controller_ID == (((NodeTag)e.Node.Tag).id))
{
this.lstPages.Items.Remove(this.lstPages.Items[i]);
}
else
{
i++;
}
}
}
}
}
public void testFindNumberFilmsByPartialTitle(string titre)
{
BllManager bllManager = new BllManager();
Console.WriteLine("Nombre de films dont le titre contient(" + titre + ") = " + bllManager.FindFilmsByPartialTitle(titre));
}
[TestCase("a b c d")] //plus de 2 mots
public void testNumberFindListFilmByPartialActorName(string nomActeur)
{
BllManager bllManager = new BllManager();
Console.WriteLine("nombre de films pour l'acteur dont le nom contient(" + nomActeur + ") = " + bllManager.FindListFilmByPartialActorName(nomActeur));
}
public void testGetNumberFavoriteActor()
{
BllManager bllManager = new BllManager();
Console.WriteLine("nombre d'acteur qui jouent dans au moins 2 films : " + bllManager.GetFavoriteActors());
}
/// <summary>
/// 商品中心-获取商品总数
/// </summary>
/// <param name="brandId">品牌ID</param>
/// <param name="connectionStr">数据库连接字符串</param>
/// <param name="dbType">数据库类型；0:mysql;1:sqlserver;2:oracel</param>
/// <returns>商品总数</returns>
public ActionResult <int> GetCrmPrdDetailCount(int brandId, string connectionStr, int dbType)
{
BllManager manager = new BllManager();
return(manager.GetCrmPrdDetailCount(brandId, connectionStr, dbType));
}
public void testGetNumberGenresFromTo()
{
BllManager bllManager = new BllManager();
Console.WriteLine("nombre de genres dans la bd = " + bllManager.getGenresFromTo());
}
public void testGetNumberCommentsFromTo()
{
BllManager bllManager = new BllManager();
Console.WriteLine("nombre de comments dans la bd = " + bllManager.getCommentsFromTo());
}
public ActorsController(BllManager bllManager)
{
_bllManager = bllManager;
}
