public async Task <IActionResult> Edit(int id, [Bind("mapID,stringURL")] maps maps)
{
if (id != maps.mapID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(maps);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!mapsExists(maps.mapID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(maps));
}
public static maps GetMaps(string mapName)
{
string query = "SELECT * FROM maps WHERE name = (@MapName) limit 1";
cmd = DBHelper.GetMapQuery(query, mapName);
maps aUser = null;
if (cmd != null)
{
dt = new DataTable();
sda = new MySqlDataAdapter(cmd);
sda.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
string uMapName = dr["name"].ToString();
string uTotalMatches = dr["total_matches"].ToString();
int iTotalMatches = Int32.Parse(uTotalMatches);
string uAttackerWin = dr["attacker_win"].ToString();
int iAttackerWin = Int32.Parse(uAttackerWin);
string uDefenderWin = dr["defender_win"].ToString();
int iDefenderWin = Int32.Parse(uDefenderWin);
aUser = new maps(uMapName, iTotalMatches, iAttackerWin, iDefenderWin);
}
}
return(aUser);
}
public Database()
{
MYSQL = new MySQLHandler();
try
{
if (MYSQL.Connection.State != ConnectionState.Open)
{
MYSQL.Connection.Open();
}
}
catch (Exception ex)
{
Console.WriteLine("MSG_FATAL", "Can't connect to database. " + ex.ToString());
return;
}
Console.WriteLine("MSG_STARTUP", "Connected to MYSQL.");
skills = new Skills(MYSQL);
Console.WriteLine("MSG_LOAD", "Skill database loaded with [" + skills.SkillList.Count + "] skills");
ItemDatabase = new Items(MYSQL);
Console.WriteLine("MSG_LOAD", "Item database loaded with [" + ItemDatabase.ItemList.Count + "] items");
monsters = new Monsters(MYSQL);
Console.WriteLine("MSG_LOAD", "Monster database loaded with [" + monsters.MonsterListDB.Count + "] monsters");
waves = new Waves(MYSQL, new Monsters(MYSQL));
Console.WriteLine("MSG_LOAD", "Waves database loaded with [" + waves.WaveList.Count + "] waves");
NPCsDatabase = new NPCs(MYSQL, ItemDatabase);
Console.WriteLine("MSG_LOAD", "NPC database loaded with [" + NPCsDatabase.NPCsList.Count + "] NPCs!");
Maps = new maps();
}
public async Task <IActionResult> Create([Bind("mapID,stringURL")] maps maps)
{
if (ModelState.IsValid)
{
_context.Add(maps);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(maps));
}
static void Main(string[] args)
{
maps mp = new maps();
if (args.Length > 0)
{
mp.debug();
}
else
{
mp.Println();
}
}
static void Main(string[] args)
{
int ii = 0;
Console.Clear();
maps mp = new maps(80, 20);
mp.grid(0, 0, mp.col, mp.count, 5, '.');
mp.lrect(1, 1, 10, 10, ',');
mp.rect(30, 5, 20, 10, ':');
mp.fillcircle((mp.col / 2), (mp.count) / 2, 8, '-');
mp.vstring(10, 2, "vertical");
mp.pstring(1, 1, "lrect");
mp.vcenter(8, "vcenter");
mp.center(8, "circle");
mp.Println();
}
public maps getMap()
{
int[,] myMapAttack = getMyMap(true);
int[,] enemyMapAttack = enemy.GetComponent <clanController>().getMyMap(true);
int[,] myMapDefense = getMyMap(false);
int[,] enemyMapDefense = enemy.GetComponent <clanController>().getMyMap(false);
for (int i = 0; i < boardSize.x; ++i)
{
for (int j = 0; j < boardSize.y; ++j)
{
myMapAttack [i, j] -= enemyMapAttack [i, j];
myMapDefense [i, j] -= enemyMapDefense [i, j];
}
}
maps ret = new maps();
ret.attack = myMapAttack;
ret.defense = myMapDefense;
return(ret);
}
private void FindMap(string name)
{
maps Map = mapsDA.GetMaps(name);
if (Map != null)
{
tm_name.Text = "Total Matches: ";
wr.Text = "Win Rate: ";
lr.Text = "Lose Rate: ";
map_name.Text = name;
total_matches.Text = Map.TotalMatches.ToString();
num_of_wins.Text = Math.Round(((Convert.ToDouble(Map.AttackerWin) / Convert.ToDouble(Map.TotalMatches)) * 100.00f), 2).ToString() + "%";
num_of_loses.Text = Math.Round(((Convert.ToDouble(Map.DefenderWin) / Convert.ToDouble(Map.TotalMatches)) * 100.00f), 2).ToString() + "%";
}
else
{
MessageBox.Show($"Invalid Map! Try Again!");
}
}
public async Task <JObject> Parks([FromUri] double lat, [FromUri] double lng)
{
maps mp = new maps();
Response Response = new Response();
Response = await mp.GetNearByPlaces(lat, lng, "parking", 10000);
JObject Error = new JObject();
if (Response.Code == 200)
{
Error.Add("Code", Response.Code);
Error.Add("Message", "Success");
ParkingYard Yard = new ParkingYard();
JArray jarr = JArray.Parse(Response.Data);
for (int count = 0; count < jarr.Count; count++)
{
Yard.Image = jarr[count]["place image"].ToString();
Yard.Name = jarr[count]["name"].ToString();
Yard.Place_ID = jarr[count]["place_id"].ToString();
Yard.Reference = jarr[count]["reference"].ToString();
ParkingYard.YardLocation YardLocation = new ParkingYard.YardLocation();
YardLocation.Name = jarr[count]["vicinity"].ToString();
YardLocation.Latitude = Convert.ToDouble(jarr[count]["geometry"]["location"]["lat"]);
YardLocation.Longitude = Convert.ToDouble(jarr[count]["geometry"]["location"]["lng"]);
Yard.Location = YardLocation;
ParkRepo = new ParkRepository();
if (await ParkRepo.CreateParkingYard(Yard))
{
Response.Message = "Parking Created Successfully";
}
else
{
Response.Message = "Parking Already exists";
}
JObject Parking = new JObject();
ParkingYard py = ParkRepo.GetParkingYard(Yard.Place_ID);
JObject Space = new JObject();
Space.Add("space id", py.Spaces.Space_ID);
Space.Add("space count", py.Spaces.Count);
Space.Add("used spaces", py.Spaces.UsedSpaces);
JObject Location = new JObject();
Location.Add("id", py.Location.id);
Location.Add("name", py.Location.Name);
Parking.Add("park_id", py.id);
Parking.Add("Space", Space);
Parking.Add("Location", Location);
JObject FinalJarr = (JObject)jarr[count];
FinalJarr.Add("Park Data", Parking);
jarr[count] = FinalJarr;
}
// JArray FinalJSONArray = (JArray)jarr;
Error.Add("values", jarr);
}
else
{
Error.Add("Code", Response.Code);
Error.Add("Message", Response.Message);
Error.Add("Values", Response.Data);
}
return(Error);
}
