//For store employee to view catalogue details and update & delete catalogue
public ActionResult Details(long itemId, string sessionId)
{
ViewData["catalogue"] = CatalogueService.GetCatalogueById(itemId);
ViewData["pricelist"] = PriceListService.GetPriceListByItemId(itemId);
ViewData["sessionId"] = sessionId;
return(View());
}
public ActionResult Index()
{
CatalogueService.GetTopItems();
CustomerService.GetCustomerDashboardDisplay();
ShoppingCartService.GetCartItemCount();
return(View());
}
public ActionResult UpdateCatalogue(Inventory catalogue, string sessionId)
{
long ItemId = catalogue.ItemId;
CatalogueService.UpdateCatalogue(catalogue);
return(RedirectToAction("UpdateNext", new { itemId = ItemId, sessionid = sessionId }));
}
//The following code used for Stock taking in order to generate Adjustment Voucher
public ActionResult Check(string sessionId)
{
List <Inventory> inventories = CatalogueService.GetAllCatalogue();
ViewData["inventories"] = inventories;
ViewData["sessionId"] = sessionId;
return(View());
}
public ActionResult StockCard(long itemId, string sessionId)
{
ViewData["catalogue"] = CatalogueService.GetCatalogueById(itemId);
ViewData["priceList"] = PriceListService.GetPriceListByItemId(itemId);
ViewData["stockCards"] = StockCardService.GetStockCardById(itemId);
ViewData["sessionId"] = sessionId;
return(View());
}
public CatalogueController(BusinessService businessService, CatalogueService catService, SignInManager <ApplicationUser> signInManager, UserManager <ApplicationUser> userManager)
{
_businessService = businessService;
_catalogueService = catService;
_signInManager = signInManager;
_userManager = userManager;
_bookLoader = new BookLoader(businessService);
}
public MediaDetailsViewModel(int mediaId)
{
Item = CatalogueService.GetMediaById(mediaId);
Reviews = ReviewService.GetReviewsForMediaId(mediaId);
if (Item.RatingCount > 0)
{
AverageRating = (float)Item.RatingSum / Item.RatingCount;
}
}
private async void Initialisation()
{
try
{
ListTechnologies = new ObservableCollection <Technology>(await CatalogueService.GetAllTechnologies());
}
catch (Exception)
{
throw;
}
}
public ActionResult Create(string sessionId)
{
List <string> categories = CatalogueService.GetAllCategories();
ViewData["categories"] = categories;
List <string> unitsOfMeasure = CatalogueService.GetAllUnits();
ViewData["unitsOfMeasure"] = unitsOfMeasure;
ViewData["sessionId"] = sessionId;
return(View());
}
public ActionResult Update(long itemId, string sessionId)
{
ViewData["catalogue"] = CatalogueService.GetCatalogueById(itemId);
List <string> categories = CatalogueService.GetAllCategories();
ViewData["categories"] = categories;
List <string> unitsOfMeasure = CatalogueService.GetAllUnits();
ViewData["unitsOfMeasure"] = unitsOfMeasure;
ViewData["sessionId"] = sessionId;
return(View());
}
public ActionResult CreateReview(int mediaId)
{
var vm = new CreateReviewViewModel();
vm.mediaId = mediaId;
vm.Item = CatalogueService.GetMediaById(mediaId);
User currentUser = UserService.GetUserByUserName(HttpContext.User.Identity.Name);
vm.ReviewerName = currentUser.Name;
vm.ReviewerLocation = currentUser.City + ", " + currentUser.Country;
vm.ReviewDate = DateTime.Now;
return(View(vm));
}
static void Main(string[] args)
{
ContainerBuilder builder = new ContainerBuilder();
builder.RegisterType <CatalogueService>();
builder.RegisterType <CatalogueRepository>().AsImplementedInterfaces();
IContainer container = builder.Build();
using (ILifetimeScope scope = container.BeginLifetimeScope())
{
CatalogueService catalogueService = scope.Resolve <CatalogueService>();
catalogueService.GetFavoriteProduct();
}
}
public void GetFavoriteProductTest()
{
using (var mock = AutoMock.GetLoose())
{
//arrange
mock.Mock <ICatalog>().Setup(c => c.GetProduct(It.IsAny <string>())).Returns(new Product("test"));
CatalogueService catalogueService = mock.Create <CatalogueService>();
//act
string name = catalogueService.GetFavoriteProduct();
//assert
Assert.Equal("test", name);
}
}
private async void SearchCourses()
{
var list = await CatalogueService.SearchCourses(SearchText);
var resList = new List <Cour>();
foreach (var tech in ListTechnologies)
{
if (tech.IsTechSelected)
{
resList.AddRange(list.Where(c => c.Category.TechnologieID == tech.C_id));
}
}
SearchResult = new ObservableCollection <Cour>(resList);
}
public override async void Activate(object parameter)
{
var cat = parameter as Category;
if (cat == null)
{
ListCategories =
new ObservableCollection <Category>(
await CatalogueService.GetCategoriesByTechnology((long)parameter));
}
else
{
DataContextCategory = cat;
}
base.Activate(parameter);
}
public ActionResult Delete(bool confirm, long itemId, string sessionId)
{
if (confirm)
{
if (PriceListService.GetPriceListByItemId(itemId) != null)
{
PriceListService.DeletePriceList(itemId);
}
CatalogueService.DeleteCatalogue(itemId);
List <Inventory> catalogues = CatalogueService.GetAllCatalogue();
ViewData["catalogues"] = catalogues;
return(RedirectToAction("All", new { sessionid = sessionId }));
}
return(null);
}
public ActionResult CreatePriceList(long ItemId, PriceList priceList, string sessionId)
{
if (priceList.Supplier1Name == priceList.Supplier2Name || priceList.Supplier2Name == priceList.Supplier3Name || priceList.Supplier3Name == priceList.Supplier1Name)
{
TempData["errorMsg"] = "<script>alert('Please select three different suppliers.');</script>";
return(RedirectToAction("CreateNext", new { itemId = ItemId, sessionid = sessionId }));
}
else
{
priceList.Item = new Inventory();
priceList.Item.ItemId = ItemId;
PriceListService.CreatePriceListDetaills(priceList);
List <Inventory> catalogues = CatalogueService.GetAllCatalogue();
ViewData["catalogues"] = catalogues;
return(RedirectToAction("All", new { sessionid = sessionId }));
}
}
public ActionResult CreateCatalogue(Inventory catalogue, string sessionId)
{
long ItemId = 0;
try
{
string itemCode = catalogue.ItemCode.ToUpper();
catalogue.ItemCode = itemCode;
ItemId = CatalogueService.CreateCatalogueDetaills(catalogue);
}
catch (SqlException)
{
TempData["errorMsg"] = "<script>alert('Catalogue code already exists! Please verify.');</script>";
return(RedirectToAction("Create", new { sessionid = sessionId }));
}
return(RedirectToAction("CreateNext", new { itemId = ItemId, sessionid = sessionId }));
}
public async override void Activate(object parameter)
{
_keep = true;
PinSecTileVisibility = Visibility.Collapsed;
UnpinSecTileVisibility = Visibility.Collapsed;
var course = parameter as Cour;
if (course != null)
{
SelectedCourse = course;
}
else
{
SelectedCourse = CatalogueService.GetCourseByCourseId(long.Parse((parameter.ToString()).Substring(1)));
BackButtonVisibility = Visibility.Collapsed;
}
try
{
IsLoadingProgressRing = true;
CoursesScheduleList = new ObservableCollection <CourDate>(await CatalogueService.GetCourseScheduleByCourseId(SelectedCourse.C_id));
IsLoadingProgressRing = false;
if (CoursesScheduleList.Count == 0)
{
var dialog = new MessageDialog("Desolé, aucune date disponible pour cette formation."); //eng: This course has no available dates.
if (_keep)
{
Window.Current.Dispatcher.RunAsync(Windows.UI.Core.CoreDispatcherPriority.Normal, () => dialog.ShowAsync());
}
}
}
catch (Exception ex)
{
var dialog = new MessageDialog("L'application n'a pas réussi à récupérer les dates pour cette formation, vérifier votre connexion Internet s'il vous plaît."); //eng: The app can't retrieve the dates, please check your internet connection.
if (_keep)
{
Window.Current.Dispatcher.RunAsync(Windows.UI.Core.CoreDispatcherPriority.Normal, () => dialog.ShowAsync());
}
IsLoadingProgressRing = false;
}
PinSecTileVisibility = SecondaryTile.Exists("S" + SelectedCourse.C_id.ToString()) ? Visibility.Collapsed : Visibility.Visible;
UnpinSecTileVisibility = SecondaryTile.Exists("S" + SelectedCourse.C_id.ToString()) ? Visibility.Visible : Visibility.Collapsed;
base.Activate(parameter);
}
public ActionResult GetTrademeListingDuration()
{
var oauth = repository.GetOAuthToken(subdomainid.Value, OAuthTokenType.TRADEME, true);
var service = new CatalogueService(oauth.token_key, oauth.token_secret);
foreach (var category in db.trademe_categories)
{
if (!category.isLeaf)
{
continue;
}
var duration = service.GetCategoryDuration(new GetCategoryDurationRequest(category.id));
if (duration.GetCategoryDurationResult.Durations == null)
{
continue;
}
if (db.trademe_listingdurations.Any(x => x.categoryid == category.id))
{
continue;
}
category.default_listingduration = (byte)duration.GetCategoryDurationResult.Default.ToInt();
foreach (var entry in duration.GetCategoryDurationResult.Durations)
{
var ld = new trademe_listingduration();
ld.categoryid = category.id;
ld.duration = (byte)entry.ToInt();
db.trademe_listingdurations.InsertOnSubmit(ld);
}
db.SubmitChanges();
}
return(Content("done"));
}
public ActionResult PutReason(string sessionId)
{
List <AdjVoucher> adjVouchers = new List <AdjVoucher>();
//status = 0 means need to be submit for reason.
adjVouchers = AdjVoucherService.GetAdjByStatus(0);
if (adjVouchers.Count == 0)
{
return(RedirectToAction("AllAdjVouchers", new { sessionId }));
}
else
{
foreach (AdjVoucher adj in adjVouchers)
{
adj.Reason = null;
adj.Item = CatalogueService.GetCatalogueById(adj.ItemId);
adj.Item.ItemSuppliersDetails = PurchaseOrderService.GetItemSuppliersDetails(adj.ItemId);
}
ViewData["adjVouchers"] = adjVouchers;
ViewData["sessionId"] = sessionId;
return(View());
}
}
public ActionResult CreateReview(CreateReviewViewModel vm, int pMediaId)
{
vm.mediaId = pMediaId;
Media media = CatalogueService.GetMediaById(pMediaId);
vm.Item = media;
User currentUser = UserService.GetUserByUserName(HttpContext.User.Identity.Name);
vm.AuthorId = currentUser.Id;
// Get the Review Message Type
var reviewMessage = vm.toMessageType();
// Update the rating sum and count on the media
media.RatingCount++;
media.RatingSum += vm.Rating;
// Save the review to the database
ServiceFactory.Instance.ReviewService.SubmitReview(reviewMessage, media, currentUser);
// Go back to the media details page
return(RedirectToAction("ShowDetails", "Details", routeValues: new { mediaId = pMediaId }));
}
public ActionResult UpdatePurchaseOrder(PurchaseOrder order, FormCollection formCollection, string sessionId)
{
PurchaseOrder selectedOrder = PurchaseOrderService.GetOrderDetails(order.OrderNumber);
List <long> selectedItemsIds = new List <long>();
List <Inventory> selectedItems = new List <Inventory>();
foreach (var item in order.ItemDetails)
{
if (item.Item.IsChecked)
{
selectedItemsIds.Add(item.Item.ItemId);
}
}
foreach (var id in selectedItemsIds)
{
selectedItems.Add(CatalogueService.GetCatalogueById(id));
}
foreach (var item in selectedItems)
{
item.ItemSuppliersDetails = PurchaseOrderService.GetItemSuppliersDetails(item.ItemId);
item.ItemSuppliersDetails.Supplier1Name = SupplierService.GetSupplierName(item.ItemSuppliersDetails.Supplier1Id);
item.ItemSuppliersDetails.Supplier2Name = SupplierService.GetSupplierName(item.ItemSuppliersDetails.Supplier2Id);
item.ItemSuppliersDetails.Supplier3Name = SupplierService.GetSupplierName(item.ItemSuppliersDetails.Supplier3Id);
}
ViewData["selectedItems"] = selectedItems;
ViewData["order"] = selectedOrder;
ViewData["deliverTo"] = formCollection["deliverTo"];
ViewData["deliverBy"] = formCollection["deliverBy"];
ViewData["sessionId"] = sessionId;
return(View());
}
public override void Activate(object parameter)
{
RoamingFavorite = (bool)(ApplicationData.Current.RoamingSettings.Values["RoamingFavorite"]);
CourseDetails = (parameter as Cour);
if (CourseDetails != null)
{
IsCourseFavorite = CatalogueService.IsCourseFavorite(CourseDetails.C_id, RoamingFavorite);
}
else
{
CourseDetails = CatalogueService.GetCourseByCourseId(long.Parse(parameter.ToString()));
IsCourseFavorite = CatalogueService.IsCourseFavorite(CourseDetails.C_id, RoamingFavorite);
BackButtonVisibility = Visibility.Collapsed;
}
RegisterForShare();
SendLiveTileUpdate();
Network.InternetConnectionChanged += async(s, e) => Windows.ApplicationModel.Core.CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(CoreDispatcherPriority.Normal, () =>
{
IsDatesVisible = (e.IsConnected ? Visibility.Visible : Visibility.Collapsed);
});
PinSecTileVisibility = SecondaryTile.Exists(CourseDetails.C_id.ToString()) ? Visibility.Collapsed : Visibility.Visible;
UnpinSecTileVisibility = SecondaryTile.Exists(CourseDetails.C_id.ToString()) ? Visibility.Visible : Visibility.Collapsed;
base.Activate(parameter);
}
public ActionResult AdjDetails(long adjId, string sessionId)
{
List <AdjVoucher> adjVouchers = new List <AdjVoucher>();
adjVouchers = AdjVoucherService.GetAdjByAdjId(adjId);
foreach (AdjVoucher adj in adjVouchers)
{
Inventory c = CatalogueService.GetCatalogueById(adj.ItemId);
adj.ItemCode = c.ItemCode;
adj.Description = c.Description;
PriceList p = PriceListService.GetPriceListByItemId(adj.ItemId);
if (p != null)
{
adj.UnitPrice = p.Supplier1UnitPrice;
}
else
{
adj.UnitPrice = 1;
}
double total = adj.AdjQty * adj.UnitPrice;
adj.TotalPrice = Math.Abs(total);
}
string adjIdstring = adjId.ToString("000/000/00");
string authorisedBy = "Nil";
if (adjVouchers[0].AuthorisedBy != 0)
{
authorisedBy = EmployeeService.GetEmployeeById(adjVouchers[0].AuthorisedBy).EmpName;
}
ViewData["adjIdstring"] = adjIdstring;
ViewData["adjVouchers"] = adjVouchers;
ViewData["authorisedBy"] = authorisedBy;
ViewData["sessionId"] = sessionId;
return(View());
}
public List <Media> GetRecommendedMedia(int pMediaId, int pUserId)
{
RecommendedItems = CatalogueService.GetRecommendedMedia(pMediaId, pUserId);
return(RecommendedItems);
}
public Tuple <int, int> GetLikesAndDislikesForMedia(int pMediaId)
{
return(CatalogueService.GetLikesAndDislikesForMedia(pMediaId));
}
public Rating GetRating(int pUserId, int pMediaId)
{
return(CatalogueService.GetRating(pUserId, pMediaId));
}
public ReviewsViewModel(ICatalogueService catalogueService, INavigationService navigationService)
: base(catalogueService, navigationService)
{
Messenger.Default.Register <long>(this, async(cId) =>
{
SelectedCourseId = cId;
IsLoadingProgressRing = true;
ReviewsList = new ObservableCollection <CourReview>(await CatalogueService.GetCourseReviewByCourseId(cId));
IsLoadingProgressRing = false;
IsNoReviewMessageVisible = (ReviewsList.Count > 0) ? Visibility.Collapsed : Visibility.Visible;
});
}
//public ActionResult AuthoriseByS(List<AdjVoucher> adjVouchers, string sessionId)
//{
// Employee user = EmployeeService.GetUserBySessionId(sessionId);
// double totalAmount = 0;
// foreach (AdjVoucher adj in adjVouchers)
// {
// PriceList priceList = PriceListService.GetPriceListByItemId(adj.ItemId);
// double price = 0;
// if (priceList != null)
// {
// price = priceList.Supplier1UnitPrice;
// }
// double amount = price * adj.AdjQty;
// totalAmount = totalAmount + amount;
// AdjVoucherService.UpdateReason(adj);
// }
// if (totalAmount > -250)
// {
// //status = 1, auto approved by supervisor
// AdjVoucherService.UpdateStatus(adjVouchers[0].AdjId, 1);
// AdjVoucherService.AuthoriseBy(adjVouchers[0].AdjId, user.EmpId);
// TempData["errorMsg"] = "<script>alert('Total discrepancy is less than $250, authorised already.');</script>";
// }
// else
// {
// //status = 2, pending approve for manager
// AdjVoucherService.UpdateStatus(adjVouchers[0].AdjId, 2);
// TempData["errorMsg"] = "<script>alert('Total discrepancy is more than $250, pending for Store Manager to authorise.');</script>";
// }
// ViewData["userName"] = user.EmpName;
// ViewData["sessionId"] = sessionId;
// return View("~/Views/StoreLandingPage/Home.cshtml");
//}
public ActionResult PendingApprove(string sessionId)
{
Employee user = EmployeeService.GetUserBySessionId(sessionId);
List <AdjVoucher> adjVouchers = new List <AdjVoucher>();
string authoriseBy = null;
if (user.EmpRole == "STORE_SUPERVISOR")
{
adjVouchers = AdjVoucherService.GetAdjByStatus(2);
foreach (var adj in adjVouchers)
{
//to get item details for view
adj.Item = CatalogueService.GetCatalogueById(adj.ItemId);
adj.Item.ItemSuppliersDetails = PurchaseOrderService.GetItemSuppliersDetails(adj.ItemId);
}
if (adjVouchers.Count == 0)
{
return(RedirectToAction("AllAdjVouchers", new { sessionId }));
}
authoriseBy = "Supervisor";
}
else if (user.EmpRole == "STORE_MANAGER")
{
adjVouchers = AdjVoucherService.GetAdjByStatus(3);
foreach (var adj in adjVouchers)
{
//to get item details for view
adj.Item = CatalogueService.GetCatalogueById(adj.ItemId);
adj.Item.ItemSuppliersDetails = PurchaseOrderService.GetItemSuppliersDetails(adj.ItemId);
}
if (adjVouchers.Count == 0)
{
return(RedirectToAction("AllAdjVouchers", new { sessionId }));
}
authoriseBy = "Manager";
}
//To group by vouchers
Dictionary <long, List <AdjVoucher> > byVouchers = new Dictionary <long, List <AdjVoucher> >();
foreach (var adj in adjVouchers)
{
if (byVouchers.ContainsKey(adj.AdjId))
{
byVouchers[adj.AdjId].Add(adj);
}
else
{
List <AdjVoucher> adjs = new List <AdjVoucher>();
adjs.Add(adj);
byVouchers[adj.AdjId] = adjs;
}
}
ViewData["authoriseBy"] = authoriseBy;
ViewData["adjVouchers"] = adjVouchers;
ViewData["byVouchers"] = byVouchers;
ViewData["sessionId"] = sessionId;
return(View());
}