public ActionResult Create([Bind(Include = "TechId,TechnologyName,Level_Id,Cost_Id")] TechnologyViewModel technologyViewModel) { //Get database values var dbTechnologyLevel = db.TechnologyLevel.ToList(); var dbCost = db.Cost.ToList(); //Make selectlist, which is IEnumerable<SelectListItem> var LevelDropdownList = new SelectList(db.TechnologyLevel.Select(item => new SelectListItem() { Text = item.LevelNumber.ToString(), Value = item.LevelNumber.ToString() }).ToList(), "Value", "Text"); var CostDropdownList = new SelectList(db.Cost.Select(item => new SelectListItem() { Text = item.Cost.ToString(), Value = item.Cost.ToString() }).ToList(), "Value", "Text"); if (ModelState.IsValid) { db.Technology.Add(technologyViewModel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(technologyViewModel)); }
private IHttpActionResult Inserttechnology(TechnologyViewModel TechnologyVM) { try { if (!IsNametechnologyAvailble(TechnologyVM.Name, TechnologyVM)) { return(Json(new { Result = "ERROR", Message = "technology Name already exists" })); } Technology TechnologyADD = new Technology { Name = TechnologyVM.Name, IsActive = TechnologyVM.IsActive }; _repository.TechnologyRepository.Add(TechnologyADD); if (_repository.TechnologyRepository.Save((WindowsPrincipal)User) > 0) { var Record = _repository.TechnologyRepository.GetField(TechnologyADD.ID); return(Json(new { Result = "OK", Record = TechnologyADD })); } else { return(Json(new { Result = "ERROR", Message = Errors.MessageError })); } } catch (Exception ex) { return(Json(new { Result = "ERROR", Message = Errors.Write(ex) })); } }
private IHttpActionResult Updatetechnology(TechnologyViewModel TechnologyVM) { try { if (!IsNametechnologyAvailble(TechnologyVM.Name, TechnologyVM)) { return(Json(new { Result = "ERROR", Message = "technology Name already exists" })); } Technology TechnologyUpdated = _repository.TechnologyRepository.Find(TechnologyVM.ID); TechnologyUpdated.Name = TechnologyVM.Name; TechnologyUpdated.IsActive = TechnologyVM.IsActive; _repository.TechnologyRepository.Edit(TechnologyUpdated); if (_repository.TechnologyRepository.Save((WindowsPrincipal)User) > 0) { var Record = _repository.TechnologyRepository.GetField(TechnologyVM.ID); return(Json(new { Result = "OK", Record = Record })); } else { return(Json(new { Result = "ERROR", Message = Errors.MessageError })); } } catch { return(Json(new { Result = "ERROR", Message = Errors.MessageError })); } }
public static Technology MapingTechnology(TechnologyViewModel technology) { return(new Technology() { Name = technology.Name }); }
public async Task <IActionResult> Index(int thePage = 1) //Index { //VM instance TechnologyViewModel technologyVM = new TechnologyViewModel { Technologies = await repositoryTech.Technologies.AsQueryable() //with projects relations .Include(i => i.TechnologiesProjects) .ThenInclude(i => i.Project) //with literature relations .Include(i => i.LiteraturesTechnologies) .ThenInclude(i => i.Literature) .OrderBy(i => i.Name) .Skip((thePage - 1) * PageSize) .Take(PageSize) .ToListAsync(), PagingInfo = new PagingInfoViewModel { CurrentPage = thePage, ItemsPerPage = PageSize, TotalItems = repositoryTech.Technologies.Count() } }; return(View(technologyVM)); }
public IActionResult GetTechnologies() { var result = new TechnologyViewModel { Languages = new List <TechnologyModel>(), Frameworks = new List <TechnologyModel>(), Databases = new List <TechnologyModel>() }; try { var technologies = this.technologyService.GetAll(); if (technologies != null && technologies.Any()) { result.Languages = technologies.Where(l => l.TechnologyType == 1).ToList(); result.Frameworks = technologies.Where(l => l.TechnologyType == 2).ToList(); result.Databases = technologies.Where(l => l.TechnologyType == 3).ToList(); } } catch (Exception e) { return(BadRequest(e.Message)); } return(Ok((new { technologies = result }))); }
public static ResponseResult Delete(TechnologyViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XBC_Context()) { t_technology tec = db.t_technology .Where(t => t.id == entity.id) .FirstOrDefault(); if (tec != null) { object data = new { tec.id, tec.name, tec.notes, tec.is_delete }; var json = new JavaScriptSerializer().Serialize(data); t_audit_log log = new t_audit_log(); log.type = "Modify"; log.json_before = json; log.created_by = entity.UserId; log.created_on = DateTime.Now; tec.is_delete = true; tec.deleted_by = entity.UserId; tec.deleted_on = DateTime.Now; object data2 = new { tec.id, tec.name, tec.notes, tec.is_delete }; var json2 = new JavaScriptSerializer().Serialize(data2); log.json_after = json2; db.t_audit_log.Add(log); db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.ErrorMessage = "Technology Not Found"; } } } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
// GET: TechnologyViewModels/Create public ActionResult Create() { //Get database values var dbTechnologyLevel = db.TechnologyLevel.ToList(); var dbCost = db.Cost.ToList(); //Make selectlist, which is IEnumerable<SelectListItem> var LevelDropdownList = new SelectList(db.TechnologyLevel.Select(item => new SelectListItem() { Text = item.LevelNumber.ToString(), Value = item.LevelNumber.ToString() }).ToList(), "Value", "Text"); var CostDropdownList = new SelectList(db.Cost.Select(item => new SelectListItem() { Text = item.Cost.ToString(), Value = item.Cost.ToString() }).ToList(), "Value", "Text"); // Assign the Selectlist to the View Model var ViewTech = new TechnologyViewModel() { //TechnologyLevel = dbTechnologyLevel.FirstOrDefault(), //Cost = dbCost.FirstOrDefault(), // The Dropdownlist values TechLevelDropDownList = LevelDropdownList, CostDropDownList = CostDropdownList, }; return(View(ViewTech)); }
public ActionResult Save([DataSourceRequest] DataSourceRequest dsRequest, TechnologyViewModel technology) { var technologies = _technologyService.GetAllTechnologies().Where(model => model.TechnologyName == technology.TechnologyName && model.TechnologyId != technology.TechnologyId); if (technologies.Any()) { ModelState.AddModelError(string.Empty, "The Technology already exists, please create with other name."); } if (technology != null) { var userEmailId = User.Identity.Name; var user = _containerUserService.FindUserByEmail(userEmailId); if (user != null) { technology.CreatedBy = user.ID; technology.CreatedDate = DateTime.Now; technology.IsActive = true; technology.Description = HttpUtility.HtmlDecode(technology.Description); var technologyBusinessModel = _mappingService.Map <TechnologyViewModel, TechnologyBusinessModel>(technology); _technologyService.Add(technologyBusinessModel); } return(Json(technology)); } return(Json(true)); }
public ActionResult DeleteConfirmed(int id) { TechnologyViewModel technologyViewModel = db.Technology.Find(id); db.Technology.Remove(technologyViewModel); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "TechId,TechnologyName")] TechnologyViewModel technologyViewModel) { if (ModelState.IsValid) { db.Entry(technologyViewModel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(technologyViewModel)); }
public async Task <TechnologyViewModel> GetByNameAsync(string TechnologyName) { TechnologyViewModel tech = new TechnologyViewModel(); using (_repository = new TechnologyRepository()) { tech = Mapper.MapingTechnologyViewModel(await _repository.GetByNameAsync(TechnologyName)); } return(tech); }
public async Task <TechnologyViewModel> GetByIdAsync(int id) { TechnologyViewModel sd = new TechnologyViewModel(); using (_repository = new TechnologyRepository()) { sd = Mapper.MapingTechnologyViewModel(await _repository.GetByIDAsync(id)); } return(sd); }
public static LessonViewModel MapingLessonViewModel(DateTime startingDate, DateTime endingDate, int technologyViewModelId, TechnologyViewModel technologyViewModel) { return(new LessonViewModel() { StartingDate = startingDate, EndingDate = endingDate, }); }
public ActionResult Delete(TechnologyViewModel model) { ResponResultViewModel result = TechnologyRepo.Update2(model); return(Json(new { success = result.Success, message = result.Message, entity = result.Entity }, JsonRequestBehavior.AllowGet)); }
public static ResponResultViewModel Update2(TechnologyViewModel entity) { //untuk create dan edit ResponResultViewModel result = new ResponResultViewModel(); try { using (var db = new MinProContext()) { if (entity.id == 0) { t_technology technology = new t_technology(); technology.name = entity.name; technology.notes = entity.notes; technology.active = entity.active; technology.created_by = 1; technology.created_on = DateTime.Now; db.t_technology.Add(technology); db.SaveChanges(); result.Entity = technology; } else { t_technology technology = db.t_technology.Where(o => o.id == entity.id).FirstOrDefault(); if (technology != null) { technology.name = entity.name; technology.notes = entity.notes; technology.active = false; technology.created_by = 1; technology.created_on = DateTime.Now; db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.Message = "technology not found!"; } } } } catch (Exception e) { result.Success = false; result.Message = e.Message; } return(result); }
public bool IstechnologyExists(TechnologyViewModel technology) { try { bool IsOrder = _repository.TechnologyRepository.Any(cc => cc.ID == technology.ID); return(IsOrder); } catch (Exception) { return(false); } }
public bool IsNametechnologyAvailble(string Name, TechnologyViewModel technology) { try { bool IsOrder = !_repository.TechnologyRepository.Any(cc => cc.Name.Trim().ToLower() == Name.Trim().ToLower() && cc.ID != technology.ID); return(IsOrder); } catch (Exception) { return(true); } }
// GET: TechnologyViewModels/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TechnologyViewModel technologyViewModel = db.Technology.Find(id); if (technologyViewModel == null) { return(HttpNotFound()); } return(View(technologyViewModel)); }
public ActionResult AddTechnology(TechnologyViewModel technology) { Technology tech = Mapper.Map <TechnologyViewModel, Technology>(technology); ApplicationDbContext db = new ApplicationDbContext(); tech.ShowInCv = false; tech.LevelOfKnowledge = 2; db.Technologies.Add(tech); db.SaveChanges(); return(RedirectToAction("TechnologiesView")); }
public ActionResult Update([DataSourceRequest] DataSourceRequest dsRequest, TechnologyViewModel technology) { if (technology != null) { var userEmailId = User.Identity.Name; var user = _containerUserService.FindUserByEmail(userEmailId); if (user != null) { technology.ModifiedBy = user.ID; technology.ModifiedDate = DateTime.Now; technology.IsActive = true; technology.Description = HttpUtility.HtmlDecode(technology.Description); var technologyBusinessModel = _mappingService.Map <TechnologyViewModel, TechnologyBusinessModel>(technology); _technologyService.Update(technologyBusinessModel); } } return(Json(true)); }
// POST api/technology public IHttpActionResult Post([FromBody] TechnologyViewModel TechnologyVM) { //Update or Create try { if (IstechnologyExists(TechnologyVM)) { return(Inserttechnology(TechnologyVM)); } else { return(Updatetechnology(TechnologyVM)); } } catch (Exception ex) { return(Json(new { Result = "ERROR", Message = Errors.Write(ex) })); } }
public ActionResult Delete(TechnologyViewModel viewModel) { try { if (ModelState.IsValid) { var entity = Mapper.Map <TechnologyViewModel, Technology>(viewModel); _technologyService.Delete(entity); return(RedirectToAction("Index")); } } catch (Exception e) { ModelState.AddModelError("", e.Message); } return(View(viewModel)); }
public ActionResult Technology(string id) { string technologyName = id; string patternsFilePath = Server.MapPath("~/App_Data/") + technologyName + "StringPatterns.txt"; FileStream patternsFile = new FileStream(patternsFilePath, FileMode.Open); ITechnology technology = new Technology("technologyName", patternsFile); string sitesFilePath = Server.MapPath("~/App_Data/") + technologyName + "SitesURLs.txt"; FileStream sitesFile = new FileStream(sitesFilePath, FileMode.Open); SitesLoader sitesLoader = new SitesLoader(sitesFile); TechnologyFinder finder = new TechnologyFinder(technology, sitesLoader.SitesURLs); finder.RunCrawler(); TechnologyViewModel model = new TechnologyViewModel(); model.Name = technology.Name; model.URLs = finder.SiteURLsWithTheTechnology; ViewData["Title"] = technologyName; ViewData["Message"] = "It's the " + technologyName + " message to view page"; return View(model); }
//GetById public static TechnologyViewModel ById(long id) { TechnologyViewModel result = new TechnologyViewModel(); using (var db = new XBC_Context()) { result = (from tec in db.t_technology where tec.id == id && tec.is_delete == false select new TechnologyViewModel { id = tec.id, name = tec.name, notes = tec.notes, created_by = tec.created_by }).FirstOrDefault(); if (result == null) { result = new TechnologyViewModel(); } return(result); } }
public static TechnologyViewModel GetTechnology(long id) { TechnologyViewModel result = new TechnologyViewModel(); using (var db = new MinProContext()) { result = (from tc in db.t_technology where tc.id == id select new TechnologyViewModel { id = tc.id, name = tc.name, notes = tc.notes, active = tc.active }).FirstOrDefault(); if (result == null) { result = new TechnologyViewModel(); } } return(result); }
public static ResponseResult Update(TechnologyViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XBC_Context()) { //Create if (entity.id == 0) { t_technology tec = new t_technology(); tec.name = entity.name; tec.notes = entity.notes; tec.is_delete = entity.is_delete; tec.created_by = entity.UserId; tec.created_on = DateTime.Now; db.t_technology.Add(tec); db.SaveChanges(); entity.id = tec.id; foreach (var item in entity.Details) { t_technology_trainer ttr = new t_technology_trainer(); ttr.technology_id = entity.id; ttr.trainer_id = item.id; ttr.created_by = entity.UserId; ttr.created_on = DateTime.Now; db.t_technology_trainer.Add(ttr); db.SaveChanges(); object datattr = new { ttr.id, ttr.trainer_id, ttr.technology_id }; var jsonttr = new JavaScriptSerializer().Serialize(datattr); t_audit_log logttr = new t_audit_log(); logttr.type = "Insert"; logttr.json_insert = jsonttr; logttr.created_by = entity.UserId; logttr.created_on = DateTime.Now; db.t_audit_log.Add(logttr); db.SaveChanges(); } object data = new { tec.id, tec.name, tec.notes }; var json = new JavaScriptSerializer().Serialize(data); t_audit_log log = new t_audit_log(); log.type = "Insert"; log.json_insert = json; log.created_by = entity.UserId; log.created_on = DateTime.Now; db.t_audit_log.Add(log); db.SaveChanges(); result.Entity = entity; } //Edit else { t_technology tec = db.t_technology .Where(t => t.id == entity.id) .FirstOrDefault(); if (tec != null) { object data = new { tec.id, tec.name, tec.notes }; var json = new JavaScriptSerializer().Serialize(data); t_audit_log log = new t_audit_log(); log.type = "Modify"; log.json_before = json; log.created_by = entity.UserId; log.created_on = DateTime.Now; tec.name = entity.name; tec.notes = entity.notes; tec.modified_by = entity.UserId; tec.modified_on = DateTime.Now; entity.id = tec.id; if (entity.Details != null) { foreach (var item in entity.Details) { t_technology_trainer ttr = new t_technology_trainer(); ttr.technology_id = entity.id; ttr.trainer_id = item.id; ttr.created_by = entity.UserId; ttr.created_on = DateTime.Now; db.t_technology_trainer.Add(ttr); object datattr = new { ttr.id, ttr.trainer_id, ttr.technology_id }; var jsonttr = new JavaScriptSerializer().Serialize(datattr); t_audit_log logttr = new t_audit_log(); logttr.type = "Insert"; logttr.json_insert = jsonttr; logttr.created_by = entity.UserId; logttr.created_on = DateTime.Now; db.t_audit_log.Add(logttr); } } object data2 = new { tec.id, tec.name, tec.notes }; var json2 = new JavaScriptSerializer().Serialize(data2); log.json_after = json2; db.t_audit_log.Add(log); db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.ErrorMessage = "Technology Not Found!"; } } } } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public ActionResult Index() { TechnologyViewModel model = new TechnologyViewModel(); return(View(model)); }
// GET: Home public ActionResult Index() { PostViewModel postViewModel = new PostViewModel(); var homePost = postManager.GetAll().OrderByDescending(c => c.Id); var politicsPost = homePost.Where(c => c.Category.Name == "Politics"); var datas = homePost.OrderByDescending(c => c.Id).FirstOrDefault(c => c.Category.Name == "Politics"); BannerViewModel bannerViewModel = new BannerViewModel() { Id = datas.Id, Title = datas.Title, Description = datas.Description, ImagePath = datas.ImagePath, Tags = datas.Tags, PostDate = datas.PostDate }; List <SiteBannerViewModel> siteBannerViewModels = new List <SiteBannerViewModel>(); var siteBannder = homePost.Where(c => c.Category.Name == "Politics").OrderByDescending(c => c.Id).Skip(1).Take(2); foreach (var data in siteBannder) { var siteBannerVM = new SiteBannerViewModel() { Id = data.Id, Title = data.Title, Description = data.Description, ImagePath = data.ImagePath }; siteBannerViewModels.Add(siteBannerVM); } /*banner Bottom post*/ List <BannerBottomViewModel> bannerBottomViewModels = new List <BannerBottomViewModel>(); var BannerBottom = homePost.Where(c => c.Category.Name == "Politics").OrderByDescending(c => c.Id).Skip(3).Take(4); foreach (var data in BannerBottom) { var bannerBottomVM = new BannerBottomViewModel() { Id = data.Id, Title = data.Title, Description = data.Description, ImagePath = data.ImagePath, PostDate = data.PostDate.ToString("d") }; bannerBottomViewModels.Add(bannerBottomVM); } postViewModel.BannerBottomViewModels = bannerBottomViewModels; /*banner Bottom post*/ /*latest Post */ List <LatestPostViewModel> latestPostViewModels = new List <LatestPostViewModel>(); var latestPost = homePost.Where(c => c.Category.Name == "Politics").OrderByDescending(c => c.Id).Skip(7).Take(7); foreach (var data in latestPost) { var latestPostVM = new LatestPostViewModel() { Id = data.Id, Title = data.Title, Description = data.Description, ImagePath = data.ImagePath }; latestPostViewModels.Add(latestPostVM); } postViewModel.LatestPostViewModels = latestPostViewModels; /*latest Post */ /*popular Post */ var popularPost = homePost.Skip(14).Take(4); List <PopularPostViewModel> popularPostViewModels = new List <PopularPostViewModel>(); foreach (var data in popularPost) { var popularPostVM = new PopularPostViewModel() { Id = data.Id, Title = data.Title, PostDate = data.PostDate.ToString("d"), ImagePath = data.ImagePath, Category = data.Category }; popularPostViewModels.Add(popularPostVM); } postViewModel.PopularPostViewModels = popularPostViewModels; /*popular Post */ /*Sports Post */ var entertainmentPost = homePost.Where(c => c.Category.Name == "Entertainment").OrderByDescending(c => c.Id).Take(4); List <EntertainmentViewModel> entertainmentViewModels = new List <EntertainmentViewModel>(); foreach (var data in entertainmentPost) { var entertainmentVM = new EntertainmentViewModel() { Id = data.Id, Title = data.Title, ImagePath = data.ImagePath, Description = data.Description, PostDate = data.PostDate.ToString("D") }; entertainmentViewModels.Add(entertainmentVM); } postViewModel.EntertainmentViewModels = entertainmentViewModels; /*Sports Post */ /*Sports Post */ var sportsPost = homePost.Where(c => c.Category.Name == "Sports").OrderByDescending(c => c.Id).Take(4); List <SportsViewModel> sportsViewModels = new List <SportsViewModel>(); foreach (var data in sportsPost) { var sportsVM = new SportsViewModel() { Id = data.Id, Title = data.Title, ImagePath = data.ImagePath, Description = data.Description, PostDate = data.PostDate.ToString("D") }; sportsViewModels.Add(sportsVM); } postViewModel.SportsViewModels = sportsViewModels; /*Sports Post */ /*technology Post */ var techPost = homePost.OrderByDescending(c => c.Id).FirstOrDefault(c => c.Category.Name == "Technology"); TechnologyViewModel technologyViewModel = new TechnologyViewModel() { Id = techPost.Id, Title = techPost.Title, Description = techPost.Description, PostDate = techPost.PostDate.ToString("D"), ImagePath = techPost.ImagePath }; postViewModel.TechnologyViewModel = technologyViewModel; /*technology Post */ /*education Post */ var educationPost = homePost.OrderByDescending(c => c.Id).FirstOrDefault(c => c.Category.Name == "Education"); EducationViewModel educationViewModel = new EducationViewModel() { Id = educationPost.Id, Title = educationPost.Title, Description = educationPost.Description, ImagePath = educationPost.ImagePath, PostDate = educationPost.PostDate.ToString("D") }; postViewModel.EducationViewModel = educationViewModel; /*education Post */ /*travel Post */ var travelPost = homePost.OrderByDescending(c => c.Id).FirstOrDefault(c => c.Category.Name == "Travel"); TravelViewModel travelViewModel = new TravelViewModel() { Id = travelPost.Id, Title = travelPost.Title, Description = travelPost.Description, ImagePath = travelPost.ImagePath, PostDate = travelPost.PostDate.ToString("D") }; postViewModel.TravelViewModel = travelViewModel; /*travel Post */ /*food Post */ var foodPost = homePost.OrderByDescending(c => c.Id).FirstOrDefault(c => c.Category.Name == "Food"); FoodViewModel foodViewModel = new FoodViewModel() { Id = foodPost.Id, Title = foodPost.Title, Description = foodPost.Description, ImagePath = foodPost.ImagePath, PostDate = foodPost.PostDate.ToString("D") }; postViewModel.FoodViewModel = foodViewModel; /*food Post */ /*health Post */ var healthPost = homePost.OrderByDescending(c => c.Id).FirstOrDefault(c => c.Category.Name == "Health"); HealthViewModel healthViewModel = new HealthViewModel() { Id = healthPost.Id, Title = healthPost.Title, Description = healthPost.Description, ImagePath = healthPost.ImagePath, PostDate = healthPost.PostDate.ToString("D") }; postViewModel.HealthViewModel = healthViewModel; /*health Post */ /*economics Post */ var economicsPost = homePost.OrderByDescending(c => c.Id).FirstOrDefault(c => c.Category.Name == "Economics"); EconomicsViewModel economicsViewModel = new EconomicsViewModel() { Id = economicsPost.Id, Title = economicsPost.Title, Description = economicsPost.Description, ImagePath = economicsPost.ImagePath, PostDate = economicsPost.PostDate.ToString("D") }; postViewModel.EconomicsViewModel = economicsViewModel; /*economics Post */ postViewModel.BannerViewModel = bannerViewModel; postViewModel.SiteBannerViewModels = siteBannerViewModels; return(View(postViewModel)); }