// Use this for initialization void Start() { selectedBrick = brickList[0]; //brickInfo = selectedBrick.GetComponent<BrickInfo>(); InstantiateTest(); bi = boatTrans.GetComponent <BoatInfo>(); }
public List <BoatInfo> GetReturnedBoatInfo() { Query = "SELECT * FROM BoatInfo WHERE Status = 'True'"; Command = new SqlCommand(Query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); List <BoatInfo> boatInfos = new List <BoatInfo>(); while (Reader.Read()) { BoatInfo boatInfo = new BoatInfo(); boatInfo.BoatId = Convert.ToInt32(Reader["BoatId"]); boatInfo.BoatName = Reader["BoatName"].ToString(); boatInfo.BoatRegNo = Reader["BoatRegNo"].ToString(); boatInfo.OwnerName = Reader["OwnerName"].ToString(); boatInfo.OwnerNidNo = Reader["OwnerNidNo"].ToString(); boatInfo.OwnerMobileNo = Reader["OwnerMobileNo"].ToString(); boatInfo.StartingTime = Reader["StartingTime"].ToString(); boatInfo.StartDate = Reader["StartDate"].ToString(); boatInfo.FinishDate = Reader["FinishDate"].ToString(); boatInfo.TotalPerson = Convert.ToInt32(Reader["TotalPerson"]); boatInfo.Status = Convert.ToBoolean(Reader["Status"]); boatInfos.Add(boatInfo); } Reader.Close(); Connection.Close(); return(boatInfos); }
public BoatInfo GetBoatInfo(int id) { Query = "SELECT * FROM BoatInfo WHERE BoatId = @id"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("id", id); Connection.Open(); Reader = Command.ExecuteReader(); BoatInfo boatInfo = null; while (Reader.Read()) { boatInfo = new BoatInfo(); boatInfo.BoatId = Convert.ToInt32(Reader["BoatId"]); boatInfo.BoatName = Reader["BoatName"].ToString(); boatInfo.BoatRegNo = Reader["BoatRegNo"].ToString(); boatInfo.OwnerName = Reader["OwnerName"].ToString(); boatInfo.OwnerNidNo = Reader["OwnerNidNo"].ToString(); boatInfo.OwnerMobileNo = Reader["OwnerMobileNo"].ToString(); boatInfo.StartingTime = Reader["StartingTime"].ToString(); boatInfo.StartDate = Reader["StartDate"].ToString(); boatInfo.FinishDate = Reader["FinishDate"].ToString(); boatInfo.TotalPerson = Convert.ToInt32(Reader["TotalPerson"]); boatInfo.Status = Convert.ToBoolean(Reader["Status"]); } Reader.Close(); Connection.Close(); return(boatInfo); }
public int SaveBoat(BoatInfo boatInfo) { Query = "INSERT INTO BoatInfo VALUES(@boatName, @boatRegNo, @ownerName, @ownerNidNo, @ownerMobileNo, @startingTime, @startDate, @finishDate, @totalPerson, @status)"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("boatName", boatInfo.BoatName); Command.Parameters.AddWithValue("boatRegNo", boatInfo.BoatRegNo); Command.Parameters.AddWithValue("ownerName", boatInfo.OwnerName); Command.Parameters.AddWithValue("ownerNidNo", boatInfo.OwnerNidNo); Command.Parameters.AddWithValue("ownerMobileNo", boatInfo.OwnerMobileNo); Command.Parameters.AddWithValue("startingTime", boatInfo.StartingTime); Command.Parameters.AddWithValue("startDate", boatInfo.StartDate); Command.Parameters.AddWithValue("finishDate", boatInfo.FinishDate); Command.Parameters.AddWithValue("totalPerson", boatInfo.TotalPerson); Command.Parameters.AddWithValue("status", boatInfo.Status); Connection.Open(); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); if (rowAffected > 0) { int rowAffectedSailors = SaveSailors(boatInfo.BoatRegNo, boatInfo.Sailors); int rowAffectedFishermans = SaveFishermans(boatInfo.BoatRegNo, boatInfo.Fishermans); if (rowAffectedSailors <= 0 || rowAffectedFishermans <= 0) { rowAffected = 0; } } return(rowAffected); }
// Use this for initialization void Start() { boatInfo = boat.GetComponent <BoatInfo>(); bv = boat.GetComponent <BuoyancyVisualizer>(); gv = boat.GetComponent <GravityVisualizer>(); if (testObj) { originObjPos = testObj.transform.position; originObjRot = testObj.transform.rotation; } }
public string UpdateBoatInfo(BoatInfo boatInfo) { int rowAffected = aAdminGateway.UpdateBoatInfo(boatInfo); if (rowAffected > 0) { return("Success"); } else { return("Boat information updating failed. Please try again!"); } }
private void TestBoat() { int typeIndex = -1; float select = UnityEngine.Random.Range(0, 100); if (select >= 0 && select < 70) { typeIndex = (int)BoatType.NormalAttack; } else if (select >= 70 && select < 100) { typeIndex = (int)BoatType.SuicideAttack; } // int index = UnityEngine.Random.Range(0, DataController.instance.boatPositions.Length); Vector3 pos = new Vector3(7, 0, DataController.instance.boatPositions[index]); float speed = 0; // GameObject obj = null; obj = Common.Generate(DataController.prefabPath_Boat + typeIndex, transEnemy); obj.transform.localPosition = pos; // obj.tag = nameof(Tag.Boat); BoatInfo info = obj.GetComponent <BoatInfo>(); // CardInfo cardInfo = info.cardInfo; cardInfo.myTag = Tag.Boat; cardInfo.isEnemy = true; cardInfo.Hp = GameManager.BackBoatHp((BoatType)typeIndex); cardInfo.Atk = GameManager.BackBoatAtk((BoatType)typeIndex); cardInfo.myName = "船只->" + (int)typeIndex; cardInfo.SetInit(); // switch ((BoatType)typeIndex) { case BoatType.NormalAttack: speed = 0.5f; break; case BoatType.SuicideAttack: speed = 6f; break; } info.Init(speed); // showEnemy.Add(cardInfo); }
public string SaveBoat(BoatInfo boatInfo) { if (aUserGateway.IsBoatValid(boatInfo.BoatName, boatInfo.BoatRegNo) == false) { int rowAffected = aUserGateway.SaveBoat(boatInfo); if (rowAffected > 0) { return("Success"); } else { return("Boat information saving failed. Try again!"); } } return("The boat is already exist"); }
public int UpdateBoatInfo(BoatInfo boatInfo) { Query = "UPDATE BoatInfo SET OwnerName = @ownerName, OwnerNidNo = @ownerNidNo, OwnerMobileNo = @ownerMobileNo, StartDate = @startDate, StartingTime = @startingTime WHERE BoatId = @boatId"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("ownerName", boatInfo.OwnerName); Command.Parameters.AddWithValue("ownerNidNo", boatInfo.OwnerNidNo); Command.Parameters.AddWithValue("ownerMobileNo", boatInfo.OwnerMobileNo); Command.Parameters.AddWithValue("startDate", boatInfo.StartDate); Command.Parameters.AddWithValue("startingTime", boatInfo.StartingTime); Command.Parameters.AddWithValue("boatId", boatInfo.BoatId); Connection.Open(); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public ActionResult BoatDetails(int id) { if (User.IsInRole("Admin")) { if (id > 0) { BoatInfo boatInfo = aAdminManager.GetBoatInfo(id); List <Sailors> sailors = aAdminManager.GetSailors(id); List <Fishermans> fishermans = aAdminManager.GetFishermans(id); ViewBag.GetBoatInfo = boatInfo; ViewBag.GetAllSailors = sailors; ViewBag.GetAllFisherman = fishermans; } } return(View()); }
public static async Task RefreshSelectedBoat(CancellationToken cancellationToken) { await Task.Run(async() => { while (!cancellationToken.IsCancellationRequested) { if (Global.Instance.SelectedBoatNumber != null) { List <BoatInfo> boats = Methods.GetBoats(null, Global.Instance.SelectedBoatNumber); if (boats.Count == 1) { BoatInfo boat = boats.First(); boat.FixQuality = NMEAServerLib.InstrumentsData.FixQualityType.GPS; Global.Instance.MessageHub.PublishAsync(new SelectedBoatRefreshed(Global.Instance, boats.First())); } } await Task.Delay(Conf.REQUEST_RATE, cancellationToken); } }); }
public ActionResult AddBoat(BoatInfo boatInfo) { int totalSailor = boatInfo.Sailors.Count; int totalFisherman = boatInfo.Fishermans.Count; boatInfo.TotalPerson = totalSailor + totalFisherman; boatInfo.StartDate = DateTime.Now.ToString("dd/MM/yyyy"); boatInfo.FinishDate = DateTime.Now.AddDays(12).ToLongDateString(); boatInfo.Status = false; string message = aUserManager.SaveBoat(boatInfo); if (message == "Success") { ViewBag.Message = "Boat information saved successfully"; } else { ViewBag.ErrorMessage = message; } return(View()); }
public ActionResult BoatDetails(BoatInfo boatInfo) { if (User.IsInRole("Admin")) { string message = aAdminManager.UpdateBoatInfo(boatInfo); if (message == "Success") { ViewBag.Message = "Boat information updated successfully"; } else { ViewBag.ErrorMessage = message; } BoatInfo aBoatInfo = aAdminManager.GetBoatInfo(boatInfo.BoatId); List <Sailors> sailors = aAdminManager.GetSailors(boatInfo.BoatId); List <Fishermans> fishermans = aAdminManager.GetFishermans(boatInfo.BoatId); ViewBag.GetBoatInfo = aBoatInfo; ViewBag.GetAllSailors = sailors; ViewBag.GetAllFisherman = fishermans; } return(View()); }
public void ShootController <T>(T t, Vector3 checkPos, float shootRange) { bool isHave = false;; int index = -1; List <GameObject> objs = new List <GameObject>(); for (int i = 0; i < myCards.Count; i++) { objs.Add(myCards[i].gameObject); } CharacterInfo cInfo = t as CharacterInfo; BoatInfo bInfo = t as BoatInfo; //switch (tag) //{ // case Tag.Enemy: // cInfo = t as CharacterInfo; // checkPos = cInfo.transform.position; // break; // case Tag.Boat: // bInfo = t as BoatInfo; // checkPos = bInfo.transform.position; // break; //} GetShootInfo(objs, checkPos, shootRange, ref isHave, ref index); if (isHave) { if (cInfo != null) { cInfo.Shoot(myCards[index].cardInfo); } if (bInfo != null) { bInfo.Shoot(myCards[index].cardInfo); } } }
public void TrrigerLogic(Collider coll) { if (isHit) { return; } string info = ""; GameObject obj = coll.gameObject; switch (obj.tag) { case nameof(Tag.Enemy): if (myTag != Tag.Player) { return; } else { targetTag = Tag.Enemy; isHit = true; //info += obj.tag + "/" + obj.name; CharacterInfo cInfo = obj.GetComponent <CharacterInfo>(); cInfo.BeShoot(Atk); } break; case nameof(Tag.Player): if (myTag != Tag.Player) { targetTag = Tag.Player; isHit = true; //info += obj.tag + "/" + obj.name; CharacterInfo cInfo = obj.GetComponent <CharacterInfo>(); cInfo.BeShoot(Atk); } else { return; } break; case nameof(Tag.Support): if (myTag != Tag.Player) { targetTag = Tag.Player; isHit = true; //info += obj.tag + "/" + obj.name; SupportInfo sInfo = obj.GetComponent <SupportInfo>(); sInfo.BeShoot(Atk); } else { return; } //info += myTag + "子弹射中Support"; break; case nameof(Tag.Bullet): //info += " 子弹都能射中?"; break; case nameof(Tag.Boat): if (myTag != Tag.Player) { return; } else { targetTag = Tag.Boat; isHit = true; BoatInfo bInfo = obj.GetComponent <BoatInfo>(); bInfo.BeShoot(Atk); } break; default: info += "未判断的Tag->" + obj.tag + "/" + obj.name; break; } if (info != "") { Debug.LogError(info); } if (isHit) { PoolDestroy(); } }