public IActionResult Index()
{
SqlConnection conn = new SqlConnection("Server=tcp:poppycat.database.windows.net,1433;Initial Catalog=PoppyCat;Persist Security Info=False;User ID=chikarurus;Password=Karunarat1;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM CatCafe", conn);
SqlDataReader reader = cmd.ExecuteReader();
List <CatCafe> catcafes = new List <CatCafe>();
while (reader.Read())
{
CatCafe cafe = new CatCafe();
cafe.ID = reader.GetInt32(reader.GetOrdinal("ID"));
cafe.Name = reader.GetString(reader.GetOrdinal("Name"));
cafe.Price = reader.GetInt32(reader.GetOrdinal("Price"));
cafe.RateStar = reader.GetInt32(reader.GetOrdinal("RateStar"));
cafe.RateNum = reader.GetInt32(reader.GetOrdinal("RateNum"));
cafe.Img = reader.GetString(reader.GetOrdinal("Img"));
//cafe.Place = reader.GetString(reader.GetOrdinal("Place"));
cafe.Page = reader.GetString(reader.GetOrdinal("Page"));
catcafes.Add(cafe);
}
ViewBag.catcafes = catcafes;
// List<int> listIndex = new List<int>();
// Random rnd = new Random();
// // This will return either 1 or 2 randomly.
// for (int i = 0; i < 6; i++)
// {
// int index = rnd.Next(1, 6);
// listIndex.Add(index);
// }
return(View());
}
public ActionResult BookingPage(int id)
{
SqlConnection conn = new SqlConnection("Server=tcp:poppycat.database.windows.net,1433;Initial Catalog=PoppyCat;Persist Security Info=False;User ID=chikarurus;Password=Karunarat1;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM CatCafe WHERE id=" + id, conn);
SqlDataReader reader = cmd.ExecuteReader();
CatCafe cafe = new CatCafe();
reader.Read();
cafe.ID = reader.GetInt32(reader.GetOrdinal("ID"));
cafe.Name = reader.GetString(reader.GetOrdinal("Name"));
cafe.Price = reader.GetInt32(reader.GetOrdinal("Price"));
cafe.RateStar = reader.GetInt32(reader.GetOrdinal("RateStar"));
cafe.RateNum = reader.GetInt32(reader.GetOrdinal("RateNum"));
cafe.Img = reader.GetString(reader.GetOrdinal("Img"));
cafe.Place = reader.GetString(reader.GetOrdinal("Place"));
cafe.Page = reader.GetString(reader.GetOrdinal("Page"));
ViewBag.cafe = cafe;
return(View());
}
protected override void Awake()
{
base.Awake();
catCafe = GetComponent <CatCafe>();
}
protected virtual void Awake()
{
catCafe = GameManager.Instance.catCafe;
actionHolder = GameManager.Instance.actionHolder;
}
