public static List <AAF> GetAAF(string criteria, int intIDMasLocation)
{
var dbUtil = new DatabaseManager();
var dAAF = new List <AAF>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetAAF";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", criteria);
cmd.Parameters.AddWithValue("@intIDMasLocation", intIDMasLocation);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var drcrAAF = new AAF
{
ID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]),
strDescription = ReferenceEquals(reader["strDescription"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strDescription"]),
};
dAAF.Add(drcrAAF);
}
return(dAAF);
}
}
}
}
IEnumerator Fire()
{
yield return(new WaitForSeconds(3f));
GameObject rkt = Instantiate(missilePrefab, transform.Find("Spawnpoint").position, transform.rotation);
AAF aa = rkt.GetComponent <AAF>();
aa.Target = Target;
aa.Damping = 0.75f;
aa.MotorForce = 300;
aa.gameObject.tag = "AntiArtillery";
yield return(new WaitForSeconds(5f));
Fired = false;
}
