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