public IHttpActionResult PutSalesTrend(int id, int tid, [FromBody] SalesTrendInterfaceModel model)
{
if (tid == 0 || model == null || model.Id == 0)
{
return(BadRequest());
}
var result = service.ModifySalesTrend(id, tid, model);
if (result.Code == HttpStatusCode.OK)
{
return(Content(result.Code, result.message));
}
return(Ok(result.resultData));
}
public RepositoryResult <SalesTrendInterfaceModel> ModifySalesTrend(int productId, int trendId, SalesTrendInterfaceModel modifiedSalesTrend)
{
if (productId == 0 || trendId == 0 || modifiedSalesTrend == null || modifiedSalesTrend.Id == 0)
{
return(new RepositoryResult <SalesTrendInterfaceModel>(HttpStatusCode.BadRequest));
}
using (DataContext dbContext = DataContext.Create())
{
var work = dbContext.SalesTrendModels.Where(st => st.Id == trendId).Where(st => st.ProductModelId == productId).SingleOrDefault();
if (work == null)
{
return(new RepositoryResult <SalesTrendInterfaceModel>(HttpStatusCode.NotFound));
}
work.TargetDate = modifiedSalesTrend.Detail_date;
work.Sales = modifiedSalesTrend.Quantity;
work.Comments = modifiedSalesTrend.Comments;
work.UserModelId = modifiedSalesTrend.User_id;
if (dbContext.SaveChanges() == 0)
{
return(new RepositoryResult <SalesTrendInterfaceModel>(HttpStatusCode.BadRequest));
}
var result = GetSalesTrandsByIdForInterface(productId, work.Id);
if (result.Code != HttpStatusCode.OK)
{
return(new RepositoryResult <SalesTrendInterfaceModel>(HttpStatusCode.OK));
}
return(new RepositoryResult <SalesTrendInterfaceModel>(HttpStatusCode.OK, result.resultData));
}
}
public RepositoryResult <SalesTrendInterfaceModel> CreateSalesTrend(int productId, SalesTrendInterfaceModel createSalesTrend)
{
if (createSalesTrend == null || createSalesTrend.Id != 0)
{
return(new RepositoryResult <SalesTrendInterfaceModel>(HttpStatusCode.BadRequest));
}
using (DataContext dbContext = DataContext.Create())
{
var addmodel = new SalesTrendModel();
addmodel.ProductModelId = createSalesTrend.Product_id;
addmodel.TargetDate = createSalesTrend.Detail_date.Date;
addmodel.Sales = createSalesTrend.Quantity;
addmodel.Comments = createSalesTrend.Comments;
addmodel.UserModelId = createSalesTrend.User_id;
addmodel.Deleted = false;
dbContext.Database.ExecuteSqlCommand(ServiceResource.IncrementResetSalesTrend);
dbContext.SalesTrendModels.Add(addmodel);
if (dbContext.SaveChanges() == 0)
{
return(new RepositoryResult <SalesTrendInterfaceModel>(HttpStatusCode.BadRequest));
}
dbContext.Database.ExecuteSqlCommand(ServiceResource.IncrementResetSalesTrend);
var result = GetSalesTrandsByIdForInterface(productId, addmodel.Id);
if (result.Code != HttpStatusCode.OK)
{
return(new RepositoryResult <SalesTrendInterfaceModel>(HttpStatusCode.OK));
}
return(new RepositoryResult <SalesTrendInterfaceModel>(HttpStatusCode.OK, result.resultData));
}
}
