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