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);
}
