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)}");
}
