static void Main(string[] args) { //BrakeDownQuery.Example1(); //Example1(); //TranslationExample.Example(); //Console.WriteLine("------------"); //RangeVariables.Example2(); //Console.WriteLine("------------"); //RangeVariables.Example3(); //Console.WriteLine("------------"); //FilteringAndOrdering.Example3(); //Console.WriteLine("------------"); //FilteringAndOrdering.Example4(); //Console.WriteLine("------------"); //Joins.Example(); //Console.WriteLine("------------"); //RangeVariables.Example3(); //Console.WriteLine("------------"); //FilteringAndOrdering.Example1(); //JoinsGroupping.Example2(); Console.WriteLine("------------"); Groupings.Example(); }
/// <summary> /// Checks or unchecks the specified grouping mode. /// </summary> public void SetGrouping(T groupingMode, bool checked_) { var grouping = Groupings.First(o => o.Mode.Equals(groupingMode)); if (checked_) { objectListView.CheckObject(grouping); } else { objectListView.UncheckObject(grouping); } }
public IActionResult CreateGrouping(ViewModel FormData, int id) { Groupings newGrouping = new Groupings() { ProductId = FormData.Groupings.ProductId, Product = _context.Products.SingleOrDefault(p => p.Id == FormData.Groupings.ProductId), CategoryId = FormData.Groupings.CategoryId, Category = _context.Categories.SingleOrDefault(p => p.Id == FormData.Groupings.CategoryId), }; _context.Groupings.Add(newGrouping); _context.SaveChanges(); newGrouping.Category.GroupingList.Add(newGrouping); _context.SaveChanges(); return(RedirectToAction("ProductProfile", id)); }
public IActionResult LinkCat2Prod(ViewModel FormData, int id) { System.Console.WriteLine("**********Hitting the LinkCat2Prod Route and the id is " + id + " **********"); System.Console.WriteLine("*****" + FormData.Groupings.ProductId + "*****"); Groupings NewCatorgization = new Groupings() { ProductId = FormData.Groupings.ProductId, CategorizedProduct = _context.products.SingleOrDefault(p => p.Id == FormData.Groupings.ProductId), CategoryId = FormData.Groupings.CategoryId, AddedCategory = _context.categories.SingleOrDefault(c => c.Id == FormData.Groupings.CategoryId), }; _context.categorized.Add(NewCatorgization); _context.SaveChanges(); NewCatorgization.AddedCategory.Grouplist.Add(NewCatorgization); _context.SaveChanges(); return(Redirect("/")); }
public Dictionary <string, string> ListSubscribe(string email, string listIndex, string merge_vars, string groupings, string email_type) { if (checkEmail(email)) { list_key = System.Web.Configuration.WebConfigurationManager.AppSettings["MailChimp:listKey" + listIndex]; MergeVars mergeVars = jsonSerializer.Deserialize <MergeVars>(merge_vars); string mergeVars_url = "&merge_vars[OPTIN_TIME]=now"; foreach (MergeVar thisMergeVar in mergeVars.merge_vars) { mergeVars_url += "&merge_vars[" + thisMergeVar.key + "]=" + HttpUtility.UrlEncode(thisMergeVar.value); } Groupings groupingsDeserialized = jsonSerializer.Deserialize <Groupings>(groupings); string groupings_url = ""; foreach (Grouping thisGroup in groupingsDeserialized.groupings) { groupings_url += "&merge_vars[GROUPINGS][0][name]=" + HttpUtility.UrlEncode(thisGroup.key) + "&merge_vars[GROUPINGS][0][groups]=" + HttpUtility.UrlEncode(thisGroup.value); } string url = "https://" + server + ".api.mailchimp.com/1.3/?method=listSubscribe&apikey=" + api_key + "&id=" + list_key + "&email_address=" + HttpUtility.UrlEncode(email) + mergeVars_url + groupings_url + "&email_type=" + email_type + "&update_existing=true&double_optin=true"; returnValue.Add("url", url); GetUrl(url); //GetUrl("https://" + server + ".api.mailchimp.com/1.3/?method=listInterestGroupings&apikey=" + api_key + "&id=" + list_key); returnValue.Add("status", status.SUCCESS.ToString()); return(returnValue); } else { returnValue.Add("status", status.ERROR.ToString()); returnValue.Add("message", "Invalid Email"); return(returnValue); } }
protected string BuildGroupByClause() { return(!Groupings.Any() ? string.Empty : "\nGROUP BY " + string.Join("\n, ", Groupings)); }
public void Day02_IdParse(string before, Groupings expected) { Assert.Equal( expected, GetGroupings(before)); }
public GroupsPageViewModel() { if (ServiceLocator.IsLocationProviderSet) { MessengerInstance.Register <RefreshDataFromRepositoriesMessage>(this, x => Initialize()); MessengerInstance.Register <SetSelectedCollectionProgramNumber>(this, x => SelectedGrouping = Groupings.FirstOrDefault(g => g.ProgramNumber == x.ProgramNumber)); } }
private string BuildGroupByClause() { return(!Groupings.Any() ? string.Empty : $"\nGROUP BY {string.Join("\n, ", Groupings)}"); }