コード例 #1
0
ファイル: BusDAO.cs プロジェクト: busmanagerprn292/BusManager
        public bool DeleteById(object id)
        {
            string query = "Delete Bus Where busId = @id";

            SqlParameter[] sqlParameters = new SqlParameter[1];
            sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar)
            {
                Value = id
            };
            try
            {
                conn.ExecuteDeleteQuery(query, sqlParameters);
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
        public bool DeleteById(object id)
        {
            string query = "Delete Route Where id = @id";

            SqlParameter[] sqlParameters = new SqlParameter[1];
            sqlParameters[0] = new SqlParameter("@id", SqlDbType.Int)
            {
                Value = Convert.ToInt32(id)
            };
            try
            {
                conn.ExecuteDeleteQuery(query, sqlParameters);
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }