public ActionResult Cancel(FormCollection form)
 {
     try
     {
         string    id     = form["BillID"];
         DetailDAO dao    = new DetailDAO();
         int       cancel = dao.Cancel(Session["LotID"].ToString(), Session["hostID"].ToString(), int.Parse(id));
         if (cancel > 0)
         {
             int available = dao.SetAvailable(Session["LotID"].ToString());
             if (available > 0)
             {
                 return(RedirectToAction("List", "Host", new { area = "Host" }));
             }
         }
         return(RedirectToAction("List", "Host", new { area = "Host" }));
     }
     catch
     {
         return(RedirectToAction("List", "Host", new { area = "Host" }));
     }
 }
        public DetailBLL()
        {
            SqlConnectBLL sql = new SqlConnectBLL();

            dao = new DetailDAO(sql.host, sql.port, sql.database, sql.username, sql.password);
        }