public CategoryController(CategoryContext context, IOptionsSnapshot <CategorySettings> settings)
{
_categoryContext = context ?? throw new ArgumentNullException(nameof(context));
_settings = settings.Value;
((DbContext)context).ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
}
// GET: Home
public ActionResult Index(int page = 1)
{
ProductContext db = new ProductContext();
List <SelectListItem> categoryName = new List <SelectListItem>();
CategoryContext cc = new CategoryContext();
categoryName.Add(new SelectListItem {
Text = "--Select--", Value = ""
});
foreach (var a in cc.Categories.ToList())
{
categoryName.Add(new SelectListItem {
Text = a.CategoryName, Value = a.CategoryID.ToString()
});
}
var productView = new ProductViewModel
{
productPerPage = 5,
product = db.Products.OrderBy(d => d.ProductID),
CurrentPage = page
};
productView.CategoryName = categoryName;
//Add a Dummy Row.
//products.Insert(0, new Product());
return(View(productView));
}
public void ProcessRequest(HttpContext context)
{
String uname = context.Request.QueryString["uname"].ToString();
String fvtname = context.Request.QueryString["fvtid"].ToString();
CategoryContext categoryContext = new CategoryContext();
Favourite favourite = categoryContext.Favourites.Where(f => f.Name.ToString().Equals(fvtname)).FirstOrDefault();
List <Essay> essays = favourite.Essays.ToList <Essay>();
String html = "<div class='content-header'>" +
"<nav aria-label='breadcrumb'></nav><a><h1 class='page-title'>" +
favourite.Name.ToString() + "</h1></a></div><div class='row'>" +
"<table class='table table-hover'><caption></caption>" +
"<thead><tr>" +
"<th width = '10px'></th>" +
"<th width = '10px'></th>" +
"<th width='75%'></th></thead><tbody>";
foreach (Essay essay in essays)
{
String link = essay.Url.ToString();
String title = essay.Title.ToString();
String description = essay.Description.ToString();
html += ("<tr><td><a href='javascript:void(0)'><i class='fa fa-star'></i></a></td>" +
"<td></td>" +
"<td style=' overflow: hidden; white-space: nowrap; text-overflow: ellipsis '><a href='" + link + "'target='_blank'><b>" + title + "</b> " + description + "</a></td></tr>");
}
html += "</tbody></table>";
context.Response.ContentType = "text/plain";
context.Response.Write(html);
}
public void ProcessRequest(HttpContext context)
{
CategoryContext categoryContext = new CategoryContext();
String str = context.Request.QueryString["str"];
String str2 = context.Request.QueryString["uname"];
String type = context.Request.QueryString["type"];
if (type.Equals("cty"))
{
Category category = new Category
{
//Id = categoryContext.Configs.ToList<Config>()[0].max_cty_id,
Name = str,
UserName = str2
};
categoryContext.Categories.Add(category);
}
else if (type.Equals("fvt"))
{
Favourite favorite = new Favourite
{
//Id = categoryContext.Configs.ToList<Config>()[0].max_cty_id,
Name = str,
UserName = str2
};
categoryContext.Favourites.Add(favorite);
}
categoryContext.SaveChanges();
}
public static List <Category> GetCategories()
{
CategoryContext catContext = new CategoryContext();
var ls = catContext.Categories.ToList();
return(ls);
}
internal PostPropertiesForm(CommandManager commandManager, CategoryContext categoryContext)
{
this.commandManager = commandManager;
InitializeComponent();
this.Name = "PostPropertiesForm";
Text = Res.Get(StringId.PostProperties);
AccessibleName = Text;
buttonClose.Text = Res.Get(StringId.CloseButtonNoMnemonic);
this.labelPageOrder.Text = Res.Get(StringId.PropertiesPageOrder);
this.labelPageParent.Text = Res.Get(StringId.PropertiesPageParent);
this.labelCategories.Text = Res.Get(StringId.PropertiesCategories);
this.labelPublishDate.Text = Res.Get(StringId.PropertiesPublishDate);
this.labelSlug.Text = Res.Get(StringId.PropertiesSlug);
this.labelComments.Text = Res.Get(StringId.PropertiesComments);
this.labelPings.Text = Res.Get(StringId.PropertiesPings);
this.labelTags.Text = Res.Get(StringId.PropertiesKeywords);
this.labelAuthor.Text = Res.Get(StringId.PropertiesAuthor);
this.labelPassword.Text = Res.Get(StringId.PropertiesPassword);
this.labelTrackbacks.Text = Res.Get(StringId.PropertiesTrackbacks);
this.labelExcerpt.Text = Res.Get(StringId.PropertiesExcerpt);
this.textPassword.PasswordChar = Res.PasswordChar;
ControlHelper.SetCueBanner(textTrackbacks, Res.Get(StringId.PropertiesCommaSeparated));
SuppressAutoRtlFixup = true;
comboComments.Items.AddRange(new[] {
new CommentComboItem(BlogCommentPolicy.Unspecified),
new CommentComboItem(BlogCommentPolicy.None),
new CommentComboItem(BlogCommentPolicy.Open),
new CommentComboItem(BlogCommentPolicy.Closed),
});
comboPings.Items.AddRange(new[] {
new TrackbackComboItem(BlogTrackbackPolicy.Unspecified),
new TrackbackComboItem(BlogTrackbackPolicy.Allow),
new TrackbackComboItem(BlogTrackbackPolicy.Deny),
});
InitializePropertyFields();
controller = new SharedPropertiesController(
this, labelCategories, categoryDropDown, labelTags, textTags, labelPageOrder, textPageOrder,
labelPageParent, comboPageParent, labelPublishDate, datePublishDate, fields, categoryContext);
this.comboComments.SelectedIndexChanged += controller.MakeDirty;
this.comboPings.SelectedIndexChanged += controller.MakeDirty;
this.textSlug.TextChanged += controller.MakeDirty;
this.textPassword.TextChanged += controller.MakeDirty;
this.textExcerpt.TextChanged += controller.MakeDirty;
this.textTrackbacks.TextChanged += controller.MakeDirty;
SimpleTextEditorCommandHelper.UseNativeBehaviors(commandManager,
textExcerpt, textPageOrder, textPassword,
textSlug, textTags, textTrackbacks);
}
public void CreatesACategoryContext()
{
var mockCategoryRepository = new MockCategoryRepository();
var mockCategoryMapper = new MockCategoryMapper();
var categoryContext = new CategoryContext(mockCategoryRepository, mockCategoryMapper);
Assert.NotNull(categoryContext);
}
public ActionResult Categories()
{
CategoryContext c = new CategoryContext();
return(View(c.GetAll()));
}
// GET: Home
public ActionResult Index()
{
CategoryContext db = new CategoryContext();
List <Category> categories = db.Categories.ToList();
//Add a Dummy Row.
categories.Insert(0, new Category());
return(View(categories));
}
public ActionResult Edit(int Id)
{
NewsContext newsContext = new NewsContext();
ViewData["news"] = newsContext.GetNewsById(Id);
CategoryContext categoryContext = new CategoryContext();
ViewData["ListCategories"] = categoryContext.GetAllCategories();
return(View());
}
public JsonResult InsertCategory(Category category)
{
using (CategoryContext entities = new CategoryContext())
{
entities.Categories.Add(category);
entities.SaveChanges();
}
return(Json(category));
}
public void ContextBuildsAViewModelWithNewCategory()
{
var mockCategoryRepository = new MockCategoryRepository();
var mockCategoryMapper = new MockCategoryMapper();
var categoryContext = new CategoryContext(mockCategoryRepository, mockCategoryMapper);
var viewModel = categoryContext.BuildViewModel();
Assert.NotNull(viewModel);
}
public SharedPropertiesController(IWin32Window parentFrame, Label labelCategory, CategoryDropDownControlM1 categoryDropDown, Label labelTags, AutoCompleteTextbox textTags,
Label labelPageOrder, NumericTextBox textPageOrder, Label labelPageParent, PageParentComboBox comboPageParent, Label labelPublishDate, PublishDateTimePicker datePublishDate, List <PropertyField> fields,
CategoryContext categoryContext)
{
this.parentFrame = parentFrame;
this.labelCategory = labelCategory;
this.categoryDropDown = categoryDropDown;
this.labelPublishDate = labelPublishDate;
this.datePublishDate = datePublishDate;
this.fields = fields;
this.labelTags = labelTags;
this.textTags = textTags;
this.labelPageOrder = labelPageOrder;
this.textPageOrder = textPageOrder;
this.labelPageParent = labelPageParent;
this.comboPageParent = comboPageParent;
this.categoryDropDown.AccessibleName = Res.Get(StringId.CategoryControlCategories).Replace("{0}", " ").Trim();
this.datePublishDate.AccessibleName = Res.Get(StringId.PropertiesPublishDate);
textTags.TextChanged += MakeDirty;
textTags.ButtonClicked += (sender, args) =>
{
_targetBlog.RefreshKeywords();
LoadTagValues();
};
comboPageParent.SelectedIndexChanged += MakeDirty;
textPageOrder.TextChanged += MakeDirty;
datePublishDate.ValueChanged += MakeDirty;
DATETIME_PICKER_PROMPT = "'" + Res.Get(StringId.PublishDatePrompt).Replace("'", "''") + "'";
// HACK ALERT - WinLive 209226: For RTL languages, we need to reverse the string, so it displays in the right direction
// when right aligned. We need this hack because we are essentially using the CustomFormat string to display
// the cue text. The control assumes this to be a valid format string and does a blind reverse on RTL languages
// to mirror the date formatting. Unfortunately we don't need that mirroring for the cue text.
// We reverse only if either the system (control panel setting) or UI is RTL, not if both are RTL.
bool isUIRightToLeft = BidiHelper.IsRightToLeft;
bool isSystemRightToLeft = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.IsRightToLeft;
if ((isUIRightToLeft && !isSystemRightToLeft) || (!isUIRightToLeft && isSystemRightToLeft))
{
// Reverse the string
char[] charArray = DATETIME_PICKER_PROMPT.ToCharArray();
Array.Reverse(charArray);
DATETIME_PICKER_PROMPT = new string(charArray);
}
datePublishDate.CustomFormat = DATETIME_PICKER_PROMPT;
categoryDropDown.Initialize(parentFrame, categoryContext);
InitializeFields();
InitializeSync();
}
public void ProcessRequest(HttpContext context)
{
CategoryContext categoryContext = new CategoryContext();
String userName = context.Request.QueryString["uname"].ToString();
String url = context.Request.QueryString["url"].ToString();
String type = context.Request.QueryString["type"].ToString();
if (type.Equals("rss"))
{
String ctyname = context.Request.QueryString["ctyname"].ToString();
Category category = categoryContext.Categories.Where(c => c.Name.ToString().Equals(ctyname)).FirstOrDefault();
var reader = XmlReader.Create(url);
var feed = SyndicationFeed.Load(reader);
String title = feed.Title.Text.ToString();
Rss rss = new Rss
{
Name = title,
UserName = userName,
Url = url
};
category.Rsses.Add(rss);
categoryContext.SaveChanges();
}
else if (type.Equals("essay"))
{
String fvtname = context.Request.QueryString["fvtname"].ToString();
Favourite favourite = categoryContext.Favourites.Where(f => (f.UserName.ToString().Equals(userName) && f.Name.ToString().Equals(fvtname))).FirstOrDefault();
List <String> tad = getWebTitleAndDescription(url);
String title = tad[0];
String description = tad[1];
Essay essay = new Essay
{
Url = url,
Title = title,
Description = description
};
favourite.Essays.Add(essay);
categoryContext.SaveChanges();
}
//context.Response.ContentType = "text/plain";
//context.Response.Write("");
}
public CategoryController(CategoryContext context)
{
_context = context;
if (_context.Category.Count() == 0)
{
_context.Category.Add(new Category {
Name = "Cat1"
});
_context.SaveChanges();
}
}
public ActionResult DeleteCategory(int prodID)
{
using (CategoryContext entities = new CategoryContext())
{
Category product = (from c in entities.Categories
where c.CategoryID == prodID
select c).FirstOrDefault();
entities.Categories.Remove(product);
entities.SaveChanges();
}
return(new EmptyResult());
}
/// <summary>
/// I denne klasse opstilles der funktioner til at tilføje data til min database,
/// når mit projekt startes. Dette bliver typisk kaldt for at 'Seed' en database.
/// Jeg valgte at oprette en SeedData klasse så at der er noget data at teste med,
/// frem for at mine API er tomme, og skal fyldes manuelt.
/// </summary>
/// <param name="serviceProvider"></param>
public static void AddCategories(IServiceProvider serviceProvider)
{
///<summary>
/// Her specificeres hvilken service og context som skal bruges.
/// IServiceProvider bruges til at hente vores context, som her er Category,
/// som er påkrævet for at jeg kan tilføje nye dataobjekter.
///</summary>
using (var context = new CategoryContext(
serviceProvider.GetRequiredService <DbContextOptions <CategoryContext> >()))
{
/// <summary>
/// Vi bruger denne 'if' statement for at tjekke om der er nogen data elementer
/// gemt via. vores context. Hvis der er, bliver de returneret.
/// </summary>
if (context.Categories.Any())
{
return;
}
/// <summary>
/// Her tilføjer jeg nye data elementer gennem min context.
/// 'AddRange' lader mig tilføje flere elementer ad gangen,
/// og vil så holde på dem indtil vi har gemt dem til databasen.
/// </summary>
context.Categories.AddRange(
new Category
{
Name = "Beverages",
Description = "Liquid beverages in various packaging. Includes juices, soft drinks, etc."
},
new Category
{
Name = "Salty Snacks",
Description = "Bagged salty snackfoods. Includes various chips, nuts, etc."
},
new Category
{
Name = "Frozen Vegetables",
Description = "Bagged frozen vegetable. Must be kept cool until used."
},
new Category
{
Name = "Sweets",
Description = "Sweet baked goods and candy."
}
);
/// <summary>
/// Her gemmer vi vores ændringer, så at vores elementer
/// nu vil bliver tilføjet til databasen.
/// </summary>
context.SaveChanges();
}
}
public CategoryController(CategoryContext context)
{
_context = context;
if (_context.GetCategories.Count() == 0)
{
_context.GetCategories.Add(new Category {
Name = "Beer"
});
_context.SaveChanges();
}
}
public ShowAdvertisementViewModel getEditAdvertisementModelForUser(string user_id, string user_name, int advertisement_id)
{
this.user_id = user_id;
this.user_name = user_name;
AdvertisementsContext adv_ctx = new AdvertisementsContext();
CategoryContext cat_ctx = new CategoryContext();
advertisement = adv_ctx.Advertisements.Where(a => a.Id.Equals(advertisement_id)).First();
category = cat_ctx.Categories.Where(a => a.Id.Equals(advertisement.category)).First().name;
return(this);
}
//Получить список товаров заданной категории
public List <Product> GetProductsByCategory(string categoryName)
{
List <Product> products = new List <Product>();
using (CategoryContext categoryDB = new CategoryContext())
{
using (ProductContext productDB = new ProductContext())
{
int catID = 0;
catID = categoryDB.Categories.Where(x => x.Name == categoryName).Select(c => c.Id).First();
products = productDB.Products.Where(x => x.CategoryId == catID).ToList();
}
}
return(products);
}
public PostPropertiesBandControl(CommandManager commandManager)
{
SetStyle(ControlStyles.UserPaint, true);
SetStyle(ControlStyles.DoubleBuffer, true);
SetStyle(ControlStyles.AllPaintingInWmPaint, true);
SetStyle(ControlStyles.ResizeRedraw, true);
InitializeComponent();
categoryContext = new CategoryContext();
controller = new SharedPropertiesController(this, null, categoryDropDown,
null, textTags, labelPageOrder, textPageOrder, labelPageParent, comboPageParent, null,
datePublishDate, fields, categoryContext);
SimpleTextEditorCommandHelper.UseNativeBehaviors(commandManager,
textTags, textPageOrder);
postPropertiesForm = new PostPropertiesForm(commandManager, categoryContext);
if (components == null)
{
components = new Container();
}
components.Add(postPropertiesForm);
postPropertiesForm.Synchronize(controller);
commandManager.Add(CommandId.PostProperties, PostProperties_Execute);
commandManager.Add(CommandId.ShowCategoryPopup, ShowCategoryPopup_Execute);
linkViewAll.KeyDown += (sender, args) =>
{
if (args.KeyValue == ' ')
{
linkViewAll_LinkClicked(sender, new LinkLabelLinkClickedEventArgs(null));
}
};
// WinLive 180287: We don't want to show or use mnemonics on labels in the post properties band because
// they can steal focus from the canvas.
linkViewAll.Text = TextHelper.StripAmpersands(Res.Get(StringId.ViewAll));
linkViewAll.UseMnemonic = false;
labelPageParent.Text = TextHelper.StripAmpersands(Res.Get(StringId.PropertiesPageParent));
labelPageParent.UseMnemonic = false;
labelPageOrder.Text = TextHelper.StripAmpersands(Res.Get(StringId.PropertiesPageOrder));
labelPageOrder.UseMnemonic = false;
}
public ActionResult Index()
{
VModel models = new VModel();
using (var db = new PostContext())
{
models.postsList = db.Post.ToList();
}
using (var db = new CategoryContext())
{
models.categories = db.Category.ToList();
}
return(View(models));
}
public ActionResult index()
{
NewsContext newsBL = new NewsContext();
CategoryContext categoryBL = new CategoryContext();
Tuple <List <News>, int> getDatas = newsBL.GetNewsOfPage(-1, 1, this.pageSize);
int NumPage = getDatas.Item2 / this.pageSize;
int div = getDatas.Item2 % this.pageSize;
if (div > 0)
{
NumPage++;
}
ViewData["ListNews"] = Tuple.Create(getDatas.Item1, NumPage);
ViewData["ListCategories"] = categoryBL.GetAllCategories();
return(View());
}
public CategoriesController(CategoryContext _context)
{
context = _context;
if (context.Categories.Count() == 0)
{
context.Categories.Add(new Category
{
Name = "Groceries"
});
context.Categories.Add(new Category
{
Name = "Entertainment"
});
context.SaveChanges();
}
}
public CategoryDbFixture()
{
var builder = new ConfigurationBuilder().AddJsonFile("appsettings.json");
configuration = builder.Build();
context = new CategoryContext(configuration);
context.Categories.DeleteMany(Builders <Category> .Filter.Empty);
context.Categories.InsertMany(new List <Category>
{
new Category {
Id = 101, Name = "Sports", CreatedBy = "Mukesh", Description = "All about sports", CreationDate = DateTime.Now
},
new Category {
Id = 102, Name = "Politics", CreatedBy = "Mukesh", Description = "INDIAN politics", CreationDate = DateTime.Now
}
});
}
public ActionResult GetPageNewsOfCategory(int CategoryId = 13)
{
NewsContext newsContext = new NewsContext();
CategoryContext categoryContext = new CategoryContext();
var dataSet = newsContext.GetNewsOfPage(CategoryId, 1, this.numPage);
int NumPage = dataSet.Item2 % this.numPage;
if (NumPage > 0)
{
NumPage = dataSet.Item2 / this.numPage + 1;
}
Tuple <List <News>, int, int> dataReturn = Tuple.Create(dataSet.Item1, NumPage, CategoryId);
ViewData["ListNews"] = dataReturn;
ViewData["ListCategory"] = categoryContext.GetAllCategories();
return(View());
}
public ActionResult Index()
{
NewsContext newsContext = new NewsContext();
var data = newsContext.GetNewsOfPage(-1, 1, this.numPage);
int div = data.Item2 % this.numPage;
int numPage = data.Item2 / this.numPage;
if (div > 0)
{
numPage++;
}
ViewData["ListNews"] = Tuple.Create(data.Item1, numPage);
CategoryContext categoryContext = new CategoryContext();
ViewData["ListCategory"] = categoryContext.GetAllCategories();
return(View());
}
public void ProcessRequest(HttpContext context)
{
String html = "";
String ctyname = context.Request.QueryString["ctyname"].ToString();
String uname = context.Request.QueryString["uname"].ToString();
CategoryContext categoryContext = new CategoryContext();
List <Category> categories = categoryContext.Categories.ToList <Category>();
var category = categories.Where(c => c.UserName.Equals(uname)).Where(c => c.Name.Equals(ctyname)).Where(c => c.Rsses != null).FirstOrDefault();
foreach (Rss r in category.Rsses)
{
html += "<li><a href='javascript:void(0)'class='rss-a' id='rssid-" + r.RssId.ToString() + "'>                " + r.Name.ToString() +
" </a></li >";
}
context.Response.ContentType = "text/plain";
context.Response.Write(html);
}
public void ContextSavesANewCategory()
{
var category = new Category {
Id = 4, Description = "This is new category"
};
var categoryViewModel = new CategoryViewModel {
Id = 4, Description = "This is a new category"
};
var mockCategoryRepository = new MockCategoryRepository();
var mockCategoryMapper = new MockCategoryMapper().StubMapToReturn(category);
var categoryContext = new CategoryContext(mockCategoryRepository, mockCategoryMapper);
categoryContext.Save(categoryViewModel);
mockCategoryRepository.VerifyGetByCalledWith(categoryViewModel.Id);
mockCategoryRepository.VerifyAddCalledWith(category);
mockCategoryMapper.VerifyMapCalledWith(categoryViewModel);
}
public void ContextBuildsAViewModelWithEditedCategory()
{
var category = new Category {
Id = 2, Description = "This is category 2"
};
var categoryViewModel = new CategoryViewModel {
Id = 2, Description = "This is category 2"
};
var mockCategoryRepository = new MockCategoryRepository().StubGetByIdToReturn(category);
var mockCategoryMapper = new MockCategoryMapper().StubMapToReturn(categoryViewModel);
var categoryContext = new CategoryContext(mockCategoryRepository, mockCategoryMapper);
var viewModel = categoryContext.BuildViewModel(category.Id);
Assert.NotNull(viewModel);
mockCategoryRepository.VerifyGetByCalledWith(category.Id);
mockCategoryMapper.VerifyMapCalledWith(category);
}
