public ActionResult Create(NewsTableModel newsTableModel)
{
try
{
NewsTable newsTable = new NewsTable
{
ID = newsTableModel.ID,
NewsDate = newsTableModel.NewsDate,
NewsHeadLine = newsTableModel.NewsHeadLine,
NewsText = newsTableModel.NewsText
};
if (ModelState.IsValid)
{
if (newsTable.ID > 0)
{
newsRepository.UpdateNews(newsTable);
}
else
{
newsRepository.InsertNews(newsTable);
}
}
else
{
return(View(newsTableModel));
}
return(RedirectToAction("Index"));
}
catch (Exception)
{
return(View(newsTableModel));
}
}
public NewsTable InsertNews(NewsTable newsTable)
{
var inserted = iTIDataEntities.NewsTables.Add(newsTable);
iTIDataEntities.SaveChanges();
return(inserted);
}
internal void TableSetup()
{
refreshControl = new UIRefreshControl();
refreshControl.ValueChanged += refreshTable;
NewsTable.AddSubview(refreshControl);
NewsTable.ContentInset = new UIEdgeInsets(10, 0, 0, 0);
}
public override void ViewDidLoad()
{
base.ViewDidLoad();
TableSetup();
NavigationItem.TitleView = SetTitle("News", "from «hse.ru»");
List <News> emptyNews = new List <News>();
emptyNews.AddRange(new List <News> {
new News("", "launchCellInside.png", " "),
new News("", "launchCellInside.png", " "),
new News("", "launchCellInside.png", " "),
new News("", "launchCellInside.png", " ")
});
NewsTable.Source = new NewsTableSource(emptyNews, false);
NewsTable.ScrollEnabled = false;
new Thread(new ThreadStart(() =>
{
NewsUpdate.SavedNewsList = NewsUpdate.InitialUpdateNews();
InvokeOnMainThread(() => {
NewsTable.Source = new NewsTableSource(NewsUpdate.SavedNewsList, true);
NewsTable.ReloadData();
NewsTable.ScrollEnabled = true;
});
})).Start();
SubmenuButton.Title = "";
SubmenuButton.Enabled = false;
}
public ActionResult Delete(int id = 0)
{
NewsTable newsTable = new NewsTable();
if (id > 0)
{
newsRepository.DeleteNews(id);
}
return(RedirectToAction("Index"));
}
void ReleaseDesignerOutlets()
{
if (NewsTable != null)
{
NewsTable.Dispose();
NewsTable = null;
}
if (SubmenuButton != null)
{
SubmenuButton.Dispose();
SubmenuButton = null;
}
}
public IHttpActionResult UploadContent(NewsTable dd2)
{
var _db = new ApplicationDbContext();
_db.Configuration.ProxyCreationEnabled = false;
// NewsTable dd = new NewsTable();
// dd.Headline = property1;
// dd.NewsContent = property2;
dd2.Date_Added = DateTime.Now;
// dd2.Userid = "*****@*****.**";
dd2.Status = "Pending";
_db.Books.Add(dd2);
_db.SaveChanges();
return(Ok());
}
public ActionResult Create(int id = 0)
{
NewsTable newsTable = new NewsTable();
if (id > 0)
{
newsTable = newsRepository.GetNewsById(id);
}
ViewBag.Trade = StaticData.GetTrade();
NewsTableModel newsTableModel = new NewsTableModel
{
ID = newsTable.ID,
NewsDate = newsTable.NewsDate,
NewsHeadLine = newsTable.NewsHeadLine,
NewsText = newsTable.NewsText
};
return(View(newsTableModel));
}
public static async Task Run(
[QueueTrigger("news", Connection = "AccountStorage-Conn")] string item,
[Table("news", Connection = "AccountStorage-Conn")] IAsyncCollector <NewsTable> collector,
ILogger log)
{
log.LogInformation($"C# Queue trigger function processed: {item}");
var news = JsonConvert.DeserializeObject <News>(item);
var invertedTicks = DateTimeHelper.InvertTicks(news.Date);
var table = new NewsTable
{
PartitionKey = invertedTicks,
RowKey = news.Id,
Title = news.Title,
Summary = news.Summary,
Url = news.Url
};
await collector.AddAsync(table);
}
public IActionResult Index()
{
ViewModel VM = new ViewModel();
VM.news = new List <NewsTable>();
VM.special = new List <ProductTable>();
VM.recom = new List <ProductList>();
VM.coming = new List <ProductList>();
VM.disco = new List <ProductList>();
//写入NEWS
//第一个有active 无法用foreach
//其他可以使用foreach
var news = db.NewsTable;
foreach (var p in news)
{
NewsTable pl = new NewsTable();
pl.Img = p.Img;
pl.Name = p.Name;
if (p.ObjId == 1)
{
ViewBag.newsname = pl.Name;
ViewBag.newsimg = pl.Img;
}
else
{
VM.news.Add(pl);
}
}
//END
//Special
var special = db.ProductTable.Take(6);
foreach (var p in special)
{
var pl = new ProductTable();
pl.Hdiscribe = p.Hdiscribe;
pl.ProductId = p.ProductId;
pl.Name = p.Name;
pl.Price = p.Price * p.Discount;//现价
pl.Hpicture = p.Hpicture;
if (p.Discount != 1)
{
pl.Discount = p.Discount * 100; //折扣
pl.Id = (int)p.Price; //原价（暂存）
}
VM.special.Add(pl);
}
//END
//推荐
var recom = db.ProductTable;
foreach (var p in recom)
{
var pl = new ProductList();
pl.product = new ProductTable
{
Typeid = p.Typeid,
ProductId = p.ProductId,
Name = p.Name,
Price = p.Price * p.Discount,
Hpicture = p.Hpicture,
Discount = p.Discount * 100,//去除小数点
Id = (int)p.Price
};
/////////////////类型写入///////////////////////（或许应该使用子函数）
var type = db.TypeTable.Where <TypeTable>(m => m.Typeid == pl.product.Typeid);
pl.type = new List <TypeTable>();
foreach (var t in type)
{
var ty = new TypeTable();
ty = new TypeTable {
Type = t.Type
};
pl.type.Add(ty);
}
VM.recom.Add(pl);
}
//END
//即将上市
var coming = db.ProductTable.Take(5);
foreach (var p in coming)
{
var pl = new ProductList();
pl.product = new ProductTable
{
Typeid = p.Typeid,
ProductId = p.ProductId,
Name = p.Name,
Price = p.Price * p.Discount,
Hpicture = p.Hpicture,
Discount = p.Discount * 100,
Id = (int)p.Price
};
/////////////////类型写入///////////////////////
var type = db.TypeTable.Where <TypeTable>(m => m.Typeid == pl.product.Typeid);
pl.type = new List <TypeTable>();
foreach (var t in type)
{
var ty = new TypeTable();
ty = new TypeTable {
Type = t.Type
};
pl.type.Add(ty);
}
VM.coming.Add(pl);
}
//END
//打折
var disco = db.ProductTable.Where <ProductTable>(m => m.Discount < 1).OrderBy <ProductTable, float>(m => (float)m.Discount).Take(10);
foreach (var p in disco)
{
var pl = new ProductList();
pl.product = new ProductTable
{
Typeid = p.Typeid,
ProductId = p.ProductId,
Name = p.Name,
Price = p.Price * p.Discount,
Hpicture = p.Hpicture,
Discount = p.Discount * 100,
Id = (int)p.Price
};
/////////////////类型写入///////////////////////
var type = db.TypeTable.Where <TypeTable>(m => m.Typeid == pl.product.Typeid);
pl.type = new List <TypeTable>();
foreach (var t in type)
{
var ty = new TypeTable();
ty = new TypeTable {
Type = t.Type
};
pl.type.Add(ty);
}
VM.disco.Add(pl);
}
//END
return(View(VM));
}
public NewsTable UpdateNews(NewsTable newsTable)
{
iTIDataEntities.Entry(newsTable).State = EntityState.Modified;
iTIDataEntities.SaveChanges();
return(newsTable);
}
