protected void updateList(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "addOne")
{
string connectionString = "Provider=Microsoft.JET.OLEDB.4.0;data source=" + Server.MapPath("~\\App_Data\\G2C.mdb");
OleDbConnection conn = new OleDbConnection(connectionString);
int index = Convert.ToInt32(e.CommandArgument);
string item = MakeList.DataKeys[index].Values[0].ToString();
string sql;
string svUserId = (string)(Session["UserId"]);
sql = "Update Item set Item.ItemQuantity=Item.ItemQuantity+1, Item.ItemTimesUpdated=Item.ItemTimesUpdated+1, Item.ItemModifyDate=now Where Item.ItemUserId='" + svUserId + "' and Item.ItemId=" + item;
OleDbCommand cmd = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader reader;
reader = cmd.ExecuteReader();
reader.Close();
conn.Close();
MakeList.DataBind();
}
}
public async Task <ActionResult <MakeList> > Post(MakeList dto)
{
dataContext.Add(dto);
await dataContext.SaveChangesAsync();
return(Ok(dto));
}
public void SetMakeItems(IEnumerable <Make> makes)
{
foreach (var make in makes)
{
MakeList.Add(new SelectListItem()
{
Value = make.MakeID.ToString(),
Text = make.MakeName
});
}
}
void Start()
{
ml = GetComponent <MakeList>();
if (File.Exists(PlayerPrefs.GetString("Level", "None")))
{
file = PlayerPrefs.GetString("Level", "None");
}
else
{
file = "savedata.xml";
}
LoadTheData();
}
public void CreateStyle(ICarRepo repo)
{
var list = repo.GetAllStyles();
foreach (var item in list)
{
MakeList.Add(new SelectListItem
{
Value = item.StyleId.ToString(),
Text = item.StyleType,
});
}
}
public void PopulateModelList(ICarRepo repo)
{
foreach (var model in repo.GetAllModels())
{
var addModel = new SelectListItem
{
Value = model.ModelId.ToString(),
Text = model.ModelType,
};
MakeList.Add(addModel);
}
}
public void PopulateMakeList(ICarRepo repo)
{
foreach (var make in repo.GetAllMakes())
{
var addMake = new SelectListItem
{
Value = make.MakeId.ToString(),
Text = make.MakeType,
};
MakeList.Add(addMake);
}
}
public void PopulateStyleList(ICarRepo repo)
{
foreach (var style in repo.GetAllStyles())
{
var addStyle = new SelectListItem
{
Value = style.StyleId.ToString(),
Text = style.StyleType,
};
MakeList.Add(addStyle);
}
}
public static void Start()
{
List <int> list = MakeList.Make();
list.Reverse();
List <int> listR = list;
for (int i = 0; i < listR.Count; i++)
{
Console.WriteLine(listR[i]);
}
}
public static void Load()
{
var index = Utility.ConsoleSelect("API", apis);
var selected = apis[index];
var cardIndex = 0;
var cardCounter = 1;
var cardLoaded = 0;
switch (selected)
{
case "carqueryapi":
{
HttpClient client = new HttpClient();
var s = Kartenset.LoadFrom(AppDomain.CurrentDomain.BaseDirectory + "/Data/Autoquartett.json");
set = new ExpandoObject();
set.reversals = s.reversals;
set.cards = new ExpandoObject[64];
MakeList makes = null;
var rand = new Random();
Console.WriteLine("Loading Data...");
makes = JsonConvert.DeserializeObject <MakeList>(client
.GetStringAsync("https://www.carqueryapi.com/api/0.3/?cmd=getMakes").Result);
Console.WriteLine("Selecting cars...");
var ts = new Task[Environment.ProcessorCount];
for (int j = 0; j < Environment.ProcessorCount; j++)
{
ts[j] = Task.Run(() =>
{
while (cardLoaded < 64)
{
var make = makes.Makes[rand.Next(0, makes.Makes.Count)];
TrimList trims = null;
trims = JsonConvert.DeserializeObject <TrimList>(client
.GetStringAsync(
"https://www.carqueryapi.com/api/0.3/?cmd=getTrims&make=" + make.make_id)
.Result);
if (trims == null)
{
Console.WriteLine("Trims are null for " + make.make_id);
continue;
}
var i = 0;
Trim trim = null;
while (trim == null && trims.Trims.Count > i + 1)
{
trim = trims.Trims[i];
if (string.IsNullOrEmpty(trim.model_0_to_100_kph) ||
string.IsNullOrEmpty(trim.model_make_display) ||
string.IsNullOrEmpty(trim.model_trim) ||
string.IsNullOrEmpty(trim.model_engine_cc) ||
string.IsNullOrEmpty(trim.model_engine_power_ps) ||
string.IsNullOrEmpty(trim.model_top_speed_kph))
{
trim = null;
i++;
}
}
if (trim != null)
{
dynamic card = new ExpandoObject();
card.card_id = alphabet[cardIndex].ToString().ToUpper() + cardCounter;
card.identifier = (trim.model_make_display.Trim() + " " + trim.model_trim.Trim());
card.zero_to_hundred = trim.model_0_to_100_kph;
card.ccm = trim.model_engine_cc;
card.hp = trim.model_engine_power_ps;
card.kmh = trim.model_top_speed_kph;
lock (set)
{
if (cardLoaded < 64)
{
set.cards[cardLoaded] = card;
cardLoaded++;
cardCounter++;
if (cardCounter > 4)
{
cardIndex++;
cardCounter = 1;
}
}
}
}
}
});
}
Task.WaitAll(ts);
Console.WriteLine("Saving...");
using (StreamWriter sw =
new StreamWriter(AppDomain.CurrentDomain.BaseDirectory + "/Data/Autoquartett-New.json"))
{
sw.Write(JsonConvert.SerializeObject(set));
sw.Flush();
}
set = null;
makes = null;
client.Dispose();
GC.Collect();
Console.WriteLine("Done!");
break;
}
}
}
static void Main(string[] args)
{
var myDicList = new MakeList <string, string>();
myDicList.Add("A1", "1,2,3");
myDicList.Add("A2", "3,2,4");
myDicList.Add("A3", "3,4,5");
myDicList.Add("A4", "5,4,6");
myDicList.Add("A5", "5,6,7");
myDicList.Add("A6", "7,6,8");
myDicList.Add("A7", "7,8,9");
myDicList.Add("A8", "9,8,10");
myDicList.Add("A9", "9,10,11");
myDicList.Add("A10", "11,10,12");
myDicList.Add("A11", "11,12,13");
myDicList.Add("A12", "13,12,14");
myDicList.Add("B1", "15,1,16");
myDicList.Add("B2", "16,1,3");
myDicList.Add("B3", "16,3,17");
myDicList.Add("B4", "13,3,5");
myDicList.Add("B5", "17,5,18");
myDicList.Add("B6", "18,5,7");
myDicList.Add("B7", "18,7,19");
myDicList.Add("B8", "19,7,9");
myDicList.Add("B9", "18,9,20");
myDicList.Add("B10", "20,9,11");
myDicList.Add("B11", "20,11,21");
myDicList.Add("B12", "21,11,13");
myDicList.Add("C1", "22,15,23");
myDicList.Add("C2", "23,16,24");
myDicList.Add("C3", "21,16,24");
myDicList.Add("C4", "24,16,17");
myDicList.Add("C5", "24,17,25");
myDicList.Add("C6", "25,17,18");
myDicList.Add("C7", "26,18,26");
myDicList.Add("C8", "26,18,19");
myDicList.Add("C9", "26,18,27");
myDicList.Add("C10", "27,19,20");
myDicList.Add("C11", "27,20,28");
myDicList.Add("C12", "28,20,21");
myDicList.Add("D1", "29,22,30");
myDicList.Add("D2", "30,22,23");
myDicList.Add("D3", "30,23,31");
myDicList.Add("D4", "31,23,24");
myDicList.Add("D5", "31,24,32");
myDicList.Add("D6", "32,24,25");
myDicList.Add("D7", "23,25,33");
myDicList.Add("D8", "33,25,26");
myDicList.Add("D9", "33,26,34");
myDicList.Add("D10", "34,26,27");
myDicList.Add("D11", "34,27,35");
myDicList.Add("D12", "35,27,28");
myDicList.Add("E1", "36,29,37");
myDicList.Add("E2", "37,29,30");
myDicList.Add("E3", "37,30,38");
myDicList.Add("E4", "38,30,31");
myDicList.Add("E5", "38,31,39");
myDicList.Add("E6", "39,32,32");
myDicList.Add("E7", "39,32,40");
myDicList.Add("E8", "40,32,33");
myDicList.Add("E9", "40,33,41");
myDicList.Add("E10", "40,33,34");
myDicList.Add("E11", "21,34,42");
myDicList.Add("E12", "42,34.35");
myDicList.Add("F1", "43,36,44");
myDicList.Add("F2", "44,36,37");
myDicList.Add("F3", "44,37,45");
myDicList.Add("F4", "45,37,38");
myDicList.Add("F5", "45,38.46");
myDicList.Add("F6", "46,38,38");
myDicList.Add("F7", "46,39,47");
myDicList.Add("F8", "47,39,40");
myDicList.Add("F9", "47,40,48");
myDicList.Add("F10", "48,40,41");
myDicList.Add("F11", "48,41,49");
myDicList.Add("F12", "49,41,42");
var uniqueResults = myDicList
.Where(item => item.Value.Contains("48,40,41"))
.Select(item => item.Key)
.Distinct().FirstOrDefault();
Console.WriteLine(uniqueResults);
Console.ReadLine();
}
