public async Task <IActionResult> PostArticle([FromBody] NewDTO model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Article articulo = new Article { idcategoria = model.idcategoria, codigo = model.codigo, idempresa = model.idempresa, nombre = model.nombre, precio_venta = model.precio_venta, stock = model.stock, descripcion = model.descripcion, condicion = true, imagen = model.imagen }; _context.Articles.Add(articulo); try { await _context.SaveChangesAsync(); } catch (Exception ex) { return(BadRequest()); } return(Ok()); }
public NewDTO ConvertToDTO(New EF) { var DTO = new NewDTO() { NewsId = EF.NewsId, NDetail = EF.NDetail, NPostDate = EF.NPostDate, NPublicDate = EF.NPublicDate, NQuote = EF.NQuote, Nstatus = EF.Nstatus, NTitle = EF.NTitle, N_CategoryId = EF.N_CategoryId, N_WebmasterInfoId = EF.N_WebmasterInfoId, NAvatar = EF.NAvatar, NType = EF.NType }; if (EF.WebmasterInfo != null) { DTO.WebmasterInfoDTO = new ConvertDataWebmasterInfo().ConvertToDTO(EF.WebmasterInfo); } if (EF.Category != null) { DTO.CategoryDTO = new ConvertDataCategory().ConvertToDTO(EF.Category); } //convert to name type switch (EF.NType) { case (int)BU.Common.Enum.TypeNew.Hot: DTO.NameType = "Hot"; break; default: DTO.NameType = "Normal"; break; } //convert to name status switch (EF.Nstatus) { case (int)BU.Common.Enum.StatusNew.Active: DTO.NameStatus = "Active"; break; case (int)BU.Common.Enum.StatusNew.Block: DTO.NameStatus = "Dừng hoạt động"; break; default: DTO.NameStatus = "Deleted"; break; } return(DTO); }
//Insert public NewDTO Insert(NewDTO ndto) { try { return(convertData.ConvertToDTO(new NewDAO().Insert(convertData.ConvertToEF(ndto)))); } catch (Exception) { return(null); } }
public NewDTO GetDetail(int newsId) { var news = _context.News.Find(newsId); var newDTO = new NewDTO(); newDTO.address = news.Address; newDTO.title = news.Title; newDTO.shortContent = news.SortContent; newDTO.content = news.Content; return(newDTO); }
/// <summary> /// 新增 /// </summary> /// <param name="t_New"></param> /// <returns></returns> public long InsertNew(NewDTO t_New) { using (B2CDbContext ctx = new B2CDbContext()) { NewsEntity newsEntity = new NewsEntity(); newsEntity.NewsState = t_New.NewsState; newsEntity.Title = t_New.Title; newsEntity.Content = t_New.Content; ctx.News.Add(newsEntity); ctx.SaveChanges(); return(newsEntity.Id); } }
/// <summary> /// 更新new /// </summary> /// <param name="t_New"></param> /// <returns></returns> public long UpdateNew(NewDTO t_New) { using (B2CDbContext ctx = new B2CDbContext()) { BaseService <NewsEntity> bs = new BaseService <NewsEntity>(ctx); var NewEntitis = bs.GetAll().Where(u => u.Id == t_New.Id).SingleOrDefault(); NewEntitis.NewsState = t_New.NewsState; NewEntitis.Title = t_New.Title; NewEntitis.Content = t_New.Content; ctx.SaveChanges(); return(NewEntitis.Id); } }
//Insert public int Update(NewDTO ndto) { var result = 0; try { result = new NewDAO().Update(convertData.ConvertToEF(ndto)); return(result); } catch (Exception) { return(result); } }
public JsonResult CUNew(NewDTO ndto, int?typePost) { var resultMessage = ""; var resultStatus = "error"; var resultCode = 0; if (string.IsNullOrEmpty(ndto.NTitle) || string.IsNullOrEmpty(ndto.NQuote) || string.IsNullOrEmpty(ndto.NDetail) || string.IsNullOrEmpty(ndto.NAvatar) || ndto.N_CategoryId == null) { resultMessage = "Please enter all information"; } //typePost = 1: create new else if (typePost == 1) { ndto.NPostDate = DateTime.Now; ndto.N_WebmasterInfoId = 2; var insert = newmanage.Insert(ndto); if (insert != null) { resultCode = 1; resultMessage = "Done"; resultStatus = "success"; // string path = Server.MapPath("/Assets/template/SendMailToRegisterTinRao.html"); // ParameterizedThreadStart job = new ParameterizedThreadStart(SendEmail); // Thread thread = new Thread(job); // thread.Start(new EmailClient() { TieuDe = insert.NTitle, Path = path, newdto = insert }); } else { resultMessage = "Fail"; } } //typePost = 2: update new else { resultCode = newmanage.Update(ndto); if (resultCode == 1) { resultMessage = "Update successfull"; resultStatus = "success"; } else { resultMessage = "Fail"; } } return(Json(new { code = resultCode, message = resultMessage, status = resultStatus }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 指定id查询new /// </summary> /// <param name="t_newsId"></param> /// <returns></returns> public NewDTO SelectNewByID(long t_newsId) { using (B2CDbContext ctx = new B2CDbContext()) { BaseService <NewsEntity> bs = new BaseService <NewsEntity>(ctx); var NewEntitis = bs.GetAll().Where(u => u.Id == t_newsId).SingleOrDefault(); NewDTO newDTO = new NewDTO() { Id = NewEntitis.Id, Content = NewEntitis.Content, CreateDateTime = NewEntitis.CreateDateTime, NewsState = NewEntitis.NewsState, Title = NewEntitis.Title }; return(newDTO); } }
public int UpdateNew(NewDTO newDTO) { News news = _context.News.Find(newDTO.newId); news = NewsMapper.toNews(news, newDTO); news.ActiveFlag = 0; try { _context.SaveChanges(); var newsId = (_context.News.FirstOrDefault(x => x.Title == newDTO.title)).NewsId; AddImages(newsId, newDTO.baseImages); return(1); } catch { return(0); } }
public int AddNew(NewDTO newDTO) { News news = new News(); news = NewsMapper.toNews(news, newDTO); try { _context.News.Add(news); _context.SaveChanges(); var newsId = (_context.News.FirstOrDefault(x => x.Title == newDTO.title)).NewsId; AddImages(newsId, newDTO.baseImages); return(1); } catch { return(0); } }
public static News toNews(News news, NewDTO newDTO) { news.ProvincialId = newDTO.provincialId; news.DistrictId = newDTO.districtId; news.WardId = newDTO.wardId; news.StreetId = newDTO.streetId; news.HomeNum = newDTO.homeNum; news.Address = newDTO.address; news.CategoryId = newDTO.categoryId; news.Title = newDTO.title; news.SortContent = newDTO.shortContent; news.Content = newDTO.content; news.Price = newDTO.price; news.Area = newDTO.area; news.Sex = newDTO.sex; if (newDTO.newId == 0) { news.AccountId = newDTO.accountId; news.ActiveFlag = 0; news.StartDate = DateTime.Now; } var startMiliseconds = ((DateTimeOffset)news.StartDate).ToUnixTimeMilliseconds(); if (newDTO.type.Equals("day")) { var totalMiliseconds = startMiliseconds + newDTO.time * 86400000; var date = (new DateTime(1970, 1, 1)).AddMilliseconds(totalMiliseconds); news.EndDate = date; } else if (newDTO.type.Equals("week")) { var totalMiliseconds = startMiliseconds + newDTO.time * 7 * 86400000; var date = (new DateTime(1970, 1, 1)).AddMilliseconds(totalMiliseconds); news.EndDate = date; } else { var totalMiliseconds = startMiliseconds + newDTO.time * 30 * 86400000; var date = (new DateTime(1970, 1, 1)).AddMilliseconds(totalMiliseconds); news.EndDate = date; } return(news); }
public New ConvertToEF(NewDTO DTO) { var EF = new New() { NewsId = DTO.NewsId, NDetail = DTO.NDetail, NPostDate = DTO.NPostDate, NPublicDate = DTO.NPublicDate, NQuote = DTO.NQuote, Nstatus = DTO.Nstatus, NTitle = DTO.NTitle, N_CategoryId = DTO.N_CategoryId, N_WebmasterInfoId = DTO.N_WebmasterInfoId, NAvatar = DTO.NAvatar, NType = DTO.NType }; var a = EF.NDetail.Length; return(EF); }
/// <summary> /// 获取所有new /// </summary> /// <returns></returns> public NewDTO[] GetAllNew() { using (B2CDbContext ctx = new B2CDbContext()) { BaseService <NewsEntity> bs = new BaseService <NewsEntity>(ctx); var NewEntitis = bs.GetAll().ToList(); List <NewDTO> newDTOs = new List <NewDTO>(); foreach (var item in NewEntitis) { NewDTO newDTO = new NewDTO() { Id = item.Id, Content = item.Content, CreateDateTime = item.CreateDateTime, NewsState = item.NewsState, Title = item.Title }; newDTOs.Add(newDTO); } return(newDTOs.ToArray()); } }
public static NewDTO toDTO(News news) { var newDTO = new NewDTO(); newDTO.newId = news.NewsId; newDTO.accountId = news.AccountId; newDTO.provincialId = news.ProvincialId; newDTO.districtId = news.DistrictId; newDTO.wardId = news.WardId; newDTO.streetId = news.StreetId; newDTO.categoryId = news.CategoryId; newDTO.title = news.Title; newDTO.shortContent = news.SortContent; newDTO.content = news.Content; newDTO.address = news.Address; newDTO.homeNum = news.HomeNum; newDTO.price = news.Price; newDTO.area = news.Area; newDTO.sex = news.Sex; newDTO.type = "day"; newDTO.time = int.Parse((((((DateTimeOffset)news.EndDate).ToUnixTimeMilliseconds() - ((DateTimeOffset)news.StartDate).ToUnixTimeMilliseconds()) / 86400000)).ToString()) + 1; return(newDTO); }