public JsonResult GetMLeads(string sidx, string sord, int rows, int page = 1)
{
string getMarketingListID = Request["_ID"];
var data = db.marketingListLead.Where(x => x.MarketingListID == new Guid(getMarketingListID) && x.DeletionStateCode == 0).ToList()
.Select(x => new
{
Id = x.ID,
Name = x.Name,
Topic = x.Topic,
Fullname = x.Fullname,
Email = x.Email,
EntityID = x.EntityID
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public static CityObject FromTemplate(CityLevel cityLevel, JSONTable template)
{
string type = template.getString("type");
switch (type)
{
case "inbox":
return(new ChemicalInbox(cityLevel, template));
case "outbox":
return(new ChemicalOutbox(cityLevel, template));
case "factory":
return(new ChemicalFactory(cityLevel, template));
case "silo":
return(new ChemicalSilo(cityLevel, template));
case "crystalOutbox":
return(new CrystalOutbox(cityLevel, template));
case "buildingSite":
return(new BuildingSite(cityLevel, template));
case "plinth":
return(new WeaponPlinth(cityLevel, template));
case "blueprint":
return(new Blueprint(cityLevel, template));
default:
throw new ArgumentException("Unknown CityObject type \"" + type + "\"");
}
}
//Show list of marketing list in campaign
public JsonResult GetCMarketingList(string sidx, string sord, int rows, int page = 1)
{
string getCampaignID = Request["_ID"];
var data = db.campaignMarketingList.Where(x => x.CampaignID == new Guid(getCampaignID) && x.DeletionStateCode == 0).ToList()
.Select(x => new
{
Id = x.ID,
name = x.Name,
purpose = x.Purpose,
description = x.Description,
EntityID = x.EntityID
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public ConvergePlayer(JSONTable template, ContentManager Content)
{
this.home = new ConvergeZone(template.getJSON("home"), this, ConvergeZoneId.Home);
this.resourceZone = new ConvergeZone(template.getJSON("resources"), this, ConvergeZoneId.Resources);
this.attack = new ConvergeZone(template.getJSON("attack"), this, ConvergeZoneId.Attack);
this.defense = new ConvergeZone(template.getJSON("defense"), this, ConvergeZoneId.Defense);
this.hand = new ConvergeZone(template.getJSON("hand"), this, ConvergeZoneId.Hand);
this.homeBase = new ConvergeObject(new ConvergeCardSpec(template.getJSON("homebase"), Content), home);
this.discardPile = new ConvergeZone(template.getJSON("discardPile"), this, ConvergeZoneId.DiscardPile);
this.laboratory = new ConvergeZone(template.getJSON("laboratory"), this, ConvergeZoneId.Laboratory);
zones = new Dictionary <ConvergeZoneId, ConvergeZone>()
{
{ ConvergeZoneId.Home, home },
{ ConvergeZoneId.Resources, resourceZone },
{ ConvergeZoneId.Attack, attack },
{ ConvergeZoneId.Defense, defense },
{ ConvergeZoneId.Hand, hand },
{ ConvergeZoneId.DiscardPile, discardPile },
{ ConvergeZoneId.Laboratory, laboratory },
};
this.life = template.getInt("startingLife");
this.faceLeft = template.getBool("faceLeft", false);
}
public JsonResult LoadGrid(string sidx, string sord, int rows, int page = 1)
{
string getVal = Request["_val"];
Guid reportID = new Guid(getVal);
Guid roleID = new Guid(Session["RoleID"].ToString());
var data = db.reportRoleView.Where(x => x.ReportID == reportID)
.OrderBy(x => x.SecurityRoleName).ToList()
.Select(x => new
{
Id = x.ID,
Name = x.SecurityRoleName
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadGrid(string sidx, string sord, int rows, int page = 1)
{
string getVal = Request["_val"];
var data = db.reportColumn.Where(x => x.ReportID == new Guid(getVal)).OrderBy(x => x.SeqNo).ToList()
.Select(x => new
{
Id = x.ID,
Label = x.Label,
// Value = MappingSC(x.FilterValue, x.FilterType),
// Value = x.ValueText,
//Editable = x.IsEditable == 0 ? "No" : "Yes"
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadHistory(string sidx, string sord, int rows, int page = 1)
{
string getRequestID = Request["_requestID"];
var data = db.requestresolution.Where(x => x.RequestID == new Guid(getRequestID) && (x.ActivityTypeLabel == "Case Resolution" || (x.ActivityTypeLabel == "Task" && x.StatusCode == 5 || x.StatusCode == 6))).ToList()
.Select(x => new
{
Id = x.ActivityId,
Subject = x.Subject,
ActivityType = x.ActivityTypeLabel,
ActivityStatus = x.StatusCodeLabel,
Regarding = x.RequestTitle,
ActualEnd = x.CreatedOn,
CreatedBy = x.CreatedByName
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
//Show list of customer in campaign
public JsonResult GetCCustomer(string sidx, string sord, int rows, int page = 1)
{
string getCampaignID = Request["_ID"];
var data = db.campaignCustomer.Where(x => x.CampaignID == new Guid(getCampaignID) && x.DeletionStateCode == 0).ToList()
.Select(x => new
{
Id = x.ID,
cisnumber = x.CisNumber,
fullname = x.Fullname,
customertypelabel = x.CustomerTypeLabel,
email = x.Email,
EntityID = x.EntityID
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadTask(string sidx, string sord, int rows, int page = 1)
{
string getRequestID = Request["_requestID"];
var data = db.task.Where(x => x.RequestID == new Guid(getRequestID) && x.TaskStatusLabel != "Canceled" && x.TaskStatusLabel != "Completed").ToList()
.Select(x => new
{
Id = x.TaskID,
Subject = x.Subject,
TaskStatusLabel = x.TaskStatusLabel,
CreatedByName = x.CreatedByName,
Regarding = x.Regarding,
CreatedOn = x.CreatedOn
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadGrid2(string sidx, string sord, int rows, int page)
{
string getParam = Request["_param"];
string getVal = Request["_val"];
string getFilter = Request["_filter"];
var model = db.calltype.Where(x => x.DeletionStateCode == 0).Where(x => x.CallWrapUpID == new Guid(getVal));
var data = model.ToList()
.Select(x => new
{
Id = x.CallTypeID,
summary = x.Summary,
category = x.CategoryName,
createdon = x.CreatedOn,
modifiedon = x.ModifiedOn
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.ToArray().Length;
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public ResourceType(JSONTable template, ContentManager content)
{
name = template.getString("name");
string textureName = template.getString("texture");
texture = (textureName != null) ? content.Load<Texture2D>(textureName) : null;
}
public Compiler(JSONTable settings)
{
this.settings = settings;
this.operators = new List <Operator>();
int precedence = 0;
foreach (string s in settings.getArray("OPERATORS").asStrings())
{
foreach (char c in s)
{
symbols.Add(c);
}
operators.Add(new Operator(s, precedence));
precedence++;
}
string startPatternName = settings.getString("START", null);
if (startPatternName != null)
{
startPattern = settings.getArray(startPatternName);
}
else
{
startPattern = settings.getArray("START", null);
}
}
public LevelScript(JSONTable template)
{
spawns = new List<List<MinionType>>();
name = template.getString("name", "UNNAMED");
JSONArray spawnTemplate = template.getArray("monsters");
for (int Idx = 0; Idx < spawnTemplate.Length; ++Idx)
{
List<MinionType> thisTurn = new List<MinionType>();
foreach (string minion in spawnTemplate.getArray(Idx).asStrings())
{
MinionType type = MinionType.get(minion);
thisTurn.Add(type);
}
spawns.Add(thisTurn);
}
scenery = new List<KeyValuePair<MinionType, Point>>();
foreach (JSONArray entry in template.getArray("scenery", JSONArray.empty).asJSONArrays())
{
scenery.Add(new KeyValuePair<MinionType,Point>(MinionType.get(entry.getString(0)), new Point(entry.getInt(1), entry.getInt(2))));
}
ongoingEffects = new List<KeyValuePair<Card, Point>>();
foreach (JSONArray entry in template.getArray("ongoingEffects", JSONArray.empty).asJSONArrays())
{
ongoingEffects.Add(new KeyValuePair<Card, Point>(Card.get(entry.getString(0)), new Point(entry.getInt(1), entry.getInt(2))));
}
levelType = LevelType.get(template.getString("type"));
string unlock = template.getString("unlock", null);
if(unlock != null)
unlocksCard = Card.get(unlock);
}
internal static MagicCard LoadCard(string card, GraphicsDevice GraphicsDevice, JSONTable table)
{
if (cards.ContainsKey(card))
return cards[card];
else
{
JSONTable cardTable = table.getJSON(card);
MagicCardType type = 0;
foreach (var item in cardTable.getArray("types").toStringArray())
{
type |= (MagicCardType)Enum.Parse(typeof(MagicCardType), item);
}
cards.Add
(
card,
new MagicCard
(
card,
GraphicsDevice,
type,
cardTable.getArray("subtypes").toStringArray(),
new Ability[0],
new Cost(new List<CostComponent>() { ManaPaymentComponent.Parse(cardTable.getString("manaCost", "0")) }),
int.Parse(cardTable.getString("power", "0")),
int.Parse(cardTable.getString("toughness", "0"))
)
);
return cards[card];
}
}
static void Main(string[] args)
{
Options options = new Options();
ParserResult <Options> result = Parser.Default.ParseArguments <Options>(args).WithParsed <Options>(o =>
{
if (string.IsNullOrEmpty(o.DataPackageFile))
{
o.DataPackageFile = "ExtendedDataPackage.json";
}
options = o;
});
if (result.Tag == ParserResultType.NotParsed)
{
// Help text requested, or parsing failed. Exit.
return;
}
DataPackage dataPackage = FilterJSON(options);
if (options.ExportType == "gv")
{
ERD erd = new ERD(dataPackage.Tables);
erd.Generate(options);
}
else if (options.ExportType == "json")
{
JSONSchema schema = new JSONSchema(dataPackage.Tables);
schema.Generate(options);
}
else if (options.ExportType == "table")
{
JSONTable schema = new JSONTable(dataPackage.Tables);
schema.Generate(options);
}
else if (options.ExportType == "csv")
{
CSVSchema schema = new CSVSchema(dataPackage.Tables);
schema.Generate(options);
}
else if (options.ExportType == "sql")
{
SQL sql = new SQL(dataPackage.Tables);
sql.Generate(options);
}
else if (options.ExportType == "html")
{
HTML html = new HTML(dataPackage);
html.Generate(options);
}
else if (options.ExportType == "erd")
{
LucidChart lucidChart = new LucidChart(dataPackage);
lucidChart.Generate(options);
}
else
{
Console.WriteLine("Export type not recognised");
}
}
public LevelState(JSONTable template)
{
unlocked = true;// false;
//done = true;
//starred = true;
script = new LevelScript(template);
}
public static void ConstructTableObjectFromPostRequest(JSONTable jt, ref BaseTable bt, ref int pageIndex, ref int pageSize, ref int totalRows,
ref SqlFilter whereFilter, ref BaseFilter join, ref OrderBy orderBy)
{
pageIndex = jt.PageIndex;
pageSize = jt.PageSize;
totalRows = jt.TotalRows;
bt = (BaseTable)DatabaseObjects.GetTableObject(jt.TableName);
ColumnList selCols = new ColumnList();
foreach (JTableSelectColumn col in jt.JSelectColumns)
{
selCols.Add(bt.TableDefinition.ColumnList.GetByCodeName(col.ColumnName), true);
}
bt.SelectedColumns.Clear();
bt.SelectedColumns.AddRange(selCols);
if ((jt.JOrderByList != null))
{
foreach (JOrderBy jOrderBy in jt.JOrderByList)
{
orderBy = new OrderBy(true, false);
orderBy.Add(bt.TableDefinition.ColumnList.GetByCodeName(jOrderBy.ColumnName), OrderByItem.ToOrderDir(jOrderBy.OrderDirection));
}
}
if (jt.JWhereClause != null && jt.JWhereClause.Trim() != "")
{
whereFilter = new SqlFilter(jt.JWhereClause);
}
}
public Blueprint(CityLevel cityLevel, JSONTable template) : base(cityLevel, TextureCache.blueprint, template.getVector2("pos"), TextureCache.blueprint.Size())
{
this.unlocks = template.getString("unlocks");
this.price = template.getInt("price", 0);
this.label = template.getString("label");
this.canDrag = false;
Init();
}
public WeaponPlinth(CityLevel cityLevel, JSONTable template) : base(cityLevel, TextureCache.plinth, template.getVector2("pos"), TextureCache.plinth.Size())
{
this.weapon = Game1.instance.inventory.unlockableWeapons[template.getString("weapon")];
this.price = template.getInt("price", 0);
this.canDrag = false;
this.crystals = template.getInt("crystals", 0);
Init();
}
public ConvergeTriggeredAbilitySpec(JSONTable template, ContentManager Content)
{
triggerType = (ConvergeTriggerType)Enum.Parse(typeof(ConvergeTriggerType), template.getString("trigger"));
triggerPlayer = ConvergeSelector.New(template.getProperty("triggerPlayer", null));
triggerSubject = ConvergeSelector.New(template.getProperty("triggerSubject", null));
triggerTarget = ConvergeSelector.New(template.getProperty("triggerTarget", null));
condition = ConvergeSelector.New(template.getProperty("condition", null));
effect = ConvergeCommand.New(template.getArray("effect"), Content);
}
public JsonResult LoadGrid(string sidx, string sord, int rows, int page)
{
string getParam = Request["_param"];
string getVal = Request["_val"];
string getFilter = Request["_filter"];
bool isDisabled = "1".Equals(getFilter) ? false : true;
int totalRecords = 0;
var model = db.businessunit.Take(1);
if (string.IsNullOrEmpty(getVal))
{
totalRecords = db.businessunit.OrderBy(x => x.Name).Where(x => x.IsDisabled == isDisabled).Count();
model = db.businessunit.OrderBy(x => x.Name).Where(x => x.IsDisabled == isDisabled).Take(int.Parse(ConfigurationManager.AppSettings["RecordStaticCount"]));
}
else
{
switch (getParam)
{
case "searchBUName":
totalRecords = db.businessunit.OrderBy(x => x.Name).Where(x => x.IsDisabled == isDisabled).Where(x => x.Name.ToLower().Contains(getVal.ToLower())).Count();
model = db.businessunit.OrderBy(x => x.Name).Where(x => x.IsDisabled == isDisabled).Where(x => x.Name.ToLower().Contains(getVal.ToLower())).Take(int.Parse(ConfigurationManager.AppSettings["RecordStaticCount"]));
break;
case "searchBUParent":
totalRecords = db.businessunit.OrderBy(x => x.Name).Where(x => x.IsDisabled == isDisabled).Where(x => (string.IsNullOrEmpty(x.ParentBusinessUnit) ? string.Empty : x.ParentBusinessUnit).ToLower().Contains(getVal.ToLower())).Count();
model = db.businessunit.OrderBy(x => x.Name).Where(x => x.IsDisabled == isDisabled).Where(x => (string.IsNullOrEmpty(x.ParentBusinessUnit) ? string.Empty : x.ParentBusinessUnit).ToLower().Contains(getVal.ToLower())).Take(int.Parse(ConfigurationManager.AppSettings["RecordStaticCount"]));
break;
}
}
var data = model.ToList().Select(x => new
{
Id = x.BusinessUnitId,
name = x.Name,
mainPhone = x.MainPhone,
webSite = x.WebSite,
parentBusiness = x.ParentBusinessUnit,
isDisabled = x.IsDisabled
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.AsQueryable().OrderBy(sidx + " " + sord).Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public void Init(JSONTable template, ContentManager Content)
{
string artName = template.getString("art");
art = Content.Load <Texture2D>(artName);
name = template.getString("name", artName); // for now
text = template.getString("text", "").InsertLineBreaks(Game1.font, ConvergeUIObject.CardTooltipWidth - 15);
textHeight = (int)Game1.font.MeasureString(text).Y;
cardType = 0;
foreach (string name in template.getArray("cardType").asStrings())
{
cardType |= (ConvergeCardType)Enum.Parse(typeof(ConvergeCardType), name);
}
power = template.getInt("power", 0);
toughness = template.getInt("toughness", 0);
string producesTemplate = template.getString("produces", "");
if (producesTemplate != "")
{
produces = new ConvergeManaAmount(template.getString("produces"));
}
string costTemplate = template.getString("cost", "");
if (costTemplate != "")
{
cost = new ConvergeManaAmount(costTemplate);
}
keywords = 0;
foreach (string name in template.getArray("keywords", JSONArray.empty).asStrings())
{
keywords |= (ConvergeKeyword)Enum.Parse(typeof(ConvergeKeyword), name);
}
activatedAbilities = new List <ConvergeActivatedAbilitySpec>();
foreach (JSONTable abilityTemplate in template.getArray("activated", JSONArray.empty).asJSONTables())
{
activatedAbilities.Add(new ConvergeActivatedAbilitySpec(abilityTemplate, Content));
}
triggeredAbilities = new List <ConvergeTriggeredAbilitySpec>();
foreach (JSONTable abilityTemplate in template.getArray("triggered", JSONArray.empty).asJSONTables())
{
triggeredAbilities.Add(new ConvergeTriggeredAbilitySpec(abilityTemplate, Content));
}
if (template.hasKey("effect"))
{
actionEffect = ConvergeCommand.New(template.getArray("effect"), Content);
}
if (template.hasKey("target"))
{
actionTarget = ConvergeSelector.New(template.getProperty("target"));
}
}
public JsonResult LoadGrid(string sidx, string sord, int rows, int page = 1)
{
string getSearchby = Request["_searchby"];
string getVal = Request["_val"];
string getStartDate = Request["_startDate"];
string getEndDate = Request["_endDate"];
string getTrxType = Request["_trxType"];
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.RequestTransType = "saldo".Equals(getTrxType) ? "GetSMSTransactionInfoSaldo" :
"mutasi".Equals(getTrxType) ? "GetSMSTransactionInfoMutasi" :
"kupon".Equals(getTrxType) ? "GetSMSTransactionInfoCoupon" :
"payment".Equals(getTrxType) ? "GetSMSTransactionInfoPayment" :
"all".Equals(getTrxType) ? "GetSMSTransactionAll" : string.Empty;
param.Parameter.Add("mobileNo", getVal);
param.Parameter.Add("startDate", getStartDate);
param.Parameter.Add("endDate", getEndDate);
SMSBCATransaction model = ChannelTransaction.SMSBCA(param);
var trx = model.Transactions.ToList().Select(x => new
{
TransactionDate = x.TransactionDate,
AccountNumber = x.AccountNumber,
TransactionType = x.TransactionType,
ResponseCode = x.ResponseCode,
Amount = x.Amount,
ReferenceNumber = x.ReferenceNumber,
Biller = x.Biller,
Receiver = x.Receiver,
Total = x.Total,
Other = x.Other
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = trx.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
trx = trx.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = trx.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = trx.ToArray();
jTable.additional = model.ATMCardHolderName + "<@z>" + model.ATMCardNumber + "<@z>" + model.Status;
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public Centrifuge(CityLevel cityLevel, JSONTable template) : base(
cityLevel,
TextureCache.centrifuge,
template.getVector2("pos")
)
{
this.inputSignature = new ChemicalSignature(template.getArray("chemical"));
canDrag = template.getBool("movable", true);
Init();
}
public ChemicalFactory(CityLevel cityLevel, JSONTable template) : base(
cityLevel,
template.getBool("movable", true)? TextureCache.processor : TextureCache.processor_rusty,
template.getVector2("pos")
)
{
this.canDrag = template.getBool("movable", true);
this.isBigFactory = template.getBool("bigFactory", false);
InitPipes();
}
public ChemicalSilo(CityLevel cityLevel, JSONTable template) : base(
cityLevel,
TextureCache.silo,
template.getVector2("pos"),
TextureCache.silo.Size()
)
{
this.signature = new ChemicalSignature(template.getArray("chemical"));
canDrag = template.getBool("movable", true);
Init();
}
public Card(JSONTable template, ContentManager content)
{
name = template.getString("name");
cost = ResourceAmount.createList(template.getJSON("cost", null));
effect = Effect_Base.create(template.getArray("effect", null));
if (template.hasKey("ongoing") || template.hasKey("triggers"))
{
ongoingType = new PermanentType(template, content);
}
image = content.Load<Texture2D>(template.getString("texture"));
smallFrameTexture = content.Load<Texture2D>("square");
Enum.TryParse<TargetType>(template.getString("target", "none"), out targetType);
frameTexture = content.Load<Texture2D>("cardframe_large");
description = DragonGfx.Tooltip.StringToLines(template.getString("description", ""), Game1.font, 100);
upgradeCost = ResourceAmount.createList(template.getJSON("upgradeCost", null));
targetTest = TriggerItemTest.create(template.getArray("targetTest", null));
spellSet = template.getString("spellSet", null);
foreach (JSONTable upgradeTemplate in template.getArray("upgrades", JSONArray.empty).asJSONTables())
{
if(upgrades == null)
upgrades = new List<Card>();
upgrades.Add(new Card(upgradeTemplate, content));
}
switch (template.getString("type", null))
{
case "special":
frameColor = new Color(235, 200, 255);
break;
case "minion":
frameColor = new Color(200, 255, 200);
break;
case "production":
frameColor = new Color(255, 220, 190);
break;
case "modifier":
frameColor = new Color(255, 190, 200);
break;
default:
frameColor = Color.White;
break;
}
string id = template.getString("id", null);
if (id != null)
{
cardsById.Add(id, this);
}
defaultUnlocked = template.getBool("unlocked", false);
unlocked = defaultUnlocked;
}
public static List<ResourceAmount> createList(JSONTable template)
{
List<ResourceAmount> costs = new List<ResourceAmount>();
if (template != null)
{
foreach (string key in template.Keys)
{
costs.Add(new ResourceAmount(ResourceType.get(key), template.getInt(key)));
}
}
return costs;
}
public ConvergeZone(JSONTable template, ConvergePlayer owner, ConvergeZoneId zoneId)
{
this.owner = owner;
this.zoneId = zoneId;
this.basePos = template.getVector2("basePos");
this.slotOffset = template.getVector2("slotOffset");
this.inPlay = template.getBool("inPlay", false);
this.isHidden = template.getBool("isHidden", false);
Vector2 topLeft = template.getVector2("topLeft");
Vector2 bottomRight = template.getVector2("bottomRight");
bounds = new Rectangle(topLeft.ToPoint(), (bottomRight - topLeft).ToPoint());
}
/* public WorldLevel()
* {
* objects.Add(new WorldObject_City(new CityLevel("TUTOPIA", new Vector2(100, 140))));
* objects.Add(new WorldObject_City(new CityLevel("SHEFFIELD", new Vector2(530, 90))));
* objects.Add(new WorldObject_City(new CityLevel("MANCHESTER", new Vector2(430, 70))));
* objects.Add(new WorldObject_City(new CityLevel("LIVERPOOL", new Vector2(300, 70))));
* objects.Add(new WorldObject_City(new CityLevel("BRISTOL", new Vector2(200, 320))));
* objects.Add(new WorldObject_City(new CityLevel("LONDON", new Vector2(700, 370))));
* objects.Add(new WorldObject_City(new CityLevel("BIRMINGHAM", new Vector2(400, 190))));
* objects.Add(new WorldObject_City(new CityLevel("READING", new Vector2(530, 370))));
* objects.Add(new WorldObject_City(new CityLevel("OXFORD", new Vector2(480, 300))));
* objects.Add(new WorldObject_City(new CityLevel("CARDIFF", new Vector2(100, 310))));
* }*/
public WorldLevel(JSONTable template)
{
foreach (string cityCode in template.Keys)
{
WorldObject_City city = new WorldObject_City(new CityLevel(template.getJSON(cityCode)));
objects.Add(city);
if (city.cityLevel.isTutorial)
{
tutorialCity = city;
}
}
}
static void Main(string[] args)
{
Options options = new Options();
ParserResult <Options> result = Parser.Default.ParseArguments <Options>(args).WithParsed <Options>(o =>
{
options = o;
});
if (result.Tag == ParserResultType.NotParsed)
{
// Help text requested, or parsing failed. Exit.
return;
}
List <Table> tables = FilterJSON(options);
if (options.ExportType == "gv")
{
ERD erd = new ERD(tables);
erd.Generate(options);
}
else if (options.ExportType == "json")
{
JSONSchema schema = new JSONSchema(tables);
schema.Generate(options);
}
else if (options.ExportType == "table")
{
JSONTable schema = new JSONTable(tables);
schema.Generate(options);
}
else if (options.ExportType == "csv")
{
CSVSchema schema = new CSVSchema(tables);
schema.Generate(options);
}
else if (options.ExportType == "sql")
{
SQL sql = new SQL(tables);
sql.Generate(options);
}
else if (options.ExportType == "html")
{
HTML html = new HTML(tables);
html.Generate(options);
}
else
{
Console.WriteLine("Export type not recognised");
}
}
public JsonResult LoadGridWorkflow(string sidx, string sord, int rows, int page = 1)
{
if (sidx == "Id")
{
sidx = "SeqNo";
sord = "asc";
}
CRMDb db = new CRMDb();
string getVal = Request["_val"];
if (getVal == "" || getVal == null)
{
getVal = Guid.Empty.ToString();
}
Guid serviceLevelID = new Guid(getVal);
//Query to workflow by service Level ID
var wf = db.Workflow.Where(x => x.SLID == serviceLevelID);
var data = wf.ToList()
.Select(x => new
{
ID = x.ID,
ServiceLevelID = x.SLID,
WgID = x.WgID,
WgName = x.WgName,
WorkflowSLADays = x.WorkflowSLADays,
SeqNo = x.SeqNo,
Keterangan = x.Keterangan
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.AsQueryable().OrderBy(sidx + " " + sord).Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
public override object Execute(object[] Parameters)
{
if (Parameters[0] is JSONTable)
{
JSONTable table = Parameters[0] as JSONTable;
table.Open();
}
else
{
//TODO: throw error: incorrect type
Error.ThrowRuntimeError("OPEN", "Table is required.");
}
return(null);
}
public override object Execute(object[] Parameters)
{
if (Parameters[0] is Structure && Parameters[1] is JSONTable)
{
JSONTable table = Parameters[1] as JSONTable;
table.ReadPrevious(Parameters[0] as Structure);
}
else
{
//TODO: throw error: incorrect type
Error.ThrowRuntimeError("READ", "Table is required.");
}
return(null);
}
public static long GetRecordCount(JSONTable jt)
{
BaseTable bt = null;
BaseFilter join = null;
SqlFilter whereFilter = null;
OrderBy orderBy = null;
GroupBy groupBy = null;
ConstructTableObjectFromPostRequest(jt, ref bt, ref whereFilter, ref join, ref orderBy, ref groupBy);
long count = bt.GetRecordListCount(join, whereFilter, groupBy, orderBy);
return(count);
}
public override object Execute(object[] Parameters)
{
if (Parameters[0] is JSONTable)
{
JSONTable table = Parameters[0] as JSONTable;
table.SetLowerLimit(Parameters[1] as dynamic[]);
}
else
{
//TODO: throw error: incorrect type
Error.ThrowRuntimeError("SETLL", "Table is required.");
}
return(null);
}
public PermanentType(JSONTable template, ContentManager content)
{
name = template.getString("name");
string textureName = template.getString("texture");
texture = (textureName != null) ? content.Load<Texture2D>(textureName) : null;
upkeep = ResourceAmount.createList(template.getJSON("upkeep", null));
ongoing = Effect_Base.create(template.getArray("ongoing", null));
ongoing_late = Effect_Base.create(template.getArray("ongoing_late", null));
triggers = TriggeredAbility.createList(template.getArray("triggers", null));
}
public MinionType(JSONTable template, ContentManager content)
: base(template, content)
{
upkeep = ResourceAmount.createList(template.getJSON("upkeep", null));
attackCost = ResourceAmount.createList(template.getJSON("attackCost", null));
whenDies = Effect_Base.create(template.getArray("whenDies", null));
awakenTypeName = template.getString("awakenType", null);
string onFireTextureName = template.getString("onFireTexture", null);
if (onFireTextureName != null)
onFireTexture = content.Load<Texture2D>(onFireTextureName);
stats.maxHealth = template.getInt("health", 1);
stats.health = stats.maxHealth;
stats.attack = template.getInt("attack", 0);
stats.move = template.getInt("move", 1);
stats.armor = template.getInt("armor", 0);
Enum.TryParse<Range>(template.getString("range", "adjacent"), out stats.range);
foreach (string abilityName in template.getArray("keywords", JSONArray.empty).asStrings())
{
Keyword keyword;
bool ok = Enum.TryParse<Keyword>(abilityName, out keyword);
Debug.Assert(ok);
stats.keywords |= keyword;
}
spells = template.getString("spells", null);
description = template.getString("description", "Just a guy");
}
public static void load(JSONTable template, ContentManager content)
{
types = new Dictionary<string, MinionType>();
foreach (string key in template.Keys)
{
types.Add(key, new MinionType(template.getJSON(key), content));
}
}
/// <summary>
/// Allows the game to perform any initialization it needs to before starting to run.
/// This is where it can query for any required services and load any non-graphic
/// related content. Calling base.Initialize will enumerate through any components
/// and initialize them as well.
/// </summary>
protected override void Initialize()
{
// TODO: Add your initialization logic here
Assembly current = Assembly.GetExecutingAssembly();
table = JSONTable.parse(new StreamReader(current.GetManifestResourceStream("MagicTheGathering.AllCards.json")).ReadToEnd());
host = new MagicGame();
base.Initialize();
}
public static void load(JSONTable template, ContentManager content)
{
levelTypes = new Dictionary<string, LevelType>();
foreach (string key in template.Keys)
{
levelTypes[key] = new LevelType(template.getJSON(key), content);
}
}
public LevelType(JSONTable template, ContentManager content)
{
spawnPoint = new List<Point>();
foreach(JSONArray spawnTemplate in template.getArray("spawnPoint").asJSONArrays())
{
spawnPoint.Add(spawnTemplate.toPoint());
}
wizardPos = template.getArray("wizardPos").toPoint();
levelSize = template.getArray("levelSize").toPoint();
startingResources = ResourceAmount.createList(template.getJSON("startingResources"));
floorTexture = content.Load<Texture2D>(template.getString("floorTexture"));
entranceTexture = content.Load<Texture2D>(template.getString("entranceTexture"));
pathTexture = content.Load<Texture2D>(template.getString("pathTexture"));
}
